Error output with multiple regression?

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

Error Output With Multiple Regression?

Rate this: (3/5 from 2 votes)

	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 benwts on 06 Apr 2009

Replies - Displaying 1 to 4 of 4

Order Replies By: Most recent | Chronological | Highest Rated

	Error output with multiple regression Rate this: (4/5 from 2 votes) We can define a test problem that we can use to demonstrate the different modeling strategies. We will use the make_regression() function to create a test dataset for multiple-output regression. We will generate 1,000 examples with 10 input features, five of which will be redundant and five that will be informative. The problem will require the prediction of two numeric values. Problem Input: 10 numeric variables.Problem Output: 2 numeric variables.The example below generates the dataset and summarizes the shape. # example of multioutput regression test problemfrom sklearn.datasets import make_regression# create datasetsX, y = make_regression(n_samples=1000, n_features=10, n_informative=5, n_targets=2, random_state=1, noise=0.5)# summarize datasetprint(X.shape, y.shape)Running the example creates the dataset and summarizes the shape of the input and output elements of the dataset for modeling, confirming the chosen configuration. (1000, 10) (1000, 2)Next, let’s look at modeling this problem directly. Regards,Rachel Gomez
	rachel
	Posted by RachelGomez161999 on 13 Dec 2022

	Version of Excel for TDIST Rate this: (2.5/5 from 2 votes) Which version of Excel are you running?  There maybe an issue with the TDist function in certain versions.
	Excel Business Forums Administrator
	Posted by Excel Helper on 09 Mar 2013

	regression error 1004 Rate this: (2/5 from 2 votes) 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 jaimin on 09 Mar 2013

	Analysis Toolpak add-in for Excel Rate this: (2.2/5 from 5 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 Excel Helper on 06 Apr 2009

Displaying page 1 of 1