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

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:

Scenario: You have put together a time-series data set that includes numerous financial and economic variables. The data runs quarterly from the years 2000 through 2016. Before doing more complex...

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:

9/14/10 12:39 PM Page 381 Chapter dug84356_ch06a.qxd 6 Rational Expressions Advanced technical developments have made sports equipment faster, lighter, and more responsive to the human body. Behind...

Q:

Hi There, I need someone to help me with the attached finance worksheet. There are 3 problems in this excel file - one problem on each individual tab. I am attaching a couple of additional files as...

Q:

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

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:

Can someone assist with any of these questions below: Question 1.The time required to play a certain game is uniformly distributed between 30 and 52 minutes. Complete parts a through c below. a. Find...

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:

Dear Friends, I need the solution by today 11.00 PM. Its really important. I dont have lot of funds. I can only pay $10. Max Harvard Business School 9-292-140 June 12, 1992 Arundel Partners: The...

Q:

Supervisor Vic Sower at Huntsville Equipment Company is concerned that material is not arriving as promptly as needed at work cells. A new kanban system has been installed, but there seems to be some...

Q:

Differentiate which are the current assets and which are the current liabilities from this balance sheet (please list them under current assets and current liabilities).

Q:

4. The demand for an item is 20,000 units per year. The item can be produced at the rate of 4000 per month. The set-up cost is Rs 3000 per cycle and the inventory carrying cost is Re 0.40 per unit...

Q:

Inside / Out Hotels wishes to establish a unique position in the competitive hotel industry by prioritizing sustainability, technology, and outstanding guest experiences. Among its concepts, the...

Q:

What are the advantages and disadvantages of seeking an external candidate as part of a succession plan?

Q:

Succession planning is very uncommon among public health organizations. What are some reasons for this? In your opinion, are these reasons valid?

Q:

Succession planning is widely practiced in industry. It is fairly common among large hospitals and medical centers. In your opinion, why is this so?