Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a Data set as:
Data C1 C2 C3 0.2481 1 0 0 0.9231 1 0 0 1.0361 1 0 0 0.7399 1 0 0 0.9579 1 0 0 0.8665 1 0 0 0.9891 1 0 0 0.9817 1 0 0 0.9013 1 0 0 0.9865 1 0 0 0.9604 0 1 0 0.2267 0 1 0 0.9783 0 1 0 0.9886 0 1 0 0.9921 0 1 0 0.9647 0 1 0 0.9612 0 1 0 0.7114 0 1 0 0.1549 0 1 0 0.9375 0 0 1 0.528 0 0 1 1 0.5488 0 0 1 It gives regression data as: SUMMARY OUTPUT Regression Statistics Multiple R 0.245021818 R Square 0.060035691 Adjusted R Square -0.091539499 Standard Error 0.28257586 Observations 22 ANOVA df SS MS F Significance F Regression 3 0.096899575 0.032299858 0.606766727 .6191 Residual 19 1.517133218 0.079849117 Total 22 1.614032793 Coefficients Standard Error t Stat P-value Intercept 0.770 0.0941 8.184 1.19234E-07 X Variable 1 0.09 0.129 0.7093 0.486 X Variable 2 0 0 65535 #NUM! X Variable 3 -0.099 0.18 -0.5281 #NUM! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Whats wrong with this!!!!! | Excel Programming | |||
Whats Wrong With This | Excel Programming | |||
Whats wrong with this? | Excel Programming | |||
Whats wrong with this? | Excel Discussion (Misc queries) | |||
Whats wrong? | Excel Programming |