Please solve this using excel and explain how to achieve the answer and which excel formulas to use NORMAL DISTRIBUTION 1 A new tax law is expected to benefit middle income families, those with incomes between $20,000 and $30,000 If family income N($25000, $10000), what percentage of the population will benefit from the law 2 The mean June midday temperature in Desertville is 36C and the standard deviation is 3C a) Assuming this data is normally distributed, how many days in June would you expect the midday temperature to be between 39C and 42C b) What temperature can you expect in 10 warmest days in June

The Answer is in the image, click to view ...

Question: Please solve this using excel and explain how to achieve the answer and which excel formulas to use. NORMAL DISTRIBUTION 1. A new tax law

Please solve this using excel and explain how to achieve the answer and which excel formulas to use.

NORMAL DISTRIBUTION

A new tax law is expected to benefit "middle income" families, those with incomes between $20,000 and $30,000. If family income ~ N($25000, $10000), what percentage of the population will benefit from the law?

The mean June midday temperature in Desertville is 36C and the standard deviation is 3C a) Assuming this data is normally distributed, how many days in June would you expect the midday temperature to be between 39C and 42C?

b) What temperature can you expect in 10% warmest days in June?

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!

CAN YOU PLEASE HELP ME SOLVE THE QUESTION REFERENCING THE ANNUAL REPORT OF BILLABOG 2015 AND 2016. THANKS FEDERATION BUSINESS SCHOOL BUACC1508 ACCOUNTING AND FINANCE ASSESSMENT TASK 2: GROUP...

Normal Distribution Question 2 of 11 1 Point The Fresha Tea Company pack tea in bags marked as 250 g A large number of packs of tea were weighed and the mean and standard deviation were calculated as...

Need help with these 4 case problems: Topics include deferred taxes, investments, stockholder's equity, and pensions. This is due Sunday 3/8 Case Assignment #4: FAR Deferred Taxes - DT-3 The...

Models that pertain to the distribution of a resource within supply chains are often referred to as networks. Distribution among these networks is key to the success of a business while also keeping...

You throw a glove straight upward to celebrate a victory. Its initial kinetic energy is K and it reaches a maximum height h. What is the kinetic energy of the glove when it is at the height h/2?

Which of the principal diagrams should be used to do the following: Determine the number of trays in a distillation column? Determine the top and bottom temperatures in a distillation column?...

=+c) Complete the test and report your conclusion.

Maria Cohen is employed as a salesperson in the men's department of Lee's Fashions. In addition to her weekly base salary of $400 (35-hour week), Cohen is paid a commission of 1% on her total net...

Hearne Company has a number of potential capital investments. Because these projects vary in nature, initial investment, and time horizon, management is finding it difficult to compare them. Assume...

Diamond e-framwork for Turning around organizations in crisis: the cases of two major Alberta orchestras

The average retirement age in America is 64 years old. Do small business owners retire at an older average age? The data below shows the results of a survey of small business owners who have recently...

The average accident on a certain road section is at 2.4 per day, what is the probability that there will be 12 accidents in a week? A bus company operates both a walk-in and online booking to...

Step 3: Analyze and document control plane logical configuration features. Analyze the configurations of the devices for control plane features such as routing protocols, First Hop Redundancy...

You have been given a program Lab01_P2.c that computes the prime factorization of a hardcoded integer value. This program does not work in its current state: it has 1 syntax error (this will cause...

One of the principal roles of the system architect is to Choose the best answer below: Provide objective evidence that specified requirements have been fulfilled by system elements and integrated...

4.6a C90A3F What are the four hexadecimal values after the statement executes and what are the values of NZVC? A: Accumulator (Enter the 4 digit hex content of the accumulator Example FFFF) X: Index...

The following cost information was provided to you for analysis: September 12,000 Units Produced Costs: TIC TAC TOE TING August 10,000 P80,000 70.000 60.000 50,000 How much is the fixed cost per...

How are interest rates used to allocate capital among firms?

What are derivatives, and how is their value related to that of an underlying asset?

Distinguish between: (1) physical asset markets and financial asset markets; (2) spot and futures markets; (3) money and capital markets; (4) primary and secondary markets; and (5) private and public...