ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   add a second independent variable, doing regression in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/81081-add-second-independent-variable-doing-regression-excel.html)

cheeks

add a second independent variable, doing regression in excel?
 
I would like to add a second independent variable in a regression analysis
using excel. When I click on data analysis, then regression, there is only
cells for one x-variable. The help says you can have as many as 16. Must be
some simple process for adding additional variables. Hope someone can help. I
am a compete novice at this one.
Thanks, Cheeks

Jerry W. Lewis

add a second independent variable, doing regression in excel?
 
Excel is asking for one X matrix, consisting of up to 16 columns (variables).
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

Jerry

"cheeks" wrote:

I would like to add a second independent variable in a regression analysis
using excel. When I click on data analysis, then regression, there is only
cells for one x-variable. The help says you can have as many as 16. Must be
some simple process for adding additional variables. Hope someone can help. I
am a compete novice at this one.
Thanks, Cheeks



All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com