the Statistics Add-In for Microsoft® Excel

Simple Regression

Sample Results as an Excel Table:

           

Simple Regression

         
           

X-Variable:

Horsepower

       

Y-Variable:

Mileage

       
           
           
 

N

A

B

R

R-Square

           

Y = A + B*X

72

20.27266145

-0.048712126

0.568507348

0.323200605

Y = A * X^B

72

68.31853762

-0.342707381

0.684551601

0.468610895

Y = A * e^(B*X)

72

20.06746357

-0.00298937

0.594547263

0.353486447

Y = A + B*ln(X)

72

41.52073474

-5.879421715

0.68914352

0.474918791

Y = A + B/X

72

10.09198984

396.0812058

0.723111483

0.522890217

Y = 1 / (A + B*X)

72

0.049866116

0.000194645

0.606364426

0.367677817

Y = X / (A + B*X)

72

-1.311113503

0.086562344

0.638929317

0.408230672

           

Sample Results as an Excel Chart: