Regression excel mac 20113/29/2024 It's generally good practice, at least for this kind of work, to ensure that you do specify the locations of your ranges. 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. 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? To calculate descriptive statistics for a column of data, click on the Data ribbon. The Microsoft Excel LINEST function uses the least squares method to calculate the statistics for a straight line and returns an array describing that line. Go to the Excel Reference home page for instructions for PC and Mac. Have you tried running the regression manually, i.e. This Excel tutorial explains how to use the Excel LINEST function with syntax and examples. 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.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |