Excel assingment | Management homework help

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Order a Similar Paper HERE Order a Different Paper HERE

Excel Assingment  

REQUIRED

Estimate the values of a and b, using,

1. the High-Low Method, and  

2. the Linear Regression method    

For help outside of the textbook, try “Linear Regression in Excel” on YouTube

Note, to use the linear regression method, you MUST use the Microsoft Excel program.  

Make sure to report 

i). the values of a and b

  ii) a scatter plot of the data points, and

iii) the R-square or the adjusted R-square 

3. Which of the above two methods is more appropriate? Why ? (3 sentences maximum)