Използване на симулации в средата на MS Excel за определяне на оценкиte на математическото очакване и дисперсията
Using Simulations in Excel to Evaluate the Estimators of the Expectation and the Variance

Author(s): Deyan Mihaylov
Subject(s): Economy, ICT Information and Communications Technologies
Published by: Икономически университет - Варна
Keywords: MS Excel; Re-sample; Simulations; Unbiased Estimators
Summary/Abstract: Unbiased estimators of the expected value and the variance are well known in statistical theory. This paper presents an approach for experimental validation of the theoretical formulas. It is assumed that we have the entire population or a representative sample and the expected value and fhe variance are known. Re-samples are taken from the population and for each re-sample mean values, biased and unbiased estimates of variance are calculated. The experiment shows that the mean of sample variance is equal to the population variance. The re-samples are simulated in MS Excel.

• Details
• Contents