Overview

Dataset Statistics

Number of Variables 35
Number of Rows 282800
Missing Cells 608515
Missing Cells (%) 6.1%
Duplicate Rows 521
Duplicate Rows (%) 0.2%
Total Size in Memory 189.1 MB
Average Row Size in Memory 701.2 B
Variable Types
  • Categorical: 10
  • Numerical: 25

Dataset Insights

Aetna Medicare and Blue Medicare have similar distributions Similar Distribution
Aetna Medicare and Cigna Healthsprings have similar distributions Similar Distribution
Aetna Medicare and HealthTeam Advantage have similar distributions Similar Distribution
Aetna Medicare and Humana Medicare have similar distributions Similar Distribution
Aetna Medicare and UHC Medicare have similar distributions Similar Distribution
Aetna Medicare and Wellcare Medicare have similar distributions Similar Distribution
Blue Medicare and Cigna Healthsprings have similar distributions Similar Distribution
Blue Medicare and HealthTeam Advantage have similar distributions Similar Distribution
Blue Medicare and Humana Medicare have similar distributions Similar Distribution
Blue Medicare and UHC Medicare have similar distributions Similar Distribution
Blue Medicare and Wellcare Medicare have similar distributions Similar Distribution
Beech Street and Humana Choicecare have similar distributions Similar Distribution
Beech Street and Multiplan Private Health Care Systems have similar distributions Similar Distribution
Cigna Healthsprings and HealthTeam Advantage have similar distributions Similar Distribution
Cigna Healthsprings and Humana Medicare have similar distributions Similar Distribution
Cigna Healthsprings and UHC Medicare have similar distributions Similar Distribution
Cigna Healthsprings and Wellcare Medicare have similar distributions Similar Distribution
HealthTeam Advantage and Humana Medicare have similar distributions Similar Distribution
HealthTeam Advantage and UHC Medicare have similar distributions Similar Distribution
HealthTeam Advantage and Wellcare Medicare have similar distributions Similar Distribution
Humana Choicecare and Multiplan Private Health Care Systems have similar distributions Similar Distribution
Humana Medicare and UHC Medicare have similar distributions Similar Distribution
Humana Medicare and Wellcare Medicare have similar distributions Similar Distribution
UHC Medicare and Wellcare Medicare have similar distributions Similar Distribution
DRG has 282299 (99.82%) missing values Missing
NDC has 278318 (98.42%) missing values Missing
CPT has 47390 (16.76%) missing values Missing
Rev Code is skewed Skewed
Gross Charge is skewed Skewed
Discounted Cash Price is skewed Skewed
Aetna Medicare is skewed Skewed
Aetna Whole Health is skewed Skewed
BCBS (PPO, State Health, Federal Employees, Blue Select, Blue Value) is skewed Skewed
Blue Local Group is skewed Skewed
Blue Local Individual is skewed Skewed
Blue Medicare is skewed Skewed
Beech Street is skewed Skewed
Cigna Healthsprings is skewed Skewed
Cigna Managed Care is skewed Skewed
Coventry Carolinas is skewed Skewed
Coventry Wellpath is skewed Skewed
First Health is skewed Skewed
HealthTeam Advantage is skewed Skewed
Humana Choicecare is skewed Skewed
Humana Medicare is skewed Skewed
Medcost is skewed Skewed
Medcost Ultra is skewed Skewed
Multiplan Private Health Care Systems is skewed Skewed
UHC Managed Care is skewed Skewed
UHC Medicare is skewed Skewed
Wellcare Medicare is skewed Skewed
NDC has a high cardinality: 4256 distinct values High Cardinality
CPT has a high cardinality: 3064 distinct values High Cardinality
Procedure Description has a high cardinality: 260284 distinct values High Cardinality
Minimum Negotiated Charge has a high cardinality: 28241 distinct values High Cardinality
Maximum Negotiated Charge has a high cardinality: 26363 distinct values High Cardinality
Aetna Managed Care has a high cardinality: 22196 distinct values High Cardinality
NDC has constant length 13.0 Constant Length
Aetna Medicare has 276870 (97.9%) zeros Zeros
Blue Medicare has 279112 (98.7%) zeros Zeros
Cigna Healthsprings has 279125 (98.7%) zeros Zeros
HealthTeam Advantage has 279111 (98.7%) zeros Zeros
Humana Medicare has 279112 (98.7%) zeros Zeros
UHC Medicare has 279112 (98.7%) zeros Zeros
Wellcare Medicare has 279112 (98.7%) zeros Zeros
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Variables

