11 Using Microsoft Excel or Minitab or R find the least squa

11. Using Microsoft Excel (or Minitab or R), find the least squares estimate of the regression line for the following set of ten (10) x, y data points. Include the output as identified below.

Y: 2 2 1 1 3 4 5 5 7 6

X: 3 1 1 3 5 4 7 6 7 8

A. The regression estimates including coefficients, SE, t-stats and p-values.

B. ANOVA output

C. The 90% confidence intervals for X = 3.

Regression output
variables	coefficients	std. error	t (df=8)	p-value
Intercept	0.1752	0.6631	0.264	.7983
X	0.7611	0.1303	5.841	.0004

11. Using Microsoft Excel (or Minitab or R), find the least squares estimate of the regression line for the following set of ten (10) x, y data points. Include

11 Using Microsoft Excel or Minitab or R find the least squa

Solution

Get Help Now

Submit a Take Down Notice