About regression analysis in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2330213%22%20slang%3D%22en-US%22%3EAbout%20regression%20analysis%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330213%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Sir%2Fmam%2C%3C%2FP%3E%3CP%3EI%20am%20inserting%20a%20table%20in%20which%2C%20CS%20is%20dependent%20variable%20and%20MSF%20%26amp%3B%20SFRC%20are%20independent%20variables.%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22192%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3ECS%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EMSF%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESFRC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E6.72%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E6.67%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E7.49%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E8.13%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E0.7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E8.89%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E0.7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E7.91%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E0.7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E9.24%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E1.4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E9.78%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E1.4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E9.72%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E1.4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E12.12%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E2.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E12.89%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E2.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E13.93%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E2.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E12.49%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3E2.8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E12.82%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3E2.8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E11.65%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3E2.8%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Ewhen%20I%20applying%20regression%20analysis%20then%20a%20output%20table%20shown%20as%20below%2C%20on%20SFRC%2C%20co-efficient%2C%20standard%20error%2C%20lower%20%26amp%3B%20upper%20are%200%20where%20t%20stat%20is%2065535.%20which%20is%20incorrect.%20Please%20tell%20me%20how%20can%20I%20resolve%20this%20problem%3F%20Please%20give%20the%20suitable%20formula%20with%20steps.%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22448%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ECoefficients%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EStandard%20Error%3C%2FTD%3E%3CTD%20width%3D%2264%22%3Et%20Stat%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EP-value%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ELower%2095%25%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EUpper%2095%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EIntercept%3C%2FTD%3E%3CTD%3E6.952%3C%2FTD%3E%3CTD%3E0.430495%3C%2FTD%3E%3CTD%3E16.14886%3C%2FTD%3E%3CTD%3E5.54E-10%3C%2FTD%3E%3CTD%3E6.021973%3C%2FTD%3E%3CTD%3E7.882027%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EMSF%3C%2FTD%3E%3CTD%3E0.513%3C%2FTD%3E%3CTD%3E0.058583%3C%2FTD%3E%3CTD%3E8.75682%3C%2FTD%3E%3CTD%3E8.2E-07%3C%2FTD%3E%3CTD%3E0.386439%3C%2FTD%3E%3CTD%3E0.639561%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E%3CFONT%20color%3D%22%23FF0000%22%3ESFRC%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E0%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E0%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E65535%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E%23NUM!%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E0%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E0%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2330213%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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