Formula to predict, forecast, trend, etc. in a sequence of numbers from the bottom up.

[DarrenTunstall]

I want to develop a formula that will either predict, forecast, trend, etc. that will provide me with the mostly likely number that will be next in the sequence below (from bottom up) and will display in A1. For example,

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Putting your sequence of numbers in Column B, starting ib B2, Forecast and Trend both return the same result based on linear behavior.
Sheet7

*	A	B	C
*
*
*
*
*
*
*
*

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.392857[/TD]
[TD="align: right"]8.392857[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B1 =TREND(B2:B9,A2:A9,A1) C1 =FORECAST(A1,B2:B9,A2:A9) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[DarrenTunstall]

Can't get this to work. I have blank cells in my real working spreadsheet. Say for example, rows 3 and 8 have blanks. Each cell also already contains a formula. Is there any way around that to forecast?

Putting your sequence of numbers in Column B, starting ib B2, Forecast and Trend both return the same result based on linear behavior.
Sheet7

*	A	B	C
*
*
*
*
*
*
*
*

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.392857[/TD]
[TD="align: right"]8.392857[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B1 =TREND(B2:B9,A2:A9,A1) C1 =FORECAST(A1,B2:B9,A2:A9) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4