Click on Data Analysis and you can see many Data Analysis options along with the option for Regression Analysis. Once you activate this Add-in, you will find the Data Analysis button in the Data tab of Excel ribbon. It's generally good practice, at least for this kind of work, to ensure that you do specify the locations of your ranges. To conduct Multiple Regression Analysis in Excel, you should enable the Analysis ToolPak Add-in of Excel. If you continue to have trouble with the Analysis toolpak regression, there's other regressions around such as Excel's LINEST, or available elsewhere on the internet, or I've probably got one on my computer somewhere.Īs one further point, I see you specify your output range as being on the ActiveWorksheet but not your input ranges. That could suggest that the problem is really elsewhere in a part of your code that you haven't posted.

Have you tried what I did in my opening paragraph above, where I was unable to get your error. LinearRegression with Excel:Mac 97,198 views 171 Dislike Share Save Michael Christofersen 24 subscribers Instructions for performing linear regression on a mac. If it does work manually, then have you tried recording the steps using the macro recorder? without the macro attempt, to ensure that it really is the macro at fault? Have you tried running the regression manually, i.e. d o c, r e p l a c e c t i t l e ( Mo d e l 1 ) Mac users click here to go to the directory where myreg. This button is next to Home in the upper-left corner of the app window. For older versions of outreg2, you may need to specify the option word or excel (after comma) d i r : s e e o u t my r e g. Find the Excel file you want to edit on your computer, and open it. It has a user-friendly interface and is available in a number of languages, making it suitable for users from around the world. I copied your code into a module, filled range CE2:CF10 with some random numerical data, ran that bit of code, and it worked quite OK. 1 Open the Excel file you want to analyze. This program is well known and has been available on Windows for a long time.

Regression in excel mac