yeah it would be obs 1:5, 6:10, 11:15 and so on.
umm, it creates 200 sheets of results but i am only taking that one value.
that value is "coefficient" of the x value. because when i run the regression(the function) it creates the sheet with numerous values/information and i only need that one...
Hi, so what I'm trying to do is run a regression for every 5 cells of data, copy a value and paste it and repeat for 1000cells. I tried making a Macro but it just regresses the exact 5cells I used. I want to make it so that i can keep applying the task for the next 5 cells for the macro, or...