![]() Regression analysis in Excel - the basics In statistical modeling, regression analysis is used to estimate the relationships between two or more variables: Dependent variable (aka criterion variable) is the main factor you are trying to understand and predict. Then I gave them a number of assignments that require them to use the multiple regression tool and write the resulting formula. And (3) it was something that Windows and Mac users could use, equally, and discuss together. It is one of several VBA projects I've provided to them. This approach worked well, and gave the students three things: (1) it became part of my ongoing efforts to show undergraduate statistics students that they not only need to learn about Excel statistics tools, but they also need to be able to do some VBA coding, and (2) it provides a tool that they can take with them and use in a variety of applications they might encounter in the future. ![]() ![]() My LINEST function calls are directly on the spreadsheet, just like the other function calls in Excel, It has no menu items, so once it is set up it runs again and again as needed. ![]() What I decided to do was use VBA to create a simple interface that calls LINEST, and does so in a more user friendly way than using LINEST directly in the spreadsheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |