was sun Jun 26 u. null 9 0 "M I] Done

Jtwave Revie Page Layout Formulas Data Insert Home PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless X V fx Store # Customer base data for sporting goods stores 23038.43, 65.2127 38964.941 87.5973 39674.56; 79.8526 14235 sun Jun 26 Done No Yes 0 60% a myclassroom.apus.edu Store # 10 11 12 13 14 15 16 17 Sales 1695712.62 33.1574 Age Growth 3403862.053 2710352.905 529215.459 663686.654 2546324.335 2787046.202 612696.054 891822.033 1124967.965 909500.976 2631166.881 882972.654 1078573.124 844320.194 1849119.029 3860007.316 826573.88 604682.868 1903611.6 2356808.391 32.6667 35.6553 33.0728 35.7585 33.8132 30.9797 30.7843 32.3164 32.5312 31.44 33.1613 31.8736 33.4072 Income 2674861 08299 5306379 0.6619 36090.14 09688 3205807 0.0821 0.4646 4784342 50180.97 2.1796 30710.08 1.8048 29141.7 -0.0569 25980.15 -0.1577 18730.88 0.3664 31109.23 2.2256 35614.12 1.5158 0.1413 34531.72 -1.04 30350.36 1.6836 2.3596 0.784 49392.77 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 2788571.957 634878.286 2371627.369 2627837.961 1868116.33 2236796.862 1318876.234 1868097.836 1695218.566 2700194.415 1156049.774 643858.4M 2188687.363 830351.94 1226905.572 566903889 826518.398 34.047 28.8879 36.1056 32.8083 33.0538 33.4996 32.6809 28.5166 32.8945 30.5024 30.2922 31.2911 33.0498 32.9348 31.8381 31.0794 32.1807 31.6944 34.0263 34.7315 30.5613 33.5183 32.3952 299108 0.1164 1.1498 0.0606 1.6338 1.1256 _ 7937 1.8922 1.8667 1.7896 0.2707 3.0129 23.463 0.7041 -0.1569 0.7084 0.1353 0.3848 07417 0.6693 25595.69 29622.61 31586.1 28878.98 24287.08 46711.24 33449.81 31694.45 25459.22 47047.34 26433.24 33396.66 26179.36 33454.64 42271.5 46514.75 27030 RI 4291008 40561.4 2232586 HS 73.5949 884557 735362 79.178 84.1838 93.4996 78.0234 70.2949 70.6674 63.7395 76.9059 82.9452 73.4944 80.2201 85.3041 65.5884 80.6176 80.379 81.2371 70.2244 87.1046 80.2057 75.2914 77.6162 85.1753 74.1792' 81.6991 73.414 73.7161 78.6493 80 qr003 668057 77.8905 79.3622 68.361 College 17.835 31.9439 18.6198 206284 36.2032 41.7057 28.025 150882 10.9829 13.2458 19.55 20.8135 16.9796 32.992 22.3185 24.567 30.879 17.4545 18.6356 38.3249 23.778 16.93 19.1429 30.8843 26.557 28.36 19.249 35.4994 186375 41.113 17.8566 26.5426 29.8734 246374 14.139 20.834 19.0309 106729 It cannot be determined View hint for Question 16 Question 17 (5 points) Using the estimated regression equation derived in question 14, find a 95% confidence interval estimate for the monthly sales associated with a store located in an area where the median family income is $35000. Place your limits, rounded to the nearest dollar, in the blanks. Do not use dollar signs, commas, or other punctuation in your responses. A minus sign can be used. For example, -67543 or 4336452 would be valid entries. Lower limit = _ Upper limit = _ Blank Blank #2 Question 18 (5 points) With respect to the response variable, monthly sales, which predictor variable among those given in the worksheet CustomerData, provides the most explanatory power? Age Growth Income HS College