Nikita is a government official looking to find evidence on whether the mean taxable income for an individual taxpayer in the region dropped since the previous year. She surveyed 32 individual taxpayers in the region and found the taxable income of each individual as shown in the data set provided. Instead of using the standard deviation from the survey, Nikita decided to use the census data for the region to assume that the population standard deviation of income is $26,744. The mean taxable income in the region was $62,712 for the previous year. (a) H0:μ=$62,712;Ha:μ<$62,712, which is a left-tailed test. (b) Taxable income of each individual is given below. Use Excel to test whether this year's mean taxable income for an individual taxpayer in the region is less than the mean taxable income from the previous year, and then draw a conclusion in the context of the problem, where α=0.10. Calculate the test statistic, z, rounding to two decimal places, and the p-value, rounding to three decimal places. Taxable income ($) 12193 64586 60363 59639 103402 24127 53641 38963 78596 49328 33983 64023 49771 89073 59433 21930 53789 30236 41639 87935 73396 69640 69371 104896 112354 96396 83921 72539 52186 91483 32069 17296
Nikita is a government official looking to find evidence on whether the
(a) H0:μ=$62,712;Ha:μ<$62,712, which is a left-tailed test.
(b) Taxable income of each individual is given below.
Use Excel to test whether this year's mean taxable income for an individual taxpayer in the region is less than the mean taxable income from the previous year, and then draw a conclusion in the context of the problem, where α=0.10. Calculate the test statistic, z, rounding to two decimal places, and the p-value, rounding to three decimal places. Taxable income ($)
12193
64586
60363
59639
103402
24127
53641
38963
78596
49328
33983
64023
49771
89073
59433
21930
53789
30236
41639
87935
73396
69640
69371
104896
112354
96396
83921
72539
52186
91483
32069
17296
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images