target_date,values,timeline,confidence_level,seasonality,data_completion,aggregation!Returns a confidence interval for the ...

!target_date,values,timeline,confidence_level,seasonality,data_completion,aggregation!!Returns a confidence interval for the forecast value at the specified target date.!is the data point for which (!idspnExcel_NV) predicts a value. It should carry on the pattern of values in the timeline.!is the array or range of numeric data you're predicting.!is the independent array or range of numeric data. The dates in the timeline must have a consistent step between them and can't be zero.!is a number between 0 and 1 that shows the confidence level for the calculated confidence interval. The default value is .95.!is an optional numeric value that indicates the length of the seasonal pattern. The default value of 1 indicates seasonality is detected automatically.!is an optional value for handling missing values. The default value of 1 replaces missing values by interpolation, and 0 replaces them with zeros.!is an optional numeric value for aggregating multiple values with the same time stamp. If blank, (!idspnExcel_NV) averages the values.!