summary showing 0's instead of actual values

Hi ,

I'm sharing a vector that is a column in my dataframe called 'hos.per.1thou' that should = 'hospitals' / 'population'*1000

As you can see, there are lots of numbers ranging in 'hos.per.1thou' from 0 to 7.1

but R is not recognizing the values in the column.

The column 'hospitals' which I can't include because of space, acts normally when I use summary() and when I include in an equation

summary(data$hos.per.1thou)
   Min. 1st Qu.  Median    Mean 3rd Qu.    Max.    NA's 
      0       0       0       0       0       0      33 

It's also throwing off results when I use this in a regresssion for some reason. Has anyone ever encountered this?

Thank you!!

dput(data$hos.per.1thou)
c(0, 3.62320809714546e-09, 4.7343104950195e-09, 1.81656342531199e-08, 
5.01228008621122e-09, 0, 0, 0, 9.47687642153146e-08, 4.93096646942801e-08, 
8.62939343993511e-09, 2.93962020107002e-08, 0, 0, 0, 0, 7.41674701475933e-08, 
0, 1.96113039556e-08, 3.67802563583868e-08, 0, 0, 7.95144318693843e-08, 
7.19631548647093e-08, 0, 0, 0, 0, 2.47044727447904e-08, 5.28052805280528e-08, 
0, 0, 6.33452633579324e-08, 0, 1.16455106556423e-07, 6.59674120984234e-08, 
0, 9.62547285135382e-09, 0, 6.06891864007671e-09, 0, 1.07943567103118e-08, 
0, 0, 1.10794730602613e-08, 0, 0, 2.85736328231035e-09, 0, 0, 
0, 2.41376230717056e-09, 4.55062571103527e-08, 1.06220097145866e-08, 
4.39769209119054e-09, 8.36435113546067e-09, 0, 0, 0, 0, 1.70543693294222e-08, 
0, 0, 7.52728641324802e-08, 0, 2.4415254651106e-08, 0, 0, 5.91401029037791e-08, 
8.99361453368109e-08, 4.16441094407196e-08, 0, 3.6613942589338e-08, 
0, 0, 1.78353900510627e-09, 3.75580808893754e-09, 0, 5.89476662618927e-09, 
7.11981944137897e-09, 0, 2.87161580077878e-09, 0, 2.84624580178744e-08, 
0, 2.22002686232503e-09, 9.69073630214424e-09, 9.71656771961872e-09, 
0, 0, 0, 0, 0, 0, 3.662735330745e-08, 0, 1.1312409147214e-08, 
1.01151099512452e-08, 6.80241773042623e-09, 5.11012315396801e-08, 
6.88032365042452e-09, 4.10500605488393e-08, 0, 0, 6.29750681705113e-09, 
2.93698694509303e-09, 0, 2.51844762888156e-08, 0, 0, 2.82956670844993e-09, 
0, 0, 6.38038025565058e-09, 2.59235255994815e-08, 0, 0, 2.53678335870117e-08, 
7.96143480978142e-10, 0, 2.85968184609621e-09, 6.1436382625791e-09, 
9.57907419312265e-09, 1.56815761865857e-09, 0, 4.57955138714611e-09, 
0, 1.22023391884224e-08, 7.53748011989618e-09, 2.2578205258464e-09, 
8.80366936939316e-09, 0, 4.42830573022761e-08, 0, 5.87307118553815e-09, 
0, 3.25055259394097e-08, 4.06058391196654e-08, 5.43183052688756e-08, 
0, 8.88809883565905e-08, 0, 0, 0, 0, 0, 0, 5.26703887074687e-08, 
6.4853366538257e-09, 7.79119594857811e-08, 0, 6.39181847235539e-08, 
0, 0, 0, 4.25912517568891e-08, 0, 0, 9.12242291552636e-08, 0, 
0, 7.71128932757557e-08, 7.07681529158248e-09, 0, 0, 4.33596815664986e-09, 
8.19423617427502e-09, 0, 0, 1.46756677428823e-07, 4.11868399808893e-09, 
0, 2.17381852962915e-08, 0, 5.84692743963047e-08, 7.37327188940092e-09, 
0, 0, 0, 0, 3.67147630062048e-08, 2.76280491005689e-09, 4.76303881876637e-08, 
0, 1.08311851482789e-08, 7.23154690019742e-09, 9.54198473282443e-08, 
0, 1.79044617918785e-08, 5.1562338867691e-08, 0, 9.31705953601044e-08, 
4.16371736686514e-08, 9.13283711585004e-09, 0, 4.9057844103983e-09, 
4.50694068866054e-08, 7.02277485886731e-09, 0, 0, 0, 1.78319870183135e-08, 
3.9769337840525e-08, 0, 0, 0, 0, 0, 3.48833153102871e-08, 0, 
3.91880241398229e-08, 0, 0, 6.7052441714665e-09, 1.06780565936999e-07, 
0, 7.36865374696043e-08, 6.68762121313449e-08, 6.17245849021665e-08, 
0, 0, 0, 0, 9.63205548063957e-08, 2.0919626793858e-08, 0, 0, 
0, 0, 8.77978542204428e-09, 3.21605454428507e-08, 0, 0, 7.22230247002744e-08, 
0, 0, 0, 1.69176112332939e-07, 0, 3.69767785830498e-08, 0, 0, 
0, 1.49773093762949e-08, 0, 0, 0, 6.67423079490089e-09, 0, 3.33422245932249e-08, 
0, 0, 0, 8.7260034904014e-08, 4.70389011712686e-08, 0, 0, 0, 
1.98591982841653e-08, 0, 0, 0, 1.14995400183993e-07, 0, 3.90869293308318e-08, 
0, 0, 0, 0, 0, 0, 0, 0, 2.22335860550948e-08, 0, 0, 0, 0, 0, 
0, 0, 4.53864657559116e-08, 0, 0, 0, 0, 0, 0, 3.33266679997334e-08, 
0, 0, 0, 0, 0, 1.00765820233777e-07, 0, 0, NA, NA, NA, NA, NA, 
2.34853146327601e-09, 0, 0, 0, 0, 2.20940765780694e-08, 0, 0, 
2.41610089637343e-08, 9.17523786804173e-09, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6.76974735302878e-09, 0, 0, 
0, 0, 2.62370782389673e-08, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
1.49367428938446e-08, 0, 5.83532707008228e-08, 0, 0, 5.91331086275205e-08, 
0, 0, 0, 4.84449181280884e-09, 5.90179414542021e-08, 0, 7.42611020347542e-08, 
2.6414496275556e-08, 0, 6.8865582990201e-09, 5.14376832467466e-08, 
0, 1.91464512052691e-08, 6.1267001592942e-08, 0, 5.37337428560989e-09, 
5.60915413955576e-08, 0, 2.91069973221562e-08, 0, 7.26849832824538e-08, 
0, 2.77415596304824e-08, 0, 7.46825989544436e-08, 1.98657078151695e-08, 
1.21197430614471e-07, 0, 2.39635753654445e-07, 0, 4.02568386304623e-08, 
3.47053515652114e-08, 3.37906332364668e-08, 0, 2.59585182877761e-08, 
4.45612940599795e-08, 0, 0, 7.59568185486551e-09, 8.96917295256204e-09, 
0, 1.93229247178853e-08, 1.42269771941556e-09, 3.57350247911735e-08, 
6.0306356289953e-08, 2.88035025059047e-08, 2.68254734696067e-08, 
3.35345405767941e-08, 3.1518895577899e-08, 3.25644858230511e-09, 
0, 1.84495037083502e-08, 4.30274084591885e-08, 1.12461060357851e-08, 
5.19440043632964e-08, 0, 7.17823558969205e-08, 0, 0, 0, 0, 6.82570560731716e-08, 
2.87348064710784e-08, 0, 1.92182034823385e-08, 5.35280326306887e-09, 
9.26140310257004e-08, 6.07201408707268e-08, 6.22897720194344e-08, 
0, 0, 0, 9.10912734560029e-08, 6.22200099552016e-08, 0, 1.50619989531911e-08, 
4.05531448963867e-08, 5.03425812655118e-09, 1.38792505204719e-07, 
0, 4.54318295397756e-08, 0, 2.16062053021628e-08, 7.38552437223043e-09, 
5.72803299347004e-08, 1.25607626895105e-08, 8.63036161215155e-08, 
0, 0, 6.05436822667555e-08, 0, 0, 2.91809775043844e-09, 1.48508969941784e-08, 
6.92290651307045e-09, 2.5560412033842e-08, 2.8724901617212e-08, 
1.64129498174059e-08, 1.2468361532611e-08, 0, 8.08799741184083e-08, 
0, 0, 0, 2.60933096753992e-08, 1.75449369698139e-08, 3.76392652815417e-08, 
3.05885231861006e-08, 0, 3.06908510572998e-08, 2.01808201485308e-08, 
3.79650721336371e-08
)

I think you're missing that the values have "e-08" at the end. This means they are very small numbers. For example, 3.79650721336371e-08=0.0000000379650721336371 The maximum value is 2.396358e-07

So the summary function rounds this quite a bit and it all rounds to 0. I tried adjusting the digits with no luck to get it to print out.

max(hos.per.1thou, na.rm = TRUE)
#> [1] 2.396358e-07

Created on 2020-08-04 by the reprex package (v0.3.0)

2 Likes

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