View Single Post
  #1   Report Post  
ShriHanuman ShriHanuman is offline
Junior Member
 
Posts: 1
Default Regressions p-value is #NUM! whats wrong

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!