Question

According to the IRS, 2012 tax returns showed an average refund of $2691 with a standard deviation of $2303. Assume that 2012 tax return amounts are normally distributed. Based on this information (and information in Questions 7-13), generate excel output in the given space on the Tax sheet in this workbook to answer the following questions. Each orange numerical answer cell below MUST reference Excel output cells in the Tax sheet. lower: The probability is 0.25 that a randomly selected 2012 tax return showed between what two amounts equidistant from the mean? Question 11A Find the lower endpoint using Excel. Use this lower endpoint and some math to find the upper endpoint. (Remember the label.) Question 11B upper: The probability is 0.90 that a randomly selected 2012 tax return showed at least what amount? (Remember the label.) Question 12 Question 13 The probability is 0.24 that a randomly selected 2012 tax return showed no more than what amount? (Remember the label.) Normal 2691 mu 2303 sigma P(X

Answer 1

Lat be the tan nturns for h yr 2012 By aahiom, * 29, 303) Jhat M2691 and 2303 Q.A By the uhon EO,5- 0.25 2 =O.375 O.37S F6.35) 2 69) O.3186 2 303 Mude th inws nom dishibtin CDF n195.17 35 Lowir 1951.135 Similas to 1A 0,5 o. 25 0.625 2424.826 S Nppar 34 24.8265.

Px 0.90 P( <x)= 0.90 -010) 0.10 281 n$260.4133 rondandy letd 2012 tax tun dhow atot 260. 4133 The probalaiut s 0 tha O. 24 n 1064 3852 9 Tandomly elected 2012 1064. 385 2 Persbabity 024 tax utun Ahond The that thom