We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

I've read that Excel can solve multiple linear regression problems containing dummy variables. Apparently Calc cannot (I tried one and it failed). Do you know any way to get Calc to solve multiple linear regression problems containing dummy variables?

asked 2017-12-20 22:44:41 +0200

wtb32141 gravatar image

A dummy variable (or vector) is one that can have only 2 values, 0 and 1, to indicate the presence or absence of some characteristic.

edit retag flag offensive close merge delete


It helps if you don't try to define terms, but provide sample file instead with the problem, expected result, and steps tried.

Mike Kaganski gravatar imageMike Kaganski ( 2017-12-20 22:46:42 +0200 )edit

Lengthy titles are not appropriate for this site. Also, the question is not clear. You tried something; that's a good start. Now tell us exactly what you tried, and in what way it failed. See guidelines for asking.

Jim K gravatar imageJim K ( 2017-12-20 23:07:13 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-03 15:39:49 +0200

BSNatal gravatar image

Your question is stale now. Excel definitely can solve regression problems with dummy variables, although it is some time since I did it. I have not tried with Solver, but would be surprised if one of the solver engines can not do it. Once you have set up your equations, start Solver and select the options button. There are a number of engines that you can select from as well as other parameters you can try.

edit flag offensive delete link more


IIUC, OP didn't declare Excel to be unable doing that.

Mike Kaganski gravatar imageMike Kaganski ( 2019-10-03 15:47:51 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-20 22:44:41 +0200

Seen: 355 times

Last updated: Oct 03 '19