Question: Use Excel Function wherever possible and please provide an explanation of the work please. Show work. Thanks! Problem-2 The average annual amount American households spend

Use Excel Function wherever possible and please provide an explanation of the work please. Show work. Thanks!

Problem-2

The average annual amount American households spend for daily transportation is $6312 (Money, August 2001). Assume that the amount spent is normally distributed.

a) Suppose you learn that 5% of American households spend less than $1000 for daily transportation. What is the standard deviation of the amount spent?

b) What is the probability that a household spends between $4000 and $6000?

c) What is the range of spending for the 3% of households with the highest daily transportation cost?

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!