|
Title: A PivotChart, in few instances, is the same as a Post by: judahblumbergs on Mar 10, 2018 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. 2 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. Q. 3 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. Q. 4 The 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. 5 To 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. 6 A 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. 7 A 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. Title: A PivotChart, in few instances, is the same as a Post by: EgMneedshelp on Mar 10, 2018 a RATIONALE: The PivotChart is same as a clustered column chart in a study based on a couple of quantitative variables belonging to the same category. 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. 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. a RATIONALE: These measures of forecast accuracy are used to determine how well a particular forecasting method is able to reproduce the time series data that are already available. By selecting the method that is most accurate for the data already known, we hope to increase the likelihood that we will obtain more accurate forecasts for future time periods. b RATIONALE: It is not possible to generate a scatter chart matrix using native Excel functionality. A scatter chart matrix is generated using the Excel Add-In XLMiner. d RATIONALE: A time series that shows a recurring pattern over one year or less is said to follow a seasonal pattern. c RATIONALE: A scatter chart matrix is a useful chart for displaying multiple variables. Title: A PivotChart, in few instances, is the same as a Post by: judahblumbergs on Mar 10, 2018 Genius!!!!!!
|