Fit two predictors and inspect the residuals
Enter separate formulas in G2:G8. Fit measured Y in D2:D9 against both X1 and X2 in B2:C9 with an intercept. G2 is the X1 coefficient, G3 the X2 coefficient and G4 the intercept. G5 estimates Y at B12:C12. G6 is training R-squared, G7 residual standard error with five degrees of freedom, and G8 the sum of squared differences between all eight measured and fitted responses. Keep computed values unrounded.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter separate formulas in G2:G8. Fit measured Y in D2:D9 against both X1 and X2 in B2:C9 with an intercept. G2 is the X1 coefficient, G3 the X2 coefficient and G4 the intercept. G5 estimates Y at B12:C12. G6 is training R-squared, G7 residual standard error with five degrees of freedom, and G8 the sum of squared differences between all eight measured and fitted responses. Keep computed values unrounded.
No account. No upload. Just try it.