EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 8220100460463
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 51SE
Refer to the Costello Music Company time series in exercise 49.
- a. Deseasonalize the data and use the deseasonalized time series to identify the trend.
- b. Use the results of part (a) to develop a quarterly forecast for next year based on trend.
- c. Use the seasonal indexes developed in exercise 50 to adjust the forecasts developed in part (b) to account for the effect of season.
50. Refer to the Costello Music Company problem in exercise 49.
- a. Using time series decomposition, compute the seasonal indexes for the four quarters.
- b. When does Costello Music experience the largest seasonal effect? Does this result appear reasonable? Explain.
49. Consider the Costello Music Company problem in exercise 48. The quarterly sales data follow.
| Year | Quarter I | Quarter 2 | Quarter 3 | Quarter 4 | Total Yearly Sales |
| 1 | 4 | 2 | 1 | 5 | 12 |
| 2 | 6 | 4 | 4 | 14 | 28 |
| 3 | 10 | 3 | 5 | 16 | 34 |
| 4 | 12 | 9 | 7 | 22 | 50 |
| 5 | 18 | 10 | 13 | 35 | 76 |
- a. Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; and Qtr3 = 1 if Quarter 3, 0 otherwise.
- b. Compute the quarterly forecasts for next year.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
T
Teenage obesity (O), and weekly fast-food meals (F), among some selected Mississippi teenagers are:
Name Obesity (lbs) # of Fast-foods per week
Josh
185
10
Karl
172
8
Terry
168
9
Kamie
Andy
204
154
12
6
(a) Compute the variance of Obesity, s²o, and the variance of fast-food meals, s², of this data. [Must show full work].
(b) Compute the Correlation Coefficient between O and F. [Must show full work].
(c) Find the Coefficient of Determination between O and F. [Must show full work].
(d) Obtain the Regression equation of this data. [Must show full work].
(e) Interpret your answers in (b), (c), and (d). (Full explanations required).
Edit View Insert Format Tools Table
The average miles per gallon for a sample of 40 cars of model SX last year was 32.1, with a population standard deviation of 3.8. A sample of 40 cars from this year’s model SX has an average of 35.2 mpg, with a population standard deviation of 5.4.
Find a 99 percent confidence interval for the difference in average mpg for this car brand (this year’s model minus last year’s).Find a 99 percent confidence interval for the difference in average mpg for last year’s model minus this year’s. What does the negative difference mean?
A special interest group reports a tiny margin of error (plus or minus 0.04 percent) for its online survey based on 50,000 responses. Is the margin of error legitimate? (Assume that the group’s math is correct.)
Chapter 17 Solutions
EBK STATISTICS FOR BUSINESS & ECONOMICS
Ch. 17.2 - Consider the following time series data. Week 1 2...Ch. 17.2 - Refer to the time series data in exercise 1. Using...Ch. 17.2 - Exercises 1 and 2 used different forecasting...Ch. 17.2 - Consider the following time series data. Month 1 2...Ch. 17.3 - Consider the following time series data. Week 1 2...Ch. 17.3 - Consider the following time series data. Month 1 2...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Refer again to the gasoline sales time series data...Ch. 17.3 - With the gasoline time series data from Table...Ch. 17.3 - With a smoothing constant of = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in ...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Automobile unit sales at B. J. Scott Motors, Inc.,...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies. Inc., supplies milk to several...Ch. 17 - Prob. 44SECh. 17 - Prob. 45SECh. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Suppose that 73 percent of a sample of 1,000 U.S. college students drive a used car as opposed to a new car or no car at all. Find an 80 percent confidence interval for the percentage of all U.S. college students who drive a used car.What sample size would cut this margin of error in half?arrow_forwardYou want to compare the average number of tines on the antlers of male deer in two nearby metro parks. A sample of 30 deer from the first park shows an average of 5 tines with a population standard deviation of 3. A sample of 35 deer from the second park shows an average of 6 tines with a population standard deviation of 3.2. Find a 95 percent confidence interval for the difference in average number of tines for all male deer in the two metro parks (second park minus first park).Do the parks’ deer populations differ in average size of deer antlers?arrow_forwardSuppose that you want to increase the confidence level of a particular confidence interval from 80 percent to 95 percent without changing the width of the confidence interval. Can you do it?arrow_forward
- A random sample of 1,117 U.S. college students finds that 729 go home at least once each term. Find a 98 percent confidence interval for the proportion of all U.S. college students who go home at least once each term.arrow_forwardSuppose that you make two confidence intervals with the same data set — one with a 95 percent confidence level and the other with a 99.7 percent confidence level. Which interval is wider?Is a wide confidence interval a good thing?arrow_forwardIs it true that a 95 percent confidence interval means you’re 95 percent confident that the sample statistic is in the interval?arrow_forward
- Tines can range from 2 to upwards of 50 or more on a male deer. You want to estimate the average number of tines on the antlers of male deer in a nearby metro park. A sample of 30 deer has an average of 5 tines, with a population standard deviation of 3. Find a 95 percent confidence interval for the average number of tines for all male deer in this metro park.Find a 98 percent confidence interval for the average number of tines for all male deer in this metro park.arrow_forwardBased on a sample of 100 participants, the average weight loss the first month under a new (competing) weight-loss plan is 11.4 pounds with a population standard deviation of 5.1 pounds. The average weight loss for the first month for 100 people on the old (standard) weight-loss plan is 12.8 pounds, with population standard deviation of 4.8 pounds. Find a 90 percent confidence interval for the difference in weight loss for the two plans( old minus new) Whats the margin of error for your calculated confidence interval?arrow_forwardA 95 percent confidence interval for the average miles per gallon for all cars of a certain type is 32.1, plus or minus 1.8. The interval is based on a sample of 40 randomly selected cars. What units represent the margin of error?Suppose that you want to decrease the margin of error, but you want to keep 95 percent confidence. What should you do?arrow_forward
- 3. (i) Below is the R code for performing a X2 test on a 2×3 matrix of categorical variables called TestMatrix: chisq.test(Test Matrix) (a) Assuming we have a significant result for this procedure, provide the R code (including any required packages) for an appropriate post hoc test. (b) If we were to apply this technique to a 2 × 2 case, how would we adapt the code in order to perform the correct test? (ii) What procedure can we use if we want to test for association when we have ordinal variables? What code do we use in R to do this? What package does this command belong to? (iii) The following code contains the initial steps for a scenario where we are looking to investigate the relationship between age and whether someone owns a car by using frequencies. There are two issues with the code - please state these. Row3<-c(75,15) Row4<-c(50,-10) MortgageMatrix<-matrix(c(Row1, Row4), byrow=T, nrow=2, MortgageMatrix dimnames=list(c("Yes", "No"), c("40 or older","<40")))…arrow_forwardDescribe the situation in which Fisher’s exact test would be used?(ii) When do we use Yates’ continuity correction (with respect to contingencytables)?[2 Marks] 2. Investigate, checking the relevant assumptions, whether there is an associationbetween age group and home ownership based on the sample dataset for atown below:Home Owner: Yes NoUnder 40 39 12140 and over 181 59Calculate and evaluate the effect size.arrow_forwardNot use ai pleasearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY