Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Linear Algebra

Authors: Peter J. Olver, Cheri Shakiban

1st edition

131473824, 978-0131473829

More Books

Students also viewed these Mathematics questions