Formula=IF(RAND()>0.5,T.INV(RAND(),10)-2,T.INV(RAND(),10)+2 observation sample 1 1 1.37700278 2 1.827378045 3 3.479013387 4 1.382604626 5 2.572039451 6 2.38234939 7 0.240414349 8 -1.347432349 9 2.85777933 10 -3.379978992 11 -2.746482213 12 1.886442756 13 -1.947527669 14 1.540754548 15 -0.233174876 16 -1.104079702 17 -1.226712691 18 3.300631732 19 0.940368484 20 -1.845113569 21 -1.250733918 22 -1.392547733 23 2.478557615 24 0.823135564 25 1.630991977 sample mean 0.489827213 Use the excel spreadsheet to simulate 1000 samples of size 25 by copying cells C:3...

70.2K

Verified Solution

Question

Statistics

Formula=IF(RAND()>0.5,T.INV(RAND(),10)-2,T.INV(RAND(),10)+2
observation sample 1
1 1.37700278
2 1.827378045
3 3.479013387
4 1.382604626
5 2.572039451
6 2.38234939
7 0.240414349
8 -1.347432349
9 2.85777933
10 -3.379978992
11 -2.746482213
12 1.886442756
13 -1.947527669
14 1.540754548
15 -0.233174876
16 -1.104079702
17 -1.226712691
18 3.300631732
19 0.940368484
20 -1.845113569
21 -1.250733918
22 -1.392547733
23 2.478557615
24 0.823135564
25 1.630991977
samplemean 0.489827213
Use the excel spreadsheet to simulate 1000 samples of size 25 bycopying cells C:3 through C:27 and pasting into rows 3 through 27in the adjacent columns. For each sample calculate the sample mean.Then in row 28 you obtain a sample of sample means. If you copy andpaste these into the column â€œsample of sample meansâ€ (starting withcell c:31) then the histogram counts will be automaticallyproduced. (Using copy special and the â€œvaluesâ€ and â€œtransposeâ€options.) Plug these counts into a bar chart to get a histogram.Submit only your histogram. Then create a second histogram by usingonly observations 1 through 8 for each sample (instead of using all25 observations). How do the two histograms differ?

Answer & Explanation Solved by verified expert

3.7 Ratings (364 Votes)

The image on the left is the histogram by using observations 1to 8 while the histogram on the right is histogram by using all 25observationSince the the See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

observation	sample 1
1	1.37700278
2	1.827378045
3	3.479013387
4	1.382604626
5	2.572039451
6	2.38234939
7	0.240414349
8	-1.347432349
9	2.85777933
10	-3.379978992
11	-2.746482213
12	1.886442756
13	-1.947527669
14	1.540754548
15	-0.233174876
16	-1.104079702
17	-1.226712691
18	3.300631732
19	0.940368484
20	-1.845113569
21	-1.250733918
22	-1.392547733
23	2.478557615
24	0.823135564
25	1.630991977
samplemean	0.489827213