Total Excel work

profileafdybz
Regression_Assignment_data1.xlsx
Home>Business & Finance homework help>Total Excel work

Q1 data

Day 24oz units 12oz units Size change Label change Total minutes
1 4400 7650 7 6 178
2 9600 4430 3 9 136 SUMMARY OUTPUT
3 7440 4060 5 7 88
4 9800 8035 2 5 124 Regression Statistics
5 11500 6140 9 10 241 Multiple R 0.9652034251
6 6280 6900 8 12 202 R Square 0.9316176518
7 8320 6770 4 2 111 Adjusted R Square 0.9206764761
8 10500 5300 4 8 146 Standard Error 16.7299882564
9 11450 4560 10 14 263 Observations 30
10 2830 3830 7 7 177
11 10850 6880 6 9 200 ANOVA
12 2680 3920 11 14 269 df SS MS F Significance F
13 7400 7160 14 16 318 Regression 4 95328.9873235525 23832.2468308881 85.1478558015 0
14 3720 8700 6 11 199 Residual 25 6997.3126764474 279.8925070579
15 4580 8500 8 9 191 Total 29 102326.3
16 3770 5050 9 13 247
17 2820 3220 2 4 60 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
18 5070 6400 8 12 200 Intercept -2.377596872 16.2975483293 -0.1458867815 0.8851807109 -35.9430259715 31.1878322275 -35.9430259715 31.1878322275
19 7300 8900 7 8 181 24oz units 0.0022415107 0.0010252698 2.18626413 0.0383707821 0.0001299279 0.0043530934 0.0001299279 0.0043530934
20 7060 6640 3 3 117 12oz units 0.0047027371 0.0020134783 2.335628347 0.0278322673 0.0005559008 0.0088495734 0.0005559008 0.0088495734
21 3050 7740 7 9 199 Size change 14.2080770462 1.9837469465 7.1622426799 0.000000166 10.122473731 18.2936803614 10.122473731 18.2936803614
22 10480 6400 10 12 271 Label change 5.2559462352 1.5885859955 3.3085689097 0.0028443161 1.9841921331 8.5277003374 1.9841921331 8.5277003374
23 3800 6000 4 4 114
24 6570 6800 9 9 212 x1 0.005 55%
25 6140 7000 7 12 189 x2 0.0039215686 -20%
26 10370 8600 6 7 195 x3 10 -42%
27 4060 7000 5 5 139 x4 5 -5%
28 3470 7200 8 12 223
29 10130 6900 10 10 246
30 11300 8450 6 9 195

Q2 data

Property # Profit Size Advertexp Mgrperf Neighbors Attract
1 166.855 0 12.72 3 8 1
2 299.980 0 42.50 3 5 2
3 840.615 1 32.35 4 28 3
4 201.433 0 10.09 5 4 2
5 872.874 1 20.27 4 31 3
6 186.493 1 23.70 2 9 3
7 300.901 1 19.11 3 9 4
8 755.746 1 32.87 4 19 3
9 808.764 1 40.37 4 17 3
10 332.976 0 25.37 4 13 2
11 590.922 1 46.40 3 6 2
12 329.644 0 39.47 2 12 1
13 829.321 1 38.99 5 7 3
14 713.162 1 42.72 4 13 4
15 341.979 0 29.17 3 24 2
16 322.471 0 43.33 3 6 2
17 608.782 1 40.95 3 3 2 SUMMARY OUTPUT
18 134.128 0 26.01 3 9 1
19 194.545 0 22.53 5 11 1 Regression Statistics
20 494.896 1 21.52 4 12 3 Multiple R 0.3851958122
21 206.774 1 27.91 3 4 3 R Square 0.1483758138
22 565.189 1 31.51 4 8 3 Adjusted R Square 0.1336926381
23 279.658 0 33.81 3 7 3 Standard Error 244.2010125818
24 89.235 0 43.45 1 6 2 Observations 60
25 372.522 1 17.41 4 2 2
26 89.877 0 29.45 4 7 3 ANOVA
27 91.116 0 23.86 2 11 1 df SS MS F Significance F
28 201.996 0 32.04 5 6 2 Regression 1 602612.368589524 602612.368589524 10.1051582819 0.002372386
29 673.770 1 44.16 5 11 2 Residual 58 3458779.80366727 59634.1345459875
30 326.183 0 45.10 4 7 4 Total 59 4061392.1722568
31 382.848 0 28.69 4 14 1
32 730.514 1 43.87 4 13 2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
33 457.112 1 24.84 3 12 1 Intercept 158.6375159665 91.6634833378 1.730651184 0.0888315905 -24.8468812884 342.1219132214 -24.8468812884 342.1219132214
34 823.807 1 49.36 3 20 3 Attract 108.7188643834 34.2005702269 3.1788611612 0.002372386 40.2589849925 177.1787437743 40.2589849925 177.1787437743
35 425.945 1 32.73 3 9 4
36 530.593 1 14.23 3 20 3
37 449.527 1 27.69 3 9 3 SUMMARY OUTPUT
38 297.237 0 35.02 3 6 3
39 198.809 0 45.02 2 10 2 Regression Statistics
40 420.942 1 13.65 4 9 1 Multiple R 0.9440259813
41 581.784 1 48.10 3 9 5 R Square 0.8911850534
42 229.914 0 15.01 4 17 2 Adjusted R Square 0.8811095954
43 683.982 1 49.55 4 10 3 Standard Error 90.4658900748
44 801.843 1 41.93 5 11 3 Observations 60
45 203.803 1 11.46 2 10 3
46 101.432 0 18.82 3 13 3 ANOVA
47 254.989 1 40.94 3 -0 2 df SS MS F Significance F
48 432.992 0 46.02 3 17 3 Regression 5 3619451.99983697 723890.399967393 88.4510710674 9.35899484975784E-25
49 496.599 1 24.53 4 12 3 Residual 54 441940.172419833 8184.0772670339
50 204.977 1 23.36 4 5 3 Total 59 4061392.1722568
51 -5.541 1 16.78 1 4 2
52 645.317 1 27.97 5 11 3 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
53 707.284 1 36.58 2 20 4 Intercept -548.6481457102 58.7941616378 -9.3316773371 0 -666.5233426442 -430.7729487762 -666.5233426442 -430.7729487762
54 372.360 0 14.59 3 26 2 Size 255.9771554027 26.0985271242 9.8081073382 0 203.6527589191 308.3015518863 203.6527589191 308.3015518863
55 190.481 1 17.92 3 8 2 Advertexp 9.5709608184 1.0331515504 9.2638498333 0 7.4996166733 11.6423049634 7.4996166733 11.6423049634
56 421.723 0 49.20 4 9 3 Mgrperf 91.3665182189 12.3795841212 7.380419029 0.000000001 66.5469464179 116.1860900198 66.5469464179 116.1860900198
57 172.960 0 11.54 4 9 3 Neighbors 19.6507863624 1.741968598 11.2807925383 8.09143067121739E-16 16.1583495996 23.1432231253 16.1583495996 23.1432231253
58 413.843 0 36.03 4 13 1 Attract -3.2510704768 14.5079526262 -0.2240888539 0.8235338616 -32.337764211 25.8356232574 -32.337764211 25.8356232574
59 761.802 0 47.79 4 26 2
60 1322.114 1 37.38 5 29 4

Profit = annual profit in thousands Size = small (0) or large (1) design Advertexp = annual spending on local advertising, in thousands Mgrperf = Performance rating of local manager, on scale where 5 = best and 1 = worst Attract = Rating of physical attractiveness of property (location, architecture, etc.) on a scale where 4 is best Neighbors = Quantity and quality of nearby attractions: restaurants, shopping, arts venues, etc. Scale from 0 to 30, where 30 is best

