Excel Assingment

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)