Patient Type

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 20.2 MB
  • The largest value (Outpatient) is over 555.69 times larger than the second largest value (Inpatient)

Length

Mean 9.9982
Standard Deviation 0.04235
Median 10
Minimum 9
Maximum 10

Sample

1st row Inpatient
2nd row Inpatient
3rd row Inpatient
4th row Inpatient
5th row Inpatient

Letter

Count 2827492
Lowercase Letter 2544692
Space Separator 0
Uppercase Letter 282800
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Outpatient, Inpatient) take over 50.0%
  • The largest value (outpatient) is over 555.69 times larger than the second largest value (inpatient)

DRG

numerical

Approximate Distinct Count 501
Approximate Unique (%) 100.0%
Missing 282299
Missing (%) 99.8%
Infinite 0
Infinite (%) 0.0%
Memory Size 7.8 KB
Mean 486.5329
Minimum 3
Maximum 989
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 3
5-th Percentile 69
Q1 254
Median 476
Q3 699
95-th Percentile 918
Maximum 989
Range 986
IQR 445

Descriptive Statistics

Mean 486.5329
Standard Deviation 268.4882
Variance 72085.8974
Sum 243753
Skewness nan
Kurtosis nan
Coefficient of Variation 0.5518

NDC

categorical

Approximate Distinct Count 4256
Approximate Unique (%) 95.0%
Missing 278318
Missing (%) 98.4%
Memory Size 341.4 KB
  • The largest value (00002-7510-17) is over 3.75 times larger than the second largest value (00338-0049-02)

Length

Mean 13
Standard Deviation 0
Median 13
Minimum 13
Maximum 13

Sample

1st row 00904-6719-80
2nd row 00904-6773-61
3rd row 10939-0854-44
4th row 50580-0600-02
5th row 51645-0703-01

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 8964
Decimal Number 49302
  • NDC contains many words: 4256 words
  • The largest value (00002751017) is over 3.75 times larger than the second largest value (00338004904)
  • NDC has words of constant length

Rev Code

numerical

Approximate Distinct Count 117
Approximate Unique (%) 0.0%
Missing 501
Missing (%) 0.2%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 281.1112
Minimum 114
Maximum 999
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Rev Code is skewed right (γ1 = 9.5695)

Quantile Statistics

Minimum 114
5-th Percentile 272
Q1 274
Median 278
Q3 278
95-th Percentile 278
Maximum 999
Range 885
IQR 4

Descriptive Statistics

Mean 281.1112
Standard Deviation 42.0364
Variance 1767.0611
Sum 7.9357e+07
Skewness 9.5695
Kurtosis 98.076
Coefficient of Variation 0.1495
  • Rev Code is not normally distributed (p-value 2.3642769444804375e-23)
  • Rev Code has 8377 outliers

CPT

categorical

Approximate Distinct Count 3064
Approximate Unique (%) 1.3%
Missing 47390
Missing (%) 16.8%
Memory Size 15.7 MB
  • The largest value (C1713) is over 2.78 times larger than the second largest value (C1776)

Length

Mean 5
Standard Deviation 0.008244
Median 5
Minimum 1
Maximum 5

Sample

1st row A9270
2nd row A9270
3rd row A9270
4th row A9270
5th row A9270

Letter