multiple regression log

Property # Profit Size Advertexp lnAdvertexp Mgrperf Neighbors Attract
1 166.855 0 12.72 2.54 3 8 1
2 299.980 0 42.50 3.75 3 5 2 SUMMARY OUTPUT
3 840.615 1 32.35 3.48 4 28 3
4 201.433 0 10.09 2.31 5 4 2 Regression Statistics
5 872.874 1 20.27 3.01 4 31 3 Multiple R 0.9471137742
6 186.493 1 23.70 3.17 2 9 3 R Square 0.8970245013
7 300.901 1 19.11 2.95 3 9 4 Adjusted R Square 0.8853668976
8 755.746 1 32.87 3.49 4 19 3 Standard Error 88.8313947304
9 808.764 1 40.37 3.70 4 17 3 Observations 60
10 332.976 0 25.37 3.23 4 13 2
11 590.922 1 46.40 3.84 3 6 2 ANOVA
12 329.644 0 39.47 3.68 2 12 1 df SS MS F Significance F
13 829.321 1 38.99 3.66 5 7 3 Regression 6 3643168.2877006 607194.714616766 76.9475897075 2.18690501472943E-24
14 713.162 1 42.72 3.75 4 13 4 Residual 53 418223.884556203 7891.0166897397
15 341.979 0 29.17 3.37 3 24 2 Total 59 4061392.1722568
16 322.471 0 43.33 3.77 3 6 2
17 608.782 1 40.95 3.71 3 3 2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
18 134.128 0 26.01 3.26 3 9 1 Intercept -32.4962643241 303.2743400538 -0.1071513809 0.9150734703 -640.7875573697 575.7950287215 -640.7875573697 575.7950287215
19 194.545 0 22.53 3.11 5 11 1 Size 261.9296637694 25.8559843833 10.1303303671 0 210.0691266376 313.7902009012 210.0691266376 313.7902009012
20 494.896 1 21.52 3.07 4 12 3 Advertexp 18.0994172884 5.0229309238 3.6033577931 0.0006935364 8.0246937032 28.1741408736 8.0246937032 28.1741408736
21 206.774 1 27.91 3.33 3 4 3 lnAdvertexp -233.50238525 134.6897186429 -1.7336318436 0.0887978388 -503.6557490285 36.6509785285 -503.6557490285 36.6509785285
22 565.189 1 31.51 3.45 4 8 3 Mgrperf 91.5759159131 12.1565156612 7.5330726719 0.0000000006 67.1930333087 115.9587985176 67.1930333087 115.9587985176
23 279.658 0 33.81 3.52 3 7 3 Neighbors 19.8425496458 1.7140683512 11.5762884437 3.94376538777331E-16 16.4045639147 23.280535377 16.4045639147 23.280535377
24 89.235 0 43.45 3.77 1 6 2 Attract -5.1585444233 14.288256456 -0.361033863 0.7195092888 -33.81715759 23.5000687434 -33.81715759 23.5000687434
25 372.522 1 17.41 2.86 4 2 2
26 89.877 0 29.45 3.38 4 7 3
27 91.116 0 23.86 3.17 2 11 1 0 0
28 201.996 0 32.04 3.47 5 6 2 5 -5747.062544808 -5747.062544808
29 673.770 1 44.16 3.79 5 11 2 10 -23169.2443521158 -17422.1818073078
30 326.183 0 45.10 3.81 4 7 4 15 -52266.5454219234 -29097.3010698076
31 382.848 0 28.69 3.36 4 14 1 20 -93038.9657542308 -40772.4203323073
32 730.514 1 43.87 3.78 4 13 2 25 -145486.505349038 -52447.5395948072
33 457.112 1 24.84 3.21 3 12 1 30 -209609.164206345 -64122.6588573069
34 823.807 1 49.36 3.90 3 20 3 35 -285406.942326151 -75797.7781198067
35 425.945 1 32.73 3.49 3 9 4 40 -372879.839708458 -87472.8973823065
36 530.593 1 14.23 2.66 3 20 3 45 -472027.856353264 -99148.0166448062
37 449.527 1 27.69 3.32 3 9 3 50 -582850.99226057 -110823.135907306
38 297.237 0 35.02 3.56 3 6 3 55 -705349.247430376 -122498.255169806
39 198.809 0 45.02 3.81 2 10 2 60 -839522.621862681 -134173.374432306
40 420.942 1 13.65 2.61 4 9 1 65 -985371.115557487 -145848.493694805
41 581.784 1 48.10 3.87 3 9 5 70 -1142894.72851479 -157523.612957305
42 229.914 0 15.01 2.71 4 17 2 75 -1312093.4607346 -169198.732219805
43 683.982 1 49.55 3.90 4 10 3 80 -1492967.3122169 -180873.851482305
44 801.843 1 41.93 3.74 5 11 3 85 -1685516.28296171 -192548.970744804
45 203.803 1 11.46 2.44 2 10 3 90 -1889740.37296901 -204224.090007304
46 101.432 0 18.82 2.93 3 13 3 95 -2105639.58223881 -215899.209269804
47 254.989 1 40.94 3.71 3 -0 2 100 -2333213.91077112 -227574.328532304
48 432.992 0 46.02 3.83 3 17 3 105 -2572463.35856592 -239249.447794803
49 496.599 1 24.53 3.20 4 12 3 110 -2823387.92562322 -250924.567057303
50 204.977 1 23.36 3.15 4 5 3 115 -3085987.61194303 -262599.686319803
51 -5.541 1 16.78 2.82 1 4 2 120 -3360262.41752533 -274274.805582303
52 645.317 1 27.97 3.33 5 11 3 125 -3646212.34237013 -285949.924844803
53 707.284 1 36.58 3.60 2 20 4 130 -3943837.38647744 -297625.044107303
54 372.360 0 14.59 2.68 3 26 2 135 -4253137.54984724 -309300.163369802
55 190.481 1 17.92 2.89 3 8 2 140 -4574112.83247954 -320975.282632302
56 421.723 0 49.20 3.90 4 9 3 145 -4906763.23437434 -332650.401894802
57 172.960 0 11.54 2.45 4 9 3 150 -5251088.75553164 -344325.521157302
58 413.843 0 36.03 3.58 4 13 1
59 761.802 0 47.79 3.87 4 26 2
60 1322.114 1 37.38 3.62 5 29 4

log mana

