Question

The owner of a grocery store wanted to determine whether the average customer bought more than $100 worth of food. she randomly selected 20 receipts and identified the total spent by each customer. the totals (rounded to the nearest dollar) are given below the owner conducts a one-mean hypothesis at the 5% significance level, to test if the average customer bought more than $100 worth of food. for this test: h0:μ=$100; ha:μ>$100, which is a right-tailed test. amount (in dollars) of money spent on food is given below. use excel to test whether the mean is greater than $100. identify the test statistic, t and p-value from the excel output, rounding to two decimal places.

Answer 1

To test whether the average customer bought more than $100 worth of food, perform a one-sample t-test and use Excel to obtain the test statistic t and p-value.

Step-by-step explanation:

To test whether the average customer bought more than $100 worth of food, we can perform a one-sample t-test. We will compare the sample mean to the hypothesized mean of $100. The test statistic t and p-value can be obtained using Excel. First, calculate the sample mean and sample standard deviation of the 20 receipts. Then, use the T.TEST function in Excel to calculate the test statistic t and p-value. Finally, round the test statistic t and p-value to two decimal places.