Reference no: EM132865772

A car manufacturer is introducing a new model, and they claim that the average fuel consumption for this model is 35 miles or more per gallon on the open road. The competitors believe this estimate is too high. You are employed by a testing agency to run a statistical test and verify the car manufacturer's claim. You conduct a highway mileage test on 80 cars and save the results in an Excel file. Upload the Excel file CarEfficiency and save it in SPSS data format for future use.

Complete the following tasks and copy your results in a word document and submit your report.

1. Examine if the sample data follows a normal distribution using the Explore feature under the Descriptive Statistics in SPSS (or Insert Statistic Chart in Excel).

2. Construct a confidence interval for the population mean at 99% confidence level.

3. Conduct a test of the hypothesis at a 1% significance level to verify if the car manufacturer claims the claim is justified. State the Null and Alternative hypotheses in the proper conventional form.

80 cars
Miles Per Gallon
34.58
37.70
36.10
34.58
37.73
39.31
36.53
32.25
34.72
42.51
35.08
33.58
35.51
35.60
39.40
37.15
36.96
37.36
34.53
38.88
37.74
41.01
34.28
40.35
39.71
36.67
40.41
40.55
34.61
34.61
35.17
34.34
34.82
39.77
38.64
39.30
40.37
36.10
36.77
34.30
42.04
39.46
41.71
34.61
42.81
37.81
36.61
37.49
35.00
35.13
30.61
40.83
38.88
30.71
38.17
38.25
35.82
34.42
35.78
35.65
36.34
40.57
30.50
37.43
32.95
35.35
41.00
30.91
34.66
39.27
35.46
37.19
38.40
31.10
38.90
41.44
38.46
35.53
32.47
34.02