Property # Profit Size Advertexp Mgrperf LogMgrperf Neighbors Attract SUMMARY OUTPUT
1 166.855 0 12.72 3 1.0986122887 8 1
2 299.980 0 42.50 3 1.0986122887 5 2 Regression Statistics
3 840.615 1 32.35 4 1.3862943611 28 3 Multiple R 0.9440421634
4 201.433 0 10.09 5 1.6094379124 4 2 R Square 0.8912156063
5 872.874 1 20.27 4 1.3862943611 31 3 Adjusted R Square 0.8789003919
6 186.493 1 23.70 2 0.6931471806 9 3 Standard Error 91.3025330916
7 300.901 1 19.11 3 1.0986122887 9 4 Observations 60
8 755.746 1 32.87 4 1.3862943611 19 3
9 808.764 1 40.37 4 1.3862943611 17 3 ANOVA
10 332.976 0 25.37 4 1.3862943611 13 2 df SS MS F Significance F
11 590.922 1 46.40 3 1.0986122887 6 2 Regression 6 3619576.08716331 603262.681193885 72.3670395488 9.24661184834702E-24
12 329.644 0 39.47 2 0.6931471806 12 1 Residual 53 441816.085093489 8336.1525489338
13 829.321 1 38.99 5 1.6094379124 7 3 Total 59 4061392.1722568
14 713.162 1 42.72 4 1.3862943611 13 4
15 341.979 0 29.17 3 1.0986122887 24 2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
16 322.471 0 43.33 3 1.0986122887 6 2 Intercept -548.7533551875 59.3441650485 -9.2469639558 0 -667.782676579 -429.724033796 -667.782676579 -429.724033796
17 608.782 1 40.95 3 1.0986122887 3 2 Size 255.8158535807 26.3730493319 9.6998966771 0 202.9182154989 308.7134916624 202.9182154989 308.7134916624
18 134.128 0 26.01 3 1.0986122887 9 1 Advertexp 9.5692486764 1.0428007303 9.1764882763 0 7.4776552876 11.6608420652 7.4776552876 11.6608420652
19 194.545 0 22.53 5 1.6094379124 11 1 Mgrperf 97.1436336235 48.9717202609 1.9836679844 0.0524834407 -1.0811981735 195.3684654206 -1.0811981735 195.3684654206
20 494.896 1 21.52 4 1.3862943611 12 3 LogMgrperf -17.1228501858 140.3444264702 -0.1220059151 0.903355768 -298.6181215437 264.372421172 -298.6181215437 264.372421172
21 206.774 1 27.91 3 1.0986122887 4 3 Neighbors 19.6726316366 1.7671727736 11.1322627479 0 16.128131923 23.2171313503 16.128131923 23.2171313503
22 565.189 1 31.51 4 1.3862943611 8 3 Attract -3.0800156551 14.7090948651 -0.209395322 0.8349424397 -32.5827237755 26.4226924653 -32.5827237755 26.4226924653
23 279.658 0 33.81 3 1.0986122887 7 3
24 89.235 0 43.45 1 0 6 2
25 372.522 1 17.41 4 1.3862943611 2 2 1 0 97.1436336235
26 89.877 0 29.45 4 1.3862943611 7 3 2 0.6931471806 182.4186119176 85.2749782941
27 91.116 0 23.86 2 0.6931471806 11 1 3 1.0986122887 272.6195272394 90.2009153218
28 201.996 0 32.04 5 1.6094379124 6 2 4 1.3862943611 364.8372238352 92.2176965958
29 673.770 1 44.16 5 1.6094379124 11 2 5 1.6094379124 458.1600038597 93.3227800245
30 326.183 0 45.10 4 1.3862943611 7 4 6 1.7917594692 552.1817727806 94.0217689209
31 382.848 0 28.69 4 1.3862943611 14 1 7 1.9459101491 646.6859074074 94.5041346268
32 730.514 1 43.87 4 1.3862943611 13 2 8 2.0794415417 741.543103 94.8571955925
33 457.112 1 24.84 3 1.0986122887 12 1 9 2.1972245773 836.6699553495 95.1268523496
34 823.807 1 49.36 3 1.0986122887 20 3 10 2.302585093 932.009516648 95.3395612984
35 425.945 1 32.73 3 1.0986122887 9 4 11 2.3978952728 1027.5211683415 95.5116516936
36 530.593 1 14.23 3 1.0986122887 20 3 12 2.4849066498 1123.1749191924 95.6537508509
37 449.527 1 27.69 3 1.0986122887 9 3 13 2.5649493575 1218.947993524 95.7730743316
38 297.237 0 35.02 3 1.0986122887 6 3 14 2.6390573296 1314.8226874428 95.8746939188
39 198.809 0 45.02 2 0.6931471806 10 2 15 2.7080502011 1410.784966464 95.9622790212
40 420.942 1 13.65 4 1.3862943611 9 1 16 2.7725887222 1506.8235166589 96.0385501949
41 581.784 1 48.10 3 1.0986122887 9 5 17 2.8332133441 1602.9290839655 96.1055673066
42 229.914 0 15.01 4 1.3862943611 17 2 18 2.8903717579 1699.094002632 96.1649186665
43 683.982 1 49.55 4 1.3862943611 10 3 19 2.9444389792 1795.3118513257 96.2178486938
44 801.843 1 41.93 5 1.6094379124 11 3 20 2.9957322736 1891.577197554 96.2653462282
45 203.803 1 11.46 2 0.6931471806 10 3 21 3.0445224377 1987.8854045059 96.3082069519
46 101.432 0 18.82 3 1.0986122887 13 3 22 3.0910424534 2084.2324828711 96.3470783652
47 254.989 1 40.94 3 1.0986122887 -0 2 23 3.1354942159 2180.6149756236 96.3824927525
48 432.992 0 46.02 3 1.0986122887 17 3 24 3.1780538303 2277.0298673455 96.4148917219
49 496.599 1 24.53 4 1.3862943611 12 3 25 3.2188758249 2373.4745120726 96.4446447271
50 204.977 1 23.36 4 1.3862943611 5 3 26 3.258096538 2469.9465753006 96.472063228
51 -5.541 1 16.78 1 0 4 2 27 3.295836866 2566.4439869421 96.4974116415
52 645.317 1 27.97 5 1.6094379124 11 3 28 3.3322045102 2662.9649028429 96.5209159008
53 707.284 1 36.58 2 0.6931471806 20 4 29 3.36729583 2759.5076730545 96.5427702116
54 372.360 0 14.59 3 1.0986122887 26 2 30 3.4011973817 2856.0708154877 96.5631424331
55 190.481 1 17.92 3 1.0986122887 8 2 31 3.4339872045 2952.6529938874 96.5821783997
56 421.723 0 49.20 4 1.3862943611 9 3 32 3.4657359028 3049.2529993061 96.6000054187
57 172.960 0 11.54 4 1.3862943611 9 3 33 3.4965075615 3145.8697344283 96.6167351222
58 413.843 0 36.03 4 1.3862943611 13 1 34 3.5263605246 3242.5022002363 96.6324658079
59 761.802 0 47.79 4 1.3862943611 26 2 35 3.5553480615 3339.1494846087 96.6472843724
60 1322.114 1 37.38 5 1.6094379124 29 4 36 3.5835189385 3435.8107525263 96.6612679176
37 3.6109179126 3532.4852376196 96.6744850933
38 3.6375861597 3629.1722348436 96.686997224
39 3.6635616461 3725.871094105 96.6988592614
40 3.6888794541 3822.5812146954 96.7101205904
41 3.7135720667 3919.3020404129 96.7208257175
42 3.7376696183 4016.0330552709 96.731014858
43 3.7612001157 4112.7737797125 96.7407244416
44 3.7841896339 4209.5237672596 96.7499875471
45 3.8066624898 4306.2826015391 96.7588342795
46 3.8286413965 4403.0498936357 96.7672920966
47 3.8501476017 4499.8252797292 96.7753860935
48 3.8712010109 4596.6084189811 96.7831392519
49 3.8918202981 4693.398991639 96.7905726578
50 3.9120230054 4790.1966973318 96.7977056928
51 3.9318256327 4887.0012535348 96.8045562031
52 3.9512437186 4983.8123941833 96.8111406485
53 3.9702919136 5080.6298684181 96.8174742348
54 3.9889840466 5177.4534394484 96.8235710303
55 4.0073331852 5274.2828835195 96.8294440711
56 4.0253516907 5371.1179889728 96.8351054532
57 4.0430512678 5467.9585553893 96.8405664165
58 4.0604430105 5564.8043928079 96.8458374186
59 4.0775374439 5661.65532101 96.8509282021
60 4.0943445622 5758.5111688646 96.8558478546
61 4.1108738642 5855.3717737271 96.8606048626
62 4.127134385 5952.2369808878 96.8652071607
63 4.1431347264 6049.1066430636 96.8696621757
64 4.1588830834 6145.9806199301 96.8739768665
65 4.1743872699 6242.8587776903 96.8781577602
66 4.189654742 6339.7409886759 96.8822109855
67 4.2046926194 6436.6271309782 96.8861423023
68 4.2195077052 6533.5170881073 96.8899571292
69 4.2341065046 6630.4107486755 96.8936605682
70 4.248495242 6727.3080061033 96.8972574278
71 4.262679877 6824.2087583469 96.9007522436
72 4.276666119 6921.1129076445 96.9041492975
73 4.2904594411 7018.0203602796 96.9074526351
74 4.3040650932 7114.9310263613 96.9106660817
75 4.3174881135 7211.8448196187 96.9137932574
76 4.3307333403 7308.7616572089 96.9168375902
77 4.3438054219 7405.6814595381 96.9198023293
78 4.3567088267 7502.6041500938 96.9226905557
79 4.3694478525 7599.5296552874 96.9255051936
80 4.3820266347 7696.4579043077 96.9282490203
81 4.3944491547 7793.3888289824 96.9309246747
82 4.4067192473 7890.3223636487 96.9335346663
83 4.4188406078 7987.2584450318 96.9360813831
84 4.4308167988 8084.1970121303 96.9385670985
85 4.4426512565 8181.1380061085 96.9409939782
86 4.4543472963 8278.0813701954 96.9433640869
87 4.4659081187 8375.027049589 96.9456793935
88 4.4773368145 8471.9749913661 96.9479417771
89 4.4886363697 8568.9251443979 96.9501530318
90 4.4998096703 8665.8774592692 96.9523148713
91 4.5108595065 8762.8318882032 96.9544289339
92 4.521788577 8859.7883849893 96.9564967862
93 4.5325994932 8956.746904916 96.9585199267
94 4.5432947823 9053.7074047063 96.9604997903
95 4.5538768916 9150.6698424572 96.9624377508
96 4.5643481915 9247.6341775818 96.9643351247
97 4.5747109785 9344.6003707555 96.9661931736
98 4.5849674787 9441.5683838632 96.9680131078
99 4.5951198501 9538.5381799511 96.9697960879
100 4.605170186 9635.5097231795 96.9715432284

