A Question on Percentages

Hello. Whenever I put in code for regressions, I get coefficients for individual percentages rather than the whole category.

Residuals:
       Min         1Q     Median         3Q        Max 
-688164406          0          0          0  623689540 

Coefficients: (5 not defined because of singularities)
                                      Estimate Std. Error t value Pr(>|t|)    
(Intercept)                         -2.951e+08  5.417e+08  -0.545  0.59193    
CorruptionNone0.01                   2.514e+08  4.727e+08   0.532  0.60066    
CorruptionNone0.04                  -2.817e+06  3.481e+08  -0.008  0.99362    
CorruptionNone0.05                   7.118e+08  6.661e+08   1.069  0.29795    
CorruptionNone0.06                   3.988e+07  5.243e+08   0.076  0.94012    
CorruptionNone0.1                    2.696e+08  3.894e+08   0.692  0.49669    
CorruptionNone0.1003                 2.858e+08  5.435e+08   0.526  0.60478    
CorruptionNone0.1012                 3.690e+08  6.439e+08   0.573  0.57299    
CorruptionNone0.10289999999999999    3.864e+08  4.839e+08   0.799  0.43389    
CorruptionNone0.10310000000000001   -1.016e+09  6.438e+08  -1.578  0.13028    
CorruptionNone0.1032                 9.240e+07  6.867e+08   0.135  0.89432    
CorruptionNone0.10400000000000001   -1.035e+08  4.153e+08  -0.249  0.80569    
CorruptionNone0.1045                -9.767e+07  6.461e+08  -0.151  0.88136    
CorruptionNone0.10679999999999999    2.601e+07  5.474e+08   0.048  0.96258    
CorruptionNone0.1069                 3.670e+08  6.404e+08   0.573  0.57304    
CorruptionNone0.1072                -6.694e+08  4.649e+08  -1.440  0.16537    
CorruptionNone0.1082                 2.014e+08  5.661e+08   0.356  0.72570    
CorruptionNone0.1084                 4.035e+07  5.728e+08   0.070  0.94454    
CorruptionNone0.10970000000000001    7.206e+08  6.744e+08   1.069  0.29800    
CorruptionNone0.10980000000000001    3.599e+08  9.553e+08   0.377  0.71035    
CorruptionNone0.11109999999999999    2.599e+08  6.867e+08   0.378  0.70910    
CorruptionNone0.1114                 7.976e+06  6.270e+08   0.013  0.98998    
CorruptionNone0.1116                 7.983e+07  6.424e+08   0.124  0.90234    
CorruptionNone0.1119                -1.256e+08  6.432e+08  -0.195  0.84710    
CorruptionNone0.11210000000000001    5.010e+08  5.233e+08   0.957  0.34981    
CorruptionNone0.11289999999999999    1.783e+08  5.419e+08   0.329  0.74550    
CorruptionNone0.1137                 1.251e+09  9.568e+08   1.307  0.20592    
CorruptionNone0.1158                 2.862e+08  5.723e+08   0.500  0.62247    
CorruptionNone0.11599999999999999    5.595e+08  5.196e+08   1.077  0.29434    
CorruptionNone0.11630000000000001    6.860e+08  6.048e+08   1.134  0.27014    
CorruptionNone0.1173                 3.436e+08  7.276e+08   0.472  0.64191    
CorruptionNone0.1188                 9.033e+07  4.954e+08   0.182  0.85715    
CorruptionNone0.1198                -8.262e+08  5.085e+08  -1.625  0.11984    
CorruptionNone0.1201                 3.302e+08  6.404e+08   0.516  0.61180    
CorruptionNone0.12139999999999999    3.411e+08  5.261e+08   0.648  0.52413    
CorruptionNone0.1217                 1.711e+08  6.100e+08   0.280  0.78199    
CorruptionNone0.12179999999999999    4.270e+08  7.291e+08   0.586  0.56461    
CorruptionNone0.12240000000000001    3.260e+08  5.927e+08   0.550  0.58836    
CorruptionNone0.123                  2.572e+08  4.631e+08   0.555  0.58472    
CorruptionNone0.12300000000000001    2.774e+08  6.432e+08   0.431  0.67092    
CorruptionNone0.1241                 1.481e+08  6.019e+08   0.246  0.80811    
CorruptionNone0.12480000000000001    3.667e+08  3.899e+08   0.940  0.35821    
CorruptionNone0.12529999999999999    4.115e+08  6.439e+08   0.639  0.52999    
CorruptionNone0.1273                 2.304e+07  4.622e+08   0.050  0.96073    
CorruptionNone0.12839999999999999    1.840e+08  5.374e+08   0.342  0.73557    
CorruptionNone0.12859999999999999    2.951e+08  6.183e+08   0.477  0.63835    
CorruptionNone0.1288                 4.614e+08  5.827e+08   0.792  0.43781    
CorruptionNone0.12909999999999999    2.957e+08  5.923e+08   0.499  0.62306    
CorruptionNone0.13059999999999999    1.384e+08  6.424e+08   0.215  0.83163    
CorruptionNone0.1318                -8.121e+08  5.943e+08  -1.366  0.18698    
CorruptionNone0.1333                 1.330e+08  3.428e+08   0.388  0.70209    
CorruptionNone0.1343                 1.594e+08  6.100e+08   0.261  0.79651    
CorruptionNone0.1346                 1.189e+07  5.388e+08   0.022  0.98261    
CorruptionNone0.13500000000000001   -2.945e+08  5.619e+08  -0.524  0.60603    
CorruptionNone0.1363                -1.106e+09  6.628e+08  -1.669  0.11078    
CorruptionNone0.1381                 3.477e+08  5.517e+08   0.630  0.53566    
CorruptionNone0.13830000000000001    3.599e+07  5.420e+08   0.066  0.94772    
CorruptionNone0.1389                 3.277e+08  7.276e+08   0.450  0.65725    
CorruptionNone0.1391                 8.320e+08  7.058e+08   1.179  0.25235    
CorruptionNone0.13980000000000001    2.602e+08  5.924e+08   0.439  0.66521    
CorruptionNone0.14000000000000001    2.689e+08  5.114e+08   0.526  0.60486    
CorruptionNone0.1401                 1.862e+08  6.904e+08   0.270  0.79012    
CorruptionNone0.14219999999999999    3.660e+07  4.985e+08   0.073  0.94221    
CorruptionNone0.14249999999999999    1.720e+08  4.675e+08   0.368  0.71690    
CorruptionNone0.14319999999999999    6.808e+08  6.597e+08   1.032  0.31445    
CorruptionNone0.14410000000000001    2.036e+08  5.620e+08   0.362  0.72102    
CorruptionNone0.1447                 3.826e+08  5.440e+08   0.703  0.48995    
CorruptionNone0.14480000000000001   -5.908e+08  5.203e+08  -1.136  0.26958    
CorruptionNone0.14550000000000002   -1.248e+08  5.304e+08  -0.235  0.81634    
CorruptionNone0.14560000000000001   -6.800e+07  5.690e+08  -0.120  0.90606    
CorruptionNone0.14599999999999999    4.295e+08  6.411e+08   0.670  0.51059    
CorruptionNone0.1479                 9.039e+08  5.017e+08   1.802  0.08668 .  
CorruptionNone0.14800000000000002    5.177e+08  9.506e+08   0.545  0.59202    
CorruptionNone0.1492                 1.655e+08  5.821e+08   0.284  0.77908    
CorruptionNone0.15                   3.212e+08  6.986e+08   0.460  0.65066    
CorruptionNone0.1502                 5.761e+08  8.857e+08   0.650  0.52278    
CorruptionNone0.1512                -1.271e+09  6.963e+08  -1.825  0.08299 .  
CorruptionNone0.1517                 4.475e+08  9.639e+08   0.464  0.64746    
CorruptionNone0.15259999999999999    7.206e+08  7.540e+08   0.956  0.35066    
CorruptionNone0.15329999999999999    3.436e+08  7.276e+08   0.472  0.64191    
CorruptionNone0.1535                 7.181e+08  6.977e+08   1.029  0.31565    
CorruptionNone0.15429999999999999    5.642e+08  5.787e+08   0.975  0.34121    
CorruptionNone0.15479999999999999   -1.155e+09  5.942e+08  -1.943  0.06621 .  
CorruptionNone0.15620000000000001    2.388e+08  6.944e+08   0.344  0.73451    
CorruptionNone0.15640000000000001    1.307e+08  6.019e+08   0.217  0.83027    
CorruptionNone0.1585                 2.766e+08  5.745e+08   0.481  0.63540    
CorruptionNone0.15939999999999999    5.450e+08  6.460e+08   0.844  0.40882    
CorruptionNone0.15989999999999999    7.642e+08  7.391e+08   1.034  0.31347    
CorruptionNone0.16                   3.212e+08  6.986e+08   0.460  0.65066    
CorruptionNone0.161                 -5.634e+08  6.439e+08  -0.875  0.39199    
CorruptionNone0.1618                 6.402e+08  6.581e+08   0.973  0.34228    
CorruptionNone0.16200000000000001    9.642e+07  6.211e+08   0.155  0.87819    
CorruptionNone0.16250000000000001    2.049e+08  4.626e+08   0.443  0.66256    
CorruptionNone0.16329999999999997   -8.603e+06  4.231e+08  -0.020  0.98398    
CorruptionNone0.16350000000000001   -7.448e+08  4.326e+08  -1.722  0.10058    
CorruptionNone0.1641                 6.128e+08  5.074e+08   1.208  0.24128    
CorruptionNone0.16739999999999999   -5.558e+08  4.643e+08  -1.197  0.24527    
CorruptionNone0.16819999999999999    2.951e+08  6.183e+08   0.477  0.63835    
CorruptionNone0.16980000000000001    1.662e+08  6.676e+08   0.249  0.80595    
CorruptionNone0.17                   1.208e+08  4.369e+08   0.277  0.78495    
CorruptionNone0.17120000000000002    9.065e+07  5.750e+08   0.158  0.87631    
CorruptionNone0.1714                 2.183e+08  4.533e+08   0.482  0.63529    
CorruptionNone0.17489999999999997   -1.899e+08  5.842e+08  -0.325  0.74857    
CorruptionNone0.17679999999999998    8.972e+07  5.276e+08   0.170  0.86667    
CorruptionNone0.17749999999999999    4.176e+08  6.070e+08   0.688  0.49934    
CorruptionNone0.1782                 3.272e+08  6.986e+08   0.468  0.64454    
CorruptionNone0.17899999999999999   -8.547e+07  6.021e+08  -0.142  0.88855    
CorruptionNone0.17929999999999999   -1.066e+09  6.416e+08  -1.662  0.11208    
CorruptionNone0.18                   5.410e+08  9.289e+08   0.582  0.56678    
CorruptionNone0.1802                 3.531e+08  6.852e+08   0.515  0.61193    
CorruptionNone0.1804                -1.319e+09  6.482e+08  -2.035  0.05527 .  
CorruptionNone0.18260000000000001    7.028e+08  5.631e+08   1.248  0.22644    
CorruptionNone0.1827                 1.817e+09  1.040e+09   1.748  0.09585 .  
CorruptionNone0.18390000000000001    4.091e+08  8.407e+08   0.487  0.63178    
CorruptionNone0.18420000000000003   -1.165e+08  5.357e+08  -0.218  0.83001    
CorruptionNone0.1855                 4.214e+08  5.999e+08   0.702  0.49051    
CorruptionNone0.189                  1.083e+08  5.355e+08   0.202  0.84177    
CorruptionNone0.19                  -5.395e+08  4.756e+08  -1.134  0.27004    
CorruptionNone0.19010000000000002    3.067e+08  6.953e+08   0.441  0.66385    
CorruptionNone0.1908                 5.880e+08  9.733e+08   0.604  0.55259    
CorruptionNone0.19159999999999999    6.271e+08  6.691e+08   0.937  0.35985    
CorruptionNone0.19189999999999999    6.923e+08  5.157e+08   1.342  0.19450    
CorruptionNone0.19420000000000001    1.758e+08  6.100e+08   0.288  0.77612    
CorruptionNone0.19439999999999999    1.303e+08  6.019e+08   0.216  0.83084    
CorruptionNone0.19520000000000001    2.409e+08  4.325e+08   0.557  0.58380    
CorruptionNone0.19620000000000001    3.215e+08  6.986e+08   0.460  0.65039    
CorruptionNone0.1971                 1.922e+08  6.424e+08   0.299  0.76787    
CorruptionNone0.19800000000000001    6.855e+08  6.357e+08   1.078  0.29374    
CorruptionNone0.19939999999999999   -1.115e+09  6.549e+08  -1.702  0.10427    
CorruptionNone0.2                    2.951e+08  6.183e+08   0.477  0.63835    
CorruptionNone0.20100000000000001    5.737e+08  9.177e+08   0.625  0.53893    
CorruptionNone0.2014                -5.885e+08  5.308e+08  -1.109  0.28068    
CorruptionNone0.20180000000000001    9.743e+07  4.163e+08   0.234  0.81732    
CorruptionNone0.20219999999999999   -4.892e+08  6.439e+08  -0.760  0.45628    
CorruptionNone0.20370000000000002   -6.931e+08  5.835e+08  -1.188  0.24887    
CorruptionNone0.20519999999999999   -2.437e+08  6.867e+08  -0.355  0.72643    
CorruptionNone0.2054                 6.255e+08  7.377e+08   0.848  0.40649    
CorruptionNone0.2077                 5.763e+08  9.983e+08   0.577  0.57022    
CorruptionNone0.2087                 6.320e+08  7.115e+08   0.888  0.38499    
CorruptionNone0.21                   1.735e+08  5.077e+08   0.342  0.73608    
CorruptionNone0.21059999999999998    9.868e+06  6.432e+08   0.015  0.98791    
CorruptionNone0.21210000000000001   -1.876e+08  4.245e+08  -0.442  0.66321    
CorruptionNone0.21260000000000001   -7.323e+08  4.805e+08  -1.524  0.14317    
CorruptionNone0.21490000000000001    2.727e+08  6.423e+08   0.425  0.67570    
CorruptionNone0.2162                 3.173e+08  5.642e+08   0.562  0.58009    
CorruptionNone0.218                  1.898e+08  6.402e+08   0.297  0.76990    
CorruptionNone0.21820000000000001   -8.711e+07  6.847e+08  -0.127  0.90003    
CorruptionNone0.22120000000000001    1.454e+06  4.676e+08   0.003  0.99755    
CorruptionNone0.222                 -1.730e+08  5.558e+08  -0.311  0.75875    
CorruptionNone0.22219999999999998    3.537e+08  7.989e+08   0.443  0.66269    
CorruptionNone0.2248                 8.466e+08  9.551e+08   0.886  0.38595    
CorruptionNone0.22579999999999997   -1.047e+08  6.422e+08  -0.163  0.87213    
CorruptionNone0.22889999999999999    2.394e+08  6.423e+08   0.373  0.71333    
CorruptionNone0.2291                -3.208e+08  5.725e+08  -0.560  0.58149    
CorruptionNone0.23300000000000001    4.827e+08  6.418e+08   0.752  0.46072    
CorruptionNone0.2336                 2.620e+08  4.829e+08   0.542  0.59353    
CorruptionNone0.23380000000000001    4.412e+08  9.795e+08   0.450  0.65728    
CorruptionNone0.2366                -1.273e+08  5.944e+08  -0.214  0.83262    
CorruptionNone0.23719999999999999    2.701e+08  6.423e+08   0.421  0.67857    
CorruptionNone0.23860000000000001    1.037e+09  6.904e+08   1.501  0.14890    
CorruptionNone0.24                   1.643e+08  4.973e+08   0.330  0.74449    
CorruptionNone0.24030000000000001    5.921e+08  7.004e+08   0.845  0.40790    
CorruptionNone0.24179999999999999   -6.842e+08  4.559e+08  -1.501  0.14907    
CorruptionNone0.2467                -1.161e+09  6.355e+08  -1.826  0.08280 .  
CorruptionNone0.249                  3.277e+08  7.276e+08   0.450  0.65725    
CorruptionNone0.25030000000000002    5.503e+08  6.865e+08   0.802  0.43219    
CorruptionNone0.25059999999999999    8.220e+08  6.244e+08   1.316  0.20295    
CorruptionNone0.25090000000000001    5.775e+08  7.640e+08   0.756  0.45857    
CorruptionNone0.25109999999999999    3.277e+08  7.276e+08   0.450  0.65725    
CorruptionNone0.25159999999999999    5.377e+08  6.708e+08   0.801  0.43229    
CorruptionNone0.2525                 5.713e+08  8.067e+08   0.708  0.48702    
CorruptionNone0.25440000000000002    7.228e+08  7.035e+08   1.027  0.31646    
CorruptionNone0.25679999999999997    7.556e+08  8.140e+08   0.928  0.36438    
CorruptionNone0.25719999999999998    8.313e+07  5.878e+08   0.141  0.88894    
CorruptionNone0.25929999999999997   -3.021e+08  5.721e+08  -0.528  0.60333    
CorruptionNone0.26                  -1.102e+09  5.690e+08  -1.937  0.06703 .  
CorruptionNone0.26219999999999999    1.817e+08  6.100e+08   0.298  0.76891    
CorruptionNone0.26390000000000002    2.587e+08  6.134e+08   0.422  0.67770    
CorruptionNone0.26500000000000001    3.560e+08  5.281e+08   0.674  0.50801    
CorruptionNone0.26519999999999999    2.247e+08  6.904e+08   0.325  0.74823    
CorruptionNone0.26619999999999999   -2.189e+08  5.620e+08  -0.389  0.70104    
CorruptionNone0.26679999999999998   -7.747e+08  6.439e+08  -1.203  0.24296    
CorruptionNone0.2697                 6.480e+08  6.006e+08   1.079  0.29347    
CorruptionNone0.27029999999999998    3.088e+08  6.918e+08   0.446  0.66009    
CorruptionNone0.27560000000000001    2.764e+07  6.185e+08   0.045  0.96480    
CorruptionNone0.2762                 1.480e+08  5.117e+08   0.289  0.77536    
CorruptionNone0.27750000000000002    2.085e+08  6.944e+08   0.300  0.76704    
CorruptionNone0.27839999999999998   -2.814e+08  5.614e+08  -0.501  0.62168    
CorruptionNone0.27860000000000001    7.425e+08  5.796e+08   1.281  0.21486    
CorruptionNone0.27879999999999999    3.433e+08  6.852e+08   0.501  0.62186    
CorruptionNone0.27989999999999998    3.101e+08  6.558e+08   0.473  0.64145    
CorruptionNone0.2828                 1.409e+08  5.702e+08   0.247  0.80732    
CorruptionNone0.28570000000000001    6.220e+08  5.844e+08   1.064  0.29993    
CorruptionNone0.29089999999999999    2.529e+08  6.852e+08   0.369  0.71591    
CorruptionNone0.29380000000000001    2.701e+08  5.368e+08   0.503  0.62042    
CorruptionNone0.2944                 3.491e+07  6.123e+08   0.057  0.95510    
CorruptionNone0.29630000000000001    1.454e+08  6.019e+08   0.242  0.81162    
CorruptionNone0.29770000000000002    1.252e+09  9.269e+08   1.351  0.19176    
CorruptionNone0.3                    1.116e+08  5.678e+08   0.197  0.84620    
CorruptionNone0.3019                -9.797e+07  4.883e+08  -0.201  0.84303    
 [ reached getOption("max.print") -- omitted 261 rows ]
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 298200000 on 20 degrees of freedom
Multiple R-squared:  0.9952,	Adjusted R-squared:  0.8867 
F-statistic:  9.17 on 455 and 20 DF,  p-value: 2.85e-07

Hi,

It would help if you share a reproducible example. My guess is your percentage variable is either a character or a factor and you need to make it a number. Your data is quite large so you can't share it all but share the output of the following in a code chunk dput(head(data,20)) - this will show us the first 20 rows.

Thanks for the advice. Although I should confess that I now know what happened. I simply had that category as a character rather than numeric.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.