Question: Suppose X ~ N (59, 7). Write the Excel function to calculate the following probabilities: a. P ( X < 58.3) multiple choice 1 =NORM.DIST(58.3,59,7,0)

Suppose X ~ N(59, 7). Write the Excel function to calculate the following probabilities: a. P(X < 58.3) multiple choice 1

  • =NORM.DIST(58.3,59,7,0)
  • =NORM.DIST(58.3,59,7,1)
  • =NORM.DIST(59,58.3,7,1)

b. P(X 63.8) multiple choice 2

  • =NORM.DIST(63.8,59,7,1)
  • =1NORM.DIST(63.8,59,7,1)
  • =1NORM.DIST(63.8,59,7,0)

c. P(55.7 X < 64.4) multiple choice 3

  • =NORMS.DIST(64.4,59,7,1) NORM.DIST(55.7,59,7,1)
  • =NORMS.DIST(64.4,59,7,0) NORMS.DIST(55.7,59,7,0)
  • =NORM.DIST(64.4,59,7,1) NORM.DIST(55.7,59,7,1)

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:

Use EXCEL only please, also make a data analyst excel file thanks! EntertainmentTech Research Analyst - 50% You have been hired to work as a research analyst at Entertainment Tech. EntertainmentTech...

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:

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:

You own a small storefront retail business and are interested in determining the average amount of money a typical customer spends per visit to your store. You take a random sample over the course of...

Q:

Hey please I just need you to show steps like how to do them because I dont know how to do it. PLEASE EXPLAIN LIKE YOURE EXPLAINING TO SOMEONE WHO NEVER USED EXCEL THANKS. STEPS 2-31. Step...

Q:

1. A player throws a fair die and simultaneously flips a fair coin. If the coin lands heads, then she wins twice, and if tails, then one-half of the value that appears on the die. Determine her...

Q:

Week 4 Homework Assignment This assignment is due by 6 p.m. eastern time on Sunday, September 17.When you turn it in, please: (1) Include your team number and assignment number in the filename(s)....

Q:

re Regular Languages and Finite Automata (a) Let L be the set of all strings over the alphabet {a, b} that end in a and do not contain the substring bb. Describe a deterministic finite automaton...

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:

Congratulations. You have just inherited your uncle's business, which is a clothing store. Although the business was successful, your uncle was a seat of the pants" (pursuing effort, judgement based...

Q:

If a lease agreement states that 'the lessee guarantees a residual value, at the end of the lease term, of $20 000', what does this mean?

Q:

Professor Marceau objects to the loop invariant used in the proof of Lemma 5.5. He questions whether it is true prior to the first iteration. His reasoning is that one could just as easily declare...

Q:

KSDLDS-Pros, an IT project management consulting firm, is forming an IT project management team of 5 professionals. In the firm of 50 professionals, 8 are considered to be data analytics specialists....

Q:

quote from the Boston Consulting Groups People & Organization website page summarizes Modules 1 and 2: Human resources has long been evolving beyond its traditionaland outdatedrole as a mere...

Q:

2. In this chapter, the reader should reflect on the following concepts: benchmark-ing, competence development, thought dispositions, identity and perception.

Q:

Is it necessary to change something in your everyday life in order for you to achieve the goal?

Q:

What comments do you get from the outside world in the imagined future when you have achieved what you wanted?