1 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 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 97.143633623545327 182.41861191762322 272.6195272394458 364.83722383524645 458.16000385970159 552.18177278061432 646.68590740743161 741.5431029999603 836.66995534952764 932.00951664796082 1027.5211683415309 1123.1749191924189 1218.947993524001 1314.8226874427814 1410.7849664639646 1506.8235166588556 1602.9290839654648 1699.0940026319681 1795.3118513257375 1891.5771975539467 1987.8854045058761 2084.2324828710621 2180.6149756236105 2277.0298673454954 2373.4745120725829 2469.946575300623 2566.4439869421531 2662.9649028429485 2759.507673054542 2856.070815487677 2952.6529938874041 3049.2529993061135 3145.8697344283378 3242.502200236268 3339.1494846086757 3435.8107525263167 3532.4852376195931 3629.1722348436315 3725.8710941049894 3822.5812146953858 3919.3020404128488 4016.0330552708606 4112.7737797124528 4209.5237672595913 4306.2826015391347 4403.0498936356862 4499.8252797291661 4596.6084189811154 4693.3989916389501 4790.1966973317485 4887.0012535348151 4983.8123941833337 5080.6298684180847 5177.4534394484099 5274.2828835195005 5371.11798897275 5467.9585553892693 5564.8043928078896 5661.6553210100119 5758.5111688645693 5855.3717737271281 5952.236980887842 6049.1066430635892 6145.9806199300965 6242.8587776903332 6339.740988675866 6436.6271309781851 6533.5170881073418 6630.4107486755047 6727.3080061032942 6824.208758346932 6921.1129076444813 7018.0203602795891 7114.9310263613024 7211.84481961866 7308.7616572088864 7405.6814595381366 7502.6041500937899 7599.5296552874343 7696.457904307731 7793.3888289824108 7890.3223636487401 7987.2584450318418 8084.1970121302975 8181.1380061085219 8278.0813701954357 8375.0270495889799 8471.974991366118 8568.9251443978847 8665.8774592692062 8762.8318882031508 8859.7883849893042 8956.7469049160227 905 3.7074047063288 9150.6698424571568 9247.6341775818237 9344.6003707554519 9441.5683838632031 9538.5381799511397 9635.5097231795462

Sheet4

