Back to 13.7 How to Use Microsoft Excel® for Regression Analysis

13.7 Exercise 2

Avg difficulty 2.5

An investigator has used a multiple regression program on 20 data points to obtain a regression equation with 3 variables. Part of the computer output is:

Variable	Coefficient	Standard Error of $b_{i}$
1	0.45	0.21
2	0.80	0.10
3	3.10	0.86

0.80 is an estimate of ___________.
0.10 is an estimate of ___________.
Assuming the responses satisfy the normality assumption, we can be 95% confident that the value of $\beta_{2}$ is in the interval,_______ ± [t_.025 ⋅ _______], where t_.025 is the critical value of the student's t-distribution with ____ degrees of freedom.

OpenStax Introductory Business Statistics 2e, 13.7 How to Use Microsoft Excel® for Regression Analysis, exercise 2

AI Tutor

Adapted from Introductory Business Statistics 2e © 2023 Rice University. Licensed under CC BY 4.0. Source: Introductory Business Statistics 2e. Imported at revision 50ec917.