This is an add-on created by Microsoft to provide data analysis tools for statistical analyses. Now that we’ve talked enough about Excel, let’s move on to Regression. There’s more Excel has an add-in called Data Analysis ToolPak that allows you to perform various statistical operations, including Regression just with the click of a button. It's generally good practice, at least for this kind of work, to ensure that you do specify the locations of your ranges. There are a few ways you can perform a linear regression in Excel, but perhaps the easiest method is to use the Analysis ToolPak. Data analysis: Introduction to Data Analysis using 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. 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. 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. |