Compute the values of p-values and confidence intervals for each coefficient? Without using the built-in formulas in
Fantastic news! We've Found the answer you've been seeking!
Question:
Compute the values of p-values and confidence intervals for each coefficient? Without using the built-in formulas in excel like the TDIST or TINV. Please show the formulas with answers.
Here are the values I got using the regression analysis tool in excel:
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept, b0 | -22.99316393 | 17.76254332 | 1.294474756 | 0.2365649717 | -64.99490462 | 19.00857677 |
X Variable 1, b1 | 1.395672916 | 0.5825416624 | 2.395833648 | 0.04775761951 | 0.01818077349 | 2.773165058 |
X Variable 2, b2 | 0.2176134068 | 0.05776696297 | 3.767091008 | 0.007009545529 | 0.08101624519 | 0.3542105683 |
And, here is the data:
x1 | x2 | y |
42 | 272 | 95 |
33 | 226 | 77 |
33 | 259 | 80 |
45 | 292 | 100 |
39 | 311 | 97 |
36 | 183 | 70 |
32 | 173 | 50 |
41 | 236 | 80 |
40 | 230 | 92 |
38 | 235 | 84 |
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date: