Description
This assignment provides students with practice in understanding when or why ANOVA and linear regression are identified based on parameters. Students will learn to implement these statistical measures for better business decision-making.
Assignment Steps
Resources: Week 5 Videos; Week 5 Readings; Statistics Lab
Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products.
Prepare an 11- to 15-slide Microsoft® PowerPoint® presentation for the senior management team based on the business problem or opportunity you described in Weeks 3-4.
Include on the slides what you would want the audience to see (include appropriate visual aids/layout) and include in the speaker's notes section what you would say as you present each slide. If any source material is quoted or paraphrased in the presentation, use APA citations and references.
Draw on material you developed in the Week's 3 and 4 assignments.
Include the following in your presentation:
- Introduction slide
- Agenda slide
- Describe the organization, with a brief description
- Explain the business problem or opportunity
- Describe the hypothesis
- Analyze why the business problem is important
- Identify what variable would be best to measure for this problem and explain why
- Identify statistical methods used to analyze data
- Apply data analysis techniques to this problem (tell which techniques should be used: descriptive statistics, inferential stats, probability) and explain why
- Apply a possible solution to the problem/opportunity, with rationale
- Evaluate how data could be used to measure the implementation of such a solution
- Conclusion
- Reference slide (if any source material is quoted or paraphrased throughout the presentation)
Format your assignment consistent with APA guidelines.
Additional Info
Watch the instructional video by clicking on the Lynda.com® link.
Type the title "Statistics with Excel Part One" in the Search Bar to find the video.
Watch the following tutorials from Section 19:
- Two-Factor ANOVA
Consider the following as you watch:
- Discover how to perform a two factor hypothesis test with Microsoft® Excel®. Watch the instructional video by clicking on the Lynda.com® link. Type the title "Statistics with Excel Part One" in the Search Bar to find the video. Watch the following tutorials from Section 20:
- Regression Line Overview
- How can you use Microsoft® Excel® to create a regression line? Watch the instructional video by clicking on the Lynda.com® link. Type the title "Descriptive Healthcare Analytics in R" in the Search Bar to find the video. Watch the following tutorials from Section 6:
- Introduction to ANOVA and Linear Regression Code
- Demonstrate what Microsoft® Excel® statistical tools are needed to produce a linear regression and ANOVA models.
Introductory Statistics Chapters 11 and 13

Explanation & Answer

Hi, Please check out this presentation..
STATISTICS WITH EXCEL PRESENTATION
COURSE
NAME
DATE
INSTRUCTOR
INTRODUCTION
❖This presentation aims at introducing the Columbus Chemical
Industries, Inc and the business problem facing the company.
❖The presentation will highlight:
✓ the best research variable,
✓ statistical method for analyzing the data,
✓ apply the data analysis techniques to the problem, and
✓ identify possible solution to the problem.
AGENDA
▪ Description of the organization
▪ Business problem
▪ Hypothesis
▪ Significance of the business problem
▪ Best research variable
▪ Statistical methods of data analysis
▪ Application of data analysis techniques to the business problem
▪ Possible solution to the problem
▪ How data can be used to measure implementation of the solution
▪ Conclusion
▪ References
DESCRIPTION OF THE ORGANIZATION
Columbus Chemical Industries, Inc
Columbus Chemical Industries is a chemical
manufacturing company
Was founded in 1978
Headquartered in Columbus, Wisconsin
Manufactures and supplies high purity and fine
chemicals
BUSINESS PROBLEM
▪ The main problem is high operational costs
▪ Increased demand calls for increased production
volume
▪ But customers expect better and high quality
▪ Lots of funds is invested in chemical formulas and
process designs
▪ This leads to high costs that impairs profitability.
VISUAL REPRESENTATION OF THE BUSINESS PROBLEM
Increased
Investment in
chemical
High Operational
Costs
High costs in
process Design
Reduced
Profitability
HYPOTHESIS
A significant relationship exists between poor chemical
formulas and high operational costs
SIGNIFICANCE OF THE BUSINESS PROBLEM
➢ Uncover inefficient areas in the operational
processes
➢ Help in identifying factors that contribute to poor
business performance
➢ Identify gaps existing in studies related to high
operational costs
➢ Form a baseline for further research
BEST RESEARCH VARIABLE
Operational cost
✓ It is a measurable metric
...
