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
Asked Sep 30, 2019
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

Expert Answer

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

Check out a sample Q&A here.

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

Math

Statistics

Other

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: b. The table below represents the results of gender prediction from an ultrasound   Predicted ...

A: Conditional rule:The formula for probability of A given B is,

question_answer

Q: Daily anxiety was measured on a scale from 1 (not at all anxious) to 5 (very anxious) in a random sa...

A: Interpretation:The 95% confidence interval can be interpreted as follows:One can be 95% confident th...

question_answer

Q: figure the standard deviation of the distribution of means for a population with a standard deviatio...

A: Population standard deviation is given and sample standard deviations have to be calculated for diff...

question_answer

Q: I Need help with answering question 2 and 3. To conclude from the table given, there is a big differ...

A: When the null hypothesis is rejected, we go with the Post-Hoc tests to check which pairs of treatmen...

question_answer

Q: On a measure of artistic ability, the men for college students in new zealand is 150 and tthe standa...

A: Given mean = 150Standard deviation = 25The Z score is calculated using the below mentioned formula a...

question_answer

Q: Suppose that a random variable z has a standard normal distribution. Use a standard normal table suc...

A: It is provided that a random variable Z has a standard normal distribution.Thus,

question_answer

Q: According to the empirical (68-95-99.7) rule, if a random variable ?z has a standard normal distribu...

A: From the given information, confidence level is 95%.Normal distribution is a symmetrical distributio...

question_answer

Q: Research has shown that approximately 1 woman in 700 carries a mutation of a particular gene. About ...

A: We are given,Research has shown that approximately 1 woman in 700 carries a mutation of a particular...

question_answer

Q: What proportion of a normal distribution is located in the tail beyond z = –1.00?​

A: It is given that the z-score is –1.00.