To answer question 2 you must create a line chart with month on the x-axis and value on the y-axis and drag a forecast line from the Analytics pane to the view. After this, you will be able to find the correct answer.
First, you should set the forecast prediction interval to 99%. To do that, right-click the forecast line and choose Forecast -> Forecast Options. After that, you must set the forecast line to show the upper prediction interval -> right-click the Sum(Value) pill from the rows shelf and choose Forecast Result -> Upper Prediction Interval.
I got question 2 wrong, how is it calculated?
Hi Arthur,
To answer question 2 you must create a line chart with month on the x-axis and value on the y-axis and drag a forecast line from the Analytics pane to the view. After this, you will be able to find the correct answer.
Hope this helps,
Narcis
The answer comes out to 12,354.8
What am I doing wrong here? How to do the 99%?
Hello,
First, you should set the forecast prediction interval to 99%. To do that, right-click the forecast line and choose Forecast -> Forecast Options. After that, you must set the forecast line to show the upper prediction interval -> right-click the Sum(Value) pill from the rows shelf and choose Forecast Result -> Upper Prediction Interval.
Hope this helps,
Narcis