In a city, 22 coffee shops are randomly selected, and the temperature of the coffee sold at each shop is noted. use excel to find the 90% confidence interval for the population mean temperature. assume the temperatures are approximately normally distributed. round your answers totwo decimal places and use increasing order. temperature 151 158 163 155 155 144 140 148 145 146 158 143 152 167 163 147 170 168 176 164

The confidence interval is (152.03, 159.77)

Step-by-step explanation:

The formula for calculating the confidence interval for a population mean is given by:

The sample size is actually .

The sample average is .

Using excel to calculate the standard deviation we get

The confidence level is therefore

We obtain the critical value

In Excel I calculated the margin error before calculating the confidence interval. The margin error is given by:

Now we can calculate the confidence interval.

english, cause i can’t you