Question

Excel or Matlab help please

A study was made on the amount of converted sugar in a certain process at various temperatures. The data were coded and recorded as follows: Ambient Temperature Converted Sugar (degrees Centigrade (mg/liter) 21.0 21.1 21.2 18.1 17.8 18.5 19.8 19.5 18.9 18.6 20.2 19.3 19.2 20.5 21.4 21.5 21.6 21.7 21.8 21.9 22.0 (e) Determine and plot the data, the regression line and the 90% confidence interval of the above regression line in the same plot.

Answer 1

Solution

Using Excel

SUMMARY OUTPUT X Variable 1 Line Fit Plot Regression Statistics 21 20.5 20 19.5 19 18.5 18 17.5 Multiple R R Square Adjusted R Square Standard Error Observations 0.707026444 0.499886392 0.444318214 0.632607239 y 1.8091x-19.768 Predicted Y ANOVA Linear (Predicted Y) MS Regression Residual Total 1 3.600090909 3.600091 8.995911 3.601727273 0.400192 7.201818182 20.8 21 212 21.4 21.6 218 22 22.2 X Variable 1 10 Standard Error P-value Lower 90.0% ef 90.0% ients tstat U Intercept X Variable 1 19.7681818212.96950037-1.52421 0.161794 - 1.809090909 0.603167336 2.999318 0.0149730.703417064 2.914764 -43.5427407 4.006377041

here we get

the regression line: y = 1.8091x - 19.768

90% confidence interval for slope: (0.7034, 2.1948)

90% confidence interval for Intercept: (-43.54, 4.00)