Question
- This problem is incorrect. Your job is to find the errors, correct the errors, and explain what they did wrong. If the area under
- This problem is incorrect. Your job is to find the errors, correct the errors, and explain what they did wrong.
If the area under the standard normal distribution curve is 0.0968 from the right, what is the corresponding z-score?
Student's incorrect answer:
We plug in "=NORM.S.INV(0.0968)" into Excel and get a z-score of -1.3.
Identify where the student went wrong when solving the problem above. Show how to correctly calculate the answer using Excel in the area to the right of this text box. Finish the problem by stating how to correctly set up the problem and solve it below.
You must provide all formulas used in EXCEL and an Explanation, Please! Thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started