Linear Regression outout problem

[user345]

Hi，

I have a problem when conducting the linear regression model. The report ouput didn't show me all the predictor variables I put in. For example, I choose one vairable that contains 3 category, but the output only show me two of them. I don't know whether it because Alteryx automately discounts values that have absolutely no significance? Could you help me with it? 

Thanks

[MarqueeCrew]

@user345 ,

i think that you are describing this:

for each of the domain values of a variable, I'm not seeing 1 value.   As an example, if the variable has {A,B,C} you only see values of {B,C}. 

this is normal.  B and C are given score values based on not being A.  

Cheers,

 mark

[IraWatt]

Hey @user345,

When you say "contains 3 category" do you mean that your inputting a categorical column with 3 categories in? I don't believe that the regression tool in the default configuration will remove variables if they have no significance. As shown below even if I put a random or a column full of 1's in, the model still shows their evaluation:

[Matthew]

i know this isn't the answer you're looking for, but I've always had trouble getting the LinReg tool to work for me, so i built my own..

it can only handle a single predictor (not multiple) and it doesn't do any statistical analysis for you, but it does draw the line of best fit for all provided values of x, even if you have null y values.. and it will output a different line for each group (works like a batch macro)

[user345]

Hey,

For example, I put one variable called product category and there are three parts respectively men's shoes / women's shoes / kid's shoes. But the output only show me men's shoes and women's shoes, the kid's one disappear. Do you know why it like this?

Thanks!

[user345]

Hey,

So I can just ignore it or I need to do something?

[IraWatt]

Probably worth investigating, I assume if you just give the model children's shoes then it will include it in the output? Have you ticked any custom options? would you be able to send a screenshot of your tool config/ sample data? 

[user345]

There is no place for me to choose which categories I want to include in the model, it include all three parts in the model i think. But only two comes out. 

[IraWatt]

@user345  Ah ! if you click on the tool it should give you a configuration window on the left in which you can specify what your target as well as which variables to include in the model:  

[user345]

Yes, I chose category as one of the variables, but it just comes out 2 categories out of 3.