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.

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	13237409	0	65535	#NUM!	13237409	13237409	13237409	13237409
Total U.S. retail units	0	0	65535	#NUM!	0	0	0	0
Total International retail units	2096.081	0	65535	#NUM!	2096.081	2096.081	2096.081	2096.081
Total U.S. distribution facilities	0	0	65535	#NUM!	0	0	0	0
Total International distribution facilities	0	0	65535	#NUM!	0	0	0	0
Total retail units	-2217.7	0	65535	#NUM!	-2217.7	-2217.7	-2217.7	-2217.7
Total distribution facilities	-220.96	0	65535	#NUM!	-220.96	-220.96	-220.96	-220.96
Total properties	0	0	65535	#NUM!	0	0	0	0

Total Revenues	Total U.S. retail units	Total International retail units	Total U.S. distribution facilities	Total International distribution facilities	Total retail units	Total distribution facilities	Total properties
559151	5342	6101	183	221	11443	404	11847
523964	5355	6146	187	221	11501	408	11909
514405	5368	5993	179	226	11361	405	11766
500343	5358	6360	179	188	11718	367	12085

excel

Forum Discussion

Data Analysis - #NUM! in P-Value

Resources