Count 232011
Lowercase Letter 0
Space Separator 0
Uppercase Letter 232011
Dash Punctuation 0
Decimal Number 945035
  • The top 2 categories (C1713, C1776) take over 50.0%
  • CPT contains many words: 3064 words
  • The largest value (c1713) is over 2.78 times larger than the second largest value (c1776)

Procedure Description

categorical

Approximate Distinct Count 260284
Approximate Unique (%) 92.0%
Missing 0
Missing (%) 0.0%
Memory Size 40.0 MB

Length

Mean 83.4522
Standard Deviation 26.6516
Median 83
Minimum 5
Maximum 243

Sample

1st row NURSERY 1 ROOM DAI...
2nd row Hc Hpmc Psych Priv...
3rd row Hc Hpmc Rm-irf Roo...
4th row Hc Hpmc Psych Semi...
5th row Hc Hpmc Psych Semi...

Letter

Count 18291381
Lowercase Letter 111209
Space Separator 3674491
Uppercase Letter 18180172
Dash Punctuation 62240
Decimal Number 1396871
  • Procedure Description contains many words: 28972 words
  • The largest value (mm) is over 4.71 times larger than the second largest value (bone)

Gross Charge

numerical

Approximate Distinct Count 22321
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 5158.7451
Minimum 0
Maximum 535132.6687
Zeros 62
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Gross Charge is skewed right (γ1 = 8.693)

Quantile Statistics

Minimum 0
5-th Percentile 280.33
Q1 1000.12
Median 3292.65
Q3 5607.58
95-th Percentile 19371.64
Maximum 535132.6687
Range 535132.6687
IQR 4607.46

Descriptive Statistics

Mean 5158.7451
Standard Deviation 8171.7242
Variance 6.6777e+07
Sum 1.4589e+09
Skewness 8.693
Kurtosis 210.9396
Coefficient of Variation 1.5841
  • Gross Charge is not normally distributed (p-value 7.096707139311743e-25)
  • Gross Charge has 25815 outliers

Discounted Cash Price

numerical

Approximate Distinct Count 22321
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 2579.3725
Minimum 0
Maximum 267566.3344
Zeros 62
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Discounted Cash Price is skewed right (γ1 = 8.693)

Quantile Statistics

Minimum 0
5-th Percentile 140.165
Q1 500.06
Median 1646.325
Q3 2803.79
95-th Percentile 9685.82
Maximum 267566.3344
Range 267566.3344
IQR 2303.73

Descriptive Statistics

Mean 2579.3725
Standard Deviation 4085.8621
Variance 1.6694e+07
Sum 7.2945e+08
Skewness 8.693
Kurtosis 210.9396
Coefficient of Variation 1.5841
  • Discounted Cash Price is not normally distributed (p-value 7.096707139311743e-25)
  • Discounted Cash Price has 25815 outliers

Minimum Negotiated Charge

categorical

Approximate Distinct Count 28241
Approximate Unique (%) 10.0%
Missing 0
Missing (%) 0.0%
Memory Size 19.2 MB
  • The largest value (1076.0) is over 1.56 times larger than the second largest value (1345.01)

Length

Mean 6.0378
Standard Deviation 0.7577
Median 6
Minimum 1
Maximum 11

Sample

1st row 813
2nd row 510
3rd row 796
4th row 510
5th row 510

Letter

Count 78
Lowercase Letter 0
Space Separator 0
Uppercase Letter 78
Dash Punctuation 0
Decimal Number 1425094
  • Minimum Negotiated Charge contains many words: 27315 words
  • The largest value (10760) is over 1.56 times larger than the second largest value (134501)

Maximum Negotiated Charge

categorical

Approximate Distinct Count 26363
Approximate Unique (%) 9.3%
Missing 0
Missing (%) 0.0%
Memory Size 19.6 MB

Length

Mean 7.8199
Standard Deviation 0.8908
Median 8
Minimum 4
Maximum 13

Sample

