New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Forecasting

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Forecasting

Postby shaan1192 » Sun Feb 21, 2016 11:55 am

Hello,

I have five years of historical daily sales data (2010 to 2014) and i need to predict the sales for jan 1st to jan 15th in the year 2015. The data is not continuous. There are dates/ month missing for example: in the year of 2010, the data for jan is absent and in the year of 2014 the data for oct, nov, dec is absent. Also i need to determine any seasonality that exist but so far i dont have any luck. i would like to know to how rectify missing months and dates so as to get a patterned data?

any help would be greatly appreciated.
  • 0

shaan1192
Rookie
 
Posts: 1
Joined: Feb 21, 2016
Reputation: 0
Excel Version: 2010

Re: Forecasting

Postby edwardsantiago » Wed Mar 30, 2016 3:30 am

The Microsoft Excel FORECAST function returns a prediction of a future value based on existing values provided.
Syntax: FORECAST( x-value, known_y_values, known_x_values )
Example: =FORECAST(5, B2:B6, A2:A6)
Result: 20.03269866
=FORECAST(10, B2:B6, A2:A6)
Result: 11.8937852
=FORECAST(8, {1,2,3}, {4,5,6})
Result: 5
=FORECAST(7, {5.8, -1}, {2, -5})
Result: 10.65714286
=FORECAST(50, {-1,-2,-3,-4}, {10,20,30,40})
Result: -5
Refer link removed by moderation for more info.
  • 0

edwardsantiago
Rookie
 
Posts: 2
Joined: Mar 30, 2016
Reputation: 0
Excel Version: excel2011


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 50 guests

cron