topic Re: Average Square Error is too high. in SAS Data Science

Average Square Error is too high.

NareshAbburi — Sat, 26 Apr 2014 19:20:29 GMT

Hi,

I'm building a model which is giving me the very high average square error and misclassification rate.

Ho can I reduce these two results. Please provide me valuable inputs.

Also, Please let me know what is basic flow for Data Mining Model.

Thanks.

Re: Average Square Error is too high.

Reeza — Sat, 26 Apr 2014 22:49:37 GMT

That's way too difficult to answer here.

Your model is clearly not fitting well, so try changing the variables included in the model.

To learn more about data mining perhaps look into the CRISP-DM framework and/or check out the data mining courses offered on Coursera, EdX, Udacity for starters.

Lecture Notes | Data Mining | Sloan School of Management | MIT OpenCourseWare

Re: Average Square Error is too high.

NareshAbburi — Sun, 27 Apr 2014 00:01:03 GMT

Hi,

I've tried with multiple combinations, but still ASE is too high. it is nearly 2000. and my validation ASE also nearly 2000.

Is there any alternative to fit my model well.

Thanks.

Re: Average Square Error is too high.

Reeza — Sun, 27 Apr 2014 01:29:28 GMT

without any context its hard to say. How many variables do you have? What is your predictor? How many categorical variables are there? How many continuous? Have you standardized your variables? Or transformed them? What did the univariate analysis show? Are the scales of your variables incredibly different?

Re: Average Square Error is too high.

NareshAbburi — Sun, 27 Apr 2014 21:21:10 GMT

Hi,

I've a continuous target variable. Input variables are both continuous and categorical variables. (Continuous - 4, Categorical - 3)

I'm trying to build logistic regression. (Will it work...?)

I've standardized and applied transformation also to reduce skewness of the variables.

Plz suggest.

Re: Average Square Error is too high.

Reeza — Sun, 27 Apr 2014 21:33:42 GMT

No.

Logistic regression is for a binary target variable. Linear Regression is for a continuous target variable.

Re: Average Square Error is too high.

NareshAbburi — Sun, 27 Apr 2014 21:35:51 GMT

Then what is best prediction model to apply for combination of categorical and continuous inputs..?

Re: Average Square Error is too high.

Reeza — Sun, 27 Apr 2014 21:39:58 GMT

Linear regression. The model is more dependent on the output required than the input.

Re: Average Square Error is too high.

Reeza — Sun, 27 Apr 2014 21:41:27 GMT

Choosing the Correct Statistical Test in SAS, Stata and SPSS