Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If you need more data please let me know I have another excel sheet I can add but it is external url and I do

If you need more data please let me know I have another excel sheet I can add but it is external url and I do not know if thats allowed on chegg. I can copy and paste all the numbers if thats needed as well

  1. Is there a relationship between years of seniority and base pay for the sample? The population? (Hint: Use a Scatter chart- the scatter chart is required and should be displayed for this question.) If you determine if there is a relationship comment if the relationship is linear, curvilinear or something else. Does it change as the values change? Discuss fully.

  2. Is there a relationship between years of seniority and commission pay for the sample? The population? (Hint: Use a Scatter chart- the scatter chart is required and should be displayed for this question.) If you determine if there is a relationship comment if the relationship is linear, curvilinear or something else. Does it change as the values change? Discuss fully.

  3. Is there a relationship between years of seniority and total pay for the sample? The population? (Hint: Use a Scatter chart- the scatter chart is required and should be displayed for this question.) If you determine if there is a relationship comment if the relationship is linear, curvilinear or something else. Does it change as the values change? Discuss fully

Down below is the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for the POPULATION

image text in transcribed

Down below is the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for my SAMPLE image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Population Base salary Commission Total Salary Years of Seniority mean 4.539215686 $20,671.06 $41,822.28 $62,493.34 mode 0 21055.98743 14075.15525 #N/A median 3 $19,711.25 $26,568.70 $46,592.24 variance 21.28767782 11165464.91 1659620982 1927510166 4.613857152 3341.476456 40738.44599 43903.41862 Standard deviation high value 26 $38,296.80 $231,130.01 $261,715.44 low value 0 $16,263.70 $7,733.01 $25,625.57 Range 26 $22,033.10 $223,397.00 $236,089.88 Population Base salary Commission Total Salary Years of Seniority mean 5.4 $21,249.78 $47,526.08 $68,775.86 mode 2 24122.031 77549.8916 101671.923 median 4 $20,609.57 $27,672.15 $48,533.10 variance 27.7551 14331728 222536197 2580828072 5.628311 3785.7269 47173.6812 50801.8511 Standard deviation high value 22 $33922.14 $216183.65 $247631.28 low value 0 $16,868.71 $8,453.75 $25,625.57 Range 22 $17,053.43 $207,729.90 $222,005.71 N Q6 6 4 J Q2 3 3 5 3 5 5 4 5 1 5 L Q4 5 2 3 5 2 2 5 5 5 4 2 5 5 5 5 9 7 7 4 10 6 5 8 3 4 5 5 10 9 8 8 8 8 3 7 6 6 EMP ID 11001 11002 11003 11004 11005 11006 11007 11008 11009 11010 11011 11012 11013 11014 11015 11016 11017 11018 11019 11020 11021 11022 11023 11024 11025 11026 11027 11028 11029 11030 11031 11032 11033 11034 11035 11036 11037 11038 11039 11040 11041 11042 11043 11044 11045 11046 11047 11048 11049 11050 11051 11052 11053 11054 11055 11056 11057 11058 11059 11060 11061 11062 11063 11064 11065 11066 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 B D GENDER YEARS SENIORITY Base Salary 1 5 $21,059.04 1 13 $26,073.00 1 11 $24,854.42 1 26 $38,296.80 0 5 $20,348.10 1 1 $17,511.06 0 1 $17,617.00 0 4 $20,304.01 1 1 2 $19,356.08 0 1 $17,767.65 1 1 $18, 154.03 1 9 $22,895.49 1 10 $23,775.44 0 0 $17,095.89 1 2 $20,314.42 0 5 $20,648.15 0 1 $17,819.08 0 0 $18,584,52 0 3 $19,199.32 1 12 $26,134.84 1 6 $21,057.21 1 1 $18,329.78 1 4 $19.581.43 1 11 $26.195.47 1 1 2 $17,717.43 1 2 $19,624.30 1 2 $18,876.61 0 3 $18,677.60 0 4 $20,611.41 1 3 $18,932.96 1 3 $19,384.87 0 1 $17,281.44 1 6 $21,221.32 1 0 $17,910.93 0 12 $27, 110.32 1 4 $20,935.96 0 1 $18,899.89 1 1 $17,512.90 0 2 $19,678.19 1 6 $21,751.62 1 0 $16,837.47 1 5 $20.240.94 1 4 $19,231.78 0 6 $21,055.99 0 0 $18,108.11 0 6 $22,379.28 1 0 $17,895.01 0 5 $20,225.63 1 4 $19,821.47 1 0 $16,693.58 1 9 $22,754.04 0 3 $19,180.95 1 6 $21,190.09 1 1 3 $19.255.05 1 9 $23,569.69 1 4 $20,601.61 0 5 $21,358.48 1 0 $18,783.54 1 1 $18,855.19 0 5 $20,834.31 1 1 $19,508.57 1 19 $30,585.43 1 3 $19,967.83 1 17 $29,481.97 1 1 $17,892.56 0 6 6 $22.163.73 2 5 5 1 3 4 3 3 5 2 2 1 2 3 4 5 E Commission $27,402.41 $104,683.28 $59,113.15 $215,905.69 $32,036.09 $19,491.42 $22,434.39 $28,212.55 $18,844.77 $13,664.26 $17.502.49 $74,395.67 $90,762.04 $10,531.46 $15,078.80 $36,094.16 $16,597.44 $11,251.59 $25,395.12 $117.998.31 $53,584.82 $12.825.34 $38,541.13 $82,855.33 $22,937.13 $20,015.59 $22,160.06 $30,688.91 $27,041.12 $30,829.76 $20,195.62 $15,474.38 $53,022.07 $9,638.65 $118,241.41 $31,330.05 $13,765.29 $16,083.06 $26,083.41 $58, 155.43 $13,565.67 $41.365.91 $39,975.26 $50.032.56 $9,059,36 $40,598.03 $11.457.95 $30,401.72 $32.954.02 $11,533.27 $90,168.67 $33.900.10 $48,546.98 $28,596.50 $54,831.57 $26,075.44 $39,764.61 $7.733.01 $13,139.47 $39,429.04 $13,906.75 $231, 130.01 $27,895.98 $206,312.56 $17,500.65 $54,210.65 Region 3 4 3 6 3 2 5 3 5 3 3 1 5 5 2 6 5 2 5 6 5 1 2 3 3 3 2 4 4 5 3 3 6 2 4 2 2. 5 2 3 1 5 5 4 3 5 2. Q1 2 1 4 4 4 5 5 4 5 5 1 5 2 3 5 4 4 3 5 5 3 4 4 5 1 5 2 4 4 3 4 5 4 7 9 7 7 2 2 8 8 Total Compensation $48,461.45 $130,756.28 $83,967.57 $254,202.49 $52,384.19 $37,002.48 $40,051.39 $48,516.57 $38,200.86 $31,431.91 $35,656.52 $97,291.15 $114,537.49 $27,627.36 $35,393.22 $56.742.31 $34,416.51 $29,836.11 $44,594.45 $144,133.14 $74,642.03 $31,155.12 $58,122.56 $109,050.80 $40,654.56 $39,639.89 $41,036.67 $49,366.52 $47,652.53 $49,762.71 $39,580.49 $32,755.81 $74,243.39 $27,549.58 $145,351.73 $52,266.01 $32,665.18 $33,595.96 $45,761.60 $79,907.05 $30,403.14 $61,606.85 $59,207.04 $71,088.55 $27,167.48 $62,977.30 $29,352.96 $50,627.35 $52,775.49 $28,226.85 $112,922.71 $53,081.05 $69.737.07 $47,851.55 $78,401.26 $46,677.05 $61,123.09 $26,516.55 $31,994.66 $60,263.35 $33,415.32 $261,715.44 $47,863.81 $235,794.53 $35,393.21 $76,374.38 H Contracts written 131 460 322 467 71 1 0 223 5 3 140 402 170 34 156 8 213 36 2 100 217 1 334 160 3 10 132 59 148 85 114 160 264 45 228 78 8 291 200 17 42 80 27 267 38 253 64 124 20 29 176 4 110 106 445 60 340 20 0 137 28 332 334 360 149 6 K Q3 4 1 5 5 1 1 2 1 4 5 1 2 4 5 2 1 1 1 5 2 2 2 2 5 1 5 2 4 4 2 4 4. 1 4 5 4 5 3 5 4 1 1 1 5 5 1 3 4 1 3 4 4 3 3 2 5 2 5 4 5 5 5 3 3 3 2 5 4 3 5 2 5 5 5 5 1 5 2 4 4 5 3 4 4 5 5 3 1 4 2 M Q5 2 5 1 1 1 1 1 1 2 1 1 1 1 3 1 1 2 2 1 4 1 2 2 3 1 1 3 3 5 1 5 3 2 1 5 2 3 1 2 2 2 3 3 1 1 3 1 3 1 2 2 1 1 1 1 2 2 3 1 1 5 2 2 2 1 1 2 1 1 4 4 7 4 3 2 5 4 4 5 2 4 3 1 3 2 4 5 2 4 3 3 3 4 5 4 4 5 1 3 3 5 4 1 3 5 5 3 5 5 5 4 3 5 3 3 5 5 2 5 2 4 2 5 5 5 9 6 5 4 3 5 10 9 1 6 9 5 5 8 10 3 7 5 10 4 2 0 5 6 2 5 5 1 3 4 4 4 1 4 5 4 5 5 1 4 4 5 1 4 4 1 1 5 2 4 4 5 1 5 1 5 5 2 2 5 1 4 4 6 2 4 5 5 5 2 3 2 8 7 3 5 4 5 2 3 2 3 4 5 3 3 1 1 3 5 4 3 4 5 4 2 4 1 6 8 9 6 2 J J 5 3 5 C 0 2 12 2 3 3 1 1 N 6 8 4 2 7 9 1 G 2 5 5 4 2 3 4 2 2 4 5 3 1 3 4 6 2 5 5 3 5 5 B 1 1 0 1 1 0 1 1 1 1 1 0 0 0 0 1 0 1 1 1 1 0 1 0 3 4. 5 3 5 5 2 3 1 6 3 2 5 1 3 5 1 5 3 1 8 7 3 7 5 6 10 2 7 8 7 4 7 7 6 6 10 9 4 9 7 6 6 1 0 1 0 5 6 5 3 3 3 2 2 3 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 3 5 1 1 5 5 1 4 1 4 1 3 5 4 4 3 5 5 2 5 2 3 3 2 3 5 5 5 5 2 3 5 5 5 4 4 5 1 5 3 2 3 4 3 6 A 11067 11068 11069 11070 11071 11072 11073 11074 11075 11076 11077 11078 11079 11080 11081 11082 11083 11084 11085 11086 11087 11088 11089 11090 11091 11092 11093 11094 11095 11096 11097 11098 11099 11100 11101 11102 11103 11104 11105 11106 11107 11108 11109 11110 11111 11112 11113 11114 11115 11116 11117 11118 11119 11120 11121 11122 11123 11124 11125 11126 11127 11128 11129 11130 11131 11132 11133 K 5 2 2 4 5 5 1 1 1 1 4 5 1 1 1 5 5 1 1 5 1 1 5 4 1 3 2 5 2 4 5 1 1 5 5 5 4 2 5 1 4 5 6 8 6 D $18,324.89 $19,074.40 $25,434.92 $19,555.10 $19,716.77 $20,011.30 $19,031.54 $17,969.72 $19,629.20 $29,456.25 $19,316.90 $19,608.98 $22,059.02 $21,412 37 $18,423.47 $18,831.30 $18.979.49 $24.780.93 $25,717.83 $21.937.78 $17,522.71 $24,169.80 $17,202.43 $19,994.16 $16,485.98 $18,739.44 $21,643.85 $18,788.43 $18,165.06 $23,806.68 $26,347.33 $22,416.02 $20,332.18 $17,148.55 $20,686.73 $21,733.25 $19.711.25 $ 16,637.23 $20,024.17 $17,207.95 $20,970.86 $17,916.45 $17,475.55 $17,171.21 $19,206.06 $27,439.15 $26,480.21 $18,506.14 $18,031.56 $22,243.95 $18,317.53 $18,114.24 $17,729.67 $20,107.44 $25,219.38 $19,196.87 $20,594.27 $18,234.26 $17.484.73 $17,936.04 $20,815.32 $18,315.70 $28,623.45 $22,570.34 $18,258.13 $27.906.38 $18,748.02 2 16 4 5 5 6 6 2 1 0 11 12 7 0 11 0 2 0 2 5 1 1 9 13 6 3 0 3 7 3 0 2 0 3 2 1 0 4 14 12 1 0 7 3 0 1 4 10 2 4 1 2 2 4 1 16 8 2 15 2 E $12,619.59 $19,409.98 $78,274.92 $17,914.00 $19,739.43 $31,527.84 $17,211.01 $17,339.00 $17,563.72 $177,006.57 $28,663.86 $41,049.34 $48,229.79 $47,816.45 $19,876.58 $18,147.91 $10,134.04 $90,608.34 $116.496.82 $78,759.30 $10,615.96 $97,090.71 $10,957.66 $18, 139.95 $11,947.22 $18.226.91 $54,807.08 $14,372.76 $14.265.59 $73,148.92 $114,320.51 $40,599.25 $29,199.68 $11,610.43 $29,200.29 $62,474.98 $32,546.18 $12.460.38 $15,123.50 $9,151.83 $25,268.98 $19,593.07 $16,923.20 $9,311.65 $28,204.59 $146.556.70 $119,027.06 $14,075.16 $10,947.25 $48,988.50 $26,541.44 $10,119.35 $14,960.00 $34.999.28 $61,375.79 $19,860.05 $33,740.89 $15,565.61 $23,158.20 $21,643.85 $29, 172.11 $15,384.36 $185,159.99 $49,601.47 $15,771.38 $167.009.31 $19,762.07 F $30.944.48 $38,484.38 $103,709.84 $37,469.10 $39,456.20 $51,539.14 $36,242.55 $35,308.73 $37.192.93 $206,462.82 $47.980.76 $60,658.32 $70,288.81 $69,228.82 $38,300.05 $36,979.21 $29,113.53 $115,389.27 $142,214.65 $100,697.07 $28.138.67 $121,260.51 $28,160.09 $38,134.12 $28,433.20 $36.966.36 $76,450.92 $33,161.19 $32.430.65 $96.955.59 $140,667.84 $63,015.27 $49,531.85 $28,758.98 $49,887.02 $84,208.22 $52,257.43 $29,097.61 $35.147.67 $26,359.79 $46,239.84 $37,509.51 $34,398.76 $26,482.86 $47,410,66 $173,995.85 $145,507.27 $32.581.30 $28.978.81 $71,232.45 $44,858.98 $28,233.59 $32,689.67 $55,106.72 $86,595.17 $39.056.92 $54.335.16 $33.799.87 $40.642.93 $39,579.89 $49,987.43 $33,700.06 $213,783.44 $72,171.80 $34,029.51 $194,915.69 $38.510.09 3 6 5 5 6 6 6 H 43 113 390 8 110 182 44 0 0 279 2 204 184 91 87 58 35 152 297 315 42 369 48 14 40 0 79 3 0 360 169 204 9 95 131 221 74 84 8 23 113 22 0 26 58 369 297 256 54 8 56 37 98 39 200 109 11 8 311 0 0 38 30 378 26 254 158 7 0 0 1 1 1 0 1 1 1 0 1 0 0 1 1 1 0 1 1 1 0 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 4 4 2 4 2 2 3 3 3 5 3 5 L 5 3 3 4. 4 2 5 4 3 4 3 1 5 4 2 5 2 2 5 3 4 5 5 3 4 5 4 2 4 5 3 3 3 3 5 1 1 5 2. 5 3 4 2 3 5 5 3 5 4 5 5 5 3 5 5 4 2 5 3 5 1 5 3 4 5 5 2 4 1 M 3 2 1 4 1 2 4 1 2 3 2 2 2 3 1 2 3 4 2 1 1 1 4 3 1 1 2 2 3 1 2 2 2 2 1 1 2 2 5 3 5 1 1 2 3 2 2 3 3 5 1 2 3 3 4 2 3 4 2 1 3 1 2 3 5 6 6 5 8 6 6 6 5 7 1 3 5 3 5 4 5 5 1 1 2 5 2 4 4 5 1 3 3 3 1 3 5 3 2 5 6 6 4 2 2 4 3 2 1 4 6 2 1 1 4 2 4 4 5 4 5 3 4 5 5 3 3 5 5 3 5 5 1 5 5 1 1 3 5 5 3 1 1 3 4 9 6 6 9 8 9 5 9 7 7 9 7 4 3 8 3 2 6 6 5 2 3 3 4 5 3 4 2 1 3 2 1 3 1 5 1 3 4 5 5 3 3 3 2 4 3 1 4 5 5 2 4 3 2 3 2 6 3 10 7 7 5 5 1 5 3 5 1 3 8 J K M 5 3 3 4 4 5 5 5 4 5 1 L 5 3 3 2 2 2 3 5 5 1 3 5 1 3 1 3 1 3 1 2 3 1 1 1 1 1 N 2 5 7 6 5 4 6 8 8 10 4 4 4 6 6 4 5 8 5 4 5 5 5 9 7 5 5 4 A 11267 11268 11269 11270 11271 11272 11273 11274 11275 11276 11277 11278 11279 11280 11281 11282 11283 11284 11285 11286 11287 11288 11289 11290 11291 11292 11293 11294 11295 11296 11297 11298 11299 11300 11301 11302 11303 11304 11305 11306 11307 11308 11309 5 3 4 4 4 4 3 5 4 3 4 3 2 3 5 5 2 5 5 3 3 4 3 4 5 1 1 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 B U 0 0 0 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 0 1 0 1 0 0 1 1 1 0 1 0 1 1 1 1 1 1 0 1 1 1 1 0 1 0 1 1 0 1 1 0 0 1 1 1 1 1 1 0 1 1 1 1 0 C U 6 3 3 13 7 6 10 9 0 4 16 0 12 3 1 16 16 11 3 1 6 4 5 2 2 2 6 1 1 6 4 0 1 5 5 23 7 2 5 1 2. 8 2 13 6 2 2 0 5 3 0 6 5 4 4 4 0 11 3 6 11 7 4 0 3 2 2 0 D $17,508.01 $20.741.84 $19.868.02 $19,465.70 $25,929.09 $21,560.56 $21,427.68 $24,554.36 $22,844.66 $16,658.06 $21,361.55 $30,413.97 $16,534.97 $26,314.87 $19,016.23 $18.490.83 $29,144.56 $27.981.09 $26,190.57 $20,016.21 $17,955.63 $21,506.68 $20,409.95 $20,793.28 $16.899.33 $18,141.18 $21,616.90 $18,740.06 $17,883.38 $22.458.28 $19,553 27 $17.282.04 $18,534.93 $20,504.87 $20,652.44 $35,935.57 $22,152.10 $19,637.77 $22,146.58 $18.873.56 $19.827.60 $22.540.32 $19,472.43 $26,549.40 $22,475.42 $19,539.19 $16,749.29 $20,349,33 $19,299.75 $18,091.58 $21,370.73 $19,899.24 $19,555.10 $20,102.55 $21,157.64 $17,181.62 $24,122.03 $19,666.55 $21,937.16 $24,497.42 $22,509.71 $21,550.76 $17,702.12 $20,258.08 $19.204.23 $18.646.37 $18,422.25 E $10,928.26 $57,389.99 $25,405.53 $24,253.08 $98,958.39 $52,536.48 $49,461.23 $69,929.77 $74,973.73 $11,873.12 $28,963.91 $175.888.44 $13,307.86 $121.644.88 $32.845.63 $17.957.48 $137,259.27 $130,484.20 $78,668.06 $24,948.71 $18,144.86 $56,302.45 $35,977 82 $42.766.37 $25,895.42 $19,715.54 $39,350.05 $12,351.37 $18,008.91 $52,071.09 $34,732.90 $9,565.16 $17,293.68 $33,771.51 $32,698.67 $217,796.10 $59,857.16 $20,183.38 $44.647.52 $13,274.81 $21,318.68 $61,467.04 $23,494.99 $141,759.51 $42,634.727 $24,547.01 $14,075.16 $37,069.04 11 $22.992.86 $9,222.25 $45,452.76 $36,075.18 $33,907.44 $31,562.74 $27.747.17 $12,170.74 $77,549.89 $23,604.60 $49,008.09 $63,780.51 $55,268.79 $22,773.63 $13,808.78 $24.213.88 $20.245.23 $19,720.44 $10,482.47 F $28.436.27 $78,131.83 S45.273.56 $43,718.78 $124,887.48 $74,097.03 $70,888.90 S94,484.13 $97,818.39 $28,531.18 $50,325.46 $206,302.41 $29,842.83 $147,959.75 $51.861.87 $36.448.31 $ 166,403.83 $158,465.29 $104,858.63 $44,964.91 S36,100.49 $77,809.13 $56,387.76 $63,559.64 $42,794.74 $37,856.72 $60.966.95 $31.091.43 $35.892.28 $74,529.36 S54,286.17 S26,847.20 $35,828.61 $54,276.37 $53,351.10 $253,731.67 $82,009.26 $39.821.14 $66.794.10 $32.148.36 $41.146.28 $84,007.37 $42.967.42 $168,308.92 S65, 110.13 $44,086.19 $30,824.45 S57,418.37 $42,292.61 $27,313.83 $66,823.49 S55,974.42 $53,462.55 $51.665.30 $48.904.80 S29,352.36 $101,671.92 $43,271.15 $70,945.25 $88,277.92 $77,778.50 $44,324.40 $31,510.90 $44,471.96 $39.449.46 $38.366.81 $28.904.73 G G 41 3 1 6 2 2 5 5 6 3 3 6 6 1 2. 3 3 2 1 5 4 2 6 5 3 2 2 3 2 2 1 3 3 5 6 4 4 2 2 2 5 2 3 2 3 1 3 2 6 1 6 6 5 2 6 5 4 4 6 6 1 6 4 2 2 5 4 2 H 56 234 82 97 233 352 159 324 286 93 25 321 68 251 42 3 139 463 334 216 2 2 176 308 68 267 34 286 0 0 314 21 24 119 94 231 308 164 34 166 3 26 380 8 188 14 3 3 51 180 67 47 185 291 244 149 63 36 344 44 99 160 114 10 66 107 83 31 19 1 5 5 5 5 5 4 5 4 5 5 4. 5 2 3 3 1 4 5 1 3 4 5 5 5 5 4 5 3 5 5 3 3 4 4 3 4 5 5 2 5 3 3 1 1 2 5 4 5 3 5 5 2 5 5 5 5 4 4 2 3 3 5 4 3 3 4 3 3 1 5 3 2 4 2 2 5 1 3 4 5 2 1 2 5 5 4 1 4 1 2 2 4 4 5 1 1 2 4 2 1 2 4 2 5 5 5 5 5 5 1 1 4 4 4 4 4 5 1 4 1 4 1 1 1 1 5 4 5 4. 1 1 5 4 4 3 5 2 5 5 4 4 5 5 5 3 3 4 6 7 8 9 8 7 9 8 5 8 8 7 8 9 0 3 9 4 5 4 4 8 5 8 8 10 8 7 2 2 2 3 4 2 3 2 1 1 1 1 1 1 3 2 3 5 2 1 5 3 1 2 1 2 2 2 4 1 2 3 1 1 3 2 3 4 4 3 2 4 2 2 1 2 4 5 1 3 1 2 3 11310 9 5 4 5 4 5 5 5 4 4 2 4 2 4 1 5 3 3 2 3 4 5 5 4 5 3 5 11311 11312 11313 11314 11315 11316 11317 11318 11319 11320 11321 11322 11323 11324 11325 11326 11327 11328 11329 11330 11331 11332 11333 5 3 1 5 3 5 5 4 1 2 5 3 2 2 2 4 5 5 5 5 8 4 7 6 9 9 4 3 4 4 1 2 5 2 3 3 5 4 4 4 3 0 10 2 8 4 1 8 8 8 1 9 9 3 2 3 5 4 4 3 5 4 G 0 3 1 j 1 3 4 2 M 2 1 2 5 4 0 6 4 7 . 23 147 67 270 36 49 42 479 101 195 50 0 2 1 1 2 5 1 0 5 1 1 1 B 0 0 1 0 0 1 1 0 1 1 0 1 1 1 0 0 1 1 0 1 1 1 1 1 1 1 1 1 1 0 2 5 3 1 3 3 5 2 3 5 4 1 3 5 5 151 L 4 5 3 4 5 5 5 2 2 4 4 5 4 4 5 5 3 1 1 5 1 4 5 4 2 5 5 4 5 5 3 2 3 3 1 2 3 3 3 2 3 N. 9 10 4 3 7 3 8 7 7 9 8 6 5 7 8 5 5 3 7 7 9 9 8 5 8 10 220 1 1 1 0 1 2 0 7 2 1 1 19 0 2 1 1 0 7 7 0 0 1 3 4 1 3 1 2 2 2 5 4 1 3 3 1 1 1 2 2 4 6 7 7 3 9 2 3 1 1 1 4 4 4 5 4 5 9 7 9 . A 202 11201 203 11202 204 11203 205 11204 206 11205 207 11206 208 11207 209 11208 210 11209 211 11210 212 11211 213 11212 214 11213 215 11214 216 11215 217 11216 218 11217 219 11218 11219 221 11220 222 11221 223 11222 224 11223 225 11224 226 11225 227 11226 228 11227 229 11228 230 11229 231 11230 232 11231 233 11232 234 11233 235 11234 236 11235 237 11236 238 11237 239 11238 240 11239 241 11240 242 11241 243 11242 244 11243 245 11244 246 11245 247 11246 248 11247 249 11248 250 11249 251 11250 252 11251 253 11252 254 11253 255 11254 256 11255 257 11256 258 11257 259 11258 260 11259 261 11260 262 11261 263 11262 264 11263 265 11264 266 11265 267 11266 268 11267 1 1 1 1 1 1 9 2 0 10 3 1 D $18.483.49 $18.702.70 $17.986.86 $20.841.66 $17.855.21 $21.578.93 $20.682.45 $22.417.85 $20.484.65 $17.520.25 $18.018.71 $20.213.38 $17.330.43 $18.291.20 $18.767.62 $18.245.89 $18.631.07 $18.786.59 $17.271.64 $22.632.79 $18.985.00 $17.299.81 $31.447.63 $18.520.84 $18.173.64 $18.424.09 $16.857.68 $22.435.62 $18.238.54 $18.087.29 $23.755.85 $18.801.91 $17.141.82 $24,301.46 $18,043.81 $19.009.49 $19.777.39 $17.466.98 $19.343.23 $19.323.63 $20.969.64 $18.435.72 $20.509.14 $20.323.00 $19.494.49 $22.300.29 $20.810.43 $17.931.75 $20.057.23 $18.619.42 $20.623.66 $16.263.70 $25.188.76 $23.056.54 $17.171.82 $26.313.04 $23.017.36 $18.866.82 $24.728.26 $19.716.15 $19.602.26 $17.582.71 $20.355.45 $ 16,946,48 $19.025,41 $18,023.60 $17.508.01 E $9,051.40 $31.151.85 $13,148.05 $30.136.58 $8,783.80 $47.928.51 $30,285.99 $58,392.41 $50,470.39 $15.209.23 $9.837.67 $36.959.42 $16.067.74 $13.495.26 $16.190.22 $10,663.11 $17.405.13 $20.692.85 $10.413.28 $63.383.09 $23.188.81 $20.393.41 $216.183.65 $11.649.00 $17.522.09 $14.719.96 $11.792.30 $49.331.41 $8,900.15 $7,863.44 $76.577.48 $20.970.26 $11,638.59 $74,311.16 $23.714.21 $17.530.05 $20.542.83 $12.296.26 $36,507.51 $24.212.66 $27.967.61 $15.202.49 $22.863.03 $33.965.62 $24.565.99 $82.457.30 $34.140.14 $10.405.92 $34.828,43 $15.929.97 $43.728.99 $11.072.17 $97.336.27 $65.300.38 $8,453.75 $109,555.18 $49.115.25 $18.007.07 $89.133.79 $17,355.52 $23.045.52 $11,350.79 $41,515.33 $17.640.89 $29,445.23 $13,304.81 $10.928.26 F $27,534.89 $49,854.55 $31,134.91 $50,978.24 S26,639.02 $69,507.43 $50,968.45 $80,810.26 $70.955.04 $32.729.48 $27.856.38 $57.172.80 $33,398.17 $31.786.46 $34.957.84 $28.909.00 $36.036.19 $39.479.45 $ $27.684.92 S86.015.89 $42.173.81 $37.693.22 $247.631.28 $30.169.85 $35.695.73 $33.144.05 $28,649.98 $71,767.03 $27,138.69 $25,950.73 $100,333.33 $39.772.17 $28,780.41 $98,612.62 $41,758.02 $36,539.54 $40,320.22 $29.763 24 $55.850.74 $43,536 29 $48.937.25 S33.638 21 $43.372.18 $54.288.62 $44.060.48 $104.757.58 S54.950.57 $28.337.68 S54.885.66 $34,549.39 S64.352.65 $27.335.87 $122.525.03 $88.356.91 $25,625.57 $135,868.22 $72.132.61 $36,873.89 $113,862.05 $37,071.68 $42,647.78 $28,933.49 $61,870.78 $34.587.37 $48,470.65 $31,328.41 $28.436.27 6 6 3 4 3 2 1 5 5 2 2 6 2 1 2 2 4 2 2 5 5 2 2 1 5 5 5 2 1 1 6 3 1 5 3 4 1 5 1 5 4 6 1 5 5 6 1 1 6 2 1 3 2 2 2 3 5 2 1 2 3 1 2 3 6 5 4 4 I 1 5 5 5 4 2 2 4 5 4 5 5 5 3 2 1 3 4 1 4 3 3 4 5 4 5 5 5 5 5 5 5 4 5 5 4 4 2 5 5 5 5 2 4 5 4 5 1 3 1 1 2 5 3 3 2 4 5 2 5 5 3 5 5 4 4 5 5 2 3 2 5 3 5 5 5 2 1 1 1 5 1 4 5 1 5 1 4 5 5 1 5 5 5 5 4 2 4 5 1 5 1 2 4 5 5 5 5 1 5 4 1 1 5 1 2 5 4 2 4 1 4 4 1 5 4 2 5 1 1 2 1 1 1 2 1 3 4 5 2 3 2 5 3 1 5 4 7 2 9 2 0 45 98 33 0 44 34 297 158 83 434 40 126 0 68 316 113 36 441 1 50 233 8 0 0 50 73 72 225 101 291 272 38 408 75 60 112 219 274 82 209 269 22 314 386 0 248 4 194 50 398 11 129 182 56 1 1 0 1 0 0 4 3 4 1 3 4 3 3 3 3 5 8 8 9 1 5 8 8 4 9 2 8 4 3 3 9 4 0 4 2 2 4 5 5 5 1 1 3 1 6 0 11 3 2 5 2 5 2 4 2 5 5 2 5 3 1 2 3 5 5 5 5 5 5 5 4 5 5 5 1 5 5 4 4 2 5 1 0 1 1 1 1 1 0 1 0 1 1 0 1 1 1 1 1 0 0 1 0 1 0 0 1 4 1 3 1 2 5 2 1 2 1 1 2 2 3 1 2 2 2 1 2 2 2 1 4 2 2 1 2 1 2 4 8 8 9 9 6 0 13 7 1 11 2 5 5 2 5 5 4 8 8 7 9 1 8 7 3 0 5 1 5 5 3 5 2 3 3 7 5 9 8 3 4 3 1 0 1 2 4 5. 5 1 5 4 5 M 1 5 2 3 2 2 1 B 1 1 0 1 1 0 0 1 1 1 1 1 1 1 1 0 0 0 1 1 1 0 0 1 1 1 L 4 4 3 3 3 2 5 3 3 4 5 5 5 . 1 16 0 13 12 3 0 4 3 6 7 0 22 2 1 5 2 4 0 1 A 11134 11135 11136 11137 11138 11139 11140 11141 11142 11143 11144 11145 11146 11147 11148 11149 11150 11151 11152 11153 11154 11155 11156 11157 11158 11159 11160 11161 11162 11163 N 9 0 7 3 4 10 5 6 3 8 10 6 6 5 2 4 9 10 9 5 8 9 5 4 7 4 8 G 5 4 6 4 2 3 5 2 4 2 6 6 5 1 2 5 5 6 2 5 2 2 5 6 4 1 6 5 3 6 2 1 1 1 3 1 1 0 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 1 1 0 6 1 6 0 1 18 8 8 1 2 3 14 11 6 5 2 4 5 5 5 3 4 5 3 1 5 2 5 5 5 3 4 3 5 4 5 3 2 5 1 5 5 2 3 2 4 5 3 D $16,664.80 $28,472.19 $17,323.69 $25,883.17 $25,949.30 $19,705.74 $17,490.24 $20,192.57 $19.929.26 $22,114.13 $21,673.23 $17.276.53 $33,922.14 $20,494.46 $19,233.01 $20,639.59 $19,255.67 $18,870.49 $18,983.16 $17.456.57 $21,773.04 $19.258.11 $22,619.33 $18,149.75 $18,838.03 $30,845.67 $23,341.90 $22,552.57 $18,140.57 $17,741.31 $19,893.74 $27,611.23 $23,855.05 $21,594.24 $21,055.99 $18,490.23 $22.861.20 $20,835.54 $23,810.96 $23,696.45 $21,496.27 $24,282.48 $18,323.04 $21.297.24 $21,172.94 $17,453.50 $21,411.15 $18,213.43 $17,962.99 $17,723,55 $23,897.31 $17,405.13 $19,514.08 $22,378.67 $19,511.62 $22,299.07 $17,500.65 $18,967.86 $17,046.91 $17,379.41 $23,393.33 $20.912.69 $19,631.64 $25,117.73 $19,245.86 $21,292.35 $23,899.14 11164 $16,085,51 $178,218.95 $11.250.97 $106.146.81 $68,341.94 $26,358.35 S9.168.97 $26, 168.52 $26,772.92 $59,225.83 $72,365,10 $13,159.68 $208,758.28 $15,244.75 $13,781.23 $40.941.55 $16,430.87 $35,990.68 $8.157.37 $12.747.57 $47,500.48 $12.938.62 $44,908,38 $10,988.89 $16,189.00 $150,645.91 $57,318.34 $62,199,42 $16.191.45 $20.676.33 $20.983.72 $106,208.04 $73,571.44 $57,391.82 $47.281.86 $11,876.19 $69.924.25 $37,614.64 $62,325.56 $73,572.66 $39,297.39 $66,016.83 $21,505.45 $46,073.08 $42.246.48 $12.756.14 $53,243.13 $16,770.12 59.367.38 $17,471.27 $79,414.51 $10,126.08 $25,672.52 $55,074.68 $37,015 14 $41,189,56 $12,066.02 $22,208.43 $15,783.01 $12,439.55 $60,656.29 $30,466.02 $26, 100.55 $86,258.18 $26,096.26 $37,468.29 $87,819.06 $32,750.31 $206,691.15 $28,574.66 $132,029.98 $94,291.24 $46,064.10 $26.659.21 $46,361.09 $46,702.18 $81,339.96 $94,038.34 $30,436.21 $242,680.42 $35,739.21 $33,014.23 $61,581.14 $35,686.54 $54,861.17 $27.140.53 $30,204.13 $69,273.52 $32,196.72 $67,527.71 $29,138.64 $35,027.03 $181,491.59 $80,660.24 $84,751.99 $34,332.01 $38,417.63 $40,877.46 $133,819.27 $97,426.49 $78,986.07 $68,337.85 $30,366.41 $92,785.45 $58,450.18 $86,136.52 $97,269.11 $60,793.65 $90,299.31 $39,828.49 $67,370.32 $63,419.42 $30,209.64 $74,654.29 $34,983.55 $27,330.36 $35,194.82 $103,311.82 $27,531.20 $45,186.59 $77,453.35 $56,526.77 $63,488,63 $29,566.67 $41,176.29 $32,829.91 $29,818.97 $84,049.62 $51,378.71 $45,732.19 $111,375.91 $45,342.12 $58,760.64 $111.718.21 J 3 3 2 1 5 3 3 3 3 3 4 3 3 4 4 5 5 3 5 4 5 2 2 3 1 4 1 4 2 2 5 1 4 4 1 5 5 1 2 4 4 5 3 4 4 4 3 5 2 4 4 3 2 1 3 4 4 H 200 489 34 277 170 293 28 78 171 437 15 55 375 16 47 118 134 87 15 169 48 0 198 51 354 237 68 412 159 16 27 303 244 115 148 37 155 79 325 234 349 264 0 193 203 40 219 0 29 0 189 34 276 133 119 72 63 95 401 42 199 29 132 94 1 1 1 1 0 0 1 0 1 1 1 1 0 1 0 1 1 1 0 1 1 1 0 1 0 1 1 1 5 2 5 1 5 5 5 1 4 3 1 2 2 5 2 4 2 3 1 2 1 1 5 1 1 1 1 4 3 1 2 1 5 1 1 3 4 1 1 1 5 3 2 4 5 1 1 1 5 4 5 5 4 2 5 1 2 1 1 2 2 2 5 3 1 3 1 2 3 1 1 2 2 1 2 4 2 2 1 2 1 1 1 1 3 2 2 1 1 1 3 1 5 4 1 2 1 4 1 3 1 1 2 1 2 1 1 3 5 4 3 1 1 5 5 3 4 5 4 4 3 2 3 3 5 4 2 3 1 5 4 4 2 4 3 5 4 2 5 5 4 10 3 10 6 5 6 7 8 5 8 5 9 11165 11166 11167 11168 11169 11170 11171 11172 11173 11174 11175 11176 11177 11178 11179 11180 11181 11182 11183 11184 11185 11186 11187 11188 11189 11190 11191 11192 11193 11194 11195 11196 11197 11198 11199 11200 5 6 3 0 8 5 8 10 6 9 1 1 6 4 4 5 3 5 5 5 7 9 9 7 7 5 0 6 1 0 1 1 9 0 3 2 2 6 5 5 1 6 3 5 5 6 4 1 6 4 5 2 1 3 2 6 1 5 3 6 1 1 6 2 3 1 5 5 4 5 5 5 4 4 3 4 2 5 4 1 3 2 1 4 1 5 5 4 5 4 5 5 5 4 3 3 5 3 1 2 4 2 2 5 5 5 9 4 5 7 7 2 5 6 3 10 2 8 5 5 8 10 7 9 6 7 10 1 5 5 1 1 4 7 4 6 0 0 2 1 0 9 5 3 10 3 5 10 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 3 4 2 2 3 4 3 5 1 1 4 5 4 5 5 5 3 5 5 5 3 4 5 2 1 1 1 3 2 1 2 3 114 259 317 G 2 5 2 1 I 5 1 4 4 5 5 4 2 4 5 2 4 4 4 5 4 L 5 2 3 5 3 3 5 2 N 2 4 7 7 7 5 5 8 4 9 4 2 5 3 5 2 3 7 5 3 3 5 4 4 4 8 0 5 7 4 4 2. 4 3 4 5 5 3 3 1 5 4 5 4 5 3 5 4 3 4 4 3 3 4 5 4 5 5 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 B 0 0 1 1 1 1 1 0 1 1 1 0 1 0 1 0 1 0 1 1 0 1 0 1 1 1 1 1 1 1 0 1 0 1 1 0 1 1 0 1 0 1 1 1 1 1 1 0 1 0 1 1 1 0 1 1 0 1 1 1 0 1 1 1 0 0 1 1 1 11340 11341 11342 11343 11344 11345 11346 11347 11348 11349 11350 11351 11352 11353 11354 11355 11356 11357 11358 11359 11360 11361 11362 11363 11364 11365 11366 11367 11368 11369 11370 11371 11372 11373 11374 11375 11376 11377 11378 11379 11380 11381 11382 11383 11384 11385 11386 11387 11388 11389 11390 11391 11392 11393 11394 11395 11396 11397 11398 11399 11400 11401 11402 11403 11404 11405 11406 4 C 0 8 6 10 0 3 3 7 0 3 2 5 9 3 2 1 3 3 4 0 6 7 2 1 0 10 6 8 6 6 19 0 21 0 1 4 0 3 0 0 13 2 2 14 11 4 1 13 1 3 4 16 3 12 1 3 11 1 12 2 4 0 1 0 3 3 10 14 10 D $18,512.87 $23,249.43 $22.457.05 $24,857.47 $18,130.16 $19,338.95 $19.922.52 $22,229.86 $17,492.09 $20,417.29 $19,128.91 $20,552.63 $24,067.54 $19,125.23 $18,913.35 $18,177.93 $19,711.25 $19,085.43 $20,752.25 $16,622.55 $21,497.49 $22,513.39 $18,190.78 $18,945.20 $18,051.77 $23,970.79 $23,066.34 $22,634.01 $20,796.95 $30,808.33 $17,498.82 $33,219.77 $17,495.14 $17,781.73 $20,274.61 $16,744.40 $20,067.65 $16,868.71 $27,094.40 $19,757.80 $19,432.02 $27,098.07 $25,676.81 $20,014.99 $18,832.53 $27,990.27 $17,912.76 $19,443.05 $20,532.42 $29,023.31 $19,583.27 $25,801.73 $18.150.36 $19,589.39 $25,087.71 $18,602.28 $25,384.10 $17,874.80 $19,833.12 $18,049.93 $18,019.93 $17,008.93 $18,455.32 $19,390.99 $24,647.44 $26,483.28 $24,183.27 H 73 74 251 184 58 327 182 150 56 156 364 22 190 344 47 6 29 103 140 72 120 295 44 3 45 211 429 176 181 280 28 224 45 367 58 55 120 38 266 370 32 271 375 283 22 467 129 155 103 140 E $10,384.50 $55,091.83 $50,526.72 $82,308.50 $10,711.49 $22,762.00 $22,825.69 $47,558.04 $11,740.86 $23,373.74 $18.403.26 $41,692.91 $51,466.69 $29.880.00 $20,788.39 $20,270.33 $26,796.18 $22,324.16 $27,376.70 $11,477.54 $45,440.52 $58,882.30 $26,550.64 $14,248.45 $9,645.39 $79,070.98 $43,344.43 $42.972.13 $57,656.97 $177,469.47 $10,489.82 $168,079.63 $10,428.58 $14,246.00 $36,125.40 $10,867.03 $24.971.37 $10,775.17 $87,860.71 $19.422.84 $20,104.39 $140,377.34 $88,078.10 $31,261.47 $14,767.72 $124,627.66 $21,473.61 $19,560.00 $35,879.84 $200,119.29 $28,483.22 $121.647.93 $17.452.28 $26.015.44 S101,194.10 $15,847.30 $82,344.02 $24,835.43 $35,652.65 $8,584.78 $13,569.34 $11,664.32 $32,829.10 $23,109.81 $71,918.09 S123,777.14 $93,851.36 F $28,897.37 $78,341.26 $72,983.77 $ 107,165.97 $28,841.64 $42,100.95 $42.748.21 $69,787.90 $29,232.94 $43,791.03 $37,532.17 $62,245.54 $75,534.23 $49,005.23 $39,701.74 $38,448.25 $46,507.43 $41,409.59 $48,128.95 $28,100.09 $66,938.00 $81,395.68 $44,741.41 $33,193.65 $27,697.16 $103.041.77 $66,410.77 $65,606.14 $78,453.92 $208,277.80 $27,988.63 $201,299.41 $27,923.73 $32,027.73 $56,400.01 $27,611.43 $45,039.01 $27,643.88 $ 114,955.11 $39.180.64 $39,536.41 $167,475,41 $ 113,754.91 $51,276.46 $33,600.25 $152,617.93 $39,386.37 $39,003.04 $56,412.26 $229.142.60 $48,066.49 $147,449.66 $35,602.64 $45,604.83 $126,281.81 $34,449.58 $107,728.11 $42,710.23 $55,485.77 $26,634.72 $31,589.27 $28,673.25 $51.284.42 $42,500.80 $96,565.52 $150,260.41 $118,034.63 2 4 2 1 6 3 2 2 1 6 2 1 1 1 1 6 5 2 4 6 4 1 1 3 5 5 4 5 1 1 1 1 3 2 2 1 1 4 6 6 2 5 5 5 2 4 6 2 2 6 1 4 1 1 4 5 2 3 2 6 5 6 4 2 4 4 4 5 4 2 5 J 5 1 5 5 5 4 5 1 4 5 5 1 5 4 1 5 3 5 4 3 4 3 4 2 5 3 4 3 2 3 5 3 5 1 5 5 5 4 5 4 3 3 1 4 5 5 5 4 4 5 1 4 2 5 4 3 3 5 1 5 3 2 4 4 4 3 2 5 4 4 5 5 2 1 2 2 5 4 2 5 1 1 5 1 1 3 2 4 1 2 4 4 4 1 1 4 1 1 1 1 5 5 5 2 5 4 1 1 5 5 5 5 4 5 4 1 1 2 2 5 5 5 5 5 4 5 5 1 2 2 1 4 5 4 3 5 5 5 M 3 3 1 4 3 4 3 2 3 2 2 1 3 3 1 2 4 1 1 1 4 5 2 5 5 2 1 2 4 2 5 3 3 3 1 3 2 2 2 2 5 3 1 4 2 1 2 3 5 1 2 1 3 1 5 1 4 1 2 3 1 1 2 2 5 1 1 5 2 5 5 5 5 5 4 4 5 5 5 5 5 4 3 4 5 1 4 4 9 3 5 0 5 3 5 8 7 0 7 6 9 5 7 7 4 9 4 1 1 8 8 4 2 9 9 10 2 7 9 4 5 7 3 8 2 9 7 8 9 8 8 8 332 5 3 4 5 4 5 5 4 4 2 2 5 5 2 5 5 4 5 4 5 5 214 0 223 127 4 346 8 210 26 0 130 291 278 248 225 263 3 4 4 2 5 4 1 2 3 5 3 5 5 3 5 2 5 5 4 5 5 2 2 5 5 4 1 8 2 8 1 5 A B C G I L 4 408 409 11407 11408 D $21,357.26 $22,006.36 5 E $26,586.76 $48.708.03 1 1 1 H 19 15 $47,944.02 $70,714.39 2 5 J 5 1 K 4 2 M 3 2 N 4 7 6 4 4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting International Financial Reporting Standards Global Edition

Authors: Charles T. Horngren, C. William Thomas, Wendy M. Tietz, Themin Suwardy, Walter T. Harrison

11th Edition

9781292211145

More Books

Students also viewed these Accounting questions