Statistics for Business & Economics, Revised (MindTap Course List)
12th Edition
ISBN: 9781285846323
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
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 data.
c.
To determine
Calculate the forecast value for the percentage of administrative expenses for 2013.
d.
To determine
Find how long it will take 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 (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund’s board of directors has been working very hard over recent years to decrease the amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentage of the money SCF has raised that was spent on administrative and fund-raising expenses over the past seven years:
Year
Period (t)
Expense (%)
2003
1
13.9
2004
2
12.2
2005
3
10.5
2006
4
10.4
2007
5
11.5
2008
6
10.0
2009
7
8.5
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 minimizes MSE for this time series.c. Forecast the percentage of administrative expenses for year 8.d. If SCF can maintain its current trend in reducing administrative expenses, how long will it take for SCF to achieve a level of 5% or less?
please help me with this
The cost for board exam review services costs P11500, P11750, and P11250 for years 2018, 2019, and 2020 respectively.
What is the range (in %) for this data?
Chapter 17 Solutions
Statistics for Business & Economics, Revised (MindTap Course List)
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
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardIn 2014, the median salary nationwide for a high school teacher was $56,310 per year. The median annual wage for all workers was $35,540.SOURCE: United States. Department of Labor. "High School Teachers." Occupational Outlook Handbook. 17 Dec. 2015. Web. 7 March 2016. Suppose a worker makes $29,000 in wages per year. Find the percent increase in salary the worker can expect if he/she trains to be a teacher and can expect to earn a salary of $40,000. Enter your response to the nearest 0.1% %arrow_forwardFollow-up question on the Household finances: Pls. Illustrate the output path diagram. Thanks.arrow_forward
- According to Zillow.com, the median sale price for homes in January for South Carolina, California, and Virginia over the last three years is given in the table below (measured in $100,000). able South Carolina California Virginia 2018 183 534 98 2019 193 555 94 2020 216 569 85 In South Carolina, realtors take 5.4% of the sale price on average as part of their commission. The average realtor commission rates in California and Virginia are 4.9% and 5.3%, respectively. Use matrix multiplication to find the total earned by realtors from their commissionsarrow_forwardIn 2011, home prices and mortgage rates fell so far 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 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). 7. City Rent ($) Mortgage ($) Atlanta 840 539 1062 1002 Chicago Detroit 823 626 DATA file Jacksonville, Fla. Las Vegas 779 711 796 655 RentMortgage 1071 953 Miami 977 Minneapolis Orlando, Fla. 776 851 695 762 651 654 Phoenix St. Louis 723 Develop a scatter diagram for these data, treating the average asking rent as the inde- pendent variable. Does a simple linear regression model appear to be appropriate? b. Use a simple linear regression model to develop an estimated regression equation to predict the monthly mortgage on the median-priced home given the average asking…arrow_forwardThe following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost. Month Maintenance and Repair Cost ($000) Revenues ($000) July $2.31 $59.00 August 3.28 53.00 September 2.80 49.00 October 2.21 65.00 November 2.30 77.00 December 1.14 105.00 January 3.12 45.00 February 3.16 51.00 March 3.02 61.00 April 2.98 63.00 May 2.04 67.00 June 1.78 79.00 July 2.60 73.00 August 2.02 67.00 September 2.57 75.00 October 2.38 77.00 November 1.43 87.00 December 0.76 117.00 January 2.58 61.00 February 2.28 63.00 March 1.69 83.00 April 1.95 87.00 May 1.95 73.00 June 1.33 69.00 Required: Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable.…arrow_forward
- Calculate range and its co-efficient from the following statistical data: Profits ( $ in 000's) 125, 50, 30, 20, 80, 85, 90, 160, 180, 100, 170, 185, 155, 200, 140, 145.arrow_forwardThe boxplot below shows salaries for CPAs and Actuaries in a town.If a person is making the median salary for a CPA, they are making less than or equal to (ANSWER) % of Actuaries. PLEASE SEE THE ATTACHMENT BELOWarrow_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
- The amount of income spent on housing is an important component of the cost of living. The total costs of housing for homeowners might include mortgage payments, property taxes, and utility costs (water, heat, electricity). An economist selected a sample of 20 homeowners in New England and then calculated these total housing costs as a percent of monthly income, 5 years ago and now. The information is reported below. Is it reasonable to conclude the percent is less now than 5 years ago? Homeowner Five Years Ago Now Homeowner Five Years Ago Now 1 17 % 10 % 11 35 % 32 % 2 20 39 12 16 32 3 29 37 13 23 21 4 43 27 14 33 12 5 36 12 15 44 40 6 43 41 16 44 42 7 45 24 17 28 22 8 19 26 18 29 19 9 49 28 19 39 35 10 49…arrow_forwardWhat do the Forecast for each year add up to?arrow_forwardRepair revenues from labor costs of the bicycle shop are given below: X 7.1 2.2 7.2 3.1 3.3 3.5 7.7 4.1 6.8 4.7 5.3 5.5 6.1 Y 3.9 1.7 3.7 1.5 2.2 1.4 4.9 2.5 4.5 3.4 2.3 3.6 3.2 Determine whether there is significant relationship at 0.05 level of significance Predict the value of Y if x are 2.7 and 1.5.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
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
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
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY