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

Back to all questions

Error found

2 weeks ago
Vote Up Vote Down
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 2 weeks ago
Vote Up Vote Down
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

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #.