Question

Make in Excel three tables size 50 times 50, 250 times 50, 1000 times 50 with Bernoulli distributed random numbers for p(1) = 1/3. Use the generated tables for calculating new column as t he average of the first 50 columns. Random numbers in this column will have distribution close to the Normal distribution. Find population probability distribution functions, means, variances and standard deviations and compare its with sample frequency distribution functions, averages, sample estimation of variances and standard deviations for each table. Draw the graphs. Estimate mean and variance for the random variables in the obtained samples using 90% confidence intervals. For estimation of the variance use estimated mean obtained from the sample, and population mean mu = 1/3, compare the obtained confidence intervals. Recalculate the tables 10 times and determine how many times the population mean mu and sigma^2 don't belong to the obtained confident intervals for the both cases of estimations.

I know how to set up the tables in excel but I need to know how to determine the Population mean, variance, and standard deviation.

Answer 1

ANSWER::

Column1
Mean	0.3016
Standard Error	0.010394
Median	0.3
Mode	0.3
Standard Deviation	0.073495
Sample Variance	0.005401
Kurtosis	0.707045
Skewness	0.514588
Range	0.36
Minimum	0.16
Maximum	0.52
Sum	15.08
Count	50
Confidence Level(90.0%)	0.017426

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU