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
Videos
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 solution
Students have asked these similar questions
The Seneca Children’s Fund (SCC) is a local charity that runs a summer camp for disadvantagedchildren. The fund’s board of directors has been working very hard over recentyears to decrease the amount of overhead expenses, a major factor in how charities arerated by independent agencies. The following data show the percentage of the money SCChas raised that was spent on administrative and fund-raising expenses over the last sevenyears.
a. Construct a time series plot. What type of pattern exists in the data?b. Use simple linear regression analysis to find the parameters for the line that minimizesMSE for this time series.c. Forecast the percentage of administrative expenses for year 8.d. If SCC can maintain its current trend in reducing administrative expenses, how longwill it take SCC to achieve a level of 5 percent or less?
In 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data.
Enter negative values as negative numbers.
a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)
Google has changed its strategy with regard to how much and over which media it invests in advertising. The following table shows Google's marketing budget in millions of dollars for 2008 and 2011 (The Wall Street Journal, March 27, 2012).
2008
2011
Internet
$26.0
$123.3
Newspaper, etc.
$4.0
$20.7
Television
$0.0
$69.3
a. Select a side-by-side bar chart with year as the variable on the horizontal axis.
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
- In retail, a store manager uses time series models to understand shopping trends. Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image. Here is the data for Fiscal Year and Sales: Fiscal Year Sales 2010 $260,123.00 2011 $256,853.00 2012 $274,366.00 2013 $290,525.00 2014 $322,318.00 2015 $380,921.00 2016 $541,925.00 2017 $909,050.00 2018 $1,817,521.00 2019 $3,206,564.00 2020 $4,921,005.00 2021 $5,686,338.00 Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative. When do you use each? Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe? What predictions might you make about the store’s annual sales over the next few years?arrow_forwardIn Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…arrow_forwardThe following table gives the annual revenue for the Microsoft Corp. in billions of dollars for a ten-year period. Year Microsoft 2007 2008 51 60 2009 2010 58 62 2011 2012 70 73 2013 2014 2015 2016 78 86 94 85 Construct and upload a boxplot for the Microsoft data. Be sure to label all the important numbers for the box plot.arrow_forward
- The table and graph below both display the percentage of people in the United States who do not have health insurance over several different years. Data downloaded on 2/19/2020 from https://ourworldindata.org/health-meta. 30.0% 25.0% € 20.0% 15.0% 10.0% 5.0% Year 0.0% Part 1 24.3% 14.5% 1960 1970 1980 1963 1968 1994 2012 Percent without Health Insurance 24.3% 14.5% 15.8% 14.7% Part 2 Use the table to answer the questions in each part below. 15.8% Part 3 Which variable is the independent variable and which is the dependent variable? Choose the correct response below. You only get one submission. T 14.7% 1990 2000 2010 2020 Year O Percent of people without health insurance is the independent variable and year is the dependent variable. O Year is the independent variable and percent of people without health insurance is the dependent variable. Average Rate of Change In what unit is the average rate of change in the percentage of people without health insurance measured? You get two…arrow_forwardWrite a mathematical scenario to describe each of the scatter plots.arrow_forwardsam and ava compared the weights of their puppies each month during the first half of 2015. The graphs generated from this data are shown belowarrow_forward
- the costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.arrow_forwardThe box-and-whisker plots show the Test Scores of five schools that have written a common exam.arrow_forwardSuppose the table below gives the average tuition and fees at 2-year and 4-year state schools in a particular state. Values are adjusted to 2019 dollars. Academic Year 4-year state school 2-year state school 2005-06 $5,904 $2,661 2006-07 $6,066 $2,539 2007-08 $6,289 $2,604 2008-09 $7,222 $2,901 2009-10 $7,738 $3,065 2010-11 $8,035 $3,117 2011-12 $8,154 $3,108 2012-13 $8,497 $3,075 2013-14 $8,578 $3,025 2014-15 $9,390 $3,326 2015-16 $10,004 $3,504 2016-17 $10,474 $3,663 2017-18 $10,789 $3,830 2018-19 $10,874 $3,859 2019-20 $10,900 $3,907 Here is a graph of the information from the table. a. What is the absolute change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? b. What is the relative change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? Round to the nearest whole percentage…arrow_forward
- A statistics instructor at a large western university would like to examine the relationship (if any) between the number of optional homework problems students do during the semester and their final course grade. She randomly selects 12 students for study and asks them to keep track of the number of these problems completed during the course of the semester. At the end of the class each student's total marks is recorded along with their final grade. The data follow in Table 2. Table 2 Problem Course Grade 51 62 58 68 62 66 65 66 67 68 76 72 77 73 78 72 78 78 84 73 85 76 91 75 For this setting identify the response variable. i. i. For this setting, identify the predictor variable. Compute the linear correlation coefficient for this data set iv. ii. Classify the direction and strength of the correlation Test the hypothesis for a significant linear correlation, a = 0.05 What is the valid prediction range for this setting? Use the regression equation to predict a student's final course…arrow_forwardA car dealership keeps track of how much it spends on advertising each month and of its monthly revenue. From this information, the list of advertising expenditures and probable associated revenues are shown in the table below.arrow_forwardMorning House is a mail-order firm which carries a wide range of rather expensive art objects for homes and offices. It operate problems would be greatly reduced. Since it takes approximately six weeks to receive 90% of the response to a given campaign, an accurate prediction of total sales made as late as the end of the first week of receiving orders would be useful. The first week’s sales and total sales of the last 12 campaigns of the firm are shown below. Can the first week’s sales be used to predict total sales? First week’s Total Campaign Sales Sales 1 32 167 2 20 91 3 114 560 4 66 335 5 18 70 6 125 650 7 83 401 8 65 320 9 94 470 10 5 15 11 39 210 12 50 265 --------------------------------------------arrow_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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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