The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Error found

Error found

0
Votes
1
Answer

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 Answer

365 Team
0
Votes

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