UNIVERSITY OF CALIFORNIA, LOS ANGELES
Department of Economics

Economics 143 (Cameron) - Applied Regression Analysis

Classroom Handout #14: EXCEL Regression Output


Here is an EXCEL program that uses the same mpc.dat data set we used in the Guided Tour of SHAZAM Output. As you move the cursor over the links that appear below, a box will pop up in the upper left corner of your screen with a brief interpretation of what you are looking at.

100 80              
100 90              
100 100              
130 100              
140 80              
140 100              
140 120              
160 130              
160 150              
180 140              
180 178              
200 170              
220 140              
220 180              
                 
Column1   Column2            
                 
Mean 155 Mean 125.5714286          
Standard Error 11.03192171 Standard Error 9.413991391          
Median 150 Median 125          
Mode 100 Mode 100          
Standard Deviation 41.27767137 Standard Deviation 35.22393043          
Sample Variance 1703.846154 Sample Variance 1240.725275          
Kurtosis -0.950024065 Kurtosis -1.282542865          
Skewness 0.187575108 Skewness 0.265101793          
Range 120 Range 100          
Minimum 100 Minimum 80          
Maximum 220 Maximum 180          
Sum 2170 Sum 1758          
Count 14 Count 14          
                 
                 
SUMMARY OUTPUT                
                 
Regression Statistics              
Multiple R 0.843848206              
R Square 0.712079794              
Adjusted R Square 0.688086444              
Standard Error 19.67229098              
Observations 14              
                 
ANOVA                
  df SS MS F Significance F      
Regression 1 11485.44018 11485.44018 29.67821419 0.000148      
Residual 12 4643.988391 386.9990326          
Total 13 16129.42857            
                 
  Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 13.95743309 21.15186357 0.659867772 0.521802594 -32.1285 60.04338 -32.1285 60.04338
X Variable 1 0.720090293 0.132180708 5.447771489 0.000148195 0.432093 1.008087 0.432093 1.008087
                 
COURSE OUTLINE LECTURE OUTLINES PROBLEM SETS PROBLEM SOLUTIONS COMPUTER LABS
SHAZAM EXAMPLES DATA SETS ONLINE QUIZZES GRAPHICS HANDOUTS
Updated: February 11, 1998
Prepared by: Trudy Ann Cameron