1st row 813.00
2nd row 1,284.00
3rd row 1,284.00
4th row 1,284.00
5th row 1,284.00

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1687343
  • Maximum Negotiated Charge contains many words: 26363 words

Aetna Managed Care

categorical

Approximate Distinct Count 22196
Approximate Unique (%) 7.8%
Missing 0
Missing (%) 0.0%
Memory Size 19.5 MB

Length

Mean 7.3077
Standard Deviation 1.0914
Median 8
Minimum 4
Maximum 10

Sample

1st row 0.00
2nd row 0.00
3rd row 0.00
4th row 0.00
5th row 0.00

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1604816
  • Aetna Managed Care contains many words: 22196 words

Aetna Medicare

numerical

Approximate Distinct Count 1564
Approximate Unique (%) 0.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 290.6062
Minimum 0
Maximum 7.2505e+07
Zeros 276870
Zeros (%) 97.9%
Negatives 0
Negatives (%) 0.0%
  • Aetna Medicare is skewed right (γ1 = 531.7597)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 7.2505e+07
Range 7.2505e+07
IQR 0

Descriptive Statistics

Mean 290.6062
Standard Deviation 136344.5308
Variance 1.859e+10
Sum 8.2183e+07
Skewness 531.7597
Kurtosis 282775.9114
Coefficient of Variation 469.1729
  • Aetna Medicare is not normally distributed (p-value 4.22651407257404e-25)
  • Aetna Medicare has 5930 outliers

Aetna Whole Health

numerical

Approximate Distinct Count 21969
Approximate Unique (%) 7.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 2473.2741
Minimum 0
Maximum 240809.7009
Zeros 110
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Aetna Whole Health is skewed right (γ1 = 8.3563)

Quantile Statistics

Minimum 0
5-th Percentile 134.56
Q1 480.06
Median 1580.47
Q3 2691.64
95-th Percentile 9298.39
Maximum 240809.7009
Range 240809.7009
IQR 2211.58

Descriptive Statistics

Mean 2473.2741
Standard Deviation 3891.3963
Variance 1.5143e+07
Sum 6.9944e+08
Skewness 8.3563
Kurtosis 190.9634
Coefficient of Variation 1.5734
  • Aetna Whole Health is not normally distributed (p-value 7.756016443250996e-25)
  • Aetna Whole Health has 25806 outliers

BCBS (PPO, State Health, Federal Employees, Blue Select, Blue Value)

numerical

Approximate Distinct Count 22977
Approximate Unique (%) 8.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 2553.0847
Minimum 0
Maximum 229147.8192
Zeros 88
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • BCBS (PPO, State Health, Federal Employees, Blue Select, Blue Value) is skewed right (γ1 = 7.9557)

Quantile Statistics

Minimum 0
5-th Percentile 138.79
Q1 495.16
Median 1630.19
Q3 2776.31
95-th Percentile 9590.9
Maximum 229147.8192
Range 229147.8192
IQR 2281.15

Descriptive Statistics

Mean 2553.0847
Standard Deviation 3998.3549
Variance 1.5987e+07
Sum 7.2201e+08
Skewness 7.9557
Kurtosis 168.2294
Coefficient of Variation 1.5661
  • BCBS (PPO, State Health, Federal Employees, Blue Select, Blue Value) is not normally distributed (p-value 9.26670585215675e-25)
  • BCBS (PPO, State Health, Federal Employees, Blue Select, Blue Value) has 25833 outliers

Blue Local Group

numerical

Approximate Distinct Count 22898
Approximate Unique (%) 8.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 2118.8944
Minimum 0
Maximum 190192.6899
Zeros 108
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Blue Local Group is skewed right (γ1 = 7.956)

Quantile Statistics

Minimum 0
5-th Percentile 115.19
Q1 410.95
Median 1352.95
Q3 2304.15
95-th Percentile 7959.81
Maximum 190192.6899
Range 190192.6899
IQR 1893.2

Descriptive Statistics

