Discuss the below:
Q: Can demographic information be helpful in predicting sales at a sporting goods stores? The data stored in the fill Sporting are the monthly sales totals from a random sample of 38 stores in a large chain of nationwide sporting goods stores. All stores in the franchise, and thus within the sample, are approximately the same size and carry the same mechanise. The county or, in some cases, counties in which the store draws the majority of its customers is referred to here as the customer base. For each of the 38 stores, demographic information about the customer base is provided. The data are real, but the name of the franchise is not used at the request of the company. The variables in the data set are:
Sales- Latest one-month sales total (dollars)
Age- Median age of customer base (years)
HS- Percentage of customer base with a high school diploma
College- Percentage of customer base with a college diploma
Growth- Annual population growth rate of customer base over the past 10 years
Income- Median family income of customer base (dollars)
A.) Construct a scatter plot, using sales as the dependent variable and median family income as the independent variable. Discuss the scatter plot.
B.) Assuming a linear relationship, use the least-squares method to compute the regression coefficients b0 and b1.
C.) Interpret the meaning of the Y intercept, b0, and the slope, b1, in this problem.
D.) Compute the coeffiecient of determination, r2, and interpret its meaning.
E.) Perform a residual analysis on your results and determine the adequacy of the fit of the model.
F.) At the 0.05 level of significance, is there eveidence of a linear relationship between the independent variable and the dependent variable?
G.) Construct a 95% confidence interval estimate of the population slope and interpret its meaning.
| Sales |
Age |
Growth |
Income |
HS |
College |
| 1695712.620 |
33.1574 |
0.8299 |
26748.51 |
73.5949 |
17.8350 |
| 3403862.053 |
32.6667 |
0.6619 |
53063.79 |
88.4557 |
31.9439 |
| 2710352.905 |
35.6553 |
0.9688 |
36090.14 |
73.5362 |
18.6198 |
| 529215.459 |
33.0728 |
0.0821 |
32058.07 |
79.1780 |
20.6284 |
| 663686.654 |
35.7585 |
0.4646 |
47843.42 |
84.1838 |
35.2032 |
| 2546324.335 |
33.8132 |
2.1796 |
50180.97 |
93.4996 |
41.7057 |
| 2787046.202 |
30.9797 |
1.8048 |
30710.08 |
78.0234 |
28.0250 |
| 612696.054 |
30.7843 |
-0.0569 |
29141.70 |
70.2949 |
15.0882 |
| 891822.033 |
32.3164 |
-0.1577 |
25980.15 |
70.6674 |
10.9829 |
| 1124967.965 |
32.5312 |
0.3664 |
18730.88 |
63.7395 |
13.2458 |
| 909500.976 |
31.4400 |
2.2256 |
31109.23 |
76.9059 |
19.5500 |
| 2631166.881 |
33.1613 |
1.5158 |
35614.12 |
82.9452 |
20.8135 |
| 882972.654 |
31.8736 |
0.1413 |
23038.43 |
65.2127 |
16.9796 |
| 1078573.124 |
33.4072 |
-1.0400 |
34531.72 |
73.4944 |
32.9920 |
| 844320.194 |
34.0470 |
1.6836 |
30350.36 |
80.2201 |
22.3185 |
| 1849119.029 |
28.8879 |
2.3596 |
38964.94 |
87.5973 |
24.5670 |
| 3860007.316 |
36.1056 |
0.7840 |
49392.77 |
85.3041 |
30.8790 |
| 826573.880 |
32.8083 |
0.1164 |
25595.69 |
65.5884 |
17.4545 |
| 604682.868 |
33.0538 |
1.1498 |
29622.61 |
80.6176 |
18.6356 |
| 1903611.600 |
33.4996 |
0.0606 |
31586.10 |
80.3790 |
38.3249 |
| 2356808.391 |
32.6809 |
1.6338 |
39674.56 |
79.8526 |
23.7780 |
| 2788571.957 |
28.5166 |
1.1256 |
28878.98 |
81.2371 |
16.9300 |
| 634878.286 |
32.8945 |
1.4884 |
24287.08 |
70.2244 |
19.1429 |
| 2371627.369 |
30.5024 |
4.7937 |
46711.24 |
87.1046 |
30.8843 |
| 2627837.961 |
30.2922 |
1.8922 |
33449.81 |
80.2057 |
26.5570 |
| 1868116.330 |
31.2911 |
1.8667 |
31694.45 |
75.2914 |
28.3600 |
| 2236796.862 |
33.0498 |
1.7896 |
25459.22 |
77.6162 |
19.2490 |
| 1318876.234 |
32.9348 |
0.2707 |
47047.34 |
85.1753 |
35.4994 |
| 1868097.836 |
31.8381 |
3.0129 |
26433.24 |
74.1792 |
18.6375 |
| 1695218.566 |
31.0794 |
23.4630 |
33396.66 |
81.6991 |
41.1130 |
| 2700194.415 |
32.1807 |
0.7041 |
26179.36 |
73.4140 |
17.8566 |
| 1156049.774 |
31.6944 |
-0.1569 |
33454.64 |
73.7161 |
26.5426 |
| 643858.444 |
34.0263 |
0.7084 |
42271.50 |
78.6493 |
29.8734 |
| 2188687.363 |
34.7315 |
0.1353 |
46514.75 |
80.9503 |
24.5374 |
| 830351.940 |
30.5613 |
0.3848 |
27030.81 |
66.8057 |
14.1390 |
| 1226905.572 |
33.5183 |
0.7417 |
42910.08 |
77.8905 |
20.8340 |
| 566903.589 |
32.3952 |
0.6693 |
40561.40 |
79.3622 |
19.0309 |
| 826518.398 |
29.9108 |
0.1111 |
22325.96 |
58.3610 |
10.6729 |