Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 17.4, Problem 22E
a.
To determine
Construct the time series plot.
Explain the type of pattern.
b.
To determine
Find the linear trend equation for the data.
c.
To determine
Calculate the forecast value for the percentage of administrative expenses for the year 2013.
d.
To determine
Find how long it will take for them to achieve a level of 5% or less.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The report “Daily Cigarette Use: Indicators on Children and Youth" (Child Trends Data Bank, childtrends.org/wp-content/uploads/2012/11/03 _Smoking_new.pdf, retrieved April 17, 2017) included the accompanying data on the percentage of students who report smoking cigarettes daily, for students in grades 8, 10, and 12.
Construct a time series plot for students in grade 12, and comment on any trend over time.
Construct a time series plot that shows trends over time for each of the three grade levels. Graph each of the three-time series on the same set of axes, using different colors to distinguish the different grade levels. Either label the time series in the plot or include a legend to indicate which time series corresponds to which grade level.
Write a paragraph based on the plot from Part (b). Discuss the similarities and differences for the three grade levels
Suppose an Internet retailer would like to investigate the linear relationship between the amount of time in minutes a purchaser spends on its Web site and the amount of money he or she spends on an order. The table to the right shows the data from a random sample of
Which of the following time series forecasting methods would not be used to forecast seasonal data?
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. 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 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 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 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...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 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
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 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- Give at least three examples from economics where each of the following type of data can be used: cross-sectional data, time series data, and panel data.arrow_forwardFind out the next month after april income by using the forecasting method of the moving average methodarrow_forwardFor each of the following data sets, construct a scatter plot, draw a line of best fit, use two points to find the equation for the line, and predict the specified future value.arrow_forward
- After its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…arrow_forwardConsider the following time seriesweek 1 2 3 4 5 6 value 18 13 16 11 17 14 a) Construct a time series plot? What type of pattern exists in the datab) Develop the three week moving average forecasts for this time series, then compute the measures of forecasts accurecyarrow_forwardthe table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forward
- The box-and-whisker plots show the Test Scores of five schools that have written a common exam.arrow_forwardWhat would we call March 2020’s data point? What happened at that point in time to cause this? arrow_forwardStep 4: Make decision.(Select A or B) A. Reject H0B. Retain H0 Decision = Conclusion.(Select A, B, or C) A. There is no statistical difference in recycling behavior between people who have pessimistic vs. optimistic attitudes toward eco-friendly behaviors. B. People who have pessimistic attitudes toward eco-friendly behaviors recycled significantly more often than those who have optimistic attitudes. C. People who have optimistic attitudes toward eco-friendly behaviors recycled significantly more often than those who have pessimistic attitudes. Conclusion = Effect Size. Calculate the value of the effect size using Cohen's d (NOT eta-squared). d = (use 2 dec places) Is the effect size small, medium, or large? =arrow_forward
- The Badrutt’s Palace Hotel St. Moritz which is one of the best Alpine hotels in Switzerland has provided you with their quarterly bookings data over the last 6 years as follows: Year Quarter-1 (Demand in units) Quarter-2 (Demand in units) Quarter-3 (Demand in units) Quarter-4 (Demand in units) 2018 45,000 22,000 64,000 33,000 2019 48,000 27,000 74,000 41,000 2020 52,000 32,000 83,000 46,000 2021 57,000 35,000 94,000 52,000 2022 61,000 42,000 104,000 56,000 2023 67,000 49,000 120,000 61,000 Required: i) Calculate the seasonal indices for each season using multiplicative index ii) Forecast the demand for each season of the year 2024 given that the annual demand forecast is 324,000 units. iii) Deseasonalize the actual demand data (2018-2023) above using the seasonal indices obtained in (a) above. iv) Generate OLS equation using the Deseasonalized data in (iii) above (in thousand units)arrow_forwardIf year one equals P800,000, year two equals P840,000, and year three equals P896,000, the percentage to be assigned for year three in a trend analysis, assuming that year 1 is the base year, is a. 105%. b. 89%. c. 100%. d. 112%.arrow_forwardCommunity Federal Bank in Dothan, Alabama, recentlyincreased its fees to customers who use employees as tellers.Management is interested in whether its new fee policy hasincreased the number of customers now using its automatic teller machines to that point that more machines arerequired. The following table provides the number ofautomatic teller transactions by week. Use trend projectionwith regression to forecast usage for weeks 13–16.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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