Minitab Exercise 1

MINITAB Exercise #1

Data Set:

[pic]

a. Plot of DISPINC against Year

[pic]

b. Plot of PERSCONS against Year

[pic]

c. Descriptive Statistics

Descriptive Statistics: DISPINC, PERSCONS, DUMMY

Variable N Mean StDev Minimum Maximum

DISPINC 10 879.2 86.4 751.6 1015.7

PERSCONS 10 793.4 85.0 672.1 927.6

DUMMY 10 0.400 0.516 0.000000000 1.000

d/e. Additional of New Variables

[pic]

f. Regression Model of PERCONS versus DISPINC and INCDUM

Regression Analysis: PERSCONS versus DISPINC, INCDUM

The regression equation is

PERSCONS = 22.0 + 0.867 DISPINC + 0.0226 INCDUM

Predictor Coef SE Coef T P

Constant 22.02 35.45 0.62 0.554

DISPINC 0.86743 0.04303 20.16 0.000

INCDUM 0.022637 0.007461 3.03 0.019

S = 5.75637 R-Sq = 99.6% R-Sq(adj) = 99.5%

Analysis of Variance

Source DF SS MS F P

Regression 2 64740 32370 976.89 0.000

Residual Error 7 232 33

Total 9 64972

g. Regression Model of PERCONS versus DISPINC, INCDUM, and CONSDUM

Regression Analysis: PERSCONS versus DISPINC, INCDUM, CONSDUM

The regression equation is

PERSCONS = 33.0 + 0.854 DISPINC - 1.09 INCDUM + 1.22 CONSDUM

Predictor Coef SE Coef T P

Constant 32.96 35.06 0.94 0.383

DISPINC 0.85419 0.04255 20.08 0.000

INCDUM -1.0906 0.8756 -1.25 0.259

CONSDUM 1.2216 0.9608 1.27 0.251

S = 5.51841 R-Sq = 99.7% R-Sq(adj) = 99.6%

Analysis of Variance

Source DF SS MS F P

Regression 3 64789 21596 709.18 0.000

Residual Error 6 183 30

Total 9 64972

Full MINITAB session output on following pages