Discuss the below:
In the file is a global sample of 200ish Shoe Sales Associates whose 3 most recent annual sales commissions are recorded.
Q1) Calculate the mean commissions for the past 3 years. Which year was the highest and lowest?
Q2) Graph those annual means with a pivot chart.
Q3) Figure out which year(s) sales persons' made more money by comparing the difference between 2012 to 2013, 2013-2014, and 2012-2014. Since each row belongs to a specific sales person, you need to do a specific analysis - what is it?
What does the statistical significance value tell about those annual differences?
Thinking creatively, what do you think can account for those annual differences?
| Comm_2012 |
Comm_2013 |
Comm_2014 |
| $ 199,443.00 |
$ 29,916.45 |
$ 124,332.77 |
| $ 234,130.00 |
$ 35,119.50 |
$ 145,956.64 |
| $ 119,000.00 |
$ 17,850.00 |
$ 74,184.60 |
| $ 170,000.00 |
$ 25,500.00 |
$ 105,978.00 |
| $ 267,000.00 |
$ 40,050.00 |
$ 166,447.80 |
| $ 148,200.00 |
$ 22,230.00 |
$ 92,387.88 |
| $ 165,900.00 |
$ 24,885.00 |
$ 103,422.06 |
| $ 155,000.00 |
$ 23,250.00 |
$ 96,627.00 |
| $ 165,500.00 |
$ 24,825.00 |
$ 103,172.70 |
| $ 195,500.00 |
$ 29,325.00 |
$ 121,874.70 |
| $ 172,000.00 |
$ 25,800.00 |
$ 107,224.80 |
| $ 165,000.00 |
$ 24,750.00 |
$ 102,861.00 |
| $ 230,060.00 |
$ 34,509.00 |
$ 143,419.40 |
| $ 367,000.00 |
$ 55,050.00 |
$ 228,787.80 |
| $ 97,000.00 |
$ 14,550.00 |
$ 60,469.80 |
| $ 145,000.00 |
$ 21,750.00 |
$ 90,393.00 |
| $ 259,289.00 |
$ 38,893.35 |
$ 161,640.76 |
| $ 300,300.00 |
$ 45,045.00 |
$ 187,207.02 |
| $ 137,000.00 |
$ 20,550.00 |
$ 85,405.80 |
| $ 243,000.00 |
$ 36,450.00 |
$ 151,486.20 |
| $ 171,000.00 |
$ 25,650.00 |
$ 106,601.40 |
| $ 328,000.00 |
$ 49,200.00 |
$ 204,475.20 |
| $ 195,000.00 |
$ 29,250.00 |
$ 121,563.00 |
| $ 155,000.00 |
$ 23,250.00 |
$ 96,627.00 |
| $ 165,360.00 |
$ 24,804.00 |
$ 103,085.42 |
| $ 229,000.00 |
$ 34,350.00 |
$ 142,758.60 |
| $ 162,000.00 |
$ 24,300.00 |
$ 100,990.80 |
| $ 173,000.00 |
$ 25,950.00 |
$ 107,848.20 |
| $ 523,005.00 |
$ 78,450.75 |
$ 326,041.32 |
| $ 85,900.00 |
$ 12,885.00 |
$ 53,550.06 |
| $ 332,750.00 |
$ 49,912.50 |
$ 207,436.35 |
| $ 240,000.00 |
$ 36,000.00 |
$ 149,616.00 |
| $ 323,413.00 |
$ 48,511.95 |
$ 201,615.66 |
| $ 342,202.00 |
$ 51,330.30 |
$ 213,328.73 |
| $ 401,115.00 |
$ 60,167.25 |
$ 250,055.09 |
| $ 163,500.00 |
$ 24,525.00 |
$ 101,925.90 |
| $ 375,000.00 |
$ 56,250.00 |
$ 233,775.00 |
| $ 120,820.00 |
$ 18,123.00 |
$ 75,319.19 |
| $ 122,700.00 |
$ 18,405.00 |
$ 76,491.18 |
| $ 237,500.00 |
$ 35,625.00 |
$ 148,057.50 |
| $ 367,000.00 |
$ 55,050.00 |
$ 228,787.80 |
| $ 82,800.00 |
$ 12,420.00 |
$ 51,617.52 |
| $ 155,000.00 |
$ 23,250.00 |
$ 96,627.00 |
| $ 147,000.00 |
$ 22,050.00 |
$ 91,639.80 |
| $ 122,500.00 |
$ 18,375.00 |
$ 76,366.50 |
| $ 172,700.00 |
$ 25,905.00 |
$ 107,661.18 |
| $ 160,500.00 |
$ 24,075.00 |
$ 100,055.70 |
| $ 240,000.00 |
$ 36,000.00 |
$ 149,616.00 |
| $ 138,000.00 |
$ 20,700.00 |
$ 86,029.20 |
| $ 220,000.00 |
$ 33,000.00 |
$ 137,148.00 |
| $ 252,828.00 |
$ 37,924.20 |
$ 157,612.98 |
| $ 89,000.00 |
$ 13,350.00 |
$ 55,482.60 |
| $ 180,000.00 |
$ 27,000.00 |
$ 112,212.00 |
| $ 238,600.00 |
$ 35,790.00 |
$ 148,743.24 |
| $ 200,000.00 |
$ 30,000.00 |
$ 124,680.00 |
| $ 274,867.00 |
$ 41,230.05 |
$ 171,352.09 |
| $ 106,500.00 |
$ 15,975.00 |
$ 66,392.10 |
| $ 115,000.00 |
$ 17,250.00 |
$ 71,691.00 |
| $ 347,000.00 |
$ 52,050.00 |
$ 216,319.80 |
| $ 182,000.00 |
$ 27,300.00 |
$ 113,458.80 |
| $ 177,500.00 |
$ 26,625.00 |
$ 110,653.50 |
| $ 480,000.00 |
$ 72,000.00 |
$ 299,232.00 |
| $ 126,900.00 |
$ 19,035.00 |
$ 79,109.46 |
| $ 266,000.00 |
$ 39,900.00 |
$ 165,824.40 |
| $ 200,800.00 |
$ 30,120.00 |
$ 125,178.72 |
| $ 105,000.00 |
$ 15,750.00 |
$ 65,457.00 |
| $ 175,000.00 |
$ 26,250.00 |
$ 109,095.00 |
| $ 159,500.00 |
$ 23,925.00 |
$ 99,432.30 |
| $ 166,500.00 |
$ 24,975.00 |
$ 103,796.10 |
| $ 900,000.00 |
$ 135,000.00 |
$ 561,060.00 |
| $ 157,000.00 |
$ 23,550.00 |
$ 97,873.80 |
| $ 189,000.00 |
$ 28,350.00 |
$ 117,822.60 |
| $ 499,000.00 |
$ 74,850.00 |
$ 311,076.60 |
| $ 85,000.00 |
$ 12,750.00 |
$ 52,989.00 |
| $ 212,000.00 |
$ 31,800.00 |
$ 132,160.80 |
| $ 240,000.00 |
$ 36,000.00 |
$ 149,616.00 |
| $ 192,300.00 |
$ 28,845.00 |
$ 119,879.82 |
| $ 218,000.00 |
$ 32,700.00 |
$ 135,901.20 |
| $ 210,225.00 |
$ 31,533.75 |
$ 131,054.27 |
| $ 198,500.00 |
$ 29,775.00 |
$ 123,744.90 |
| $ 238,000.00 |
$ 35,700.00 |
$ 148,369.20 |
| $ 155,000.00 |
$ 23,250.00 |
$ 96,627.00 |
| $ 839,000.00 |
$ 125,850.00 |
$ 523,032.60 |
| $ 122,500.00 |
$ 18,375.00 |
$ 76,366.50 |
| $ 97,500.00 |
$ 14,625.00 |
$ 60,781.50 |
| $ 154,000.00 |
$ 23,100.00 |
$ 96,003.60 |
| $ 230,000.00 |
$ 34,500.00 |
$ 143,382.00 |
| $ 209,900.00 |
$ 31,485.00 |
$ 130,851.66 |
| $ 187,628.00 |
$ 28,144.20 |
$ 116,967.30 |
| $ 280,000.00 |
$ 42,000.00 |
$ 174,552.00 |
| $ 295,000.00 |
$ 44,250.00 |
$ 183,903.00 |
| $ 225,000.00 |
$ 33,750.00 |
$ 140,265.00 |
| $ 147,423.00 |
$ 22,113.45 |
$ 91,903.50 |
| $ 160,000.00 |
$ 24,000.00 |
$ 99,744.00 |
| $ 105,000.00 |
$ 15,750.00 |
$ 65,457.00 |
| $ 137,900.00 |
$ 20,685.00 |
$ 85,966.86 |
| $ 136,000.00 |
$ 20,400.00 |
$ 84,782.40 |
| $ 172,165.00 |
$ 25,824.75 |
$ 107,327.66 |
| $ 224,690.00 |
$ 33,703.50 |
$ 140,071.75 |
| $ 180,000.00 |
$ 27,000.00 |
$ 112,212.00 |
| $ 84,000.00 |
$ 12,600.00 |
$ 52,365.60 |
| $ 120,000.00 |
$ 18,000.00 |
$ 74,808.00 |
| $ 293,500.00 |
$ 44,025.00 |
$ 182,967.90 |
| $ 139,900.00 |
$ 20,985.00 |
$ 87,213.66 |
| $ 160,000.00 |
$ 24,000.00 |
$ 99,744.00 |
| $ 335,610.00 |
$ 50,341.50 |
$ 209,219.27 |
| $ 229,000.00 |
$ 34,350.00 |
$ 142,758.60 |
| $ 215,270.00 |
$ 32,290.50 |
$ 134,199.32 |
| $ 65,000.00 |
$ 9,750.00 |
$ 40,521.00 |
| $ 65,000.00 |
$ 9,750.00 |
$ 40,521.00 |
| $ 199,000.00 |
$ 29,850.00 |
$ 124,056.60 |
| $ 435,500.00 |
$ 65,325.00 |
$ 271,490.70 |
| $ 130,000.00 |
$ 19,500.00 |
$ 81,042.00 |
| $ 279,000.00 |
$ 41,850.00 |
$ 173,928.60 |
| $ 184,350.00 |
$ 27,652.50 |
$ 114,923.79 |
| $ 138,000.00 |
$ 20,700.00 |
$ 86,029.20 |
| $ 220,000.00 |
$ 33,000.00 |
$ 137,148.00 |
| $ 192,800.00 |
$ 28,920.00 |
$ 120,191.52 |
| $ 269,000.00 |
$ 40,350.00 |
$ 167,694.60 |
| $ 208,000.00 |
$ 31,200.00 |
$ 129,667.20 |
| $ 129,000.00 |
$ 19,350.00 |
$ 80,418.60 |
| $ 243,000.00 |
$ 36,450.00 |
$ 151,486.20 |
| $ 128,850.00 |
$ 19,327.50 |
$ 80,325.09 |
| $ 159,400.00 |
$ 23,910.00 |
$ 99,369.96 |
| $ 125,000.00 |
$ 18,750.00 |
$ 77,925.00 |
| $ 271,500.00 |
$ 40,725.00 |
$ 169,253.10 |
| $ 220,000.00 |
$ 33,000.00 |
$ 137,148.00 |
| $ 235,000.00 |
$ 35,250.00 |
$ 146,499.00 |
| $ 218,000.00 |
$ 32,700.00 |
$ 135,901.20 |
| $ 233,500.00 |
$ 35,025.00 |
$ 145,563.90 |
| $ 362,500.00 |
$ 54,375.00 |
$ 225,982.50 |
| $ 86,125.00 |
$ 12,918.75 |
$ 53,690.33 |
| $ 190,100.00 |
$ 28,515.00 |
$ 118,508.34 |
| $ 327,670.00 |
$ 49,150.50 |
$ 204,269.48 |
| $ 134,250.00 |
$ 20,137.50 |
$ 83,691.45 |
| $ 340,000.00 |
$ 51,000.00 |
$ 211,956.00 |
| $ 216,300.00 |
$ 32,445.00 |
$ 134,841.42 |
| $ 140,595.00 |
$ 21,089.25 |
$ 87,646.92 |
| $ 270,000.00 |
$ 40,500.00 |
$ 168,318.00 |
| $ 53,000.00 |
$ 7,950.00 |
$ 33,040.20 |
| $ 259,000.00 |
$ 38,850.00 |
$ 161,460.60 |
| $ 264,894.00 |
$ 39,734.10 |
$ 165,134.92 |
| $ 82,900.00 |
$ 12,435.00 |
$ 51,679.86 |
| $ 60,000.00 |
$ 9,000.00 |
$ 37,404.00 |
| $ 275,000.00 |
$ 41,250.00 |
$ 171,435.00 |
| $ 189,400.00 |
$ 28,410.00 |
$ 118,071.96 |
| $ 445,000.00 |
$ 66,750.00 |
$ 277,413.00 |
| $ 199,100.00 |
$ 29,865.00 |
$ 124,118.94 |
| $ 124,000.00 |
$ 18,600.00 |
$ 77,301.60 |
| $ 360,000.00 |
$ 54,000.00 |
$ 224,424.00 |
| $ 299,000.00 |
$ 44,850.00 |
$ 186,396.60 |
| $ 164,000.00 |
$ 24,600.00 |
$ 102,237.60 |
| $ 92,000.00 |
$ 13,800.00 |
$ 57,352.80 |
| $ 620,000.00 |
$ 93,000.00 |
$ 386,508.00 |
| $ 220,000.00 |
$ 33,000.00 |
$ 137,148.00 |
| $ 225,000.00 |
$ 33,750.00 |
$ 140,265.00 |
| $ 155,000.00 |
$ 23,250.00 |
$ 96,627.00 |
| $ 227,000.00 |
$ 34,050.00 |
$ 141,511.80 |
| $ 186,900.00 |
$ 28,035.00 |
$ 116,513.46 |
| $ 475,000.00 |
$ 71,250.00 |
$ 296,115.00 |
| $ 128,800.00 |
$ 19,320.00 |
$ 80,293.92 |
| $ 193,056.00 |
$ 28,958.40 |
$ 120,351.11 |
| $ 131,000.00 |
$ 19,650.00 |
$ 81,665.40 |
| $ 565,000.00 |
$ 84,750.00 |
$ 352,221.00 |
| $ 95,000.00 |
$ 14,250.00 |
$ 59,223.00 |
| $ 162,409.00 |
$ 24,361.35 |
$ 101,245.77 |
| $ 121,500.00 |
$ 18,225.00 |
$ 75,743.10 |
| $ 445,000.00 |
$ 66,750.00 |
$ 277,413.00 |
| $ 254,900.00 |
$ 38,235.00 |
$ 158,904.66 |
| $ 162,000.00 |
$ 24,300.00 |
$ 100,990.80 |
| $ 570,900.00 |
$ 85,635.00 |
$ 355,899.06 |
| $ 200,000.00 |
$ 30,000.00 |
$ 124,680.00 |
| $ 210,900.00 |
$ 31,635.00 |
$ 131,475.06 |
| $ 315,000.00 |
$ 47,250.00 |
$ 196,371.00 |
| $ 107,500.00 |
$ 16,125.00 |
$ 67,015.50 |
| $ 152,400.00 |
$ 22,860.00 |
$ 95,006.16 |
| $ 175,000.00 |
$ 26,250.00 |
$ 109,095.00 |
| $ 174,000.00 |
$ 26,100.00 |
$ 108,471.60 |
| $ 190,000.00 |
$ 28,500.00 |
$ 118,446.00 |
| $ 209,268.00 |
$ 31,390.20 |
$ 130,457.67 |
| $ 350,000.00 |
$ 52,500.00 |
$ 218,190.00 |
| $ 137,000.00 |
$ 20,550.00 |
$ 85,405.80 |
| $ 89,000.00 |
$ 13,350.00 |
$ 55,482.60 |
| $ 210,860.00 |
$ 31,629.00 |
$ 131,450.12 |
| $ 93,500.00 |
$ 14,025.00 |
$ 58,287.90 |
| $ 177,500.00 |
$ 26,625.00 |
$ 110,653.50 |
| $ 145,000.00 |
$ 21,750.00 |
$ 90,393.00 |
| $ 225,000.00 |
$ 33,750.00 |
$ 140,265.00 |
| $ 185,000.00 |
$ 27,750.00 |
$ 115,329.00 |
| $ 166,000.00 |
$ 24,900.00 |
$ 103,484.40 |
| $ 136,900.00 |
$ 20,535.00 |
$ 85,343.46 |
| $ 209,000.00 |
$ 31,350.00 |
$ 130,290.60 |
| $ 202,000.00 |
$ 30,300.00 |
$ 125,926.80 |
| $ 105,000.00 |
$ 15,750.00 |
$ 65,457.00 |
| $ 378,000.00 |
$ 56,700.00 |
$ 235,645.20 |
| $ 180,000.00 |
$ 27,000.00 |
$ 112,212.00 |
| $ 174,900.00 |
$ 26,235.00 |
$ 109,032.66 |
| $ 344,100.00 |
$ 51,615.00 |
$ 214,511.94 |
| $ 437,000.00 |
$ 65,550.00 |
$ 272,425.80 |
| $ 325,000.00 |
$ 48,750.00 |
$ 202,605.00 |
| $ 327,000.00 |
$ 49,050.00 |
$ 203,851.80 |