Show all work please, thanks!!! 6. The following data represents a company\'s re

Question

Show all work please, thanks!!!

6. The following data represents a company's revenue in millions of dollars. Year: 2003 2005 2007 2008 2010 2011 2012 2013 2016 Revenue: 30 32 34 35 39 39 44 46 50 Let the year 2000 be the base year with x 0 a) (5 pts) Model the data with a linear function using the points in years 2003 and 2013. Round computed values to the nearest tenth. Also, using your model predict the revenue in the year 2017 b) (5 pts) S up a able of (x y values to be used for a least squares model and find a linear least squares model v av H b for the data. Express the coefficients a and b accurate to 3 decimal places Also what is the R value accurate to 3 decimal places? Also, using your least squares mod prediet the revenue in the year 2017

Explanation / Answer

following information has been generated

for equation y=a+bx=23.5175+1.6158*x

b=r*sd(y)/sd(x)=0.9791*6.3732/3.8618= 1.6158

a=mean(y)-b*mean(x)=38.7778-1.6158*9.4444=23.5175

for x=17, y==23.5175+1.6158*17=50.9861

(b) data is not given, please share the data at earliest

Year x Revenue(y) 2003 3 30 2005 5 32 2007 7 34 2008 8 35 2010 10 39 2011 11 39 2012 12 44 2013 13 46 2016 16 50 n= 9 9 mean= 9.4444 38.7778 sd= 3.8618 6.3732 cov(x,y)= 24.0988 corr(x,y)=r= 0.9791

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---