Define a set of independent variables for fitlm

1 view (last 30 days)
Suppose I have a table T with labels
visitors price proxy_January proxy_February proxy_March
I want to run a regression
visitors = a + b*price + c_1*proxy_January + ...
A brute force way is to write down
X=[T.price T.proxy_January (then the rest of proxy variables)]
and run
mdl = fitlm(X,T.visitors)
But I would like to have Matlab to write down all the proxy variables instaad of me listing all by hand.
I understand that I can get the list of labels with T.Properties.VariableNames but I need to get the list of labels and data. Please advise.

Accepted Answer

Star Strider
Star Strider on 6 Dec 2020
Possibly:
X = T{:,2:end};
then:
mdl = fitlm(X,T.visitors)
If ‘T’ has only numeric variables, that should work. .
  4 Comments
Star Strider
Star Strider on 7 Dec 2020
As always, my pleasure!
(My apologies for the delay in responding.)

Sign in to comment.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!