Reference no: EM132866075
On a Monday morning, when you already have a ton of work, your manager asks you to take on another task. S/he asks you to review the attached sales data obtained from the CRM system and analyze it as stated in (B.1) and (B.2) below. The data file shows sales for four income levels, 1, 2, 3 and 4.
(B.1) Are there statistically significant differences in the total sales amounts between people who belong to different incomes levels? To answer this question, consider only income levels 1, 2, 3 and 4.
Hint: Use single factor ANOVA to conduct the above analysis.
(B.2) If the single factor ANOVA revealed statistical differences in (B.1), which income level groups are statistically different?
Hint: Conduct pairwise t-Tests between income levels 1 and 2, 1 and 3, 1 and 4, 2 and 3, 2 and 4, and 3 and 4. Conclude which pairs have statistically significant differences.
Data for level 1, 2, 3, & 4 is on an excel sheet. I will do my best to give you that information.
Level 1:
$1,072.41 $1,100.00 $1,346.85 $1,364.00 $1,482.52 $1,517.50 $1,531.95 $1,624.24 $1,804.98 $2,020.72 $2,137.72 $2,353.71
Level 2:
$842.73 $1,372.45 $1,450.75 $1,502.49 $1,600.00 $1,615.00 $1,640.12 $1,665.00 $1,721.34 $1,772.07 $1,825.00 $1,889.63 $1,898.46 $1,900.01 $1,931.87 $1,935.37 $1,975.00 $1,986.12 $2,008.01 $2,085.00 $2,147.39 $2,147.78 $2,148.48 $2,170.83 $2,198.89 $2,241.36 $2,333.01 $2,335.00 $2,346.63 $2,369.61 $2,402.80 $2,468.68 $2,523.00 $2,720.00 $2,725.00 $2,737.13 $3,136.22 $3,365.00
Level 3:
$1,031.26 $1,175.29 $1,349.51 $1,414.96 $1,416.59 $1,528.75 $1,593.84 $1,625.00 $1,689.93 $1,803.49 $1,814.82 $1,856.72 $1,862.62 $1,901.11 $1,905.37 $1,965.70 $1,984.05 $2,025.00 $2,101.00 $2,102.77 $2,106.63 $2,180.00 $2,205.00 $2,300.00 $2,488.50 $2,495.21 $2,550.00 $2,553.41 $2,600.00 $3,010.38 $3,075.00 $3,107.84 $3,222.14
Level 4:
$1,356.19 $1,425.00 $1,478.20 $1,779.39 $1,866.10 $2,011.34 $2,346.08 $2,596.34 $2,696.31 $2,755.00 $2,776.45 $2,865.25 $2,869.27 $2,940.86 $3,010.92 $4,120.85