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 |

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...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

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,

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...

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...

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...

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...

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,

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...

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...

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.