Question

In: Statistics and Probability

Compute in excel A random sample of six cars from a particular model year had the...

Compute in excel

A random sample of six cars from a particular model year had the fuel consumption figures, measure in miles per gallon, shown below. (i) Using T.INV, find a 90% confidence interval for the population mean of fuel consumption for cars of this model year. Assume the distribution is normal. (Round to 2 digits, since our raw data below are expressed with one digit.) (Show work in space provided.) (ii) Calculate the same interval using CONFIDENCE.T. (Show work in space provided.) (iii) Calculate the same interval using T.INV.2T. (Note: when calculating the lower and upper bounds of the interval, do not use a rounded mean that you’ve calculated with AVERAGE. Use the unrounded mean. Round only the final answers, which are the lower and upper bounds of the interval. Also, make sure to use STDEV.S to calculate the sample standard deviation.) Data: 28.6 18.4 19.2 25.8 19.4 20.5

Solutions

Expert Solution

(i)

Step 1: Store the data in C4:C9

Step 2: Find sample mean using "=AVERAGE(C4:C9)"

Step 3: Find sample sd using "=STDEV.S(C4:C9)"

Step 4: Find t(0.05,5) using "=T.INV(0.95,5)"

Step 5: Find margin of error using "=F6*F5/SQRT(F3)"

Step 6:

90% confidence interval for the population mean:

Find lower limit using "=ROUND(F4-F7,2)"

Find upper limit using "=ROUND(F4+F7,2)"

90% confidence interval for the population mean of fuel consumption for cars

=(18.54 miles per gallon , 25.43 miles per gallon )

(ii)

Step 1: Store the data in C4:C9

Step 2: Find sample mean using "=AVERAGE(C4:C9)"

Step 3: Find sample sd using "=STDEV.S(C4:C9)"

Step 4: Find margin of error using "=CONFIDENCE.T(0.1,F5,F3)"

Step 5:

90% confidence interval for the population mean:

Find lower limit using "=ROUND(F4-F14,2)"

Find upper limit using "=ROUND(F4+F14,2)"

90% confidence interval for the population mean of fuel consumption for cars

=(18.54 miles per gallon , 25.43 miles per gallon )

(iii)

Step 1: Store the data in C4:C9

Step 2: Find sample mean using "=AVERAGE(C4:C9)"

Step 3: Find sample sd using "=STDEV.S(C4:C9)"

Step 4: Find t(0.05,5) using ""=T.INV.2T(0.1,5)""

Step 5: Find margin of error using "=F21*F5/SQRT(F3)"

Step 6:

90% confidence interval for the population mean:

Find lower limit using "=ROUND(F4-F22,2)"

Find upper limit using "=ROUND(F4+F22,2)"

90% confidence interval for the population mean of fuel consumption for cars

=(18.54 miles per gallon , 25.43 miles per gallon )

Excel File:


Related Solutions

Use Excel to Answer. A random sample of six cars from a particular model year had...
Use Excel to Answer. A random sample of six cars from a particular model year had the fuel consumption figures, measure in miles per gallon, shown below. Using T.INV, find a 90% confidence interval for the population mean of fuel consumption for cars of this model year. Assume the distribution is normal.   (Round to 2 digits, since our raw data below are expressed with one digit.) (Show work in space provided.) (ii) Calculate the same interval using CONFIDENCE.T. (Show work...
A random sample of six cars from a particular model year had the following fuel consumption...
A random sample of six cars from a particular model year had the following fuel consumption figures (in miles per gallon). Find the 98% confidence interval for the true mean fuel consumption for cars of this model year. Sample Data 18.6 19.3 19.4 19.8 19.6 19.7 What is the left and right endpoint? Please help
A random sample of six cars from a particular model year had the following fuel consumption...
A random sample of six cars from a particular model year had the following fuel consumption figures ( in miles per gallon). find the 98% confidence interval for the true mean fuel consumption for cars of this model year. Sample Data: 19.3 , 18.5 , 18.4 , 20.9 , 20.7 , 18.7 Left Endpoint _____ Right Endpoint _____
A random sample of 6 cars from a particular model year had the following fuel consumption...
A random sample of 6 cars from a particular model year had the following fuel consumption figures (in miles per gallon). Find the 99% confidence interval for the true mean fuel consumption for cars of this model year. Sample data: 20.9, 18.1, 18.5, 21, 20.3, 20.2 find left endpoint & right endpoint.
A random sample of six cars from a particular model year had the fuel consumption figures, measure in miles per gallon, shown below.
  A random sample of six cars from a particular model year had the fuel consumption figures, measure in miles per gallon, shown below.   Using T.INV, find a 90% confidence interval for the population mean of fuel consumption for cars of this model year. Assume the distribution is normal.   (Round to 2 digits, since our raw data below are expressed with one digit.) (Show work in space provided.)   (ii) Calculate the same interval using CONFIDENCE.T. (Show work in...
We consider a population of cars from a given model year. A sample of 24 such...
We consider a population of cars from a given model year. A sample of 24 such cars has been recently sold. The sale price as a function of the age of the car is in the Excel file S4.XLSX (Car) in the Excel directory. a. Try a linear regression and an exponential (non-linear) regression with Excel to fit these data. Comment your results. b. Which regression model seems to fit the data better and why? c. Run the LINEST function...
Consider a random sample of 15 cars of the same model. Assume that the gas mileage...
Consider a random sample of 15 cars of the same model. Assume that the gas mileage for the population is normally distributed with a standard deviation of 5.2 miles per gallon. Calculate a 90% confidence interval for the mean, given a sample mean of 26.7 miles per gallon.
A random sample of 9 automobiles of a particular model has a mean of 32 mpg...
A random sample of 9 automobiles of a particular model has a mean of 32 mpg and a standard deviation of 10 mpg. Assume gas mileages are normally distributed. Use this information to compute a 95% confidence interval for the mean miles per gallon obtained by all automobiles of this type. Round your confidence interval values to the nearest whole number (Do NOT use any decimals in your answer). The left endpoint of the confidence interval is  , and the right...
A random sample of 28 students at a particular university had a mean age of 22.4...
A random sample of 28 students at a particular university had a mean age of 22.4 years. If the standard deviation of ages for all university students is known to be 3.1 years ,Find a 90% confidence interval for the mean of all students at that university.
1. A random sample of 28 students at a particular university had a mean age of...
1. A random sample of 28 students at a particular university had a mean age of 22.4 years. If the standard deviation of ages for all university students is known to be 3.1 years,Find a 90% confidence interval for the mean of all students at that university. SHOW WORK
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT