austenr
03-15-2018, 09:54 AM
I usually try to do this kind of thing in Tableau or Power BI but am forced to try to do it in Excel 2013.
Trying to do a forecast for calls for month of March. Using the following formula produces results that I think are unrealistic:
In E59
=forecast(A59,$C$2:$C$58,$A$2:$A$58)
Returns 32.67881
Copying that formula down the result varies from 32 to 33 with fractions.
Was expecting some more variances based on the data.
Anyone have any ideas?
Workbook attached.
Trying to do a forecast for calls for month of March. Using the following formula produces results that I think are unrealistic:
In E59
=forecast(A59,$C$2:$C$58,$A$2:$A$58)
Returns 32.67881
Copying that formula down the result varies from 32 to 33 with fractions.
Was expecting some more variances based on the data.
Anyone have any ideas?
Workbook attached.