Question

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 high
16	Morris	low
17	Mulder	medium
18	Ngozichi	low
19	Nickens	very high
20	Poteau	very high
21	Sakomoto	medium
22	Scully	high
23	Singh	high
24	Skinner	high
25	Suzuki	low
26	Tang	medium
27	Vu'oto	high
28	Walker	medium
29	Yap	high
30	Zindermanelino	very low

sample.

Answer 1

Creating random sample in excel is easy step. Formula for creating random sample is "=Rand()".

But each and every time random sample will get change automatically for any other change made with in excel.

So once we create random sample, we need to make the formula in the range a s values.which means you have to convert the value in to paste special value format in excel.

Please find the below image in detail.

If you are creating random sample with the formula “=Rand()” in your system , you might be getting different values. Because the allocation will be based on the random values.