regressions

Question: I need help creating a formula that will add multiple variables to a daily forecast. Might require VBA. I do not know VBA. Background: Our sales volumes changes based upon multiple variables such as holidays, paydays, and days of the week. We have run regression analysis that...

SO the issue I am having is that I need to create a macro that copies information into a new sheet and then runs a regression on that information. Sounds simple enough, right? So I recorded this Macro: Sub h() ' ' h Macro ' h ' ' Keyboard Shortcut: Ctrl+h '...

I want to multiply an entire column, by another column, and accumulate the results. Like this: <tbody> A b c 2 5 10 3 4 12 4 3 12 5 2 10 </tbody> and then sum them. the result would be the sum of all the column c = 44. how can I do it? how can I calculate c directly? do you know a...