If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
regression analysis specifically forecast
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 |
#2
|
|||
|
|||
regression analysis specifically forecast
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 Michael wrote: 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 |
#3
|
|||
|
|||
regression analysis specifically forecast
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. 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 |
Thread Tools | |
Display Modes | |
|
|