matteo is continuing his calculations for his weekly expenses. what value will go into cell d14? calculating…
matteo is continuing his calculations for his weekly expenses. what value will go into cell d14? calculating standard deviation expenses data
Answer
Explanation:
Step1: Recall the formula for variance
Variance $s^{2}=\frac{\sum_{i = 1}^{n}(x_{i}-\bar{x})^{2}}{n}$, where $\sum_{i = 1}^{n}(x_{i}-\bar{x})^{2}$ is the sum of the squared - differences from the mean and $n$ is the number of data points. Cell D14 is the sum of the values in column D, which is used to calculate the variance.
Step2: Identify the sum value
The sum of the values in column D (the squared differences from the mean) is 70.
Answer:
70