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
Returns 32.67881=forecast(A59,$C$2:$C$58,$A$2:$A$58)
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.