Hi - I'm struggling with the math\function used in linear regression forecasting in Excel.
I have 8 qtrs of revenue (8 columns). I want to use linear regression to forecast into the next 8 qtrs (ending with 16 columns total - 8 actual, 8 forecast). Is there a, excel formulas I can use.
For simplicity, let's assume the data is in row 4...the actuals are in b through I and I want to forecast into J through Q.
Thanks!
alyssa
I have 8 qtrs of revenue (8 columns). I want to use linear regression to forecast into the next 8 qtrs (ending with 16 columns total - 8 actual, 8 forecast). Is there a, excel formulas I can use.
For simplicity, let's assume the data is in row 4...the actuals are in b through I and I want to forecast into J through Q.
Thanks!
alyssa