Property # Profit Size Advertexp Mgrperf SquareMgrperf Neighbors Attract SUMMARY OUTPUT
1 166.855 0 12.72 3 9 8 1
2 299.980 0 42.50 3 9 5 2 Regression Statistics
3 840.615 1 32.35 4 16 28 3 Multiple R 0.9441998811
4 201.433 0 10.09 5 25 4 2 R Square 0.8915134154
5 872.874 1 20.27 4 16 31 3 Adjusted R Square 0.8792319153
6 186.493 1 23.70 2 4 9 3 Standard Error 91.1774721262
7 300.901 1 19.11 3 9 9 4 Observations 60
8 755.746 1 32.87 4 16 19 3
9 808.764 1 40.37 4 16 17 3 ANOVA
10 332.976 0 25.37 4 16 13 2 df SS MS F Significance F
11 590.922 1 46.40 3 9 6 2 Regression 6 3620785.60682018 603464.267803363 72.5899446412 8.60421359833516E-24
12 329.644 0 39.47 2 4 12 1 Residual 53 440606.56543662 8313.3314233325
13 829.321 1 38.99 5 25 7 3 Total 59 4061392.1722568
14 713.162 1 42.72 4 16 13 4
15 341.979 0 29.17 3 9 24 2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
16 322.471 0 43.33 3 9 6 2 Intercept -511.9605269917 109.0954494255 -4.6927761853 0.0000193812 -730.7782877844 -293.1427661991 -730.7782877844 -293.1427661991
17 608.782 1 40.95 3 9 3 2 Size 255.4637133568 26.3350309505 9.7005283129 0 202.6423304913 308.2850962222 202.6423304913 308.2850962222
18 134.128 0 26.01 3 9 9 1 Advertexp 9.5644502501 1.0414049328 9.1841798983 0 7.4756564766 11.6532440236 7.4756564766 11.6532440236
19 194.545 0 22.53 5 25 11 1 Mgrperf 65.8871645935 64.827379739 1.0163477972 0.3140811118 -64.1400927049 195.9144218918 -64.1400927049 195.9144218918
20 494.896 1 21.52 4 16 12 3 SquareMgrperf 3.8527101187 9.6192220565 0.4005220065 0.6903820562 -15.4410059993 23.1464262367 -15.4410059993 23.1464262367
21 206.774 1 27.91 3 9 4 3 Neighbors 19.7228873651 1.7648754031 11.1752293279 0 16.182995593 23.2627791371 16.182995593 23.2627791371
22 565.189 1 31.51 4 16 8 3 Attract -2.6686011453 14.6942099435 -0.1816090253 0.8565823515 -32.1414538938 26.8042516032 -32.1414538938 26.8042516032
23 279.658 0 33.81 3 9 7 3
24 89.235 0 43.45 1 1 6 2
25 372.522 1 17.41 4 16 2 2 0 0
26 89.877 0 29.45 4 16 7 3 1 69.7398747121 69.7398747121
27 91.116 0 23.86 2 4 11 1 2 147.1851696616 77.4452949495
28 201.996 0 32.04 5 25 6 2 3 232.3358848485 85.1507151869
29 673.770 1 44.16 5 25 11 2 4 325.1920202727 92.8561354242
30 326.183 0 45.10 4 16 7 4 5 425.7535759343 100.5615556616
31 382.848 0 28.69 4 16 14 1 6 534.0205518333 108.266975899
32 730.514 1 43.87 4 16 13 2 7 649.9929479696 115.9723961363
33 457.112 1 24.84 3 9 12 1 8 773.6707643433 123.6778163737
34 823.807 1 49.36 3 9 20 3 9 905.0540009543 131.383236611
35 425.945 1 32.73 3 9 9 4 10 1044.1426578027 139.0886568484
36 530.593 1 14.23 3 9 20 3 11 1190.9367348885 146.7940770858
37 449.527 1 27.69 3 9 9 3 12 1345.4362322117 154.4994973231
38 297.237 0 35.02 3 9 6 3 13 1507.6411497722 162.2049175605
39 198.809 0 45.02 2 4 10 2 14 1677.5514875701 169.9103377979
40 420.942 1 13.65 4 16 9 1 15 1855.1672456053 177.6157580352
41 581.784 1 48.10 3 9 9 5 16 2040.4884238779 185.3211782726
42 229.914 0 15.01 4 16 17 2 17 2233.5150223878 193.02659851
43 683.982 1 49.55 4 16 10 3 18 2434.2470411352 200.7320187473
44 801.843 1 41.93 5 25 11 3 19 2642.6844801199 208.4374389847
45 203.803 1 11.46 2 4 10 3 20 2858.8273393419 216.1428592221
46 101.432 0 18.82 3 9 13 3 21 3082.6756188013 223.8482794594
47 254.989 1 40.94 3 9 -0 2 22 3314.2293184981 231.5536996968
48 432.992 0 46.02 3 9 17 3 23 3553.4884384323 239.2591199341
49 496.599 1 24.53 4 16 12 3 24 3800.4529786038 246.9645401715
50 204.977 1 23.36 4 16 5 3 25 4055.1229390127 254.6699604089
51 -5.541 1 16.78 1 1 4 2 26 4317.4983196589 262.3753806462
52 645.317 1 27.97 5 25 11 3 27 4587.5791205425 270.0808008836
53 707.284 1 36.58 2 4 20 4 28 4865.3653416635 277.786221121
54 372.360 0 14.59 3 9 26 2 29 5150.8569830218 285.4916413583
55 190.481 1 17.92 3 9 8 2 30 5444.0540446175 293.1970615957
56 421.723 0 49.20 4 16 9 3 31 5744.9565264506 300.9024818331
57 172.960 0 11.54 4 16 9 3 32 6053.564428521 308.6079020704
58 413.843 0 36.03 4 16 13 1 33 6369.8777508288 316.3133223078
59 761.802 0 47.79 4 16 26 2 34 6693.8964933739 324.0187425452
60 1322.114 1 37.38 5 25 29 4 35 7025.6206561565 331.7241627825
36 7365.0502391763 339.4295830199
37 7712.1852424336 347.1350032572
38 8067.0256659282 354.8404234946
39 8429.5715096602 362.545843732
40 8799.8227736295 370.2512639693
41 9177.7794578362 377.9566842067
42 9563.4415622803 385.6621044441
43 9956.8090869617 393.3675246814
44 10357.8820318805 401.0729449188
45 10766.6603970366 408.7783651562
46 11183.1441824302 416.4837853935
47 11607.3333880611 424.1892056309
48 12039.2280139293 431.8946258683
49 12478.8280600349 439.6000461056
50 12926.1335263779 447.305466343
51 13381.1444129582 455.0108865803
52 13843.8607197759 462.7163068177
53 14314.282446831 470.4217270551
54 14792.4095941235 478.1271472924
55 15278.2421616533 485.8325675298
56 15771.7801494204 493.5379877672
57 16273.0235574249 501.2434080045
58 16781.9723856668 508.9488282419
59 17298.6266341461 516.6542484793
60 17822.9863028627 524.3596687166
61 18355.0513918167 532.065088954
62 18894.821901008 539.7705091913
63 19442.2978304368 547.4759294287
64 19997.4791801028 555.1813496661
65 20560.3659500063 562.8867699034
66 21130.9581401471 570.5921901408
67 21709.2557505252 578.2976103782
68 22295.2587811408 586.0030306155
69 22888.9672319937 593.7084508529
70 23490.3811030839 601.4138710903
71 24099.5003944116 609.1192913276
72 24716.3251059766 616.824711565
73 25340.8552377789 624.5301318024
74 25973.0907898186 632.2355520397
75 26613.0317620957 639.9409722771
76 27260.6781546102 647.6463925144
77 27916.029967362 655.3518127518
78 28579.0872003511 663.0572329892
79 29249.8498535777 670.7626532265
80 29928.3179270416 678.4680734639
81 30614.4914207428 686.1734937013
82 31308.3703346815 693.8789139386
83 32009.9546688575 701.584334176
84 32719.2444232708 709.2897544134
85 33436.2395979216 716.9951746507
86 34160.9401928096 724.7005948881
87 34893.3462079351 732.4060151255
88 35633.4576432979 740.1114353628
89 36381.2744988981 747.8168556002
90 37136.7967747356 755.5222758375
91 37900.0244708105 763.2276960749
92 38670.9575871228 770.9331163123
93 39449.5961236724 778.6385365496
94 40235.9400804594 786.343956787
95 41029.9894574838 794.0493770244
96 41831.7442547455 801.7547972617
97 42641.2044722446 809.4602174991
98 43458.3701099811 817.1656377365
99 44283.2411679549 824.8710579738
100 45115.8176461661 832.5764782112

0 1 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 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 0 69.739874712136952 147.18516966163804 232.33588484850327 325.19202027273258 425.75357593432602 534.02055183328366 649.99294796960521 773.67076434329101 905.05400095434106 1044.1426578027549 1190.9367348885332 1345.4362322116 756 1507.641149772182 1677.5514875700524 1855.167245605287 2040.4884238778859 2233.5150223878491 2434.247041135176 2642.6844801198667 2858.8273393419222 3082.6756188013414 3314.2293184981254 3553.4884384322727 3800.4529786037847 4055.12293901266 4317.4983196589001 4587.5791205425048 4865.3653416634725 5150.8569830218057 5444.0540446175019 5744.9565264505618 6053.5644285209873 6369.8777508287767 6693.8964933739289 7025.6206561564459 7365.0502391763275 7712.1852424335721 8067.0256659281822 8429.5715096601562 8799.8227736294939 9177.7794578361936 9563.4415622802608 9956.8090869616899 10357.882031880485 10766.660397036643 11183.144182430166 11607.333388061052 12039.228013929303 12478.828060034917 12926.133526377896 13381.14441295824 13843.860719775948 14314.282446831017 14792.409594123454 15278.242161653254 15771.780149420416 16273.023557424945 16781.972385666835 17298.626634146094 17822.986302862711 18355.051391816698 18894.821901008043 19442.297830436757 19997.479180102833 20560.365950006275 21130.958140147082 21709.255750525248 22295.258781140783 22888.96723199368 23490.381103083942 24099.500394411563 24716.325105976557 25340.855237778909 25973.090789818627 26613.03176209571 27260.678154610156 27916.029967361967 28579.087200351139 29249.849853577678 29928.317927041579 30614.491420742845 31308.370334681476 32009.954668857474 32719.244423270829 33436.239597921551 34160.940192809641 34893.346207935094 35633.457643297908 36381.274498898085 37136.796774735631 37900.024470810538 38670.957587122815 39449.596123672447 40235.940080459448 41029.989457483811 41831.744254745543 42641.204472244637 43458.370109981093 44283.241167954911 45115.817646166091

