May 06 2021 01:12 AM
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 |
May 28 2021 11:28 PM