the Statistics Add-In for Microsoft® Excel

Multiple Regression

Multiple regression methods:

  • direct
  • stepwise
  • forward
  • backward
  • max. R-square

Sample Results as an Excel Table:

Multiple Regression

X-variable:

Children

Income

Price

Mileage

Y-Variable:

Horsepower

Method:

Forward

Steps

P

R-Square

Corrected

Price(+)

6,83229E-17

0,633058746

0,627816728

Mileage(+)

0,00014014

0,703053495

0,69444635

Summary

N

R

R-Square

Std.Error

normal

72

0,838482853

0,703053495

28,95543405

corrected

0,833334476

0,69444635

Equation

95%

Coefficient

Conf. (±)

Std.Error

T

P

Constant

94,98480054

33,00647029

16,54451059

5,74116714

2,30929E-07

Price

0,006323907

0,001342881

0,00067312

9,394921456

5,73104E-14

Mileage

-3,38772804

1,675851498

0,840021445

-4,032906614

0,00014014

Analysis of variance

Sum of Squares

Degrees of Freedom

Mean Square

F

P

Regression

136968,0909

2

68484,04545

81,6825426

6,41798E-19

Residue

57850,78409

69

838,4171608

Total

194818,875

71

2743,927817