Answered step by step
Verified Expert Solution
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
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