Question

Exercise #4 Open the Excel worksheet MPGDATA.XLS from Blackboard>Excel #5 Files. The data in column A of this worksheet represent the miles per gallon gasoline consumption for a random sample of 55 makes and models of passenger cars (source: Environmental Protection Agency) Use the Excel Confidence Interval Template to: Construct a 95% confidence interval for the population mean miles per gallon consumption for passenger cars. Use the Excel Hypothesis Testing Template to: Test the hypothesis that the population mean of miles per gallon gasoline consumption for passenger cars is different from 25 mpg. Use a significance level of 5%. a) Do we know $\sigma$ for the mpg consumption? Can we use the normal distribution for the hypothesis test? b) State the null and alternative hypotheses. c) Perform the appropriate test and print the output. d) Look at the p-value in the output. Compare it to $\alpha$. Do we reject the null hypothesis or not? e) Generate the descriptive statistics (mean, standard deviation, median, and variance) for the data.

          Exercise #4
Open the Excel worksheet MPGDATA.XLS from Blackboard>Excel #5 Files. The data in column A
of this worksheet represent the miles per gallon gasoline consumption for a random sample of
55 makes and models of passenger cars (source: Environmental Protection Agency)
Use the Excel Confidence Interval Template to:
Construct a 95% confidence interval for the population mean miles per gallon consumption
for passenger cars.
Use the Excel Hypothesis Testing Template to:
Test the hypothesis that the population mean of miles per gallon gasoline consumption for
passenger cars is different from 25 mpg. Use a significance level of 5%.
a) Do we know $\sigma$ for the mpg consumption? Can we use the normal distribution for the
hypothesis test?
b) State the null and alternative hypotheses.
c) Perform the appropriate test and print the output.
d) Look at the p-value in the output. Compare it to $\alpha$. Do we reject the null hypothesis or
not?
e) Generate the descriptive statistics (mean, standard deviation, median, and variance) for
the data.

Exercise #4
Open the Excel worksheet MPGDATA.XLS from Blackboard>Excel #5 Files. The data in column A
of this worksheet represent the miles per gallon gasoline consumption for a random sample of
55 makes and models of passenger cars (source: Environmental Protection Agency)
Use the Excel Confidence Interval Template to:
Construct a 95% confidence interval for the population mean miles per gallon consumption
for passenger cars.
Use the Excel Hypothesis Testing Template to:
Test the hypothesis that the population mean of miles per gallon gasoline consumption for
passenger cars is different from 25 mpg. Use a significance level of 5%.
a) Do we know σ for the mpg consumption? Can we use the normal distribution for the
hypothesis test?
b) State the null and alternative hypotheses.
c) Perform the appropriate test and print the output.
d) Look at the p-value in the output. Compare it to α. Do we reject the null hypothesis or
not?
e) Generate the descriptive statistics (mean, standard deviation, median, and variance) for
the data.

Added by William W.

Question

Please give Ace some feedback