Excel Assingment

by

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)