Exercise #1 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%. Do we know ? for the mpg consumption? Can we use the normal distribution for the hypothesis test? State the null and alternative hypotheses. Perform the appropriate test and print the output. Look at the p-value in the output. Compare it to ?. Do we reject the null hypothesis or not? Generate the descriptive statistics (mean, standard deviation, median, and variance) for the data.
Exercise #1 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%. Do we know ? for the mpg consumption? Can we use the normal distribution for the hypothesis test? State the null and alternative hypotheses. Perform the appropriate test and print the output. Look at the p-value in the output. Compare it to ?. Do we reject the null hypothesis or not? Generate the descriptive statistics (mean, standard deviation, median, and variance) for the data.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Exercise #1
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%.
- Do we know ? for the mpg consumption? Can we use the
normal distribution for the hypothesis test? - State the null and alternative hypotheses.
- Perform the appropriate test and print the output.
- Look at the p-value in the output. Compare it to ?. Do we reject the null hypothesis or not?
- Generate the
descriptive statistics (mean, standard deviation,median , and variance) for the data.
Transcribed Image Text:32
31
15
18
24
27
Transcribed Image Text:30
35
20
18
24
13
29
27
35
23
20
27
13
31
22
33
24
25
26
21
28
25
52
25
27
25
28
28
24
49
30
24
24
37
25
25
10
24
32
28
35
29
24
27
24
29
33
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman