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

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 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!

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...

Provide answers to the following questions using Excel. You must calculate using Excel to receive credit (i.e., just the correct answer produced by a calculator is not sufficient). I must be able to...

PLEASE ANSWER THE QUESTION CORRECTLY AND ACCURATELY. ENSURE YOU SHOW THE CORRECT CODE AND THE OUTPUT THAT THE CODE RUNS ON THE SCREEN. ALL THE HEADER AND CLASS FILES ARE GIVEN REQUIRED FOR THE...

Could you please answer this question ? ACC 309: EXCEL Project: THE DAILY GRIND CASE Spring 2016: Due April 21 This case is designed to enhance your ability to use EXCEL in a consulting environment....

You are employed as a tax accountant with Azure Beach Accountants and Financial Services. Your client (use your own name as the client's name) is employed as a project manager with the LLJ, a...

This is an excel assignment in finance course. I will attach the assignment. Thank you FIN 301 SPREADSHEET ASSIGNMENT In this assignment you will practice using several Excel functions for managing...

Dear Sir, I have two question. (1) Chwastiak and Young (2003) claim that annual reports rely upon silencing of injustices in order to make profit appear to be an unproblematic measure of success....

help mi.. h2 Question: Payday Lending 1a) A firm's estimated long-run total cost function is LRTC = 160Q - .6Q2 + .002Q3. Suppose the firm is producing 100 units of output. The cost elasticity is __...

A firm has a fixed cost of $200 in its first year of operation. When the firm produces 99 units of output, its total costs are $4,000. The marginal cost of producing the 100th unit of output is $700....

The ducts of an air heating system pass through an unheated area. As a result of heat losses, the temperature of the air in the duct drops by 4C. If the mass flow rate of air is 120 kg/min, determine...

please solve and show work (Assume the bonds par value is $1,000 unless otherwise specified.) 1. Bond yields (LO16-2) The People's Corporation has a bond outstanding with an $80 annual interest...

3.25 Journalining adjusting entries and posting to account The unadjusted trial balance for Pit Class Maldo Company, the dining service, is as follows: FIRST CLASS MAIDS COMPANY Unad usted Trial...