Simple Linear Regression On Excel
1. Construct Scatterplot to see if data
looks linear. Click Chart Wizard.
Select Scatter
and
this chart sub-type
Highlight only cells that
contain the x and y values
Enter a chart title
Label x and y axes
Store on a new w

Interpreting Summary Output from
Excel
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.540656024
R Square
0.292308937
Adjusted R Square
0.281504493
Standard Error
176.6190143
Observations
134
ANOVA
df
Regression
Residual
Total
Intercept
P
WATER
2
131
13

Tests For Multinomials
The Multinomial Situation
Have k qualitative choices
Hypothesize:
H0: p1, p2, pk are the true proportions
H1: At least one of these proportions is incorrect
Determine the expected number of observations for each
choice if H0 were

Multiple Regression
Want to find the best linear relationship
between a dependent variable, Y, (Price),
and 3 independent variables X1 (Sq. Feet),
X2 (Land), and X3 (Age).
Using Excel to Get the s
Go to TOOLS/DATA ANALYSIS/REGRESSION
Note B1:D39
Must be