Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose X ~ N (59, 4). Write the Excel function to find the X values associated with the following percentages: a. Highest 21 percent multiple

Suppose X ~ N(59, 4). Write the Excel function to find the X values associated with the following percentages: a. Highest 21 percent

multiple choice 1

  • =NORM.INV(79,59,4)
  • =NORMS.INV(0.79,59,4)
  • =NORM.INV(0.79,59,4)

b. Middle 56 percent multiple choice 2

  • Xupper =NORM.INV(0.22,59,4), Xlower=NORM.INV(0.79,59,4)
  • Xupper =NORM.INV(0.78,59,4), Xlower=NORM.INV(0.22,59,4)
  • Xupper =NORMS.INV(0.79,59,4), Xlower=NORMS.INV(0.22,59,4)

c. Lowest 23 percent multiple choice 3

  • =NORM.INV(0.23,59,4)
  • =NORM.INV(0.77,59,4)
  • =NORMS.INV(0.23,59,4)

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

Concepts In Practical Differential Equations

Authors: Sabita Mahanta

1st Edition

9353146488, 9789353146481

More Books

Students also viewed these Mathematics questions