Statistical Techniques in Business and Economics
16th Edition
ISBN: 9780077639723
Author: Lind
Publisher: Mcgraw-Hill Course Content Delivery
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 18, Problem 20CE
a.
To determine
Plot the given data.
b.
To determine
Obtain the least squares trend equation.
c.
To determine
Calculate the points for the years 2011 and 2014.
d.
To determine
Find the estimation of net sales for 2017.
e.
To determine
Find the average annual change in sales during the given period.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers):
A.What would be the typical linear regression equation for the number of sales?
B.Make the sales forecast for period 15 of next year.
C. Make the sales forecast for period 17 of next year.
D. What is the standard error for the data?
The follow table gives the approximate economic value associated with various levels of oil recovery in Texas. Find the regression line, and use it to estimate the economic value associated with a recovery level of 70%.
According to human capital theory, a person’s earning is linked to her level of education – there is a relationship between workers income and years of education. Using data from the Labour Force Survey, a researcher found the following regression results for earnings on intercept, years of education, experience, and experience squared:
Earnings = 5.24 + 0.035 educ + 0.165 exper – 0.003 exper2
(2.45) (0.012) (0.031) (0.001)
Construct a 95% confidence interval for the effect of years of education on earnings ?
2. Consider an individual with 8 years of experience. What would you expect to be the return to two (2) additional years of experience (the effect on earnings)?
3. According to economic theory,…
Chapter 18 Solutions
Statistical Techniques in Business and Economics
Ch. 18 - Prob. 1SRCh. 18 - Calculate a four-quarter weighted moving average...Ch. 18 - Prob. 2ECh. 18 - Prob. 2SRCh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Sales at Tomlin Manufacturing from 2009 to 2013...Ch. 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 - Refer to Exercise 9 regarding the absences at...Ch. 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 - The quarterly production of pine lumber, in...Ch. 18 - Prob. 29CECh. 18 - Sales of roof material, by quarter, for 2007...Ch. 18 - Blueberry Farms Golf and Fish Club of Hilton Head,...Ch. 18 - Prob. 32CECh. 18 - Ray Anderson, owner of Anderson Ski Lodge in...Ch. 18 - Prob. 34CECh. 18 - Prob. 35CECh. 18 - Prob. 36CECh. 18 - Consider the variable mean amount per transaction...Ch. 18 - Prob. 38CECh. 18 - Prob. 39DECh. 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 - Listed below are the price and quantity of several...Ch. 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 equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardFind the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardDoes Table 2 represent a linear function? If so, finda linear equation that models the data.arrow_forward
- The U.S. Postal Service is attempting to reduce the number of complaints made by the public against its workers. To facilitate this task, a staff analyst for the service regresses the number of complaints lodged against an employee last year on the hourly wage of the employee for the year. The analyst ran a simple linear regression in SPSS. The results are shown below. What proportion of variation in the number of complaints can be explained by hourly wages? From the results shown above, write the regression equation If wages were increased by $1.00, what is the expected effect on the number of complaints received per employee?arrow_forwardUse the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to develop the multiple linear regression model. Assume a 5% level of significance. Which independent variable is the strongest predictor of the average P/E ratio of a company? A. Total Revenues B. Average Yield C. Earnings Per Share D.Return on Equity E. Total Assets F.Dividends Per Share Company Type Total Revenues Total Assets Return on Equity Earnings per Share Average Yield Dividends per Share Average P/E Ratio AFLAC 6 7251 29454 17.1 2.08 0.9 0.22 11.5 Albertson's 4 14690 5219 21.4 2.08 1.6 0.63 19 Allstate 6 20106 80918 20.1 3.56 1 0.36 10.6 Amerada Hess 7 8340 7935 0.2 0.08 1.1 0.6 698.3 American General 6 3362 80620 7.1 2.19 3 1.4 21.2 American Stores 4 19139 8536 12.2 1.01 1.4 0.34 23.5 Amoco 7 36287…arrow_forwardMidgett Co. has accumulated data to use in preparing its annual profit plan for the upcoming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff suggested that linear regression be employed to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis are as follows: Month MaintenanceCost Machine Hours Jan. $ 5,040 620 Feb. 3,648 420 Mar. 4,320 520 Apr. 3,331 390 May 5,221 650 June 3,550 400 July 3,655 430 Aug. 5,365 690 Sept. 5,110 640 Oct. 4,866 610 Nov. 3,944 460 Dec. 3,790 440 Sum $ 51,840 6,270 Average $ 4,320.00 522.50 Average cost per hour ($51,840/6,270) = $8.27 (rounded to the nearest cent)r = 0.99821r2 = 0.99780The percent of the total variance that can be…arrow_forward
arrow_back_ios
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
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher: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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY