- #1

stunner5000pt

- 1,455

- 2

- Homework Statement:
- Determine if the intercept term is relevant

- Relevant Equations:
- No equations, only interpretation

Hello all, need your help with interpreting regression reuslts

The results are given below for hte regression that I ran in Excel

Here, the dependant variable Pc is -63.28 with a standard error of 15.86.

But is this different from zero? I see the t-stat here is -3.99, and the p-value is 0.000215. In absolute value terms t > p, and thus Pc is different from zero.

But is this correct - should we use the absolute value of the t-stat? Or should we reject Pc since -3.99 < p value?

The results are given below for hte regression that I ran in Excel

Here, the dependant variable Pc is -63.28 with a standard error of 15.86.

But is this different from zero? I see the t-stat here is -3.99, and the p-value is 0.000215. In absolute value terms t > p, and thus Pc is different from zero.

But is this correct - should we use the absolute value of the t-stat? Or should we reject Pc since -3.99 < p value?

Summary Output | ||||||||

Regression Statistics | ||||||||

Multiple R | 0.491468698 | |||||||

R Square | 0.241541481 | |||||||

Adjusted R Square | 0.226372311 | |||||||

Standard Error | 90.29795564 | |||||||

Observations | 52 | |||||||

ANOVA | ||||||||

| df | SS | MS | F | Significance F | |||

Regression | 1 | 129833.1911 | 129833.1911 | 15.92318335 | 0.000216 | |||

Residual | 50 | 407686.0396 | 8153.720793 | |||||

Total | 51 | 537519.2308 | ||||||

| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |

Intercept | 2135.576773 | 457.8577755 | 4.6642798 | 2.34319E-05 | 1215.942 | 3055.211 | 1215.942 | 3055.211 |

Pc | -63.28227342 | 15.85868325 | -3.990386366 | 0.000215714 | -95.1354 | -31.4292 | -95.1354 | -31.4292 |