using excel find the variance of a sample of 30 observations selected randomly. Given that the median is 14.7, the mode is 11 and the coefficientof variation is 45%.

To find the variance of a sample of 30 observations using Excel, you will need the data set of the observations. However, you haven't provided the actual data set in your question. The median, mode, and coefficient of variation are related to the data set but are not sufficient to calculate the variance directly.

The variance is a measure of how spread out the data points are from the mean. It quantifies the variability in the data set. To calculate the variance, you need to have the individual values of all the observations.

Once you have the data set, follow these steps in Excel to calculate the variance:

1. Enter the 30 observations into a column in Excel. Let's say you enter them in cells A1 to A30.
2. In an empty cell, enter the formula "=VAR.S(A1:A30)" if you want to calculate the sample variance or "=VAR.P(A1:A30)" if you want to calculate the population variance.
3. Press Enter, and Excel will calculate the variance for you.

Keep in mind that the median, mode, and coefficient of variation are separate measures and may not directly correspond to the variance.