QNT275 Phoenix Columbus Chemical Industries Business Problem Presentation

User Generated

fubegl2106

Mathematics

QNT275

University of Phoenix

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












User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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

Related Tags