14:35 Sun Jun 26 n I. :7: I 4 ill '? O 80 Done

I 0 60 a myclassroom.apus.edu Data Revie Page Layout Formulas Insert Home PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unles X fx Store # Customer base data for sporting goods stores 14:35 sun Jun 26 Done < Blank # 2 Question 18 (5 points) Store # 10 11 12 13 14 15 16 17 Sales 33.1574 1695712.62 3403862.053 32.6667 35.6553 2710352.905 33.0728 529215.459 35.7585 663686.654 2546324.335 33.8132 2787046.202 30.9797 612696.054 30.7843 891822.0331 32.3164 32.5312 1124967.965 909500.976 2631166.881 882972.654 1078573.124 844320.194 1849119.029 3860007.316 826573.88 A e Growth 31.44 33.1613 31.8736 33.4072 34.047 28.8879 36.1056 32.8083 33.0538 33.4996 32.6809 28.5166 32.8945 30.5024 30.2922 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 42 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 604682.868 1903611.6 2356808.391 2788571.957 634878.286 2371627.369 2627837.961 1868116.33 2236796.862 1318876.234 1868097.836 1695218.566 2700194.415 1156049.774 643858_444 31.2911 33.0498 329348 31.8381 31.0794 32.1807 31.6944 34.0263 34.7315 30G613 33.5183 Income 2674851 08299 53063.79 06619 36090.14 09688 3205807 00821 47843.42 04646 50180.97 2M796 30710.08 18048 29141.7 -0.0569 25980.15 -0.1577 0.3664 18730.88 31109.23 29256 35614.12 1.5158 O A413 23038.43 -1.04, 34531.72 1 G836 30350.36 38964.94 2.3596 49392.77 0.784 0.1164 2559569 1.1498 29622.61 0.0606 31586.1 1.6338 39674.56 1.1256 28878.98 I .4884 24287.08 4.7937 46711.24 1.8922 33449.81 1.8667 31694.45 1.7896 25459.22 0.2707 47047.34 3.0129 26433.24 23.463 33396.66 0.7041 26179.36. -0.1569 33454.64 0.7084 42271.5 2188687.363 830351.94 1226905.572 566903.589 826518398 0.1353 0.7417 0.6693 328952 299108 46514.75 27030 RI 4291008 40561.4 2232586 HS 73.5949 884567 736362 79.178 93.4996 78.0234 70.2949 706674 637395 76.9059 82.9452 65.2127 73.4944 80.2201 87.5973 8543041 80.6176 80B79 79.8526 819371 70.2244 67M 046 899057 75991k 77.6162 85.1753 74.1792 816991 73.414 73.7161 78.6493 800503 66 nor07 77 R905 79.3622 58261 Colle e 17835 31.9439 186198 206284 35.2032 41.7057 28025 150882 10.9829 139458 19.55 208135 16.9796 32.992) 22.3185 241567 30.879 17.4545 18.6356 38.3249 23.778 16.93 19-1429 30.8843 26.657 >8136 II 9.249 "4994 186375 41.113 17.8566 26.5426 298734 248374 14.139 20.834 19.0309 106729 With respect to the response variable, monthly sales, which predictor variat among those given in the worksheet CustomerData, provides the most explanatory power? Age Growth Income College Question 19 (5 points) Data regarding the salaries and bonuses received by the nearly 1800 player the National Football League during the 2000 season are provided in the worksheet NFL2000 in the Excel workbook MATH530 Exam3.xls, which be found as an attachment to this question. Using these data, perform an appropriate test of hypothesis, at the a = .05 level of significance, to determine whether compensation for players in the NFL is dependent on th team for which they play. What is the value of the sample test statistic? 113.15 160.47 = 0.0001