Question

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	49
4-Jun	48
5-Jun	27
6-Jun	29
7-Jun	29
8-Jun	34
9-Jun	37
10-Jun	51
11-Jun	59
12-Jun	49
13-Jun	37
14-Jun	40
15-Jun	44
16-Jun	47
17-Jun	59
18-Jun	62
19-Jun	50
20-Jun	41
21-Jun	46
22-Jun	40
23-Jun	50
24-Jun	58
25-Jun	64
26-Jun	60
27-Jun	57
28-Jun	51
29-Jun	43
30-Jun	47

Answer 1

• The mean is given by= =1374/30=45.8
• The standard deviation is given by==10.49598
• The random sample selected by excel is as follows
• The below random sample has been selected as by using rand() function and sorting it on that column.

• 30

  48

  60

  41

  40

• Similary we wil calculate mean =43.8 and standard error is given by==6.94
• where 123.3 is the variance of the random sample sample
• similarly we will select other two samples and sort on it
• 2nd sample

  59

  58

  62

  51

  43

• mean=54.6 and sampling error==4.78.
• 3rd sample=

  29

  44

  46

  59

  37

• mean=43and sampling error is given by =6.98