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

13.7 Exercise 1

Avg difficulty 2.5

A computer program for multiple regression has been used to fit y^j=b0+b1⋅X1j+b2⋅X2j+b3⋅X3j\left(\overset{^}{y}\right)_{j} = b_{0} + b_{1} \cdot X_{1 j} + b_{2} \cdot X_{2 j} + b_{3} \cdot X_{3 j}.

Part of the computer output includes:

i bib_{i} SbiS_{b_{i}}
0 8 1.6
1 2.2 .24
2 -.72 .32
3 0.005 0.002
  1. Calculation of confidence interval for b2b_{2} consists of _______± (a student's t value) (_______)
  2. The confidence level for this interval is reflected in the value used for _______.
  3. The degrees of freedom available for estimating the variance are directly concerned with the value used for _______

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

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.