Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

1) Suppose that instead of shareholders borrowing $463 from the company in 1995. They take out the same amount as additional dividends in the same year . After this change, what is the $ value...

Q:

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Q:

BA 1605: Midterm Recap (Due: Feb. 27, 2015) Name _____________________________ 50 Student ID _____________________________ Section 01B 10:00~11:20 am Section 02B 01:00~02:20 pm [Questions 4 ~ 7] The...

Q:

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

Q:

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Q:

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Q:

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Q:

STATISTICS FOR DECISION MAKING Dr. Azar Abizada HOMEWORK 4 Due Date: Wednesday, March 11th class time Problem 1 (26 points): Be careful, each part of this question is independent of one another. a)...

Q:

Final Exam - MGMT 650 Fall 2016 Directions: Please answer all questions. There are 30 questions and the exam is worth 20% of your total grade. The questions are not equally weighted. The point value...

Q:

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

Q:

Change of heat content when one mole of the compound is burnt in oxygen at constant pressure is called calorific value heat of reaction heat of combustion heat of formation Fundamental principle of...

Q:

Referring to the situation described in Miscellanea 2.6.3: (a) Plot the pdfs f1 and f2 to illustrate their difference. (b) Plot the cumulant generating functions K1 and K2 to illustrate their...

Q:

When planning a five day trip and making a decision to drive or take the train the cost of boarding your dog while you are away is a blank sunk relevant opportunity irrelevant

Q:

how can traditional mail stop losing money with business intelligence systems? Explain

Q:

12. The form of creative action strategy, where would you say you have a strength, as a dreamer, as a realist or as a critic?

Q:

16. Now put the areas you have ranked in order of priority and reflect on which values they correspond to in your value hierarchy.

Q:

14. Now reconcile what you answered to problem 15 with problem 13.