Author Question: The moving averages method refers to a forecasting method that a. is used when considerable trend, ... (Read 126 times)

BRWH · **on:** Jun 24, 2018

The 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.

Question 2

To 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.

AmberC1996 · **Reply #1 on:** Jun 24, 2018

Answer to Question 1

d
RATIONALE: The moving averages method refers to a forecasting method that uses the average of the most recent data values in the time series as the forecast for the next period.

Answer to Question 2

a
RATIONALE: The PivotChart displays the same information as that of the PivotTable, but the column chart used here makes it easier to compare quantitative variables per category.