Question

b. Use Excel to select a random sample of 5 days in June 2017 and calculate...

b. Use Excel to select a random sample of 5 days in June 2017 and calculate the sample mean. Calculate the sampling error.

Homework Answers

Answer #1

b:

There are 30 days in June. We need to generate 5 numbers between 1 and 30. Using excel function "=RANDBETWEEN(1,30)" , following are the selected days and calculations for mean and SD:

X (X-mean)^2
22 1.44
16 23.04
29 67.24
27 38.44
10 116.64
Total 104 246.8

The mean is

The standard deviation is

The sampling error is

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Gather information from Table C6-1 relating to room rentals in June of 2017. -Calculate the population...
Gather information from Table C6-1 relating to room rentals in June of 2017. -Calculate the population mean for daily rooms rented in June, 2017. Calculate the standard deviation. -Use Excel to select a random sample of 5 days in June 2017 and calculate the sample mean. Calculate the sampling error. -Use Excel to select 2 more random samples, calculate the sample mean for each, and calculate the sampling error for each sample. Date Rooms Rented 1-Jun 30 2-Jun 36 3-Jun...
c.Use Excel to select 2 more random samples, calculate the sample mean for each, and calculate...
c.Use Excel to select 2 more random samples, calculate the sample mean for each, and calculate the sampling error for each TABLE C6-2: Customer Satisfaction Customer Number Customer Name Satisfaction Level 1 Anderson Very high 2 Angero high 3 Ball medium 4 Bobak low 5 Chontos high 6 Detley very low 7 Hetfield very high 8 Iruja medium 9 Jamesson high 10 Kemp medium 11 Lehmann high 12 Lee high 13 Lewins low 14 Luo very high 15 Madras very...
In a clinic, a random sample of 100 days are used to calculate the number of...
In a clinic, a random sample of 100 days are used to calculate the number of patients seen per day. The mean is 125 patients with a standard deviation of 30 patients. The standard error of the mean is 3. The 95% confidence interval will be between which two values? A. Between 122 and 128 patients B. Between 66 and 184 patients C. Between 119 and 131 patients D. Between 95 and 155 patients
A random sample of 16 passengers between the two airports flying by ABC Airlines yielded a...
A random sample of 16 passengers between the two airports flying by ABC Airlines yielded a mean fare of $172. The population standard deviation of the fare is known to be $37. Part A: What are the Mean and Standard Deviation of the sampling distribution of “Mean Fare” between the two airports? (Please use excel and show formulas used) Part B: Calculate Margin of Error at 93.5% confidence. Calculate the 93.5% Confidence Interval on the fare between the two airports...
(a). A simple random sample of 37 days was selected. For these 37 days, Parsnip was...
(a). A simple random sample of 37 days was selected. For these 37 days, Parsnip was fed seeds on 22 days and Parsnip was fed pellets on the other 15 days. The goal is to calculate a 99% confidence interval for the proportion of all days in which Parsnip was fed seeds, and to do so there are two assumptions. The first is that there is a simple random sample, which is satisfied. What is the second assumption, and specific...
(a). A simple random sample of 37 days was selected. For these 37 days, Parsnip was...
(a). A simple random sample of 37 days was selected. For these 37 days, Parsnip was fed seeds on 22 days and Parsnip was fed pellets on the other 15 days. The goal is to calculate a 99% confidence interval for the proportion of all days in which Parsnip was fed seeds, and to do so there are two assumptions. The first is that there is a simple random sample, which is satisfied. What is the second assumption, and specific...
A random sample of 16 winter days in Denver gave a sample mean pollution index of...
A random sample of 16 winter days in Denver gave a sample mean pollution index of 43 with a standard deviation of 16. For Englewood (a suburb of Denver), a random sample of 17 winter days gave a sample mean pollution index of 51 with a standard deviation of 13. Do these data indicate that the mean population pollution index of Englewood is different (either way) from that of Denver in the winter? Use a 1% level of significance. show...
From a random sample of 75 business days from January 4th, 2010, through February 24th, 2017,...
From a random sample of 75 business days from January 4th, 2010, through February 24th, 2017, Russian silver prices had a mean of $3,338.48 and σ= $205.61 was the population standard deviation of silver prices. Construct a 90% confidence interval for the true population mean μ and interpret this interval.
A realtor has 20 residential listings under contract. The following table shows the number of days...
A realtor has 20 residential listings under contract. The following table shows the number of days each of these 20 houses has been on the market as of today. Use the data to complete parts a through e below. 25 23 1 19 32 23 44 50 55 22 44 53 49 14 41 10 36 65 23 70 a. Calculate the mean for this population. muequals ?(Type an integer or a? decimal.) b. Calculate the sampling error using the...
2) A random sample of ?? = 15 summer days in Los Angeles gave a sample...
2) A random sample of ?? = 15 summer days in Los Angeles gave a sample mean pollution index of ?? = 40. Previous studies show that ?? = 15. For San Francisco, a random sample of ?? = 19 summer days gave a sample mean pollution index of ?? = 44. Previous studies show that ?? = 12. Assume the pollution index is normally distributed. Do these data indicate the mean population pollution index of San Francisco is different...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT