![How To Get Regression In Excel For Mac How To Get Regression In Excel For Mac](/uploads/1/2/5/5/125587831/295479180.jpg)
I am teaching a class where about 30% of the sutdents have Macs, and I require them to have Office for the Mac installed. When I want to explain multiple regression concepts, the Mac users don't have the data analysis toolkit, so they cannot have the same experience that the Windows users have. For a simple regression, they can use the spreadsheet functions, slope and intercept, or the graphical trendline option, but are out uinable to do a multiple regression as far as I know. Most of these are beginning users.
Are there any suggestions for how I might help them learn about multiple regressions using Office for the Mac, without their having to download any third party software? I am teaching a class where about 30% of the sutdents have Macs, and I require them to have Office for the Mac installed. When I want to explain multiple regression concepts, the Mac users don't have the data analysis toolkit, so they cannot have the same experience that the Windows users have. For a simple regression, they can use the spreadsheet functions, slope and intercept, or the graphical trendline option, but are out uinable to do a multiple regression as far as I know. Most of these are beginning users. Are there any suggestions for how I might help them learn about multiple regressions using Office for the Mac, without their having to download any third party software? (A) I think the best approach is to follow Microsoft's recommendation.
That is, have the students download the free StatPlus:mac LE from the AnalystSoft web site and use its Regression Linear Regression feature for multiple regression. The experience will be very similar to the Regression tool that's available with the Windows Excel Data Analysis add-in. (B) A very inferior alternative is to use Excel's built-in array-entered LINEST worksheet function.
But there's no friendly interface, the results are not labelled, and no charts are created automatically. Mike Middleton, www.MikeMiddleton.com. In September, I said I'd reply when I decide what to use to demonstrate multiple regression analysis in a class I'm teaching. 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. 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. 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. It is one of several VBA projects I've provided to them.
And (3) it was something that Windows and Mac users could use, equally, and discuss together. Then I gave them a number of assignments that require them to use the multiple regression tool and write the resulting formula.
Most of them did well on that part of the test that was used to evaluate their learning. Thank you very much for your helpful advice on this topic.
The 2016 version of Excel for the Mac includes the Data Analysis ToolPak which you can use if you are up to date! 4.4k Views View 3 Upvoters Thank you for your feedback! If you have the Excel desktop application, you can use the Open in Excel button to open your workbook and use either the Analysis ToolPak's Regression tool or statistical functions to perform a regression analysis there. Click Open in Excel and perform a regression analysis.