Mass Analysis

MattG

MattG
So I was messing with EDDB data the other day and figured someone else might find this useful. I worked out the mean / median and various percentiles of the masses for each type of body. If you plugged these numbers into the Exploration Value Formula, you'd get some pretty accurate valuation figures...

I split the data between curated and non-curated - this is the non-curated data because I think it's more useful. If anyone wants the data on curated systems too, I can post it.

Planets:
Planet TypeTerraformable?Num SamplesMean2nd Percentile5th Percentile10th Percentile20th PercentileMedian80th Percentile90th Percentile95th Percentile98th Percentile
Ammonia World112954.3973250.1086060.1360410.1757920.2375670.439144.55265310.2385618.71069136.633416
Earth-like World143500.7958940.2513450.2702320.295280.3346550.4980391.2736281.7257792.0787872.36062
Water World559741.9776280.1596910.1840120.2191390.2927430.7806382.7991734.6754056.8672810.248024
Water WorldYes554610.700250.1301410.1444870.1681680.2201330.4530111.1092481.630032.1096422.564254
High Metal Content Planet5748701.2782280.0006650.0024740.0085660.0387530.3449191.7255223.5088835.6745288.869612
High Metal Content PlanetYes993990.7775330.0765120.0894760.1136040.1756180.4669291.262361.9612652.6019593.260115
Icy Body4764901.0047670.0002040.0002770.0004440.0010530.018540.7868092.0480224.30657310.494602
Metal Rich Body428270.6158070.0000860.0002780.0011680.00740.3239331.0493361.4026151.8013032.543975
Rocky Body2274400.0202990.0001930.0002460.0003540.0006910.0033590.0180050.0406450.0740590.147798
Rocky BodyYes28190.1954150.0926330.0953030.0993830.1072570.1423120.2314230.3226380.4352320.650015
Rocky Ice Body567100.593590.0005010.0013420.0037550.0144480.1806860.8815691.4864662.2276843.490298
Class I Gas Giant114483135.7115883.1516775.4399710.37313719.76533269.551636253.422019371.575381457.417723545.342732
Class II Gas Giant29502451.456165.59727211.3008530.360245108.730911476.240875718.386999829.899646915.340466992.233176
Class III Gas Giant686521205.26719212.89414324.183969148.47944548.5793331148.9215091854.5146972264.4965822552.8786142806.610655
Class IV Gas Giant131812172.24185834.16280458.16118342.430841695.1361082615.6353763375.7995113569.3906983667.7907843737.627998
Class V Gas Giant24201406.90623156.08952271.813034101.852104275.332733925.5758062762.0764163340.6848143561.0822753689.560449
Gas Giant with Ammonia-based Life16405214.3617453.5470796.11750716.32850934.518085170.455071390.559387474.067047544.858124621.168231
Gas Giant with Water-based Life32391451.0476425.54862610.6161728.347137110.827815477.001832715.365833828.180737911.815436994.011141
Helium-Rich Gas Giant7681041.5048497.67667413.7159925.64852163.858424550.1418462228.6281743000.8391113291.8922853705.428066
Water Giant139863.0837422.35192423.65168125.65188130.02875747.16376986.193382116.855457157.959108210.857971


Stellar Bodies:
Star ClassNum SamplesMean2nd Percentile5th Percentile10th Percentile20th PercentileMedian80th Percentile90th Percentile95th Percentile98th Percentile
A940372.0626781.3632811.3984381.43751.5078131.6484381.7539061.7851561.9179692.367188
B334645.4185152.3789062.5664062.7968753.1914064.3984385.8046888.61953212.19140614.738907
F1668031.3066640.9843751.0234381.0703131.1445311.2968751.4570311.5585941.6289061.695313
G1357590.9322050.7617190.781250.8046880.8320310.8984381.0351561.1015631.1484381.195313
K3391010.6739290.4570310.4843750.5156250.56250.6679690.781250.8359380.8710940.90625
L710530.1440150.0898440.0976560.1015630.1132810.1406250.1718750.1914060.2031250.207031
M5886670.3335710.1953130.2070310.2226560.2460940.3281250.4101560.4414060.4765630.519531
O590726.2057814.47265614.73437515.15390617.97812523.02343829.09218837.16796955.57851679.093907
T360790.0661680.0351560.0390630.0390630.0468750.0664060.0820310.0898440.0976560.101563
TTS408160.4022340.0117190.0156250.031250.0898440.3164060.6484380.8515631.0468751.488281
Y232580.0187270.0078130.0078130.0078130.0117190.0156250.0273440.031250.0351560.035156
White Dwarf130150.4895850.3320310.3554690.3789060.4101560.4843750.5703130.6132810.6445310.667969
Neutron1777520.8296160.468750.50.5273440.5664060.6914060.8476561.5273441.9531252.246094
Black Hole211007.3670692.5351562.5703132.6289062.7695314.5429698.58984413.42187529.0937539.625
Herbig Ae/Be306612.6158843.2121883.9843754.3984384.755.79296914.60546925.82812547.46562584.013594
Carbon20081.0802510.9296880.9335940.9453130.9609381.031251.18751.3281251.4140631.457031
Wolf-Rayet167776.81272141.93601643.37988346.61601652.20234475.523438101.85109.851953114.736133118.119532
 

