# Forecasting in Excel using a Log function

#### aha_cupcake

##### New Member
Hi guys!!
I need to forecast in Excel using a Logarithmic function for the following data:

 Year Year Number Profit 2012 0 24,992 2013 1 41,521 2014 2 61,105 2015 3 82,340

<colgroup><col style="width: 73px"><col width="105"><col width="76"></colgroup><tbody>
</tbody>

I need to find the forecasted values for 2016 and 2017 as well as graph to the log function. But I don't know how to do the equation. Can someone help me?

#### JoeMo

##### MrExcel MVP
Hi guys!!
I need to forecast in Excel using a Logarithmic function for the following data:

 Year Year Number Profit 2012 0 24,992 2013 1 41,521 2014 2 61,105 2015 3 82,340

<tbody>
</tbody>

I need to find the forecasted values for 2016 and 2017 as well as graph to the log function. But I don't know how to do the equation. Can someone help me?
Plotting Profit vs Year Number produces a straight line conforming to the equation: Profit = 19163*YrNo + 23745 with an R-squared fitting factor of 0.9969.

Why do you need a log function to forecast a nearly perfect straight line fit?

#### aha_cupcake

##### New Member
Plotting Profit vs Year Number produces a straight line conforming to the equation: Profit = 19163*YrNo + 23745 with an R-squared fitting factor of 0.9969.

Why do you need a log function to forecast a nearly perfect straight line fit?
For our assignment they asked us to forecast using three different estimates - a best case scenario, worst case scenario and best estimate. So while it does appear there is a straight line I still need to consider other options.

#### JoeMo

##### MrExcel MVP
For our assignment they asked us to forecast using three different estimates - a best case scenario, worst case scenario and best estimate. So while it does appear there is a straight line I still need to consider other options.