in this file :
3.9. Population variance known, z-score_exercise_solution.xlsx
the following equations missing parenthesis when calculating confidence interval :
it should be :
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.
The 365 Team