Mathematics
QNT275 Phoenix Columbus Chemical Industries Business Problem Presentation

QNT275

University of Phoenix

Question 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
    Consider the following as you watch:
    • 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
      Consider the following as you watch:
      • Demonstrate what Microsoft® Excel® statistical tools are needed to produce a linear regression and ANOVA models.



Introductory Statistics Chapters 11 and 13












Final 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
...

Missfomen (3153)
University of Maryland

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors