Question

In: Statistics and Probability

In the third week of July, a random sample of 40 farming regions gave a sample...

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!

Solutions

Expert Solution


Related Solutions

A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.3 3.9 4.2 4.1 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.7 4.1 4.5 5.5 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.3 3.9 4.2 4.1 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.9 4.1 4.5 5.3 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.3 3.7 4.2 3.9 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.7 4.3 4.5 5.3 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population) x1: New England Crime Rate 3.5 3.7 4.2 4.1 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.9 4.3 4.5 5.1 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.5 3.7 4.0 4.1 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.7 4.3 4.7 5.3 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.3 3.7 4.0 4.1 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.7 4.3 4.7 5.3 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.4 3.6 4.0 4.1 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.8 4.5 4.4 5.5 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.5 3.9 4.0 4.1 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.7 4.3 4.5 5.3 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 x1 = 3.55 s1 = .83...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.5 3.7 4.2 3.9 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.5 4.1 4.5 5.3 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
A random sample of n1 = 10 regions in New England gave the following violent crime...
A random sample of n1 = 10 regions in New England gave the following violent crime rates (per million population). x1: New England Crime Rate 3.5 3.7 4.2 3.9 3.3 4.1 1.8 4.8 2.9 3.1 Another random sample of n2 = 12 regions in the Rocky Mountain states gave the following violent crime rates (per million population). x2: Rocky Mountain Crime Rate 3.5 4.3 4.5 5.1 3.3 4.8 3.5 2.4 3.1 3.5 5.2 2.8 Assume that the crime rate distribution...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT