June 12345 6 789 9 10 Rentals 2 3 2 3 4 2347 2 June 11 12 13 14 15 16 17 18 19 20 Rentals 3 444 TOM 62 7 5 3 June 21 22 23 24 25 26 27 28 29 30 Rentals 3 2 3 6 4 1 1 3 3 1) Use Excel to select a sample of five of the nights during the month. 2) The variable of interest is the number of rooms rented each of the 30 nights in June. Find the mean of the population. 3) Use Excel to select three random samples of five nights. 4) Calculate the mean of each sample and compare it to the population mean. 5) What is the sampling error in each case?

1) Use Excel to select a sample of five of the nights during the month. 2) The variable of interest is the number of rooms rented each of the 30 nights in June. Find the mean of the population. 3) Use Excel to select three random samples of five nights. 4) Calculate the mean of each sample and compare it to the population mean. 5) What is the sampling error in each case