Question
Find the required linear model using least-squares regression. The table below gives the total sales (in...
Find the required linear model using least-squares regression.
The table below gives the total sales (in billions of dollars) for the aerospace industry.
|
Year |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
|---|---|---|---|---|---|---|
|
Total Sales |
184.4184.4 |
186.7186.7 |
188.3188.3 |
189.5189.5 |
190.5190.5 |
191.3191.3 |
(a) Find a linear model for the data with x=6 corresponding to the year 2006.
(b) Assuming the trend continues, estimate the total sales for the year 2015.
(a) The linear model for the data is
yequals=nothing xplus+nothing .
Homework Answers
Answer #1
a)
a)
from above: y^ =1.35x+177.01
b)
predicted value =1.35*15+177.01=197.26
Not the answer you're looking for?
Similar Questions
Year Month Return Year Month Return 2006 Jan 3.95 2008 Jul 3.29 2006 Feb 3.77 2008...
Year
Month
Return
Year
Month
Return
2006
Jan
3.95
2008
Jul
3.29
2006
Feb
3.77
2008
Aug
4.62
2006
Mar
5.29
2008
Sep
4.81
2006
Apr
3.77
2008
Oct
5.16
2006
May
4.47
2008
Nov
3.69
2006
Jun
5.2
2008
Dec
5.15
2006
Jul
3.9
2009
Jan
5.29
2006
Aug
4.33
2009
Feb
3.19
2006
Sep
4.41
2009
Mar
3.89
2006
Oct
5.14
2009
Apr
4.48
2006
Nov
3.24
2009
May
5.27
2006
Dec
4.13
2009
Jun
3.93
2007
Jan...
How can I do regression analysis for Sales Revenue for Macys comparing it to TJX? Please...
How can I do regression analysis for Sales Revenue for Macys
comparing it to TJX? Please show work and example in Excel if it's
easier.
Net Profit Margin
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
Sales Revenue - MACYS
$
15,776,000.00
$
22,390,000.00
$
26,970,000.00
$
26,313,000.00
$ 24,892,000.00
$
23,489,000.00
$
25,003,000.00
$
26,405,000.00
$
27,686,000.00
$
27,931,000.00
$
28,105,000.00
$
27,079,000.00
$
25,778,000.00
$
24,837,000.00
Net Profit Margin
2005
2006
2007...
Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question:...
Please use SPSS for analysis if available
Will give positive feedback for answering all
questions!
Question:
The sales data of a company's sales records is
provided.
a. Plot a time-series plot of the data
b. Fit a Linear trend line to these data
c. Conduct a hypothesis test of the linear trend model developed
in part b. Use significance level of 0.05
d. State the predicted value of sales from 2005 to 2020
e. Calculate MAD and MSE for the...
As online attacks persist, spending on information security software continues to rise. The following table gives...
As online attacks persist, spending on information security
software continues to rise. The following table gives the forecast
for the worldwide sales (in billions of dollars) of information
security software through 2007 (t = 0 corresponds to
2002).
Year,
t
0
1
2
3
4
5
Spending,
y
6.8
8.2
9.6
11
12.4
14.6
(a) Find an equation of the least-squares line for these data.
(Round all coefficients to four decimal places.)
y =
(b) Use the result of part...
The table shows the numbers of master's degrees, y (in thousands) conferred in United States from...
The table shows the numbers of master's degrees, y (in
thousands) conferred in United States from 2009 through 2012. Find
the least squares regression line for the data. Then use the model
to predict the number of degrees conferred in 2019. Let t
represent the year t=9 corresponding to 2009. (Source:
U.S. National Center for Education Statistics)
*Please use Matrix/Linear Algebra to solve*
Year
2009
2010
2011
2012
Master's Degrees, y
662.1
693.0
730.6
754.2
Sally Reynolds sells real estate along the coastal area of Northern California. Below are her total...
Sally Reynolds sells real estate along the coastal area of
Northern California. Below are her total annual commissions between
2005 and 2015. Find the mean, median, and mode of the commissions
she earned for the 11 years.
Year
Amount (thousands)
2005
$
237.51
2006
233.8
2007
206.97
2008
248.14
2009
164.69
2010
292.16
2011
269.11
2012
225.57
2013
255.33
2014
202.67
2015
206.53
Find the mean, median, and mode of the commissions she earned
for the 11 years. (Round your...
Sally Reynolds sells real estate along the coastal area of Northern California. Below are her total...
Sally Reynolds sells real estate along the coastal area of
Northern California. Below are her total annual commissions between
2005 and 2015. Find the mean, median, and mode of the commissions
she earned for the 11 years.
Year
Amount (thousands)
2005
$
239.35
2006
204.51
2007
254.46
2008
266.38
2009
232.86
2010
206.21
2011
259.26
2012
169.27
2013
266.38
2014
226.25
2015
205.65
Find the mean, median, and mode of the commissions she earned
for the 11 years. (Round your...
Consider the data in the table below, which shows, by year, the percent of unemployed college...
Consider the data in the table below, which shows, by year, the
percent of unemployed college graduates in a particular city who
are 25 years or older.
Year
2000
2002
2005
2007
2010
Percent Unemployed
6.5
7.0
7.4
8.2
9.0
Determine whether the trend appears to be linear. If so, and
assuming the trend continues, find the linear regression model to
predict the percent of unemployed college graduates in a given year
to three decimal places. (Let t = 0...
Total revenue of a company is steadily increasing since 2005. The following table displays sales (in...
Total revenue of a company is steadily increasing since 2005.
The following table displays sales (in millions of dollars) in the
past few years.
Year Sales
2005 12
2007 19
2010 21
2012 25
2013 26
2015 30
(a) Compute the equation of the linear regression line.
(b) Display the data in a graph together with the linear regression
line. (c) Compute r.
(d) Use the linear regression equation to estimate the revenue for
2019.
The table below reports the earnings per share of common stock for Home Depot Inc. for...
The table below reports the earnings per share of common stock
for Home Depot Inc. for 2003 through 2015. Year Earnings per Share
2003 $ 1.64 2004 1.94 2005 2.33 2006 2.81 2007 2.81 2008 2.44 2009
1.40 2010 1.66 2011 2.04 2012 2.55 2013 3.80 2014 6.40 2015 9.63
Click here for the Excel Data File Develop an index, with 2003 as
the base, for earnings per share for years 2004 through 2015.
(Round your answers to 1 decimal...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 15 minutes ago
asked 27 minutes ago
asked 33 minutes ago
asked 35 minutes ago
asked 42 minutes ago
asked 42 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago