In: Statistics and Probability
In the third week of July, a random sample of 40 farming regions gave a sample mean of $6.88 per 100 pounds of watermelon. Assume that sigma is known to be $1.92 per 100 pounds. Find a 90% confidence interval for the population mean price per 100 pounds that farmers in this region get for their watermelon crop.
Find each of the following:
| x-bar |
| std dev |
| n |
| Confidence Level |
| Margin of Error |
| Point Estimate |
| Lower Limit |
| Upper Limit |
Interpret the confidence interval in the context of the problem.
Please give excel functions used. Thank you for your help!