According to the IRS, 2012 tax returns showed an average refund of $2824 with a standard deviation of $2622. 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. Question 7 Find the probability a randomly selected 2012 tax return showed an amount no less than $2,621 and at most $6,213 Question 8 Find the probability a randomly selected 2012 tax return showed an amount greater than $3,066 Question 9 ind the probability a randomly selected 2012 tax return showed an amount less than or equal to $4,264 or greater than $5,045. Question 10 Find the probability a randomly selected 2012 tax return showed an amount less than $580.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
icon
Related questions
Question
According to the IRS, 2012 tax returns showed an average refund of $2824 with a standard deviation of $2622. 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.
Question 7
Find the probability a randomly selected 2012 tax return showed an amount no less than $2,621 and at most $6,213
Question 8
Find the probability a randomly selected 2012 tax return showed an amount greater than $3,066
Question 9
ind the probability a randomly selected 2012 tax return showed an amount less than or equal to $4,264 or greater than $5,045.
Question 10
Find the probability a randomly selected 2012 tax return showed an amount less than $580.
Transcribed Image Text:According to the IRS, 2012 tax returns showed an average refund of $2824 with a standard deviation of $2622. 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. Question 7 Find the probability a randomly selected 2012 tax return showed an amount no less than $2,621 and at most $6,213 Question 8 Find the probability a randomly selected 2012 tax return showed an amount greater than $3,066 Question 9 ind the probability a randomly selected 2012 tax return showed an amount less than or equal to $4,264 or greater than $5,045. Question 10 Find the probability a randomly selected 2012 tax return showed an amount less than $580.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill