A PivotChart, in few instances, is the same as a
a. clustered-column chart. b. bubble chart.
c. stacked-column chart. d. bar chart.
Q. 2The moving averages method refers to a forecasting method that
a. is used when considerable trend, cyclical, or seasonal effects are present.
b. uses regression relationship based on past time series values to predict the future time series values.
c. relates a time series to other variables that are believed to explain or cause its behavior.
d. uses the average of the most recent data values in the time series as the forecast for the next period.
Q. 3To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs
a. PivotCharts with PivotTables.
b. stacked column charts with PivotTables.
c. heat maps with trendlines.
d. bubble charts with trendlines.
Q. 4The mean absolute error, mean squared error, and mean absolute percentage error are all methods to measure the accuracy of a forecast.These methods measure forecast accuracy by
a. determining how well a particular forecasting method is able to reproduce the time series data that are already available.
b. using the current value to estimate how well the model generates previous values correctly.
c. predicting the future values and wait for a pre-defined time period to examine how accurate the predictions were.
d. adjusting the scale of the data.
Q. 5To generate a scatter chart matrix, we use
a. native Excel functionality. b. Excel Add-In XLMiner.
c. Excel Add-In MegaStat. d. all of these.
Q. 6A time series that shows a recurring pattern over one year or less is said to follow a
a. horizontal pattern.
b. stationary pattern.
c. cyclical pattern.
d. seasonal pattern.
Q. 7A useful chart for displaying multiple variables is the
a. stacked column and bar chart. b. scatter chart.
c. scatter chart matrix. d. two-dimensional graph.