Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose X ~ N(51, 3). Write the Excel function to find the X values associated with the following percentages: a. Highest 24 percent multiple choice
Suppose X ~ N(51, 3). Write the Excel function to find the X values associated with the following percentages:
a. Highest 24 percent multiple choice 1 =NORMS.INV(0.76,51,3) =NORM.INV(0.76,51,3) =NORM.INV(76,51,3)
b. Middle 58 percent multiple choice 2
Xupper =NORMS.INV(0.21,51,3), Xlower =NORMS.INV(0.76,51,3)
Xupper =NORM.INV(0.76,51,3), Xlower =NORM.INV(0.21,51,3)
Xupper =NORM.INV(0.79,51,3), Xlower =NORM.INV(0.21,51,3)
c. Lowest 18 percent multiple choice 3
=NORM.INV(0.18,51,3) =
NORMS.INV(0.82,51,3) =
NORM.INV(0.18,51,3)
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