assignment due April 20th at 11:59 PM.
Objectives: 1) To use Excel to conduct a statistical analysis of a
case 2) To work collaboratively with the other members of your group to produce a professional-quality report of the statistical analysis
Choose ONE of the following case problems from the textbook: • Chapter 11: Air Force Training Program • Chapter 14: U.S. Department of Transportation • Chapter 14: Selecting a Point-and-Shoot Digital Camera • Chapter 14: Finding the Best Car Value • Chapter 15: Consumer Research, Inc.
Data: The data files for the case problems are on Blackboard in Content > Project > Data Files.
Directions: • Read the case problem carefully. • Download and analyze the data according to the guidance in the case problem. • All data analysis should be done using Excel. The Using Excel portions of the chapters will be important references. All data analysis in Excel should be well organized and labeled. Leave formulas in place, if appropriate in your case, so that they can be checked. It should be clear where each number in your report came from and how it was calculated. • Write a report that summarizes your findings, and answers all of the questions asked in the case problem. When writing this report, consider your audience to be a busy professional who has requested this analysis. This person requires a concise report that summarizes the data and the findings in a clear and organized manner. Recommendations and conclusions, when requested, must be well reasoned and supported by the data analysis. Use your analysis as evidence in your arguments. Suggestions for accomplishing this include, but are not limited to: o When descriptive statistics or summaries are requested, consider the best way to present them: is it a table of numbers that is well-organized and labeled properly? Or is it a chart that would best summarize your data? HINT: a long paragraph that presents numbers in sentences is probably NOT a good summary. o Use charts or tables and then point out and interpret the aspects of the chart or table you would like your audience to notice in particular. o Chapters 2 and 3 in the book (available in Week 1 on Aplia) contain a great deal of guidance about appropriate summaries of descriptive statistics. o Using bulleted lists is often appropriate (although not required), especially when presenting recommendations.
o Explain the basis for findings and recommendations. What part of your statistical analysis backs up each assertion that you make? Can your reader understand the reasoning that underlies your conclusions? • There is only one correct way to do the statistical analysis in the project, but there are many ways to properly present the results in the report. • Always be sure to read your case problem, because any questions it asks must be answered in your report.
data files attached.