0 1 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 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 0 69.739874712136952 147.18516966163804 232.33588484850327 325.19202027273258 425.75357593432602 534.02055183328366 649.99294796960521 773.67076434329101 905.05400095434106 1044.1426578027549 1190.9367348885332 1345.4362322116 756 1507.641149772182 1677.5514875700524 1855.167245605287 2040.4884238778859 2233.5150223878491 2434.247041135176 2642.6844801198667 2858.8273393419222 3082.6756188013414 3314.2293184981254 3553.4884384322727 3800.4529786037847 4055.12293901266 4317.4983196589001 4587.5791205425048 4865.3653416634725 5150.8569830218057 5444.0540446175019 5744.9565264505618 6053.5644285209873 6369.8777508287767 6693.8964933739289 7025.6206561564459 7365.0502391763275 7712.1852424335721 8067.0256659281822 8429.5715096601562 8799.8227736294939 9177.7794578361936 9563.4415622802608 9956.8090869616899 10357.882031880485 10766.660397036643 11183.144182430166 11607.333388061052 12039.228013929303 12478.828060034917 12926.133526377896 13381.14441295824 13843.860719775948 14314.282446831017 14792.409594123454 15278.242161653254 15771.780149420416 16273.023557424945 16781.972385666835 17298.626634146094 17822.986302862711 18355.051391816698 18894.821901008043 19442.297830436757 19997.479180102833 20560.365950006275 21130.958140147082 21709.255750525248 22295.258781140783 22888.96723199368 23490.381103083942 24099.500394411563 24716.325105976557 25340.855237778909 25973.090789818627 26613.03176209571 27260.678154610156 27916.029967361967 28579.087200351139 29249.849853577678 29928.317927041579 30614.491420742845 31308.370334681476 32009.954668857474 32719.244423270829 33436.239597921551 34160.940192809641 34893.346207935094 35633.457643297908 36381.274498898085 37136.796774735631 37900.024470810538 38670.957587122815 39449.596123672447 40235.940080459448 41029.989457483811 41831.744254745543 42641.204472244637 43458.370109981093 44283.241167954911 45115.817646166091

large property

Property # Profit Size Advertexp Mgrperf Neighbors Attract
3 840.615 1 32.35 4 28 3 SUMMARY OUTPUT
5 872.874 1 20.27 4 31 3
6 186.493 1 23.70 2 9 3 Regression Statistics
7 300.901 1 19.11 3 9 4 Multiple R 0.6414802463
8 755.746 1 32.87 4 19 3 R Square 0.4114969064
9 808.764 1 40.37 4 17 3 Adjusted R Square 0.3931061847
11 590.922 1 46.40 3 6 2 Standard Error 210.4180310831
13 829.321 1 38.99 5 7 3 Observations 34
14 713.162 1 42.72 4 13 4
17 608.782 1 40.95 3 3 2 ANOVA
20 494.896 1 21.52 4 12 3 df SS MS F Significance F
21 206.774 1 27.91 3 4 3 Regression 1 990680.712248975 990680.712248975 22.3752451707 0.000043454
22 565.189 1 31.51 4 8 3 Residual 32 1416823.92975642 44275.7478048883
25 372.522 1 17.41 4 2 2 Total 33 2407504.6420054
29 673.770 1 44.16 5 11 2
32 730.514 1 43.87 4 13 2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
33 457.112 1 24.84 3 12 1 Intercept -85.0213995303 139.2935482026 -0.6103757182 0.5459238178 -368.7530723931 198.7102733324 -368.7530723931 198.7102733324
34 823.807 1 49.36 3 20 3 Mgrperf 180.3127490435 38.1190907866 4.7302478974 0.000043454 102.6667019978 257.9587960892 102.6667019978 257.9587960892
35 425.945 1 32.73 3 9 4
36 530.593 1 14.23 3 20 3
37 449.527 1 27.69 3 9 3 SUMMARY OUTPUT
40 420.942 1 13.65 4 9 1
41 581.784 1 48.10 3 9 5 Regression Statistics
43 683.982 1 49.55 4 10 3 Multiple R 0.9481637532
44 801.843 1 41.93 5 11 3 R Square 0.8990145029
45 203.803 1 11.46 2 10 3 Adjusted R Square 0.8850854688
47 254.989 1 40.94 3 -0 2 Standard Error 91.5617472202
49 496.599 1 24.53 4 12 3 Observations 34
50 204.977 1 23.36 4 5 3
51 -5.541 1 16.78 1 4 2 ANOVA
52 645.317 1 27.97 5 11 3 df SS MS F Significance F
53 707.284 1 36.58 2 20 4 Regression 4 2164381.58893915 541095.397234788 64.5424871147 0
55 190.481 1 17.92 3 8 2 Residual 29 243123.053066246 8383.5535540085
60 1322.114 1 37.38 5 29 4 Total 33 2407504.6420054
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -376.5481955336 81.2882089899 -4.6322609418 0.0000704151 -542.8012501156 -210.2951409515 -542.8012501156 -210.2951409515
Advertexp 10.1110460174 1.5086458873 6.7020671334 0.0000002368 7.0255187292 13.1965733057 7.0255187292 13.1965733057
Mgrperf 102.935113747 18.0726523244 5.6956285054 0.0000036823 65.9723895012 139.8978379927 65.9723895012 139.8978379927
Neighbors 21.7252419061 2.3504979877 9.242825146 0.0000000004 16.917933748 26.5325500643 16.917933748 26.5325500643
Attract -2.6512644284 20.3256418884 -0.1304393949 0.8971194294 -44.2218697139 38.9193408571 -44.2218697139 38.9193408571

samll property

Property # Profit Size Advertexp Mgrperf Neighbors Attract SUMMARY OUTPUT
1 166.855 0 12.72 3 8 1
2 299.980 0 42.50 3 5 2 Regression Statistics
4 201.433 0 10.09 5 4 2 Multiple R 0.2118664636
10 332.976 0 25.37 4 13 2 R Square 0.0448873984
12 329.644 0 39.47 2 12 1 Adjusted R Square 0.00509104
15 341.979 0 29.17 3 24 2 Standard Error 146.6445998084
16 322.471 0 43.33 3 6 2 Observations 26
18 134.128 0 26.01 3 9 1
19 194.545 0 22.53 5 11 1 ANOVA
23 279.658 0 33.81 3 7 3 df SS MS F Significance F
24 89.235 0 43.45 1 6 2 Regression 1 24255.6686466896 24255.6686466896 1.127927283 0.2987884579
26 89.877 0 29.45 4 7 3 Residual 24 516111.327671516 21504.6386529798
27 91.116 0 23.86 2 11 1 Total 25 540366.996318205
28 201.996 0 32.04 5 6 2
30 326.183 0 45.10 4 7 4 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
31 382.848 0 28.69 4 14 1 Intercept 169.2051322314 105.0060177701 1.611385098 0.1201705984 -47.5166368066 385.9269012693 -47.5166368066 385.9269012693
38 297.237 0 35.02 3 6 3 Mgrperf 31.6893606896 29.8382210374 1.0620392097 0.2987884579 -29.8937007911 93.2724221702 -29.8937007911 93.2724221702
39 198.809 0 45.02 2 10 2
42 229.914 0 15.01 4 17 2
46 101.432 0 18.82 3 13 3
48 432.992 0 46.02 3 17 3 SUMMARY OUTPUT
54 372.360 0 14.59 3 26 2
56 421.723 0 49.20 4 9 3 Regression Statistics
57 172.960 0 11.54 4 9 3 Multiple R 0.8673054876
58 413.843 0 36.03 4 13 1 R Square 0.7522188088
59 761.802 0 47.79 4 26 2 Adjusted R Square 0.7050223915
Standard Error 79.8488983763
Observations 26
ANOVA
df SS MS F Significance F
Regression 4 406474.218308214 101618.554577053 15.9380489212 0.0000038639
Residual 21 133892.778009992 6375.8465719044
Total 25 540366.996318205
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -324.5877403149 91.7548918683 -3.5375524259 0.0019514834 -515.4024837658 -133.7729968641 -515.4024837658 -133.7729968641
Advertexp 7.8164284527 1.4117407067 5.536730942 0.0000170765 4.8805529339 10.7523039715 4.8805529339 10.7523039715
Mgrperf 62.9093776724 17.2973286177 3.6369418112 0.0015424743 26.9376136022 98.8811417426 26.9376136022 98.8811417426
Neighbors 14.5101671636 2.5778208335 5.6288501416 0.0000138031 9.1492952691 19.8710390582 9.1492952691 19.8710390582
Attract -10.1220273171 19.9838930445 -0.506509282 0.6177759217 -51.6808079641 31.4367533299 -51.6808079641 31.4367533299

