EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 9PE
Construct a column chart for the data in the Excel file State Unemployment Rates to allow comparison of the January rate with the historical highs and lows. Would any other charts be better for visually conveying this information? Why or why not?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which of the following most requires long-range forecasting (as opposed to short-range or
medium-range forecasting) for its planning purposes?
A. production levels
B. purchasing
C. capital expenditures
D. job scheduling
E. cash budgeting
As a small business owner, Emil understands the importance of sales forecasting to entrepreneurial success. Which of the following is correct regarding a sales forecast? Organizations rely on correlation analyses as their exclusive sales forecasting method. It is an estimate of the amount of a product that an organization expects to sell during a certain period of time. The accuracy of a sales forecast is not important. It is based on an unspecified level of marketing effort. 4
Which of the following statements comparing exponential smoothing to the weighted moving average technique is TRUE?
Group of answer choices
Exponential smoothing typically requires less record keeping of past data.
Exponential smoothing is more easily used in combination with the Delphi method.
Exponential smoothing allows one to develop forecasts for multiple periods, whereas the weighted moving average technique does not.
More emphasis can be placed on recent values using the weighted moving average.
Exponential smoothing is considerably more difficult to implement on a computer.
Chapter 3 Solutions
EBK BUSINESS ANALYTICS
Ch. 3 - Prob. 2PECh. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - Create a stacked area chart contrasting primary...Ch. 3 - A national homebuilder builds single-family homes...Ch. 3 - The Excel file Facebook Survey provides data...Ch. 3 - Create a bubble chart for the first five colleges...Ch. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...
Ch. 3 - A marketing researcher surveyed 92 individuals,...Ch. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Apply three different colors of data bars to...Ch. 3 - For the Store and Regional Sales database, apply a...Ch. 3 - For the Excel file Closing Stock Prices, apply...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?arrow_forwardThe file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?arrow_forwardWhich of the following is true about using forecasts? Forecast accuracy decreases the farther into the future you are trying to predict. Forecasts become more accurate when predicting further into the future. Forecasts are useless when the future will look radically different from the past. The more complex the forecast, the more accurate are the predictions. The accuracy of forecasts does not vary from one application to another.arrow_forward
- You manager gave you February 2021 actual sales and sales forecast. This is the only raw data you have access to. Which of the following is the most appropriate technique for forecasting March 2021's sales? a.Simple moving average b.Exponential smoothing c.Causal relationship forecasting d.Simple linear regression e.Weighted moving averagearrow_forwardThe following table shows the number of televisions sold over the last ten years at a local electronic store. Year TV Sales 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i. Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. ii. Use that formula to forecast television sales for years 11 and 12.arrow_forwardi. Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept.ii. Use that formula to forecast television sales for years 11 and 12.arrow_forward
- The following table shows the number of televisions sold over the last ten years at a local electronic store. Year TV Sales 1. 150 2. 300 3. 480 4. 600 5. 630 6. 640 7. 700 8. 825 9. 900 10. 980 Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. [9 marks] 2. Use that formula to forecast television sales for years 11 and 12. [2 marks]arrow_forwardWhat type of analytics seeks to recognize what is going on as well as the likely forecast and make decisions to achieve the best performance possible? domain predictive prescriptive descriptive What does the robustness of a data mining method refer to? its ability to construct a prediction model efficiently given a large amount of data its speed of computation and computational costs in using the mode its ability to overcome noisy data to make somewhat accurate predictions its ability to predict the outcome of a previously unknown data set accuratelyarrow_forwardB. The following table shows the number of televisions sold over the last ten years at a local electronic store. year TV sales 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i. Using the trend projection, develop a formula to predict sales for years 11 and 12. Develop a table to calculate the slope and intercept. Please Show All Working. Use that formula to forecast television sales for years 11 and 12arrow_forward
- Which time-series model below assumes that demand in the next period will be equal to the most recent period's forecast? A. naive approach B. moving average approach OC. trend projection D. weighted moving average approach O E. exponential smoothing approach with α = 0arrow_forwardis based on the principle of using only the last observation in a sequence of stable data as a forecast for the next period O a. Associative forecast O b. Exponentially smoothed forecast O c. Naïve forecast O d. Moving average forecastarrow_forward8. Averaging techniques are useful for: A. distinguishing between random and non-random variations B. smoothing out fluctuations in time series C. eliminating historical data D. providing accuracy in forecasts E. average peoplearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY