Error found
in this file :
3.9. Population variance known, z-score_exercise_solution.xlsx
https://www.filepicker.io/api/file/wTJ2o2jMRpOgGxTsuPjR
the following equations missing parenthesis when calculating confidence interval :
=E15-E17*E19
=E15+E17*E19
it should be :
=E15-(E17*E19)
=E15+(E17*E19)
1 answers ( 0 marked as helpful)
Hi Hamada,
Thanks for reaching out.
When you have a mathematical equation or a formula in Excel, multiplication and division are prioritized.
Therefore, even without the brackets, E17*E19 will be executed before the plus/minus sign.
Best,
The 365 Team
The 365 Team