Copy of You are given the following dataset: 2,45,34,25,6,45,67,89. Using Excel’
ID: 426924 • Letter: C
Question
Copy of
You are given the following dataset: 2,45,34,25,6,45,67,89. Using Excel’s statistical functions, calculate the standard devation.
29.3619651930861
39.125
862.125
d. 39.5
You are given the following dataset: 2,45,34,25,6,45,67,89. Using Excel’s statistical functions, calculate the sample variance
29.3619651930861
39.125
862.125
39.5
Is the median equal to the mean? Why or why not?
Copy of
You are given the following dataset: 2,45,34,25,6,45,67,89. Using Excel’s statistical functions, calculate the standard devation.
a.29.3619651930861
b.39.125
c.862.125
.d. 39.5
You are given the following dataset: 2,45,34,25,6,45,67,89. Using Excel’s statistical functions, calculate the sample variance
a.29.3619651930861
b.39.125
c.862.125
d.39.5
Is the median equal to the mean? Why or why not?
Explanation / Answer
1. By using Excel’s statistical function, “STDEV”, the standard deviation is 29.3619651930861. Hence the correct option is A.
2. By using Excel’s statistical function, “VAR, the variance is 862.125. Hence the correct option C.
Mean can only be equal to median when the data is symmetrically distributed. Here data is random and therefore median will not be equal to mean.