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_forward
Find out the next month after april income by using the forecasting method of the moving average method
arrow_forward
For 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_forward
Consider 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 accurecy
arrow_forward
the 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_forward
What would we call March 2020’s data point? What happened at that point in time to cause this?
arrow_forward
Step 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
If 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_forward
Community 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
The following data are the ages (in years) of 19 economics teachers in a school district.
58 48 40 58 41 60 47 59 53 42 51 44 61 46 43 32 52 31 34
Construct a box and whisker plot for the data.
arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher: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