Mean 2118.8944
Standard Deviation 3318.4027
Variance 1.1012e+07
Sum 5.9922e+08
Skewness 7.956
Kurtosis 168.2471
Coefficient of Variation 1.5661
  • Blue Local Group is not normally distributed (p-value 9.26670585215675e-25)
  • Blue Local Group has 25833 outliers

Blue Local Individual

numerical

Approximate Distinct Count 22583
Approximate Unique (%) 8.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 1583.1665
Minimum 0
Maximum 142071.6479
Zeros 110
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Blue Local Individual is skewed right (γ1 = 7.9563)

Quantile Statistics

Minimum 0
5-th Percentile 86.06
Q1 307.04
Median 1010.84
Q3 1721.53
95-th Percentile 5947.09
Maximum 142071.6479
Range 142071.6479
IQR 1414.49

Descriptive Statistics

Mean 1583.1665
Standard Deviation 2478.6544
Variance 6.1437e+06
Sum 4.4772e+08
Skewness 7.9563
Kurtosis 168.3195
Coefficient of Variation 1.5656
  • Blue Local Individual is not normally distributed (p-value 9.265280518883492e-25)
  • Blue Local Individual has 25827 outliers

Blue Medicare

numerical

Approximate Distinct Count 1259
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 289.7586
Minimum 0
Maximum 7.2505e+07
Zeros 279112
Zeros (%) 98.7%
Negatives 0
Negatives (%) 0.0%
  • Blue Medicare is skewed right (γ1 = 531.7597)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 7.2505e+07
Range 7.2505e+07
IQR 0

Descriptive Statistics

Mean 289.7586
Standard Deviation 136344.5302
Variance 1.859e+10
Sum 8.1944e+07
Skewness 531.7597
Kurtosis 282775.9293
Coefficient of Variation 470.5452
  • Blue Medicare is not normally distributed (p-value 4.22651407257404e-25)
  • Blue Medicare has 3688 outliers

Beech Street

numerical

Approximate Distinct Count 22210
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 4900.3483
Minimum 0
Maximum 508376.0353
Zeros 89
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Beech Street is skewed right (γ1 = 8.6951)

Quantile Statistics

Minimum 0
5-th Percentile 266.32
Q1 950.11
Median 3128.02
Q3 5327.2
95-th Percentile 18403.06
Maximum 508376.0353
Range 508376.0353
IQR 4377.09

Descriptive Statistics

Mean 4900.3483
Standard Deviation 7762.0776
Variance 6.025e+07
Sum 1.3858e+09
Skewness 8.6951
Kurtosis 211.048
Coefficient of Variation 1.584
  • Beech Street is not normally distributed (p-value 7.096692254599311e-25)
  • Beech Street has 25813 outliers

Carolina Behavioral Health

categorical

Approximate Distinct Count 3
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 17.8 MB
  • The largest value (0) is over 94264.67 times larger than the second largest value (260)

Length

Mean 1
Standard Deviation 0.009212
Median 1
Minimum 1
Maximum 3

Sample

1st row 0
2nd row 510
3rd row 0
4th row 510
5th row 510

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 282812
  • The top 2 categories (0, 260) take over 50.0%
  • The largest value (0) is over 94264.67 times larger than the second largest value (260)

Cigna Behavioral Health

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 17.8 MB
  • The largest value (0) is over 94265.67 times larger than the second largest value (1096)

Length

Mean 1
Standard Deviation 0.009771
Median 1
Minimum 1
Maximum 4

Sample

1st row 0
2nd row 1096
3rd row 0
4th row 1096
5th row 1096

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 282809
  • The top 2 categories (0, 1096) take over 50.0%
  • The largest value (0) is over 94265.67 times larger than the second largest value (1096)

Cigna Healthsprings

numerical

Approximate Distinct Count 1259
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 289.7535
Minimum 0
Maximum 7.2505e+07
Zeros 279125
Zeros (%) 98.7%
Negatives 0
Negatives (%) 0.0%
  • Cigna Healthsprings is skewed right (γ1 = 531.7597)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 7.2505e+07
