Now, for the Input Y range, I type exactly the following:įor the Input X Range I type exactly "X_data!B1:B50" I then go the ribbon, click on the Data button, then I click on "Data analysis," I click on regression. I create a new sheet called "Sheet 1." This sheet is where I want to store my regression output. There are no hidden formulas on excel, and there are no VBA code macros running in the background. The workbook is called "My-Data_Project." The data are in columns as you'd normally except, all of them are floating values, and they are constant. On the first sheet, called "Y_data" I have my Y values. Without sharing the file itself since the data is sensitive, I am describing in this post step-by-step what it is I am doing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |