Forum Discussion
About regression analysis in excel
Dear Sir/mam,
I am inserting a table in which, CS is dependent variable and MSF & SFRC are independent variables.
| CS | MSF | SFRC |
| 6.72 | 0 | 0 |
| 6.67 | 0 | 0 |
| 7.49 | 0 | 0 |
| 8.13 | 3 | 0.7 |
| 8.89 | 3 | 0.7 |
| 7.91 | 3 | 0.7 |
| 9.24 | 6 | 1.4 |
| 9.78 | 6 | 1.4 |
| 9.72 | 6 | 1.4 |
| 12.12 | 9 | 2.1 |
| 12.89 | 9 | 2.1 |
| 13.93 | 9 | 2.1 |
| 12.49 | 12 | 2.8 |
| 12.82 | 12 | 2.8 |
| 11.65 | 12 | 2.8 |
when I applying regression analysis then a output table shown as below, on SFRC, co-efficient, standard error, lower & upper are 0 where t stat is 65535. which is incorrect. Please tell me how can I resolve this problem? Please give the suitable formula with steps.
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | 6.952 | 0.430495 | 16.14886 | 5.54E-10 | 6.021973 | 7.882027 |
| MSF | 0.513 | 0.058583 | 8.75682 | 8.2E-07 | 0.386439 | 0.639561 |
| SFRC | 0 | 0 | 65535 | #NUM! | 0 | 0 |
1 Reply
- What that tells you is the MSF and SFRC are *not* independent, which is true since SFRC = MSF * 0.7/3
