Question

In: Statistics and Probability

7.29 The mean preparation fee H&R Block charged retail customers last year was $183 (The Wall...

7.29 The mean preparation fee H&R Block charged retail customers last year was $183 (The Wall Street Journal, March 7, 2012). Use this price as the population mean and assume the population standard deviation of preparation fees is $50. Use Excel to compute your answers.

Can you please help using excel I'm not understanding how to make this work with excel.

a. What is the probability that the mean price for a sample of 30 H&R Block retail customers is within $8 of the population mean?

b. What is the probability that the mean price for a sample of 50 H&R Block retail customers is within $8 of the population mean?

c. What is the probability that the mean price for a sample of 100 H&R Block retail customers is within $8 of the population mean?

d. What is the minimum samples size if you want to have at least a .95 probability that the sample mean is within $8 of the population mean?

Solutions

Expert Solution

excel formulae are in bold:

a)

for normal distribution z score =(X-μ)/σx
mean μ= 183
standard deviation σ= 50
std error=σ=σ/√n= 9.1287

probability that the mean price for a sample of 30 H&R Block retail customers is within $8 of the population mean =norm.dist(183+8,183,50/sqrt(30),true)-norm.dist(183-8,183,50/sqrt(30),true)

=0.6192

b)

probability that the mean price for a sample of 50 H&R Block retail customers is within $8 of the population mean :

=norm.dist(183+8,183,50/sqrt(50),true)-norm.dist(183-8,183,50/sqrt(50),true)

=0.7421

c)

probability that the mean price for a sample of 100 H&R Block retail customers is within $8 of the population mean

=norm.dist(183+8,183,50/sqrt(100),true)-norm.dist(183-8,183,50/sqrt(100),true)

=0.8904

d)

for95% CI crtiical Z          = 1.96 from excel:normsinv(0.975)
standard deviation σ= 50.000
margin of error E = 8
required n=(zσ/E)2 =(1.96*50/8)^2 = 151 Rounding up

Related Solutions

The mean preparation fee H&R Block charged retail customers last year was $183 (the Wall Street...
The mean preparation fee H&R Block charged retail customers last year was $183 (the Wall Street Journal, March 7, 2012). Use this price as the population mean and assume the population standard deviation of preparation fees is $50. What is the probability that the mean price for a sample of 30 H&R Block retail customers is within $8 of the population mean? What is the probability that the mean price for a sample of 50 H&R Block retail customers is...
The mean preparation fee H&R Block charged retail customers in 2011 was $183 (The Wall Street...
The mean preparation fee H&R Block charged retail customers in 2011 was $183 (The Wall Street Journal, March 7, 2012). Use this price as the population mean and assume the population standard deviation of preparation fees is $45. Suppose you have a sample of 55 customers. What is the expected value and standard error of x? Calculate the probability that the mean price for a sample of 300 H&R Block retail customers is within $12 of the population mean (i.e....
The mean preparation fee H&R Block charged retail customers in 2012 was $183 (The Wall Street...
The mean preparation fee H&R Block charged retail customers in 2012 was $183 (The Wall Street Journal, March 7, 2012). Use this price as the population mean and assume the population standard deviation of preparation fees is $50. a. What is the probability that the mean price for a sample of 30 H&R Block retail customers is within $8 of the population mean? b. What is the probability that the mean price for a sample of 50 H&R Block retail...
The mean preparation fee H&R Block charged retail customers last year was $183. Use this price...
The mean preparation fee H&R Block charged retail customers last year was $183. Use this price as the population mean and assume the population standard deviation of preparation fees is $50. Let X be the population random variable. What does X stand for and why is X a random variable? What probability distribution does the random variable X follow? Suppose  and  are the mean and the standard deviation of the probability distribution of X. What are the values of   and . Now we...
Question Workspace eBook The mean preparation fee H&R Block charged retail customers in 2012 was  (The Wall...
Question Workspace eBook The mean preparation fee H&R Block charged retail customers in 2012 was  (The Wall Street Journal, March 7, 2012). Use this price as the population mean and assume the population standard deviation of preparation fees is . Use z-table. Round your answers to four decimal places. a. What is the probability that the mean price for a sample of  H&R Block retail customers is within  of the population mean? b. What is the probability that the mean price for a...
Johnson Beverage sell to Retail store customers - about 20 customers Last year Revenue was $12...
Johnson Beverage sell to Retail store customers - about 20 customers Last year Revenue was $12 million  - Sell Sport Drinks (Exhibit 1 Customer Profitability) Saver Oscars Downtown Superstore Odd Lots Midwellon Retail Others Total JBI Net Revenue $1,168,000 $1,192,000 $121,520 $454,500 $9,063,980 $12,000,000 Cost of Goods Sold 1,048,000 1,048,000 104,800 393,000 7,886,200 10,480,000 Gross Profit 120,000 144,000 16,720 61,500 1,177,780 1,520,000 Customer Service Costs 116,800 119,200 12,152 45,450 906,398 1,200,000 Customer Profit 3,200 24,800 4,568 16,050 271,382 320,000 Profit %...
The CPA Practice Advisor reports that the mean preparation fee for 2017 federal income tax returns...
The CPA Practice Advisor reports that the mean preparation fee for 2017 federal income tax returns was $273. Use this price as the population mean and assume the population standard deviation of preparation fees is $100. A) What is the probability that the mean price for a sample of 30 federal income tax returns is within $16 of the population mean? B) What is the probability that the mean price for a sample of 50 federal income tax returns is...
1. Last year, the mean amount spent by customers at a local sandwich shop was $18.50....
1. Last year, the mean amount spent by customers at a local sandwich shop was $18.50. The shop owner believes that the mean may be higher this year. State the appropriate null and alternate hypotheses. 2. A test is made of H0 : m = 15 versus H1 : m < 15. The true value of m is 13 and H0 is not rejected. Is this a Type I error, a Type II error, or a correct decision? 3. A...
Consider a uniformly charged cylinder with dimensions of radius r and height h contains a charge...
Consider a uniformly charged cylinder with dimensions of radius r and height h contains a charge in it’s volume. What is the magnitude and direction of the electric field at any point outside the cylinder . Describe each step as you go along .Find the electric field within the cylinder and outside of it. Describe each step as you go along. Consider the total charge Q on a line of length h with the use of Gauss’s law compute the...
Consider a uniformly charged cylinder with dimensions of radius r and height h contains a charge...
Consider a uniformly charged cylinder with dimensions of radius r and height h contains a charge in it’s volume. What is the magnitude and direction of the electric field at any point outside the cylinder . Describe each step as you go along .Find the electric field within the cylinder and outside of it. Describe each step as you go along. Consider the total charge Q on a line of length h with the use of Gauss’s law compute the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT