Docstoc

Excel Notes -- Multiple Regression

Document Sample
Excel Notes -- Multiple Regression Powered By Docstoc
					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 a contiguous range
             The regression equation:
ŷ = 50128.37 +82.87971x1 +322540.7x2 – 4237.27x3


                           P-value for F-test =
                           .0000000746 < .05
                          At least 1 independent
                          variable is significant


                    Sq. Feet p-value = .0000839
                    Land p-value      = .15501
                    Age p-value       = .021931
                    Sq. Feet and Age are significant
                         IN THIS MODEL!!!

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:12/19/2011
language:
pages:4