Range 7.2505e+07
IQR 0

Descriptive Statistics

Mean 289.7535
Standard Deviation 136344.5302
Variance 1.859e+10
Sum 8.1942e+07
Skewness 531.7597
Kurtosis 282775.9293
Coefficient of Variation 470.5535
  • Cigna Healthsprings is not normally distributed (p-value 4.22651407257404e-25)
  • Cigna Healthsprings has 3675 outliers

Cigna Managed Care

numerical

Approximate Distinct Count 21992
Approximate Unique (%) 7.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 2780.6237
Minimum 0
Maximum 260692.2024
Zeros 87
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Cigna Managed Care is skewed right (γ1 = 8.1055)

Quantile Statistics

Minimum 0
5-th Percentile 151.1
Q1 539.06
Median 1774.74
Q3 3022.49
95-th Percentile 10441.31
Maximum 260692.2024
Range 260692.2024
IQR 2483.43

Descriptive Statistics

Mean 2780.6237
Standard Deviation 4372.8626
Variance 1.9122e+07
Sum 7.8636e+08
Skewness 8.1055
Kurtosis 176.0804
Coefficient of Variation 1.5726
  • Cigna Managed Care is not normally distributed (p-value 8.924963733278702e-25)
  • Cigna Managed Care has 25829 outliers

Coventry Carolinas

numerical

Approximate Distinct Count 22318
Approximate Unique (%) 7.9%
Missing 7
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 4385.0104
Minimum 0
Maximum 454862.7684
Zeros 62
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Coventry Carolinas is skewed right (γ1 = 8.693)

Quantile Statistics

Minimum 0
5-th Percentile 238.2805
Q1 900.184
Median 2798.7525
Q3 4766.443
95-th Percentile 16465.894
Maximum 454862.7684
Range 454862.7684
IQR 3866.259

Descriptive Statistics

Mean 4385.0104
Standard Deviation 6946.034
Variance 4.8247e+07
Sum 1.2401e+09
Skewness 8.693
Kurtosis 210.9361
Coefficient of Variation 1.584
  • Coventry Carolinas is not normally distributed (p-value 7.096909372492593e-25)
  • Coventry Carolinas has 26057 outliers

Coventry Wellpath

numerical

Approximate Distinct Count 22355
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 4125.2548
Minimum 0
Maximum 428106.135
Zeros 86
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Coventry Wellpath is skewed right (γ1 = 8.693)

Quantile Statistics

Minimum 0
5-th Percentile 224.27
Q1 800.09
Median 2634.12
Q3 4486.06
95-th Percentile 15497.31
Maximum 428106.135
Range 428106.135
IQR 3685.97

Descriptive Statistics

Mean 4125.2548
Standard Deviation 6537.1208
Variance 4.2734e+07
Sum 1.1666e+09
Skewness 8.693
Kurtosis 210.9722
Coefficient of Variation 1.5847
  • Coventry Wellpath is not normally distributed (p-value 7.096692254599311e-25)
  • Coventry Wellpath has 25813 outliers

First Health

numerical

Approximate Distinct Count 22212
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 4797.1835
Minimum 0
Maximum 497673.3819
Zeros 89
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • First Health is skewed right (γ1 = 8.6951)

Quantile Statistics

Minimum 0
5-th Percentile 260.71
Q1 930.11
Median 3062.16
Q3 5215.05
95-th Percentile 18015.63
Maximum 497673.3819
Range 497673.3819
IQR 4284.94

Descriptive Statistics

Mean 4797.1835
Standard Deviation 7598.6652
Variance 5.774e+07
Sum 1.3566e+09
Skewness 8.6951
Kurtosis 211.048
Coefficient of Variation 1.584
  • First Health is not normally distributed (p-value 7.096692254599311e-25)
  • First Health has 25813 outliers

HealthTeam Advantage