MattG

MattG
I'm useless when it comes to graphics stuff, and if he wanted to I'm sure CMDR Fru could update his guide easily enough. I'm not even sure it'd change the values that much, he did a pretty good job :)

I'm quite liking CMDR Jantah's alternative hologram-based one, which I think uses similar data for masses anyway :)
 

marx

marx
Hm, can't rep you again yet. Soon.

Anyway, about the data: I'm a bit surprised about ammonia worlds. Both the mean mass compared to the median, as well as the number of AWs recorded. Going by data from surveys, they should be at least as much as ELWs, if not more. Although it might simply be that scanning those blue marbles is much more attractive to people, and there are a good number of AWs which can be hard to tell at a glance.
Fun to see how WWs and WWTCs differ, too.
Also surprising how few Herbigs are in there, when compared to T Tauris. But then, that might simply be due to them not being near the bubble, and people who would go to the core might not wish to visit these.


Oh, and if you still have the curated data, would you mind posting it? Only if it's not much effort, though, because I expect there's not much more in there.
 

MattG

MattG
marx said:
Oh, and if you still have the curated data, would you mind posting it? Only if it's not much effort, though, because I expect there's not much more in there.
Click to expand...

Sure. It's less polished than the last post, but I'm sure you can work out what's what. My initial version included min and max, but I seem to have forgotten them in this version - it's scripted now though, so next time I regenerate the stats I'll include min and max too.
classtypecuratedcftcountmean2nd5th10th20th50th80th90th95th98th
planetaw00112954.3973250.1086060.1360410.1757920.2375670.439144.55265310.2385618.71069136.633416
planetaw102319.6498420.1518620.1850280.2157030.2993142.06918410.3212124.62812839.06648580.307386
planetelw01143500.7958940.2513450.2702320.295280.3346550.4980391.2736281.7257792.0787872.36062
planetelw115280.8927360.0811080.115720.202860.3122030.72281.4111261.9129912.2457732.932216
planetgg100114483135.7115883.1516775.4399710.37313719.76533269.551636253.422019371.575381457.417723545.342732
planetgg1108201125.6829633.3381225.92658310.41297819.28112663.054314227.442279351.937528436.110327521.243128
planetgg20029502451.456165.59727211.3008530.360245108.730911476.240875718.386999829.899646915.340466992.233176
planetgg2102087413.7888995.9225229.86436525.23716267.791803411.207245714.278186836.37808932.5304321004.136191
planetgg300686521205.26719212.89414324.183969148.47944548.5793331148.9215091854.5146972264.4965822552.8786142806.610655
planetgg31067051124.4534711.40807317.82824266.595146316.9999691076.1020511802.6477052217.4082042548.5538332811.156665
planetgg400131812172.24185834.16280458.16118342.430841695.1361082615.6353763375.7995113569.3906983667.7907843737.627998
planetgg41014562187.60238138.1872157.241963316.999542692.6185792573.7631843397.4911143586.0324713692.9836433765.862207
planetgg50024201406.90623156.08952271.813034101.852104275.332733925.5758062762.0764163340.6848143561.0822753689.560449
planetgg5103841513.73429855.84883266.68235581.557547151.3558011054.9412842979.8689453426.262893613.453323759.613477
planetgga0016405214.3617453.5470796.11750716.32850934.518085170.455071390.559387474.067047544.858124621.168231
planetgga10950207.4408113.7913337.10403316.01623233.053608156.387299388.275146487.402191549.608429618.257751
planetggh007681041.5048497.67667413.7159925.64852163.858424550.1418462228.6281743000.8391113291.8922853705.428066
planetggh10409978.4229079.04859914.2274334.16504379.858658497.9618831994.6249512737.2560793247.3961913636.827695
planetggw0032391451.0476425.54862610.6161728.347137110.827815477.001832715.365833828.180737911.815436994.011141
planetggw102014414.2388445.2891748.3582623.10594762.956174418.427856715.423401829.21659910.107751992.871907
planethmc005748701.2782280.0006650.0024740.0085660.0387530.3449191.7255223.5088835.6745288.869612
planethmc01993990.7775330.0765120.0894760.1136040.1756180.4669291.262361.9612652.6019593.260115
planethmc10291232.7772440.0004790.0016740.0065110.03510.562413.2501396.68250311.13444418.85266
planethmc1121081.0766210.0820870.1053190.1445410.2539660.7315461.8455652.5663043.2160073.694638
planetib004764901.0047670.0002040.0002770.0004440.0010530.018540.7868092.0480224.30657310.494602
planetib10529871.0466390.0001980.000250.000370.0007610.00580.4588061.7182633.93127810.789799
planetmr00428270.6158070.0000860.0002780.0011680.00740.3239331.0493361.4026151.8013032.543975
planetmr1037091.2245790.0000350.0001120.0004270.0034360.2947391.3746882.0671313.4040687.501099
planetrb002274400.0202990.0001930.0002460.0003540.0006910.0033590.0180050.0406450.0740590.147798
planetrb0128190.1954150.0926330.0953030.0993830.1072570.1423120.2314230.3226380.4352320.650015
planetrb10344490.0436650.0001970.0002440.0003440.000630.0027010.0138650.0347790.0720220.153238
planetrb111570.1766020.0942330.0980160.1025650.1095310.1421490.2046630.2937650.3679940.532978
planetriw00567100.593590.0005010.0013420.0037550.0144480.1806860.8815691.4864662.2276843.490298
planetriw1032860.6713110.0003960.0010260.0026810.0090050.2097320.9562651.5592982.3863564.297133
planetwg00139863.0837422.35192423.65168125.65188130.02875747.16376986.193382116.855457157.959108210.857971
planetwg1013170.59290121.96838123.35558424.65938730.88260850.33491998.463548139.818843203.756349272.499942
planetww00559741.9776280.1596910.1840120.2191390.2927430.7806382.7991734.6754056.8672810.248024
planetww01554610.700250.1301410.1444870.1681680.2201330.4530111.1092481.630032.1096422.564254
planetww1011224.2796820.1716080.2122940.2867240.4634461.4079465.2776419.16176316.70196129.616282
planetww118420.8682720.1259110.145460.181290.2496950.6370191.4220551.9214662.3066672.695229
starAEBE0306612.6158843.2121883.9843754.3984384.755.79296914.60546925.82812547.46562584.013594
starAEBE1399.2319713.0408593.0542973.0730473.1335944.6230477.29296915.93984464.05781382.152344
starA0940372.0626781.3632811.3984381.43751.5078131.6484381.7539061.7851561.9179692.367188
starA131722.3894641.4118751.4414061.4960941.6015631.8867192.3242192.9796884.77265611.594688
starB0334645.4185152.3789062.5664062.7968753.1914064.3984385.8046888.61953212.19140614.738907
starB133727.9218212.3259382.5664062.8828133.5484377.15234412.60703114.45156315.27343815.670625
starC020081.0802510.9296880.9335940.9453130.9609381.031251.18751.3281251.4140631.457031
starC1721.3402240.4968750.518750.5945320.8085941.4023441.8671881.9664062.0570312.09375
starD0130150.4895850.3320310.3554690.3789060.4101560.4843750.5703130.6132810.6445310.667969
starD11070.6904570.1768750.1902350.2542970.368750.6113281.093751.2328131.2667971.342656
starF01668031.3066640.9843751.0234381.0703131.1445311.2968751.4570311.5585941.6289061.695313
starF153231.3565311.0273441.0546881.0859381.1406251.2929691.4882811.6796881.8671882.109375
starG01357590.9322050.7617190.781250.8046880.8320310.8984381.0351561.1015631.1484381.195313
starG152220.9992230.7890630.8085940.8281250.8671880.9570311.0820311.2148441.3511721.535156
starK03391010.6739290.4570310.4843750.5156250.56250.6679690.781250.8359380.8710940.90625
starK173600.6484490.4492190.4648440.4882810.531250.6367190.750.78910.8398440.90625
starL0710530.1440150.0898440.0976560.1015630.1132810.1406250.1718750.1914060.2031250.207031
starL124300.139250.0859380.093750.1015630.1093750.1367190.1640630.1796880.1914060.203125
starM05886670.3335710.1953130.2070310.2226560.2460940.3281250.4101560.4414060.4765630.519531
starM1106800.3307220.18750.2031250.2148440.2421880.3281250.4101560.43750.468750.515625
starO0590726.2057814.47265614.73437515.15390617.97812523.02343829.09218837.16796955.57851679.093907
starO127363.63793516.76906319.34238323.83320331.29921964.84960996.140625109.742578116.029883117.523203
starTTS0408160.4022340.0117190.0156250.031250.0898440.3164060.6484380.8515631.0468751.488281
starTTS114790.3034520.0117190.0156250.0234380.0390630.1289060.4140630.7695311.1771482.280625
starT0360790.0661680.0351560.0390630.0390630.0468750.0664060.0820310.0898440.0976560.101563
starT117040.0627430.031250.0351560.0390630.0429690.06250.0820310.0898440.093750.097696
starW0167776.81272141.93601643.37988346.61601652.20234475.523438101.85109.851953114.736133118.119532
starW1681.2389710.5081250.53750.6304690.7656251.2031251.7671871.9539062.0703132.09375
starY0232580.0187270.0078130.0078130.0078130.0117190.0156250.0273440.031250.0351560.035156
starY119620.021520.0078130.0078130.0117190.0117190.0156250.0273440.031250.031250.035156
starbh0211007.3670692.5351562.5703132.6289062.7695314.5429698.58984413.42187529.0937539.625
starbh155210.1280862.5585942.6078132.7109382.96253.92968811.42656318.67734426.51328192.729844
starns01777520.8296160.468750.50.5273440.5664060.6914060.8476561.5273441.9531252.246094
starns16002.4220571.0351561.18751.281251.4726561.8632812.3398442.58.22656312.601563
 
You must log in or register to reply here.
Back
Top Bottom