STATISTICS F/BUS.+ECON.(LL)-W/2 ACCESS
8th Edition
ISBN: 9780134382364
Author: NEWBOLD
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 1.5, Problem 45E
Sales revenue totals (in dollars) by day of the week are contained in the data file Stordata. Prepare a cross table that contains the days of the week as rows and the four sales quartile intervals as columns.
- a. Compute the row percentages.
- b. What are the major differences in sales level by day of the week as indicated by the row percentages?
- c. Describe the expected sales volume patterns over the week based on this table.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
(Ch7) If the mean time between in-flight aircraft engine shutdowns is 12,500 operating hours, what is the 90 percentile on the distribution of the number of hours until the next shutdown? (hint: convert the mean time between events to the mean events per hour λ, then apply inverse exponential)
Question 7Select one:
a.
20,180 hours
b.
18,724 hours
c.
23,733 hours
d.
28,782 hours
Consider the following time series data:
Month
1
2
3
4
5
6
7
Value
24
13
20
12
19
23
15
Compute MSE using the most recent value as the forecast for the next period. What is the forecast for month 8?
Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for month 8?
Which method appears to provide the better forecast?
Suppose you have an extra six months of data on demands and prices, in addition to the data in the example. These extra data points are (350,84), (385,72), (410,67), (400,62), (330,92), and (480,53). (The price is shown first and then the demand at that price.) After adding these points to the original data, use Excel’s Trendline tool to find the best-fitting linear, power, and exponential trend lines. Then calculate the MAPE for each of these, based on all 18 months of data. Does the power curve still have the smallest MAPE?
Chapter 1 Solutions
STATISTICS F/BUS.+ECON.(LL)-W/2 ACCESS
Ch. 1.2 - Prob. 1ECh. 1.2 - Prob. 2ECh. 1.2 - Prob. 3ECh. 1.2 - Prob. 4ECh. 1.2 - Prob. 5ECh. 1.2 - Prob. 6ECh. 1.2 - Prob. 7ECh. 1.2 - Prob. 8ECh. 1.3 - Prob. 9ECh. 1.3 - Prob. 10E
Ch. 1.3 - Prob. 11ECh. 1.3 - Prob. 12ECh. 1.3 - Prob. 13ECh. 1.3 - Prob. 14ECh. 1.3 - Prob. 15ECh. 1.3 - Prob. 16ECh. 1.3 - Prob. 17ECh. 1.3 - Prob. 18ECh. 1.3 - Prob. 19ECh. 1.4 - Prob. 20ECh. 1.4 - Prob. 21ECh. 1.4 - Prob. 22ECh. 1.4 - Prob. 23ECh. 1.4 - Prob. 24ECh. 1.4 - Prob. 25ECh. 1.4 - Prob. 26ECh. 1.4 - Prob. 27ECh. 1.4 - Prob. 28ECh. 1.4 - Prob. 29ECh. 1.5 - Prob. 30ECh. 1.5 - Prob. 31ECh. 1.5 - Prob. 32ECh. 1.5 - Prob. 33ECh. 1.5 - Prob. 34ECh. 1.5 - Prob. 35ECh. 1.5 - Prob. 36ECh. 1.5 - Prob. 37ECh. 1.5 - Prob. 38ECh. 1.5 - Prob. 39ECh. 1.5 - Prob. 40ECh. 1.5 - Prob. 41ECh. 1.5 - Prob. 42ECh. 1.5 - Prob. 43ECh. 1.5 - Prob. 44ECh. 1.5 - Sales revenue totals (in dollars) by day of the...Ch. 1.5 - Prob. 46ECh. 1.6 - Prob. 47ECh. 1.6 - Prob. 48ECh. 1.6 - Prob. 49ECh. 1.6 - Prob. 50ECh. 1 - Prob. 51ECh. 1 - Prob. 52ECh. 1 - Prob. 53ECh. 1 - Prob. 54ECh. 1 - Prob. 55ECh. 1 - Prob. 56ECh. 1 - Prob. 57ECh. 1 - Prob. 58ECh. 1 - Prob. 59ECh. 1 - Prob. 60ECh. 1 - Prob. 61ECh. 1 - Prob. 62ECh. 1 - Prob. 63ECh. 1 - Prob. 64ECh. 1 - Prob. 65ECh. 1 - Prob. 66ECh. 1 - Prob. 67ECh. 1 - Prob. 68ECh. 1 - Prob. 69ECh. 1 - Prob. 71ECh. 1 - Prob. 72ECh. 1 - Prob. 73ECh. 1 - Prob. 74E
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Similar questions
- Suppose that you work for a U.S. senator who is contemplating writing a bill that would put a national sales tax in place. Because the tax would be levied on the sales revenue of retail stores, the senator has asked you to prepare a forecast of retail store sales for year 8, based on data from year 1 through year 7. The data are: (c1p2) Year Retail Store Sales 1 $1,225 2 1,285 3 1,359 4 1,392 5 1,443 6 1,474 7 1,467 54 Chapter One a. Use the first naive forecasting model presented in this chapter to prepare a forecast of retail store sales for each year from 2 through 8. b. Prepare a time-series graph of the actual and forecast values of retail store sales for the entire period. (You will not have a forecast for year 1 or an actual value for year 8.) c. Calculate the root-mean-squared error for your forecast series using the values for year 2 through year 7. 3. Use the second naive forecasting model presented in this chapter to answer parts (a) through (c) of Exercise 2. Use P 0.2 in…arrow_forwardA local moving company has collected data on the number of moves they have been asked to perform over the past two years. Moving is highly seasonal, so the owner/operator, who is both burly and highly educated, decides to apply the multiplicative seasonal method to forecast the number of customers for the coming year. The equation for the trend line of yearly sales is Ft = 16 + 60t. Please forecast demand for each quarter in Year 3. (Round the forecasts to whole numbers and show all calculations). Complete the table below and forecast the sales of Year 3 by quarter. Year 1 Year 2 Year 3 Quarter Demand Seasonal Index Quarter Demand Seasonal Index Average Seasonal Index Forecast 1 20 1 27 2 40 2 45 3 45 3 55 4 31 4 41 Total Averagearrow_forwardA researcher has a sample of 6 annual observations {94, 104, 102, 99, 111 and 107} for the CPI in country Z for the period 2015 to 2020, and wants to forecast CPI for the years 2021, 2022 and 2023. The researcher uses 3 different forecasting models: A, B and C. Model A is an AR(1) model with no drift and with an estimated autoregressive coefficient = 0.7. Model B is a MA(1) model with no constant and with an estimated MA coefficient = -0.4 (note the minus !). Model C is a random walk model with no drift. The error terms over the 2015-2020 period were estimated to have the values: {3, -1, 2, 4, -3, 1}. a. Compute the 2021, 2022 and 2023 forecasted values for the consumer price index based on the three models. Show the formulas and the details of your calculations, and explain all the related symbols. b. Suppose that the actual values of the CPI over the 2021, 2022 and 2023 were {108, 114, 105}. Calculate the Root mean square error of the three model forecasts over the 2021-2023…arrow_forward
- The type of economic indicator that can best be used for business forecasting is the:arrow_forwardJack is a discus thrower and hopes to make it to the Olympics some day. He has researched the distance (in meters) of each men's gold medal discus throw from the Olympics from 1920 to 1964. Below is the equation of the line of best fit Jack found. y=0.34x+44.63y=0.34x+44.63 When calculating his line of best fit, Jack let x represent the number of years since 1920 (so x=0 represents 1920 and x=4 represents 1924). Using the line of best fit, estimate the distance Jack should be able to throw in order to be able to win the 2020 Olympics.arrow_forwardBased on annual data from 2000-2010, the Gadget Company estimates that sales are growing according to a linear trend: Q = 50,000 + 200t where t is time and t = 0 in 2000. a. Forecast sales for 2013. b. Do you see any problems with this forecasting method?arrow_forward
- how to plot the following points?arrow_forwardA statistics instructor asks each student in his classes to report how much the student spent on textbooks for the semester. The figures reported by students are shown below. 725 735 555 420 385 480 505 270 405 285 585 450 515 560 500 395 545 595 365 455 505 345 555 485 560 475 520 455 355 590 550 495 505 505 495 465 370 355 480 385 515 605 480 410 485 560 475 350 465 435 455 380 320 535 565 520 510 495 485 650 490 295 555 540 565 490 570 380 610 600 390 375 390 335 525 445 540 490 485 555 440 560 405 590 520 470 560 510 340 385 585 635 415 455 590 385 505 510 545 405 470 560 495 515 495 595 565 615 470 680 465 470 310 470 505 465 375 360 650 460 560 500 375 500 370 415 490 440 470 525 535 640 385 475 425 595 505 365 485 495 390 380 585 690 Treat the data above as POPULATION data. 1 The mean expenditure on textbooks by all students is: a $485.38 b $495.29 c $505.40 d $515.71arrow_forwardDefine Forecasts and forecast errors in time series anaylsis?arrow_forward
- Describe A time-ordered sequence of observations taken at regular intervals.arrow_forwardName two coincident indicators used in forecastingarrow_forwardThe circulation C of a certain magazine as a function of time t is given by the formula c=5.2/0.1+0.3t Here C is measured in thousands and t is measured in years since the beginning of 2006 when the magazine was started. Find when the circulation of the magazines will reach 34.83 thousand. Write the equation you are solving.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Economics: Applications, Strategies an...EconomicsISBN:9781305506381Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. HarrisPublisher:Cengage Learning
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Forecasting: Exponential Smoothing, MSE; Author: Joshua Emmanuel;https://www.youtube.com/watch?v=k_HN0wOKDd0;License: Standard Youtube License