Question

A study is performed in a small town to determine whether the average weekly grocery bill for a four-person family is significantly less than national average of $185. A simple random sample of 19 weekly grocery bills for four-person families is selected from the town. The data is shown to the right. They suspect from the sample data that the small town's average grocery bill is less than the national average. That is, they want to test the hypotheses: Ho: µ ≥ $185 and Ha: µ < $185. Conduct the appropriate hypothesis test with alpha = 0.05. Show your answers to three decimal places.
								10	What is the critical value for this test? Use T.INV
								11	What is the value of the test statistic for this situation?
12	What is the p-value for this test using T.DIST

Please show excel functions or equations to arrive at the answer

Data

$154.52
$193.99
$110.01
$236.02
$194.28
$178.20
$161.84
$139.27
$214.69
$176.78
$198.18
$180.21
$144.03
$203.30
$190.66
$161.19
$213.89
$159.93
$188.57

Answer 1