Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Error output with multiple regression? Share

Error output with multiple regression?

Excel Help for Error Output With Multiple Regression? in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Error Output With Multiple Regression?

Rate this:
(3/5 from 2 votes)
Sad Hi,
I'm new to multiple regression I try it out today with some data and the out was

SUMMARY OUTPUT
Regression Statistics
Multiple R 1
R Square 1
Adjusted R Square 65535
Standard Error 0
Observations 3

ANOVA
df SS MS F Significance F Regression 11 0.19201459 0.017455872 #NUM! #NUM!
 BenWTS
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Shocked
Rate this:
(2/5 from 2 votes)
The results that you have posted come from the regression analysis of the Analysis Toolpak add-in for Excel. 

I suggest that download the multiple regression and analysis template from this site here, and you will be able to intepret the results and also forecast with a user friendly interface.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
As per your suggestion i downloaded the software and tried to carry out the regression i got run time error 1004 (unable to get TDist property of the worksheetFunction class  )
so can uyou plz help me out for the following.
 Posted by on
Oops
Rate this:
(3/5 from 1 vote)
Which version of Excel are you running?  There maybe an issue with the TDist function in certain versions.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Error output with multiple regression? in the