regression analysis specifically forecast

M

Michael

I have tried to get the forecast function to work
properly. I have exhausted everything I could read from
microsoft website including the technical support sheet,
XE0124. When i enter the ctrl+shift+enter nothing. Even
when I do the example on the above technical sheet.
Help
 
J

Jerry W. Lewis

You have given no details to allow us to help you. FORECAST() works
exactly as described in Excel's Help, and does not need to be array
entered (perhaps you entended to use TREND()?)

In Excel 2000, Help uses the following example to get 10.60725
=FORECAST(30,{6,7,9,15,21},{20,28,31,38,40})

In Excel XP, HELP replaces the array constants with a range reference
=FORECAST(30,A2:A6,B2:B6)
where A2:B6 contain
6
20
7
28
9
31
15
38
21
40

Another approach to computing the simple linear regression prediction at
30 is
=30*SLOPE(A2:A6,B2:B6)+INTERCEPT(A2:A6,B2:B6)

Jerry
 
M

Mike Middleton

Michael -
I have tried to get the forecast function to work properly. I have
Click to expand...
exhausted everything I could read from microsoft website including the
technical support sheet, XE0124. When i enter the ctrl+shift+enter nothing.
Even when I do the example on the above technical sheet. <

I just worked that example and obtained the results shown there. That
example uses FORECAST to obtain three values, so those cells must be
selected before entering the function and then holding down Control and
Shift while you press Enter. Perhaps you could describe the steps you are
using in more detail and what is happening or not happening.

- Mike Middleton, www.usfca.edu/~middleton
 
Top