View the step-by-step solution to:

Question

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.  
 

Current Proposed 76 74 76 75 77 77 74 78 76 74 74 80 74 73 77 73 72 78 78 76 73 76 78 74 75 77 80 69 79 76 72 75 69 72 79 75 72 72 70 76 70 72 81 77 76 73 78 77 72 69 82 77 72 75 73 76 71 74 70 77 77 75 78 78 73 72 79 77 82 78 65 78 77 76 79 75 73 76 76 76 81 75 69 76 75 80
Background image of page 1
75 77 77 76 79 75 76 73 78 77 76 77 76 77 73 79 77 75 84 75 74 72 74 82 69 76 79 76 66 74 70 72 74 78 72 71
Background image of page 2
54 3 4,016 30 2 3,159 32 4 5,100 50 5 4,742 31 2 1,864 55 2 4,070 37 1 2,731 40 2 3,348 66 4 4,764 51 3 4,110 25 3 4,208 48 4 4,219 27 1 2,477 33 2 2,514 65 3 4,214 63 4 4,965 42 6 4,412 21 2 2,448 44 1 2,995 37 5 4,171 62 6 5,678 21 3 3,623 55 7 5,301 42 2 3,020 41 7 4,828 54 6 5,573 30 1 2,583 48 2 3,866 34 5 3,586 67 4 5,037 50 2 3,605 67 5 5,345 55 6 5,370 52 2 3,890 62 3 4,705 64 2 4,157 22 3 3,579 29 4 3,890 39 2 2,972 35 1 3,121 39 4 4,183 54 3 3,730 Income ($1000s) Household Size Amount Charged ($)
Background image of page 1
23 6 4,127 27 2 2,921 26 7 4,603 61 2 4,273 30 2 3,067 22 4 3,074 46 5 4,820 66 4 5,149
Background image of page 2
Car Price ($) Nissan Altima 2.5 S (4-cyl.) 23,970.00 0.59 91 4 1.75 Kia Optima LX (2.4) 21,885.00 0.58 81 4 1.73 Subaru Legacy 2.5i Premium 23,830.00 0.59 83 4 1.73 Ford Fusion Hybrid 32,360.00 0.63 84 5 1.70 Honda Accord LX-P (4-cyl.) 23,730.00 0.56 80 4 1.62 Mazda6 i Sport (4-cyl.) 22,035.00 0.58 73 4 1.60 Hyundai Sonata GLS (2.4) 21,800.00 0.56 89 3 1.58 Ford Fusion SE (4-cyl.) 23,625.00 0.57 76 4 1.55 Chevrolet Malibu LT (4-cyl.) 24,115.00 0.57 74 3 1.48 Kia Optima SX (2.0T) 29,050.00 0.72 84 4 1.43 Ford Fusion SEL (V6) 28,400.00 0.67 80 4 1.42 Nissan Altima 3.5 SR (V6) 30,335.00 0.69 93 4 1.42 Hyundai Sonata Limited (2.0T) 28,090.00 0.66 89 3 1.39 Honda Accord EX-L (V6) 28,695.00 0.67 90 3 1.36 Mazda6 s Grand Touring (V6) 30,790.00 0.74 81 4 1.34 Ford Fusion SEL (V6, AWD) 30,055.00 0.71 75 4 1.32 Subaru Legacy 3.6R Limited 30,094.00 0.71 88 3 1.29 Chevrolet Malibu LTZ (V6) 28,045.00 0.67 83 3 1.20 Chrysler 200 Limited (V6) 27,825.00 0.70 52 5 1.20 Chevrolet Impala LT (3.6) 28,995.00 0.67 63 3 1.05 Cost/M ile Road- Test Score Predicted Reliability Value Score
Background image of page 1
Observation Brand Price ($) Megapixel ight (oz.) Score 1 Canon 330 10 7 66 2 Canon 200 12 5 66 3 Canon 300 12 7 65 4 Canon 200 10 6 62 5 Canon 180 12 5 62 6 Canon 200 12 7 61 7 Canon 200 14 5 60 8 Canon 130 10 7 60 9 Canon 130 12 5 59 10 Canon 110 16 5 55 11 Canon 90 14 5 52 12 Canon 100 10 6 51 13 Canon 90 12 7 46 14 Nikon 270 16 5 65 15 Nikon 300 16 7 63 16 Nikon 200 14 6 61 17 Nikon 400 14 7 59 18 Nikon 120 14 5 57 19 Nikon 170 16 6 56 20 Nikon 150 12 5 56 21 Nikon 230 14 6 55 22 Nikon 180 12 6 53 23 Nikon 130 12 6 53 24 Nikon 80 12 7 52 25 Nikon 80 14 7 50 26 Nikon 100 12 4 46 27 Nikon 110 12 5 45 28 Nikon 130 14 4 42
Background image of page 1
Data Page 1 13 2.962 12 0.708 8 0.885 12 1.652 11 2.091 17 2.627 18 3.83 8 0.368 13 1.142 8 0.645 9 1.028 16 2.801 12 1.405 9 1.433 10 0.039 9 0.338 11 1.849 12 2.246 14 2.855 14 2.352 11 1.294 17 4.1 8 2.19 16 3.623 15 2.623 9 0.835 8 0.82 14 2.89 8 1.267 15 3.224 10 1.014 10 0.493 14 1.443 18 3.614 10 1.926 14 1.643 16 2.943 12 1.913 15 2.814 13 2.634 9 0.926 17 3.256 Percent Under 21 Fatal Accidents per 1000
Background image of page 1

Top Answer

View the full answer
Finding the best car value.xlsx

Car
Nissan Altima 2.5 S (4-cyl.)
Kia Optima LX (2.4)
Subaru Legacy 2.5i Premium
Ford Fusion Hybrid
Honda Accord LX-P (4-cyl.)
Mazda6 i Sport (4-cyl.)
Hyundai Sonata GLS (2.4)
Ford Fusion SE...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online