numerical

Approximate Distinct Count 1259
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 289.7593
Minimum 0
Maximum 7.2505e+07
Zeros 279111
Zeros (%) 98.7%
Negatives 0
Negatives (%) 0.0%
  • HealthTeam Advantage is skewed right (γ1 = 531.7597)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 7.2505e+07
Range 7.2505e+07
IQR 0

Descriptive Statistics

Mean 289.7593
Standard Deviation 136344.5302
Variance 1.859e+10
Sum 8.1944e+07
Skewness 531.7597
Kurtosis 282775.9293
Coefficient of Variation 470.5441
  • HealthTeam Advantage is not normally distributed (p-value 4.22651407257404e-25)
  • HealthTeam Advantage has 3689 outliers

Humana Choicecare

numerical

Approximate Distinct Count 22210
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 4898.5542
Minimum 0
Maximum 497673.3819
Zeros 89
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Humana Choicecare is skewed right (γ1 = 8.5764)

Quantile Statistics

Minimum 0
5-th Percentile 266.32
Q1 950.11
Median 3128.02
Q3 5327.2
95-th Percentile 18403.06
Maximum 497673.3819
Range 497673.3819
IQR 4377.09

Descriptive Statistics

Mean 4898.5542
Standard Deviation 7741.3417
Variance 5.9928e+07
Sum 1.3853e+09
Skewness 8.5764
Kurtosis 203.8996
Coefficient of Variation 1.5803
  • Humana Choicecare is not normally distributed (p-value 7.186255160876298e-25)
  • Humana Choicecare has 25811 outliers

Humana Medicare

numerical

Approximate Distinct Count 1258
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 295.5538
Minimum 0
Maximum 7.3955e+07
Zeros 279112
Zeros (%) 98.7%
Negatives 0
Negatives (%) 0.0%
  • Humana Medicare is skewed right (γ1 = 531.7597)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 7.3955e+07
Range 7.3955e+07
IQR 0

Descriptive Statistics

Mean 295.5538
Standard Deviation 139071.4208
Variance 1.9341e+10
Sum 8.3583e+07
Skewness 531.7597
Kurtosis 282775.9293
Coefficient of Variation 470.5452
  • Humana Medicare is not normally distributed (p-value 4.22651407257404e-25)
  • Humana Medicare has 3688 outliers

Medcost

numerical

Approximate Distinct Count 22135
Approximate Unique (%) 7.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 3627.3342
Minimum 0
Maximum 322149.8666
Zeros 89
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Medcost is skewed right (γ1 = 7.9665)

Quantile Statistics

Minimum 0
5-th Percentile 197.64
Q1 705.08
Median 2321.32
Q3 3953.34
95-th Percentile 13657.01
Maximum 322149.8666
Range 322149.8666
IQR 3248.26

Descriptive Statistics

Mean 3627.3342
Standard Deviation 5659.8569
Variance 3.2034e+07
Sum 1.0258e+09
Skewness 7.9665
Kurtosis 169.2493
Coefficient of Variation 1.5603
  • Medcost is not normally distributed (p-value 9.579407774891562e-25)
  • Medcost has 25797 outliers

Medcost Ultra

numerical

Approximate Distinct Count 21992
Approximate Unique (%) 7.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 2681.8919
Minimum 0
Maximum 306095.8865
Zeros 89
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Medcost Ultra is skewed right (γ1 = 9.3352)

Quantile Statistics

Minimum 0
5-th Percentile 145.49
Q1 519.06
Median 1708.89
Q3 2910.33
95-th Percentile 10053.88
Maximum 306095.8865
Range 306095.8865
IQR 2391.27

Descriptive Statistics

Mean 2681.8919
Standard Deviation 4298.6237
Variance 1.8478e+07
Sum 7.5844e+08
Skewness 9.3352
Kurtosis 251.4715
Coefficient of Variation 1.6028
  • Medcost Ultra is not normally distributed (p-value 6.6450665051170075e-25)
  • Medcost Ultra has 25818 outliers

