Question

The sales for a particular company (in millions of dollars) for a series of years is...

The sales for a particular company (in millions of dollars) for a series of years is given:

Year Sales
2012 19.6
2013 20.9
2014 21.9
2015 23.6
2016 24.1
2017 27.7

Find the linear regression equation for this data, using Excel. Give the answer in the form y=mx+b, rounding m and b to the nearest two decimal places.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
If plotted, the following sales series would appear curvilinear. This indicates that sales are increasing at...
If plotted, the following sales series would appear curvilinear. This indicates that sales are increasing at a somewhat constant annual rate (percent). To fit the sales, therefore, a logarithmic equation should be used. Year Sales ($ millions) 2007 8.0 2008 10.4 2009 13.5 2010 17.6 2011 22.8 2012 29.3 2013 39.4 2014 50.5 2015 65.0 2016 84.1 2017 109.0 1) Determine the logarithmic equation. y = _____ + ______t 2) Determine the coordinates of the points on the logarithmic straight...
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.
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...
A company’s sales for the years 2010 to 2018 were as follows: ( x N$ 10...
A company’s sales for the years 2010 to 2018 were as follows: ( x N$ 10 000 ) Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 Sales 324 296 310 305 295 347 348 364 370 2.1) Derive, by using the method of least squares, an equation of linear trend for the sales of the company. (Use sequential numbering with x = 1 in 2010) (8) 2.2) Use the trend line equation obtained in Question 2.1 to compute...
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013...
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013 5,441 2010 3,779 2014 5,817 2011 4,504 2015 6,416 Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to fit both a linear and an exponential trend to the time series. (Round your answers to 2 decimal places.) Linear yt =  t + Exponential yt =  e  t (b) Make annual forecasts for 2016–2018, using the linear and exponential trend models. (Do not...
The quarterly production of pine lumber, in millions of board feet, by Northwest Lumber for 2012...
The quarterly production of pine lumber, in millions of board feet, by Northwest Lumber for 2012 through 2016 is: Quarter Year Winter Spring Summer Fall 2012 9.7 6.6 11.3 17.8 2013 10.0 8.9 9.3 15.9 2014 10.2 11.0 12.7 16.4 2015 10.5 9.6 13.1 17.8 2016 10.3 7.9 10.7 14.2 Click here for the Excel Data File Determine the typical seasonal pattern for the production data using the ratio-to-moving-average method. (Round your answers to 4 decimal places.) Deseasonalize the data...
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.6 2010 2 29.3 2011 3 37.8 2012 4 50.2 2013 5 59.8 2014 6 66.6 (a) Construct a time series plot.    What type of pattern exists in the data? The time series plot shows an upward linear trend. The time series plot shows a downward curvilinear trend.      The time series plot shows an upward...
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013...
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013 5,441 2010 3,779 2014 5,817 2011 4,504 2015 6,416 (a) Use Excel, MegaStat, or MINITAB to fit both a linear and an exponential trend to the time series. (Round your answers to 2 decimal places.) Linear yt =  t + Exponential yt =  e  t (b) Make annual forecasts for 2016–2018, using the linear and exponential trend models. (Do not round the intermediate calculations. Round your final...
A company’s total sales (in millions of dollars) are linear as a function of time (in...
A company’s total sales (in millions of dollars) are linear as a function of time (in years). Sales in 2010 were $2.4 million, whereas sales in 2015 amounted to $7.4 million. a) Letting ? = 0 correspond to 2010, find a function giving the company’s sales in terms of ?. b) Use your function from part (a) to determine the sales in 2013 *Please show the formulas used.
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.7 2010 2 29.3 2011 3 38.0 2012 4 50.2 2013 5 59.7 2014 6 66.7 (a) Develop a linear trend equation for this time series to forecast revenue (in billions of dollars). (Round your numerical values to three decimal places.) Tt = (b)What is the average revenue increase per year (in billions of dollars) that...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT