In this exercise, you will compute the coefficients of the best-fit line, y= a + bx, through three data points in two ways. First using Excel, you will compute the coefficients a and b so that you will know the answer." Then you will compute the same coefficients using "the calculus way" by writing-down the error function, u(a, b). taking its partial derivatives. Du Da Du :0 & = 0, to find where the error function has a minimum. 86 zero, Du da ld 1 2 3 Cost per Unit Qty 490 518 579 Cost 814 827 858 Du & , and setting the derivatives equal to 86 Use Excel to determine the coefficients of the best-fit line, y= a + bx, through the three data points. What is the slope? [round to one decimal place--round to nearest tenth] What is the intercept? [round to nearest integer with no decimals] For the next question, please use the "Data Analysis" toolkit to verify that the Regression function returns the same estimates of the coefficients. a. Launch the Data Analysis Toolkit (Data → Data Analysis) [You will need to activate the FREE Excel Add-In] b. Select "Regression" and push OK. c. For the "Input Y Range:" push the "arrow" button to the right of the input box and select the range, then push the button on the right. d. For the "Input X Range:" push the "arrow" button tot the right of the input box and select the range, then push the button on the right. e. Verify the "Output options"--the default is to put the output on a new worksheet, otherwise specify a cell in the current worksheet where you would like the output to be written. f. *IF* you included labels in your ranges from a & b above, be sure to check the "Labels" box. What is the p-value of the slope of the Qty variable? [round to four decimal places]