mutiple regression square

Property # Profit Size Advertexp SquareAdvertExp Mgrperf Neighbors Attract
1 166.855 0 12.72 161.67 3 8 1
2 299.980 0 42.50 1806.00 3 5 2 SUMMARY OUTPUT
3 840.615 1 32.35 1046.78 4 28 3
4 201.433 0 10.09 101.71 5 4 2 Regression Statistics
5 872.874 1 20.27 410.83 4 31 3 Multiple R 0.9448513444
6 186.493 1 23.70 561.64 2 9 3 R Square 0.892744063
7 300.901 1 19.11 365.19 3 9 4 Adjusted R Square 0.8806018815
8 755.746 1 32.87 1080.17 4 19 3 Standard Error 90.6588486932
9 808.764 1 40.37 1629.49 4 17 3 Observations 60
10 332.976 0 25.37 643.79 4 13 2
11 590.922 1 46.40 2152.77 3 6 2 ANOVA
12 329.644 0 39.47 1557.88 2 12 1 df SS MS F Significance F
13 829.321 1 38.99 1520.06 5 7 3 Regression 6 3625783.74939845 604297.291566408 73.5241900119 6.37618784894149E-24
14 713.162 1 42.72 1825.17 4 13 4 Residual 53 435608.422858349 8219.0268463839
15 341.979 0 29.17 851.01 3 24 2 Total 59 4061392.1722568
16 322.471 0 43.33 1877.40 3 6 2
17 608.782 1 40.95 1676.66 3 3 2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
18 134.128 0 26.01 676.31 3 9 1 Intercept -482.0574704767 96.060144526 -5.0182879992 0.0000062265 -674.7297206693 -289.3852202841 -674.7297206693 -289.3852202841
19 194.545 0 22.53 507.47 5 11 1 Size 258.1362705288 26.2696240508 9.8264166259 0 205.4460772905 310.8264637671 205.4460772905 310.8264637671
20 494.896 1 21.52 463.15 4 12 3 Advertexp 4.3193406815 6.0722303378 0.7113268834 0.4800008111 -7.8600110013 16.4986923642 -7.8600110013 16.4986923642
21 206.774 1 27.91 778.86 3 4 3 SquareAdvertExp 0.0861912205 0.0981999723 0.8777112501 0.3840619807 -0.1107729807 0.2831554217 -0.1107729807 0.2831554217
22 565.189 1 31.51 992.82 4 8 3 Mgrperf 91.9334363716 12.422791886 7.4003844881 0.000000001 67.0164712956 116.8504014476 67.0164712956 116.8504014476
23 279.658 0 33.81 1142.98 3 7 3 Neighbors 19.6915848154 1.746302863 11.2761567497 0 16.1889448414 23.1942247894 16.1889448414 23.1942247894
24 89.235 0 43.45 1887.64 1 6 2 Attract -4.0401810916 14.566668579 -0.2773579333 0.782584268 -33.2572182589 25.1768560758 -33.2572182589 25.1768560758
25 372.522 1 17.41 303.07 4 2 2
26 89.877 0 29.45 867.30 4 7 3
27 91.116 0 23.86 569.44 2 11 1
28 201.996 0 32.04 1026.82 5 6 2 0 0
29 673.770 1 44.16 1949.75 5 11 2 5 23.7514839187 23.7514839187
30 326.183 0 45.10 2034.01 4 7 4 10 51.8125288602 28.0610449415
31 382.848 0 28.69 823.17 4 14 1 15 84.1831348244 32.3706059642
32 730.514 1 43.87 1924.49 4 13 2 20 120.8633018114 36.680166987
33 457.112 1 24.84 616.88 3 12 1 25 161.8530298212 40.9897280098
34 823.807 1 49.36 2436.21 3 20 3 30 207.1523188538 45.2992890326
35 425.945 1 32.73 1071.06 3 9 4 35 256.7611689092 49.6088500554
36 530.593 1 14.23 202.41 3 20 3 40 310.6795799873 53.9184110781
37 449.527 1 27.69 766.79 3 9 3 45 368.9075520882 58.2279721009
38 297.237 0 35.02 1226.40 3 6 3 50 431.4450852119 62.5375331237
39 198.809 0 45.02 2026.71 2 10 2 55 498.2921793584 66.8470941465
40 420.942 1 13.65 186.30 4 9 1 60 569.4488345276 71.1566551692
41 581.784 1 48.10 2313.99 3 9 5 65 644.9150507196 75.466216192
42 229.914 0 15.01 225.33 4 17 2 70 724.6908279344 79.7757772148
43 683.982 1 49.55 2455.20 4 10 3 75 808.776166172 84.0853382376
44 801.843 1 41.93 1758.38 5 11 3 80 897.1710654324 88.3948992604
45 203.803 1 11.46 131.42 2 10 3 85 989.8755257155 92.7044602831
46 101.432 0 18.82 354.04 3 13 3 90 1086.8895470214 97.0140213059
47 254.989 1 40.94 1675.67 3 -0 2 95 1188.2131293501 101.3235823287
48 432.992 0 46.02 2118.21 3 17 3 100 1293.8462727016 105.6331433515
49 496.599 1 24.53 601.82 4 12 3 105 1403.7889770759 109.9427043743
50 204.977 1 23.36 545.55 4 5 3 110 1518.0412424729 114.252265397
51 -5.541 1 16.78 281.57 1 4 2 115 1636.6030688927 118.5618264198
52 645.317 1 27.97 782.21 5 11 3 120 1759.4744563353 122.8713874426
53 707.284 1 36.58 1338.10 2 20 4 125 1886.6554048007 127.1809484654
54 372.360 0 14.59 212.81 3 26 2 130 2018.1459142888 131.4905094881
55 190.481 1 17.92 321.09 3 8 2 135 2153.9459847997 135.8000705109
56 421.723 0 49.20 2420.25 4 9 3 140 2294.0556163334 140.1096315337
57 172.960 0 11.54 133.24 4 9 3 145 2438.4748088899 144.4191925565
58 413.843 0 36.03 1298.23 4 13 1 150 2587.2035624692 148.7287535793
59 761.802 0 47.79 2284.08 4 26 2
60 1322.114 1 37.38 1396.89 5 29 4

simple log

