Forum Discussion

Snubbs's avatar
Snubbs
Copper Contributor
Feb 28, 2022

Data Analysis - #NUM! in P-Value

With Excel's Data Analysis Regression option, I'm getting #NUM! for P-values and my t-Stat is the same number as the adjusted R squared.  I'm just trying to predict total revenues. Single items or pair of variables work normally, giving actual results in the regression results. However, 3+ variables gives errors.

 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept13237409065535#NUM!13237409132374091323740913237409
Total U.S. retail units0065535#NUM!0000
Total International retail units2096.081065535#NUM!2096.0812096.0812096.0812096.081
Total U.S. distribution facilities0065535#NUM!0000
Total International distribution facilities0065535#NUM!0000
Total retail units-2217.7065535#NUM!-2217.7-2217.7-2217.7-2217.7
Total distribution facilities-220.96065535#NUM!-220.96-220.96-220.96-220.96
Total properties0065535#NUM!0000

 

 

 

 

Total RevenuesTotal U.S. retail unitsTotal International retail unitsTotal U.S. distribution facilitiesTotal International distribution facilitiesTotal retail unitsTotal distribution facilitiesTotal properties
559151534261011832211144340411847
523964535561461872211150140811909
514405536859931792261136140511766
500343535863601791881171836712085
No RepliesBe the first to reply