WITHOUT USING EXCEL and SHOWING ALL STEP Solve the following

WITHOUT USING EXCEL and SHOWING ALL STEP Solve the problem

The data in the table below were obtained during a colorimetric determination of glucose in blood serum. (Use a spreadsheet to complete this question.) a. Assuming a linear relationship between the variables, find the least-squares estimates of the slope and intercept. Slope = Intercept = b. What are the standard deviations of the slope and intercept? What is the standard error of the estimate? Standard deviation of the slope = Standard deviation of the intercept = Standard error = c. Determine the 95% confidence intervals for the slope and intercept. 95% confidence interval for the slope = 95% confidence interval for the intercept = d. A serum sample gave an absorbance of 0.507 . Find the 95% confidence interval for glucose in the sample. 95% confidence interval for glucose = mM