Using Model 3 rank the managers (top is #1) by performance adjusted for: custome

Question

Using Model 3 rank the managers (top is #1) by performance adjusted for: customer density, number of 4-lane highways within a mile, and the square footage area of the store. Show your setup as well as your answer.

Model 3: Monthly Store Sales

Dependent Variable

SALE

N

19

Multiple R

0.9509087

Squared Multiple R

0.9042273

Adjusted Squared Multiple R

0.8850727

Standard Error of Estimate

1.6502013E+004

Regression Coefficients B = (X'X)-1X'Y

Effect

Coefficient

Standard Error

Std.
Coefficient

Tolerance

t

p-Value

CONSTANT

3.2117655E+004

8,954.4906489

0.0000000

.

3.5867652

0.0026979

DENSE

1,669.3796526

336.4439490

0.4957264

0.6396629

4.9618359

0.0001705

HIGHWAYS

2.7741037E+004

5,210.2912339

0.5319764

0.6395687

5.3242776

0.0000850

SQRFEET

7.8242021

2.5340736

0.2473561

0.9948254

3.0875986

0.0075049

Analysis of Variance

Source

SS

df

Mean Squares

F-Ratio

p-Value

Regression

3.8565675E+010

3

1.2855225E+010

47.2069394

0.0000001

Residual

4.0847464E+009

15

2.7231642E+008

Durbin-Watson D-Statistic

2.2994706

First Order Autocorrelation

-0.1502144

Residuals and data have been saved.

Case

ESTIMATE

RESIDUAL

SALE

DENSE

HIGHWAYS

SQRFEET

STOREMGR$

1

133,099

1,901

135,000

27

1

3,600

ALLEN

2

170,334

-25,334

145,000

28

2

4,600

ARVEDSON

3

51,732

-5,732

46,000

8

0

800

BARNES

4

63,313

16,687

80,000

14

0

1,000

BAYES

5

157,408

-7,408

150,000

35

1

5,000

BEAVIS

6

48,393

-13,393

35,000

6

0

800

BOLO

7

128,924

21,076

150,000

17

1

5,200

DAVILA

8

89,280

5,720

95,000

12

1

1,200

EDWARDS

9

135,594

-10,594

125,000

25

2

800

ENKE

10

168,981

11,019

180,000

45

2

800

HENGE

11

161,456

13,544

175,000

22

3

1,200

HOOVER

12

162,199

12,801

175,000

40

2

1,000

HOPKINS

13

157,296

7,704

165,000

38

2

800

HOWIT

14

81,247

-6,247

75,000

10

1

600

JONES

15

57,678

22,322

80,000

5

0

2,200

KISSEL

16

94,288

-34,288

60,000

15

1

1,200

MATHER

17

157,829

-7,829

150,000

54

1

1,000

MCNATT

18

191,400

-1,400

190,000

39

3

1,400

MILKEN

19

100,548

-548

100,000

15

1

2,000

NIXON

Dependent Variable

SALE

N

19

Multiple R

0.9509087

Squared Multiple R

0.9042273

Adjusted Squared Multiple R

0.8850727

Standard Error of Estimate

1.6502013E+004

Explanation / Answer

Sort the data given in the last table. The person with higher sales will be the one showing the top performance . This you can do using custom sort in excel.

Case ESTIMATE RESIDUAL SALE DENSE HIGHWAYS SQRFEET STOREMGR$ 18 191,400 -1,400 190,000 39 3 1,400 MILKEN 10 168,981 11,019 180,000 45 2 800 HENGE 11 161,456 13,544 175,000 22 3 1,200 HOOVER 12 162,199 12,801 175,000 40 2 1,000 HOPKINS 13 157,296 7,704 165,000 38 2 800 HOWIT 5 157,408 -7,408 150,000 35 1 5,000 BEAVIS 7 128,924 21,076 150,000 17 1 5,200 DAVILA 17 157,829 -7,829 150,000 54 1 1,000 MCNATT 2 170,334 -25,334 145,000 28 2 4,600 ARVEDSON 1 133,099 1,901 135,000 27 1 3,600 ALLEN 9 135,594 -10,594 125,000 25 2 800 ENKE 19 100,548 -548 100,000 15 1 2,000 NIXON 8 89,280 5,720 95,000 12 1 1,200 EDWARDS 4 63,313 16,687 80,000 14 0 1,000 BAYES 15 57,678 22,322 80,000 5 0 2,200 KISSEL 14 81,247 -6,247 75,000 10 1 600 JONES 16 94,288 -34,288 60,000 15 1 1,200 MATHER 3 51,732 -5,732 46,000 8 0 800 BARNES 6 48,393 -13,393 35,000 6 0 800 BOLO

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.