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
Textbook Question
Chapter 17.6, Problem 35E
Consider the following time series data.
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Show the four-quarter and centered moving average values for this time series.
- c. Compute seasonal indexes and adjusted seasonal indexes for the four quarters.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
the values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?
For the hawkins company, the monthly percentages of all shipments received on timeover the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.a. construct a time series plot. What type of pattern exists in the data?
A dataset that consists of information from the American Community Survey from years 2006, 2007, and 2008, is an example of which type of data?
A) •Time series
B) Pooled cross-sectional
C) Panel
D) Cross-sectional
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
- Consider the following time series data.Quarter Year 1 Year 2 Year 31 4 6 72 2 3 63 3 5 64 5 7 8a. Construct a time series plot. What type of pattern exists in the data?b. Show the four-quarter and centered moving average values for this time series.c. Compute seasonal indexes and adjusted seasonal indexes for the four quarters.arrow_forward4. The CDC released the following table of life expectancies for Americans from 1900-2010.arrow_forwardA dataset that consists of information from the American Community Survey from years 2006, 2007, and 2008, is an example of which type of data? •Time series Pooled cross-sectional Panel Cross-sectionalarrow_forward
- The folloiwing table shows data for U.S. movie theater admissions (per week). Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns. Year Admissions Year Admissions 1945 79.0 1985 20.30 1955 39.9 1995 23.3 1965 19.8 2005 26.5 1975 19.9 2015 25.4arrow_forwardSelect one: A. panel data set B. cross-sectional C. time seriesarrow_forwardWhich statistical graph is most appropriate to use when presenting the average daily temperature over a week? Histogram Bar Graph Pie Graph Time Series Grapharrow_forward
- No Religious Affiliation Trends. The following table gives the percentage of first-year college students who answered “None” when asked about their religious affiliation in selected years. Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns. Year Percentage claiming no religious affiliation 1985 9.4% 1990 12.3% 1995 14.0% 2000 14.9% 2005 17.4% 2010 23.0% 2015 29.5%arrow_forwardA Bloomberg Businessweek North American subscriber study collected data from a sample of 2861 sub-scribers. Fifty- nine percent of the respondents indicated an annual income of $ 75,000 or more, and 50% reported having an American Express credit card. a. What is the population of interest in this study? b. Is annual income a categorical or quantitative variable? c. Is ownership of an American Express card a categorical or quantitative variable? d. Does this study involve cross- sectional or time series data? e. Describe any statistical inferences Bloomberg Businessweek might make on the basis of the survey.arrow_forwardNenana, Alaska Ice Breakup Data 1917 - 2021 (Jan. 1 = day 1) (Alaska Standard Time) Year Year (since 1900) Day Number Date & Time 1917 17 119.4795 April 30 at 11:30 AM 1918 18 130.3983 May 11 at 9:33 AM 1919 19 122.6066 May 3 at 2:33 PM 1920 20 131.449 May 11 at 10:46 AM 1921 21 130.2795 May 11 at 6:42 AM 1922 22 131.5559 May 12 at 1:20 PM 1923 23 128.0837 May 9 at 2:00 AM 1924 24 131.6323 May 11 at 3:10 PM 1925 25 126.7726 May 7 at 6:32 PM 1926 26 115.6691 April 26 at 4:03 PM 1927 27 132.2378 May 13 at 5:42 AM 1928 28 126.6844 May 6 at 4:25 PM 1929 29 124.6538 May 5 at 3:41 PM 1930 30 127.7941 May 8 at 7:03 PM 1931 31 129.3913 May 10 at 9:23 AM 1932 32 121.4274 May 1 at 10:15 AM 1933 33 127.8128 May 8 at 7:30 PM 1934 34 119.5885 April 30 at 2:07 PM 1935 35 134.5642 May 15 at 1:32 PM 1936 36 120.5406 April 30 at 12:58 PM 1937 37 131.8365 May 12 at 8:04 PM 1938 38 125.8434 May 6 at 8:14 PM 1939 39 118.5601 April 29 at 1:26 PM…arrow_forward
- Suppose a government organization reported the accompanying data on the number of speed-related crash fatalities during holiday periods for the years from 1994 to 2003. Speed-Related Fatalities Holiday Period 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 New Year's Day 143 144 176 76 219 138 171 134 210 70 Memorial Day 195 176 185 197 138 183 156 190 188 181 July 4th 178 219 202 179 169 178 219 64 234 184 Labor Day 189 188 166 179 162 171 180 138 202 189 Thanksgiving 212 198 218 210 203 168 187 217 210 202 Christmas 152 129 66 183 134 191 155 210 60 198 (a) Calculate the standard deviation for the New Year's Day data. (Round the answer to three decimal places.) (b) Without calculating the standard deviation of the Memorial Day data, determine whether the standard deviation for the Memorial Day data would be larger or smaller than the standard deviation of the New Year's Day data. larger smaller (c) Memorial Day and Labor Day are holidays that always occur on Monday and Thanksgiving…arrow_forwardQUESTION 22Consider a sample of payment times (in days) for 30 randomly selected invoices22 29 16 15 18 1719 17 10 21 15 1436 35 46 20 42 3418 23 22 35 36 1913 28 17 15 24 30(a) Use the above data and determine the frequency using the below frequency distribution.Classes FrequencyLess than 1515 < 2020 < 2525 < 3030 < 3535 < 40At least 40(3)(b) Construct a stem-and-leaf plot and describe the shape of the sample data (payment times).(2)(c) Determine the modal class from the frequency distribution calculated in (a). (2)(d) Using the ungrouped data given in the selected random sample, calculate the mean, medianand the mode. (6)[13]arrow_forwardUsing the same table given in question 4, what is the cumulative relative frequency for 2009?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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