Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'm trying to use the forecasting model but I don't know what number or
operation I'm supposed to use in place of E. In my case, x = 37. I'm sure it's simple but I don't have a clue. Can anyone please help me out? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
svt steve -
That's likely the result of adding a power trendline to a chart. "3E+06" corresponds to 3*10^6 = 3*1000000 = 3000000, so the much-too-simple answer is that the function corresponds to =3000000*X^0.3088. But, first, be sure to use an XY (Scatter) chart type before fitting the trendline, and second, display more significant digits (by selecting the function and clicking the Increase Decimal button repeatedly) before using it for a forecast. - Mike http://www.mikemiddleton.com "svt steve" <svt wrote in message ... I'm trying to use the forecasting model but I don't know what number or operation I'm supposed to use in place of E. In my case, x = 37. I'm sure it's simple but I don't have a clue. Can anyone please help me out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|