This is so hard help
2 answers:
You might be interested in
Answer:
--- Population standard deviation
--- Population Variance
Step-by-step explanation:
Given: Wake-up time data
Required: Determine the population standard deviation and the population variance using Excel
First, enter the given data in Excel
For this question, I entered the data in cell A2 through cell A21
Cell B2 and Cell C2 were used to hold the results of the population standard deviation and the population variance, respectively.
In cell B2, the formula to use is:
=ROUNDUP(STDEV.P(A2:A21),3)
The round function rounds the result to 3 decimal places while STDEV.P calculates the population standard deviation.
So, the result is:
In cell C2, the formula to use is:
=ROUND(VAR.P(A2:A21),3)
The round function rounds the result to 3 decimal places while VAR.P calculates the population variance.
So, the result is:
<em>See attachment for Excel file</em>
Let 
be the larger number and 
the smaller number.
The first sentence translates to
. The second translates to 
.
Since, you can substitute this into the second equation to get
Then substituting this into the original second equation gives
The first sentence translates to
Since
Then substituting this into the original second equation gives