11 X fx =@INDIRECT("|"& RANDBETWEEN(11, 18)) A B C D E G H K M N O P R S Parameters of the sampling distribution Now, we will study the parameters of the distribution of Xbar (the so-called sampling distribution of the mean) for large samples. To do this, we'll generate 1000 random samples of size 100 each. For all practical purposes, we may assume that such a large sample of values from Xbar IS the population of Xbar, the population of all the sample means with 100 elements. Here is how you can draw a sample. For illustration, below is an example where I select a random sample of 3 elements from the population {1,2,3,4,5,6,7,8). The population is stored in column | between rows 11 and 18. To draw a random sample of 3 elements from the illutsrative population, I generated a random integer x betweem 11 and 18 (this is achieved by the function: randbetween(11,18). The random element drawn is supposed to be the content of the cell I:x. To access that content (this is called indirect access), I used the function: =indirect("l"& randbetween(11,18.)). Now, do this to select 1000 random samples of 100 elements each in the Poisson population P of Part1-Q1 and compute their means. You will generate then 1000 random means. This IS the population of Xbar. Show all your samples on a separate Sheet Called "Sampling Distribution" Population Sample meanofsample 4 8 3 51 What's the mean of Xbar? What's the standard deviation of Xbar? DO VO UI A W N H mean of Xbar=mu(Xbar)= standard deviation of Xbar=sigma(Xbar)= In theory, the standard deviation of Xbar should be 1/sqrt(100)th smaller than the standard deviation of the population P. Can you confirm this