Can you please explain the 3 question of the practice exam.
Application of functions is easy but do I have to subtract the mean from all the datapoints first and then divide it by std deviation. It will really be helpful if there were some notes or pdfs we could refer to for better understanding.
1 answers ( 0 marked as helpful)
When standardizing you can either:
- subtract the mean and divide by the stddev.S in one formula (i.e (B3(for example) - AVERAGE(B3:B81))/STDDEV.S(B3:B81)).
- Divide the standardization process into two steps: First create a new dataset which is the result of subtracting the mean, then take each value in that dataset and divide by the stddev.
Regardless of the approach, both solutions will provide the same results.
Submit an answer
Question 1 , confused about the answer and need to understand it clearly
not showing as completed even though I have complete the course. Please help me fix it
can you explain why the last answer is the right one but not the first option???