Here, the idea is for you to scale yourself to understand how the Central Limit Theorem works by seeing how a histogram of observations of sample mean values is affected by the sample size. In Excel you can generate observations of uniform discrete random variables that take values 0,1,2 using the command = RANDOM (BETWEEN (0; 2) in Swedish-languageExcel or = RANDBETWEEN (0; 2) in English-languageExcel.A such random variable, call it, has the probability distribution ( = 0) = ( = 1) = ( = 2) = 1/3. Based on the probability distribution for the random variable Xovan, calculate the expectation value and the standard deviation for the random variable X.

Create 100 standardized (ie subtract and divide by ) sample mean values, each based on sample size 2 and make histograms for the 100 standardized sample mean values. Repeat the procedure for the sample sizes 5,10,20 and 40. Tip: Make an Excel sheet for each sample size, ie a sheet with 100 sample averages based on sample size 2, a sheet with 100 sample averages based on samples of size 5o.sv. ..The histograms must be included in the report and it must be clear which sample sizes have been used for the sample mean values on which the histograms are based. *