About regression analysis in excel

Copper Contributor

Dear Sir/mam,

I am inserting a table in which, CS is dependent variable and MSF & SFRC are independent variables.

CSMSFSFRC
6.7200
6.6700
7.4900
8.1330.7
8.8930.7
7.9130.7
9.2461.4
9.7861.4
9.7261.4
12.1292.1
12.8992.1
13.9392.1
12.49122.8
12.82122.8
11.65122.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.

 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%
Intercept6.9520.43049516.148865.54E-106.0219737.882027
MSF0.5130.0585838.756828.2E-070.3864390.639561
SFRC0065535#NUM!00
1 Reply
What that tells you is the MSF and SFRC are *not* independent, which is true since SFRC = MSF * 0.7/3