Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are asked to find the area under the standard normal curve to the left of z = -0.89. Open a new Excel worksheet and
You are asked to find the area under the standard normal curve to the left of z = -0.89. Open a new Excel worksheet and click in cell A1 to place the output there. At the top of the screen, click Formulas and select Insert Function. Select the Statistical category. Select the NORM.S.DIST function. Click OK The answer, 0.186733 , is displayed in cell A1 of the worksheet. Notice the equation in the formula bar to the right of fx, = 1- NORMSDIST(-0.89,TRUE). The answer display in B1 =0.813267 Question 1 Use Excel sheet and submit the work on the Excel sheet to find the area on the left in A1 and area on the right in B1 z Area on the left Area on the right 1.4 2.5 1.3 -0.75 -0.84 -0.68 -1.5
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