DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
85%
|
|
90%
|
|
95%
|
|
100%
|
Detailed explanation-1: -An optional numerical value greater than 0 and less than 1, indicating a confidence level. For example a 95% confidence level implies that 95% of future points fall within this radius from the prediction. The default value is 95%.
Detailed explanation-2: -Prediction intervals are used to provide a range where the forecast is likely to be with a specific degree of confidence. For example, if you made 100 forecasts with 95% confidence, you would have 95 out of 100 forecasts fall within the prediction interval.
Detailed explanation-3: -Confidence interval can help you figure out the accuracy of the prediction. A smaller interval implies more confidence in the prediction for the specific point. The default level of 95% confidence can be changed using the up or down arrows.
Detailed explanation-4: -A confidence interval of 95% means that 95% of future points are expected to fall within this radius from the result FORECAST. ETS forecasted (with normal distribution). Using confidence interval can help grasp the accuracy of the predicted model.