A tax assessor wants to assess the mean property tax bill for all homeowners in a certain state. From a survey ten years ago, a sample of 28 property tax bills is given below. Assume the property tax bills are approximately normally distributed. Use Excel to construct a 95% confidence interval for the population mean property tax bill. Round your answers to two decimal places and use increasing order.1715.351157.82651.11093.361609.221391.471398.89402.991028.761571.23529.421579.48699.562222.16838.6866.411066.61498.641784.282016.992465.651098.811346.6515741447.782018.332156.751710.81

Question
45 views

A tax assessor wants to assess the mean property tax bill for all homeowners in a certain state. From a survey ten years ago, a sample of 28 property tax bills is given below. Assume the property tax bills are approximately normally distributed. Use Excel to construct a 95% confidence interval for the population mean property tax bill. Round your answers to two decimal places and use increasing order.

 1715.35 1157.82 651.1 1093.36 1609.22 1391.47 1398.89 402.99 1028.76 1571.23 529.42 1579.48 699.56 2222.16 838.6 866.41 1066.6 1498.64 1784.28 2016.99 2465.65 1098.81 1346.65 1574 1447.78 2018.33 2156.75 1710.81
check_circle

Step 1

Preliminary calculations:

Using the excel formula, “=AVERAGE(A1:A28)” mean, x-bar is obtained as 1,390.754.

Using the excel formula, “=STDEV.S(A1:A28)” standard deviation, s is obtained as 528.266.

Us...

Want to see the full answer?

See Solution

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in