Loose Leaf for Statistical Techniques in Business and Economics
17th Edition
ISBN: 9781260152647
Author: Douglas A. Lind
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 34DA
To determine
Determine the linear trend equation.
Determine the non-linear trend equation.
Identify the best equation.
Estimate the net sales for 2016 and 2017.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The accompanying data represent the yearly amount of solar power installed (in megawatts) in a particular area from
2000 through 2008. The trend forecasting equations below were found, where X is the number of years after 2000.
Complete parts (a) through (d) below.
= -10.711 +28.9000X₁
₁ = 22.70 +0.259X; +3.5801X?
Click the icon to view the data table.
a. Compute the standard error of the estimate (Syx) for each model.
Linear
Quadratic
Syx
22.431
8.032
(Round to three decimal places as needed.)
b. Compute the MAD for each model.
Linear
Quadratic
MAD
64.222
66.873
(Round to three decimal places as needed.)
c. On the basis of (a) and (b) and the principle of parsimony, which forecasting model would you select?
The model with the smallest values of Syx and MAD should be used, which is the quadratic model.
The accompanying data represent the yearly amount of solar power installed (in megawatts) in a particular area from 2000 through 2008. The trend forecasting equations
below were found, where X is the number of years after 2000. Complete parts (a) through (d) below.
Y = -11.578 +28.7000X
Y₁ = 19.29 +2.241X; +3.3074X
Click the icon to view the data table.
a. Compute the standard error of the estimate (Syx) for each model.
Linear
Syx
(Round to three decimal places as needed.)
b. Compute the MAD for each model.
Linear
Quadratic
The model with the
Quadratic
...
MAD
(Round to three decimal places as needed.)
c. On the basis of (a) and (b) and the principle of parsimony, which forecasting model would you select?
✓values of Syx and MAD should be used, which is the
model.
Yearly Amount of Solar
Power Installed
Year
2000
2001
2002
2003
2004
2005
2006
2007
2008
Print
Amount
(megawatts)
15
24
41
66
86
100
138
210
249
D
Done
The accompanying data represent the yearly amount of solar power installed (in megawatts) in a particular area from 2000 through 2008. The trend forecasting equations below were found, where X is the number of years after 2000. Complete parts (a) through (d)
below.
Y₁ = -9.689 +28.8667X₁
Y₁ = 21.02 +2.546X; +3.2900X²
Click the icon to view the data table.
a. Compute the standard error of the estimate (Syx) for each model.
Linear
Quadratic
Syx
(Round to three decimal places as needed.)
b. Compute the MAD for each model.
Linear
Quadratic
MAD
(Round to three decimal places as needed.)
c. On the basis of (a) and (b) and the principle of parsimony, which forecasting model would you select?
The model with the
✔values of Syx and MAD should be used, which is the
▼model.
Yearly Amount of Solar Power Installed
Year
2000
2001
2002
2003
2004
2005
2006
2007
2008
Amount
(megawatts)
13
30
44
Print
73
86
95
145
214
252
Q
Done
X
Chapter 18 Solutions
Loose Leaf for Statistical Techniques in Business and Economics
Ch. 18 - Prob. 1SRCh. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 2SRCh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 3SRCh. 18 - Prob. 7E
Ch. 18 - Prob. 8ECh. 18 - Prob. 4SRCh. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 5SRCh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17CECh. 18 - Prob. 18CECh. 18 - Prob. 19CECh. 18 - Prob. 20CECh. 18 - Prob. 21CECh. 18 - Prob. 22CECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34DACh. 18 - Prob. 35DACh. 18 - Prob. 36DACh. 18 - Prob. 37DACh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
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 slope of the line: x = —4.arrow_forwardUsing the accompanying Student Grades data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the model? If a student scores 70 on the midterm, what would you predict her grade on the final exam to be? Click the icon to view the Student Grades data. Choose the correct scatter chart and linear trendline for the data. Click here to view chart b. Click here to view chart d Click here to view chart a Click here to view chart c What is the model for the trendline? Final Exam Grade = =+xMidterm Grade (Round to three decimal places as needed.) Final Chart b 1201 100- 80- 60- 40- 20- 0+ 50 60 70 80 90 100 110 Midterm - - Xarrow_forwardThe data in the scatter plot below represents the selling price of a home plotted against the list price for the home. A trend line with the equation y = x - 10 has been fitted to the data. Use the line to predict the selling price for a home that is listed at $210,000. y Sell Price vs. List Price 350 300 250 200 150 100 50 50 100 150 200 250 300 350 List Price (thousands of $) MacBook Air Sell Price (thousands of $)arrow_forward
- The following table shows retail sales in drug stores in billions of dollars in the U.S. for years since 1995. 220- 210 200 190 180 170 160 150 Year 0 130- 120- 110- 100- 90 801 6 12 15 Let S(t) be the retails sales in billions of dollars in t years since 1995. A linear model for the data is F(t) = 9.44t + 84.182. Retail Sales 85.851 108.426 141.781 169.256 202.297 222.266 3 6 9 12 15 Use the above scatter plot to decide whether the linear model fits the data well. The function is a good model for the data. The function is not a good model for the data Estimate the retails sales in the U. S. in 2015. billions of dollars.arrow_forwardWrite a linear trend math problem. Create a description of a scenario involving the spread of an invasive species of jellyfish released in a lake. The scenario should ask the reader to create a linear function that models the population (P), of the jellyfish weeks (t) after the release of the first jellyfish. The description/problem should lead the reader to create the following linear function: P = 4t + 13arrow_forwarddraw a line graph following this information. The line graph depicts the historical and projected sales volume of Pepsi Co Jamaica's Diet Pepsi for the next fiscal year, with the horizontal axis representing the four quarters of the year, and the vertical axis representing the sales volume in million cases. The historical sales data is represented by a line that shows a sales volume of 1 million cases for the past fiscal year. The projected sales volume is represented by another line that shows an expected increase in sales volume to 1.5 million cases for the next fiscal year. The sales targets for each quarter are represented by markers or points on the graph, with the first quarter expected to reach 0.4 million cases, the second quarter at 0.5 million cases, the third quarter at 0.3 million cases, and the fourth quarter at 0.3 million cases.arrow_forward
- Determine the equation of the trend line for the data shown below on Canadian balance of payments for exports of wheat over a five-year period provided by Statistics Canada. Using the trend line equation, forecast the value for the year 2014. Calculate the slope, intercept and the forecast 1. using the formulas 2. using the functions Year Export-Balance of Payments (Unadjusted) -Wheat ($ millions) 2008 569.2 2009 480.8 2010 365.7 2011 471 2012 508.6 By formula By Function SLOPE INTERCEPT FORECAST Please provide calculation in excel with step by step process for me to follow . thank youarrow_forwardUse the Women's Earnings scatterplot below to answer the questions. Women's Earnings as a Percentage of Men's Earnings 90 80 70 60 50 y = 0.617x - 1156.3 R² = 0.9302 40 30 20 10 1979 1984 1989 1994 1999 2004 2009 Year Use the equation for the trend line to estimate women's earnings as a percentage of men's earnings in 2000. (Round to the tenths place.) Percentagearrow_forwardSelect your answers from the drop-down lists.arrow_forward
- The following table shows retail sales in drug stores in billions of dollars in the U.S. for years since 1995. Year Retail Sales 85.851 3 108.426 6 141.781 9 169.256 12 202.297 15 222.266 Let S(t) be the retails sales in billions of dollars in t years since 1995. A linear model for the data is F(t) 9.44t + 84.182. 220 210 200 190 180 170 160 150 140 130 120 110 100 90 3 9 12 804arrow_forwardThe following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…arrow_forwardPlease urgentarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
- College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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