Profit Advertexp LN Advertexp
166.855 12.72 2.5427823989 SUMMARY OUTPUT
299.980 42.50 3.7494334852
840.615 32.35 3.4767376609 Regression Statistics
201.433 10.09 2.3110491714 Multiple R 0.4420118887
872.874 20.27 3.0090926253 R Square 0.1953745098
186.493 23.70 3.1654328532 Adjusted R Square 0.1671420364
300.901 19.11 2.9502117583 Standard Error 239.4401242847
755.746 32.87 3.4924386888 Observations 60
808.764 40.37 3.6980126195
332.976 25.37 3.2336856165 ANOVA
590.922 46.40 3.8372563549 df SS MS F Significance F
329.644 39.47 3.6755408897 Regression 2 793492.504561277 396746.252280638 6.9202052326 0.0020390267
829.321 38.99 3.6632539065 Residual 57 3267899.66769552 57331.5731174653
713.162 42.72 3.75471401 Total 59 4061392.1722568
341.979 29.17 3.3732093451
322.471 43.33 3.7688221568 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
608.782 40.95 3.7122785475 Intercept 8.7795614035 802.4339926719 0.0109411634 0.9913085939 -1598.0667922828 1615.6259150899 -1598.0667922828 1615.6259150899
134.128 26.01 3.2583272806 Advertexp 7.9699239365 13.3368776865 0.5975854412 0.5524833789 -18.7367129656 34.6765608386 -18.7367129656 34.6765608386
194.545 22.53 3.1147145898 LN Advertexp 52.1912202903 359.0968161951 0.1453402479 0.8849549756 -666.8877506818 771.2701912623 -666.8877506818 771.2701912623
494.896 21.52 3.0690292026
206.774 27.91 3.3289133861
565.189 31.51 3.4502732193
279.658 33.81 3.5206974609 RESIDUAL OUTPUT
89.235 43.45 3.7715418044
372.522 17.41 2.8569873139 Observation Predicted Profit Residuals
89.877 29.45 3.3826939101 1 242.8280605858 -75.9729866458
91.116 23.86 3.1723291422 2 543.1649279223 -243.184753373
201.996 32.04 3.4671099584 3 448.0936615965 392.5213124821
673.770 44.16 3.7877288182 4 209.7727207095 -8.3397207095
326.183 45.10 3.8088822465 5 327.3701657507 545.5041517045
382.848 28.69 3.3565834847 6 362.8665921275 -176.3735921275
730.514 43.87 3.7812079203 7 315.0599596076 -14.158568395
457.112 24.84 3.2123344768 8 452.9937184554 302.7521454504
823.807 49.36 3.8990998601 9 523.5052722079 285.258910775
425.945 32.73 3.4882004253 10 379.7704398053 -46.7944398053
530.593 14.23 2.6551415677 11 578.8391839351 12.0828160649
449.527 27.69 3.3211074507 12 515.1834234355 -185.539811161
297.237 35.02 3.5559193269 13 510.7006474513 318.6203525487
198.809 45.02 3.8070846229 14 545.2337578428 167.9277668279
420.942 13.65 2.6136662589 15 417.3300944951 -75.3510944951
581.784 48.10 3.8733653337 16 550.8078230673 -228.3365469249
229.914 15.01 2.7087832657 17 528.8723842844 79.9095030391
683.982 49.55 3.9029822608 18 386.1014801769 -251.9729977612
801.843 41.93 3.7360731064 19 350.8787932176 -156.3341364984
203.803 11.46 2.4392116905 20 340.4766736316 154.419252469
101.432 18.82 2.9347075717 21 404.9442504829 -198.1699293371
254.989 40.94 3.7119854428 22 439.9778643688 125.2114137534
432.992 46.02 3.8291629996 23 461.9762466041 -182.3177473269
496.599 24.53 3.1999783878 24 551.890215822 -462.655215822
204.977 23.36 3.1508967251 25 296.6376214788 75.8839322857
-5.541 16.78 2.820187701 26 420.0407443695 -330.1636960063
645.317 27.97 3.3310609995 27 364.5335853943 -273.4174594204
707.284 36.58 3.599501643 28 445.1205036313 -243.1245036313
372.360 14.59 2.6801992729 29 558.3857118912 115.384536422
190.481 17.92 2.8858616024 30 567.0133433263 -240.8302849963
421.723 49.20 3.8958123194 31 412.6288371398 -29.7808505078
172.960 11.54 2.4460791926 32 555.7580101048 174.7560582905
413.843 36.03 3.584379679 33 374.38421854 82.7274461578
761.802 47.79 3.8668582615 34 605.6578467948 218.1488996455
1322.114 37.38 3.6210020317 35 451.6646988855 -25.7196010716
36 260.742747708 269.8505703647
37 402.8073756934 46.7192101153
38 473.4740665817 -176.2366321965
39 566.2739593167 -367.4649593167
40 253.9714846948 166.970760501
41 594.320445842 -12.5367452532
42 269.7907937517 -39.8768436924
43 607.3906994176 76.5910695431
44 537.972596351 263.870403649
45 227.4522040862 -23.6490063657
46 311.9076195554 -210.4756195554
47 528.7614477045 -273.7724477045
48 575.4360302938 -142.4441199461
49 371.3085123733 125.2904008393
50 359.3822198773 -154.4052307382
51 289.7039226226 -295.2447630098
52 405.534532483 239.7827559658
53 488.1817621832 219.1021858183
54 264.9276824651 107.4325830892
55 302.2092670405 -111.7286290271
56 604.1951383532 -182.4717327273
57 228.4402513925 -55.4803935155
58 483.0170401909 -69.1744151859
59 591.4942175319 170.3075176949
60 495.6399832382 826.4735187538

simple square

Profit Advertexp SquareAdvertexp
166.855 12.72 161.671225 SUMMARY OUTPUT
299.980 42.50 1805.995009
840.615 32.35 1046.781316 Regression Statistics
201.433 10.09 101.707225 Multiple R 0.4429104181
872.874 20.27 410.832361 R Square 0.1961696384
186.493 23.70 561.642601 Adjusted R Square 0.1679650643
300.901 19.11 365.1921 Standard Error 239.3217880077
755.746 32.87 1080.173956 Observations 60
808.764 40.37 1629.494689
332.976 25.37 643.789129 ANOVA
590.922 46.40 2152.774404 df SS MS F Significance F
329.644 39.47 1557.8809 Regression 2 796721.833990037 398360.916995018 6.9552420049 0.0019823739
829.321 38.99 1520.064144 Residual 57 3264670.33826676 57274.9182152064
713.162 42.72 1825.169284 Total 59 4061392.1722568
341.979 29.17 851.005584
322.471 43.33 1877.402241 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
608.782 40.95 1676.656809 Intercept 67.6075947938 223.2297705985 0.3028610145 0.7630983402 -379.4023103153 514.6174999028 -379.4023103153 514.6174999028
134.128 26.01 676.312036 Advertexp 14.247941373 15.9473006372 0.8934390652 0.3753788897 -17.6859773219 46.1818600679 -17.6859773219 46.1818600679
194.545 22.53 507.465729 SquareAdvertexp -0.0717051579 0.2575266073 -0.2784378618 0.7816838773 -0.5873932938 0.443982978 -0.5873932938 0.443982978
494.896 21.52 463.153441
206.774 27.91 778.856464
565.189 31.51 992.817081
279.658 33.81 1142.980864
89.235 43.45 1887.641809
372.522 17.41 303.073281
89.877 29.45 867.3025
91.116 23.86 569.442769
201.996 32.04 1026.817936
673.770 44.16 1949.752336
326.183 45.10 2034.01
382.848 28.69 823.173481
730.514 43.87 1924.489161
457.112 24.84 616.876569
823.807 49.36 2436.212164
425.945 32.73 1071.056529
530.593 14.23 202.407529
449.527 27.69 766.791481
297.237 35.02 1226.4004
198.809 45.02 2026.710361
420.942 13.65 186.295201
581.784 48.10 2313.994816
229.914 15.01 225.330121
683.982 49.55 2455.2025
801.843 41.93 1758.376489
203.803 11.46 131.423296
101.432 18.82 354.041856
254.989 40.94 1675.674225
432.992 46.02 2118.208576
496.599 24.53 601.819024
204.977 23.36 545.549449
-5.541 16.78 281.5684
645.317 27.97 782.209024
707.284 36.58 1338.0964
372.360 14.59 212.809744
190.481 17.92 321.090561
421.723 49.20 2420.246416
172.960 11.54 133.240849
413.843 36.03 1298.232961
761.802 47.79 2284.075264
1322.114 37.38 1396.890625