Question: PLEASE ANSWER THE QUESTION BY USING THE EXCEL FUNCTIONS AND PLEASE SHOW THE DATA USED For questions a and b, suppose that the population of

PLEASE ANSWER THE QUESTION BY USING THE EXCEL FUNCTIONS AND PLEASE SHOW THE DATA USED

For questions a and b, suppose that the population of annual health care claims by employees is normally distributed with a mean of $9,500 and a standard deviation of $3,000.

a)What is the probability that an employee selected at random has health care claims exceeding $11,000?

b)Suppose that five employees are selected at random. What is the probability that the average health care claims of these five employees exceed $11,000?

c)Suppose that five employees are selected at random. What is the probability that all five of their health care claims each exceeds $11,000?

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!

Hi there, can you please help me with my uploaded file lesson 5 questions. FNCE 300/ECON 300: Assignment 2 Due: After completion of Lesson 8. Marks: 100 Credit Weight: 20% of final grade. Prepare...

Can you please help with lesson 5.1 and 5.2 file is attached FNCE 300/ECON 300: Assignment 2 Due: After completion of Lesson 8. Marks: 100 Credit Weight: 20% of final grade. Prepare your responses to...

Hi! I need help filling out the excel questions and spreadsheet for the Dallas Health Network. i have attached the reading material for the excel spreadsheet. Case Study: Dallas Health Network - ABC...

Please I need the solution for this case. Dallas Health Network Case Study: Dallas Health Network - ABC Analysis Excel Calculations: The following tab has excel calculations for ABC costing. The...

Solve the assignment: Attached under Advanced Corporate Finance and Modeling Assignemnt Grading will be established on the quality and depth of the explanations. Note that some questions may have not...

Suppose that the diameters of Megalopizzas are normally distributed with a mean of 18.75 inches and a standard deviation of 0.25 inches. If Clark samples 4 pizzas, what is the probability that the...

PLEASE ANSWER THE QUESTION USING THE EXCEL FUNCTIONS AND SHOW THE DATA USED WITH THE FUNCTION. For questions a and b, suppose that the population of annual health care claims by employees is normally...

Research Article Introduction Rates of opioid-related morbidity and mortality continue at epidemic levels. In 2016, an estimated 2.1 million people in the United States (McCance-Katz, 2018) and 26.8...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

please complete the question with a Microsoft Excel. thank you Problem Topic #3: Budget Calculator Note: this problem is more aligned with something that could happen in an individual's life rather...

Explain the difference between cash flows from financing and investment activities.

Use the Fermi distribution function to obtain the value of F(E) for E - EF - EF = 0.01 eV at 200K.

Which business valuation model uses relevant market multiples of a set of company's industry peers and / or competitors to estimate a target company's value? Multiple Choice 1 : 2 3 discounted cash...

CALCULATOR PRINTER VERSION BACK Question 2 Splish Brothers Inc. has the following account balances: Sales Revenue 229,550. Sales Discounts 4,230, Cost of Goods Sold 692,346, and Inventory 39,090....