Multiplan Private Health Care Systems

numerical

Approximate Distinct Count 22210
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 4900.3483
Minimum 0
Maximum 508376.0353
Zeros 89
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Multiplan Private Health Care Systems is skewed right (γ1 = 8.6951)

Quantile Statistics

Minimum 0
5-th Percentile 266.32
Q1 950.11
Median 3128.02
Q3 5327.2
95-th Percentile 18403.06
Maximum 508376.0353
Range 508376.0353
IQR 4377.09

Descriptive Statistics

Mean 4900.3483
Standard Deviation 7762.0776
Variance 6.025e+07
Sum 1.3858e+09
Skewness 8.6951
Kurtosis 211.048
Coefficient of Variation 1.584
  • Multiplan Private Health Care Systems is not normally distributed (p-value 7.096692254599311e-25)
  • Multiplan Private Health Care Systems has 25813 outliers

UHC Behavioral Health

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 17.8 MB
  • The largest value (0) is over 282799.0 times larger than the second largest value (768)

Length

Mean 1
Standard Deviation 0.003761
Median 1
Minimum 1
Maximum 3

Sample

1st row 0
2nd row 0
3rd row 0
4th row 768
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 282802
  • The top 2 categories (0, 768) take over 50.0%
  • The largest value (0) is over 282799.0 times larger than the second largest value (768)

UHC Managed Care

numerical

Approximate Distinct Count 22396
Approximate Unique (%) 7.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 4056.4126
Minimum 0
Maximum 2.0173e+06
Zeros 354
Zeros (%) 0.1%
Negatives 0
Negatives (%) 0.0%
  • UHC Managed Care is skewed right (γ1 = 45.4712)

Quantile Statistics

Minimum 0
5-th Percentile 207.45
Q1 773.39
Median 2436.56
Q3 4149.61
95-th Percentile 14335.01
Maximum 2.0173e+06
Range 2.0173e+06
IQR 3376.22

Descriptive Statistics

Mean 4056.4126
Standard Deviation 11376.9831
Variance 1.2944e+08
Sum 1.1472e+09
Skewness 45.4712
Kurtosis 4901.4999
Coefficient of Variation 2.8047
  • UHC Managed Care is not normally distributed (p-value 4.230572312360952e-25)
  • UHC Managed Care has 25874 outliers

UHC Medicare

numerical

Approximate Distinct Count 1260
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 292.6455
Minimum 0
Maximum 7.323e+07
Zeros 279112
Zeros (%) 98.7%
Negatives 0
Negatives (%) 0.0%
  • UHC Medicare is skewed right (γ1 = 531.7597)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 7.323e+07
Range 7.323e+07
IQR 0

Descriptive Statistics

Mean 292.6455
Standard Deviation 137707.975
Variance 1.8963e+10
Sum 8.276e+07
Skewness 531.7597
Kurtosis 282775.9334
Coefficient of Variation 470.5624
  • UHC Medicare is not normally distributed (p-value 4.22651407257404e-25)
  • UHC Medicare has 3688 outliers

Wellcare Medicare

numerical

Approximate Distinct Count 1256
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.3 MB
Mean 295.4429
Minimum 0
Maximum 7.3955e+07
Zeros 279112
Zeros (%) 98.7%
Negatives 0
Negatives (%) 0.0%
  • Wellcare Medicare is skewed right (γ1 = 531.7598)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 7.3955e+07
Range 7.3955e+07
IQR 0

Descriptive Statistics

Mean 295.4429
Standard Deviation 139071.4149
Variance 1.9341e+10
Sum 8.3551e+07
Skewness 531.7598
Kurtosis 282775.9791
Coefficient of Variation 470.7218
  • Wellcare Medicare is not normally distributed (p-value 4.22651407257404e-25)
  • Wellcare Medicare has 3688 outliers

Interactions

Correlations

Missing Values