Use a Spreadsheet to Calculate the Variances and Standard Deviations

question 10

Essay

Use a spreadsheet to calculate the variances and standard deviations of the expected
returns for the following two securities as well as the covariance of the two securities
returns: Assume all scenarios are equally likely to occur.

---

Definitions:

Obtained Value

The real outcome or result attained through a statistical examination or experiment.

Within-groups Df

Degrees of freedom within groups in an analysis of variance (ANOVA), related to the variability of observations within each group.

Between-groups Df

Degrees of freedom associated with the variance between the groups in an ANOVA test, useful in determining the variability attributable to the difference between groups.

Simple Analysis of Variance

A statistical method used to compare the means of two or more groups to see if there is a significant difference between them.