Actividad4.6REGRESIÓN LÍNEAL
EQUIPO 1
2023-09-25
REGRESIÓN LINEAL
2.ENTENDER LA BASE DE DATOS
summary(base_act_4_6)## ClaimID TotalPaid TotalReserves TotalRecovery
## Min. : 777624 Min. : 777624 Min. : 0 Min. : 0.00
## 1st Qu.: 794257 1st Qu.: 794257 1st Qu.: 0 1st Qu.: 0.00
## Median : 811232 Median : 811232 Median : 0 Median : 0.00
## Mean : 2759736 Mean : 2759736 Mean : 1931 Mean : 67.77
## 3rd Qu.: 830786 3rd Qu.: 830786 3rd Qu.: 0 3rd Qu.: 0.00
## Max. :62203364 Max. :62203364 Max. :1529053 Max. :130335.75
##
## IndemnityPaid OtherPaid ClaimStatus IncidentDate
## Min. : -475 Min. : -7820 Min. : 777624 Min. :1971-11-24
## 1st Qu.: 0 1st Qu.: 62 1st Qu.: 794257 1st Qu.:2000-04-11
## Median : 0 Median : 233 Median : 811232 Median :2003-01-05
## Mean : 3604 Mean : 3912 Mean : 2759736 Mean :2002-06-11
## 3rd Qu.: 0 3rd Qu.: 831 3rd Qu.: 830786 3rd Qu.:2005-11-03
## Max. :640732 Max. :4129915 Max. :62203364 Max. :2068-09-27
##
## IncidentDescription ReturnToWorkDate AverageWeeklyWage
## Length:55996 Min. :1976-10-29 Min. : 0.23
## Class :character 1st Qu.:2002-03-08 1st Qu.: 266.80
## Mode :character Median :2005-04-08 Median : 471.92
## Mean :2004-02-18 Mean : 479.64
## 3rd Qu.:2007-03-20 3rd Qu.: 625.10
## Max. :2014-06-25 Max. :96666.80
## NA's :28077 NA's :35942
## ClaimantOpenedDate ClaimantClosedDate EmployerNotificationDate
## Min. :1971-11-24 Min. :1999-06-04 Min. :1972-09-10
## 1st Qu.:2000-05-15 1st Qu.:2005-03-31 1st Qu.:2000-10-25
## Median :2003-02-18 Median :2005-05-02 Median :2003-06-28
## Mean :2002-08-13 Mean :2006-06-11 Mean :2003-03-21
## 3rd Qu.:2005-12-27 3rd Qu.:2008-05-31 3rd Qu.:2006-02-15
## Max. :2068-09-27 Max. :2014-06-25 Max. :2014-06-24
## NA's :623 NA's :4921
## ReceivedDate IsDenied ClaimantAge_at_DOI Gender
## Min. :1971-11-24 Min. :0.00000 Min. :-7550.00 Length:55996
## 1st Qu.:2000-05-12 1st Qu.:0.00000 1st Qu.: 32.00 Class :character
## Median :2003-02-11 Median :0.00000 Median : 42.00 Mode :character
## Mean :2002-08-02 Mean :0.04354 Mean : 38.34
## 3rd Qu.:2005-12-12 3rd Qu.:0.00000 3rd Qu.: 50.00
## Max. :2068-09-27 Max. :1.00000 Max. : 94.00
## NA's :20920
## ClaimantType InjuryNature BodyPartRegion BodyPart
## Length:55996 Length:55996 Length:55996 Length:55996
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## BillReviewALE Hospital PhysicianOutpatient Rx
## Min. : -456.00 Min. : -12570.4 Min. : -549.5 Min. : -469.5
## 1st Qu.: 8.25 1st Qu.: 202.5 1st Qu.: 107.3 1st Qu.: 22.7
## Median : 24.00 Median : 580.5 Median : 222.7 Median : 60.0
## Mean : 189.89 Mean : 4773.9 Mean : 1762.7 Mean : 1459.0
## 3rd Qu.: 65.20 3rd Qu.: 2298.5 3rd Qu.: 689.9 3rd Qu.: 178.3
## Max. :56475.30 Max. :2759604.0 Max. :1481468.5 Max. :631635.5
## NA's :31790 NA's :35042 NA's :3892 NA's :36229
## Total_Incurred_Cost_Claim Total_Paid_calc tiempo_de_procesamiento_days
## Min. : -10400 Min. : -82 Min. :-24649
## 1st Qu.: 61 1st Qu.: 65 1st Qu.: 379
## Median : 233 Median : 237 Median : 1190
## Mean : 9379 Mean : 7515 Mean : 1415
## 3rd Qu.: 885 3rd Qu.: 918 3rd Qu.: 1897
## Max. :4734750 Max. :4527291 Max. : 12346
## NA's :623observaciones
1.En promedio el TotalPaid es de $275,9736 por atenderlos(IndemnityPaid + OtherPaid”.
2.En promedio se hacen 1,931 reservas totales (open claims).
3.En promedio 68 pacientes se recuperan en su totalidad.
4.En promedio el seguro le paga a sus empleados por accidente $3,064.
5.En promedio los accidentados pagan $3,912 adicional por su consulta.
3.GENERAR LAS 2 REGRESIONES LINEALES
Costs of Claims
regresion <- lm(Total_Paid_calc ~ OtherPaid + Total_Incurred_Cost_Claim + IndemnityPaid + ClaimStatus + Gender + ClaimantType + InjuryNature + BodyPartRegion, data = base_act_4_6)
summary(regresion)##
## Call:
## lm(formula = Total_Paid_calc ~ OtherPaid + Total_Incurred_Cost_Claim +
## IndemnityPaid + ClaimStatus + Gender + ClaimantType + InjuryNature +
## BodyPartRegion, data = base_act_4_6)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.207e-07 -3.000e-11 1.000e-11 3.000e-11 4.931e-07
##
## Coefficients:
## Estimate
## (Intercept) 1.318e-10
## OtherPaid 1.000e+00
## Total_Incurred_Cost_Claim -5.588e-14
## IndemnityPaid 1.000e+00
## ClaimStatus -1.257e-18
## GenderMale 3.789e-11
## GenderNot Available 3.338e-11
## ClaimantTypeMedical Only -4.948e-11
## ClaimantTypeReport Only -2.716e-11
## InjuryNatureAll Other Specific Injuries, Noc 2.420e-11
## InjuryNatureAmputation 2.455e-11
## InjuryNatureAngina Pectoris 3.579e-11
## InjuryNatureAsbestosis -8.561e-12
## InjuryNatureAsphyxiation 1.134e-11
## InjuryNatureBlack Lung 1.639e-11
## InjuryNatureBurn 4.904e-11
## InjuryNatureCancer 6.548e-12
## InjuryNatureCarpal Tunnel Syndrome 5.303e-11
## InjuryNatureConcussion 3.776e-11
## InjuryNatureContagious Disease 5.520e-12
## InjuryNatureContusion 4.866e-11
## InjuryNatureCrushing 6.385e-11
## InjuryNatureDermatitis 3.431e-11
## InjuryNatureDislocation 4.534e-11
## InjuryNatureDust Disease, NOC 2.526e-11
## InjuryNatureElectric Shock 2.770e-11
## InjuryNatureForeign Body 3.591e-11
## InjuryNatureFracture 4.339e-11
## InjuryNatureFreezing 4.454e-11
## InjuryNatureHearing Loss Or Impairment 1.818e-11
## InjuryNatureHeat Prostration -3.046e-11
## InjuryNatureHernia 1.277e-11
## InjuryNatureInfection 2.863e-11
## InjuryNatureInflammation 5.295e-11
## InjuryNatureLaceration 5.796e-11
## InjuryNatureLoss of Hearing 2.554e-11
## InjuryNatureMental Disorder -2.494e-11
## InjuryNatureMental Stress -4.510e-11
## InjuryNatureMultiple Injuries Including Both Physical and Psychological -8.986e-12
## InjuryNatureMultiple Physical Injuries Only -1.325e-11
## InjuryNatureMyocardial Infarction 2.629e-11
## InjuryNatureNo Physical Injury -6.071e-12
## InjuryNatureNon-Standard Code 4.587e-11
## InjuryNatureNot Available 1.081e-10
## InjuryNaturePoisoning?Chemical (Other Than Metals) 2.048e-11
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 3.171e-11
## InjuryNaturePuncture -1.080e-10
## InjuryNatureRadiation 3.600e-11
## InjuryNatureRespiratory Disorders 2.814e-11
## InjuryNatureRupture 3.719e-11
## InjuryNatureSeverance 2.479e-11
## InjuryNatureSilicosis 4.036e-11
## InjuryNatureSprain 1.849e-10
## InjuryNatureStrain 5.023e-11
## InjuryNatureSyncope -9.901e-12
## InjuryNatureVascular -2.411e-11
## InjuryNatureVDT-Related Disease 6.866e-11
## InjuryNatureVision Loss 2.853e-11
## BodyPartRegionLower Extremities -3.525e-11
## BodyPartRegionMultiple Body Parts 7.035e-11
## BodyPartRegionNeck -9.242e-12
## BodyPartRegionNon-Standard Code -2.047e-11
## BodyPartRegionTrunk -1.425e-11
## BodyPartRegionUpper Extremities -2.988e-11
## Std. Error
## (Intercept) 1.940e-09
## OtherPaid 7.280e-16
## Total_Incurred_Cost_Claim 4.809e-16
## IndemnityPaid 9.914e-16
## ClaimStatus 4.249e-18
## GenderMale 2.445e-11
## GenderNot Available 1.030e-10
## ClaimantTypeMedical Only 3.127e-11
## ClaimantTypeReport Only 5.713e-11
## InjuryNatureAll Other Specific Injuries, Noc 1.940e-09
## InjuryNatureAmputation 2.034e-09
## InjuryNatureAngina Pectoris 2.125e-09
## InjuryNatureAsbestosis 1.996e-09
## InjuryNatureAsphyxiation 2.295e-09
## InjuryNatureBlack Lung 2.742e-09
## InjuryNatureBurn 1.943e-09
## InjuryNatureCancer 2.124e-09
## InjuryNatureCarpal Tunnel Syndrome 1.944e-09
## InjuryNatureConcussion 1.952e-09
## InjuryNatureContagious Disease 1.951e-09
## InjuryNatureContusion 1.939e-09
## InjuryNatureCrushing 1.947e-09
## InjuryNatureDermatitis 1.942e-09
## InjuryNatureDislocation 1.948e-09
## InjuryNatureDust Disease, NOC 2.375e-09
## InjuryNatureElectric Shock 1.966e-09
## InjuryNatureForeign Body 1.941e-09
## InjuryNatureFracture 1.941e-09
## InjuryNatureFreezing 2.375e-09
## InjuryNatureHearing Loss Or Impairment 2.016e-09
## InjuryNatureHeat Prostration 1.962e-09
## InjuryNatureHernia 1.962e-09
## InjuryNatureInfection 1.951e-09
## InjuryNatureInflammation 1.943e-09
## InjuryNatureLaceration 1.940e-09
## InjuryNatureLoss of Hearing 2.010e-09
## InjuryNatureMental Disorder 2.124e-09
## InjuryNatureMental Stress 1.958e-09
## InjuryNatureMultiple Injuries Including Both Physical and Psychological 2.025e-09
## InjuryNatureMultiple Physical Injuries Only 1.942e-09
## InjuryNatureMyocardial Infarction 2.073e-09
## InjuryNatureNo Physical Injury 1.942e-09
## InjuryNatureNon-Standard Code 1.964e-09
## InjuryNatureNot Available 3.362e-09
## InjuryNaturePoisoning?Chemical (Other Than Metals) 1.952e-09
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 2.005e-09
## InjuryNaturePuncture 1.940e-09
## InjuryNatureRadiation 2.018e-09
## InjuryNatureRespiratory Disorders 1.943e-09
## InjuryNatureRupture 1.973e-09
## InjuryNatureSeverance 1.975e-09
## InjuryNatureSilicosis 3.359e-09
## InjuryNatureSprain 1.940e-09
## InjuryNatureStrain 1.939e-09
## InjuryNatureSyncope 1.959e-09
## InjuryNatureVascular 2.742e-09
## InjuryNatureVDT-Related Disease 2.742e-09
## InjuryNatureVision Loss 2.051e-09
## BodyPartRegionLower Extremities 5.097e-11
## BodyPartRegionMultiple Body Parts 5.377e-11
## BodyPartRegionNeck 8.262e-11
## BodyPartRegionNon-Standard Code 3.171e-10
## BodyPartRegionTrunk 5.500e-11
## BodyPartRegionUpper Extremities 4.786e-11
## t value
## (Intercept) 6.800e-02
## OtherPaid 1.374e+15
## Total_Incurred_Cost_Claim -1.162e+02
## IndemnityPaid 1.009e+15
## ClaimStatus -2.960e-01
## GenderMale 1.550e+00
## GenderNot Available 3.240e-01
## ClaimantTypeMedical Only -1.582e+00
## ClaimantTypeReport Only -4.750e-01
## InjuryNatureAll Other Specific Injuries, Noc 1.200e-02
## InjuryNatureAmputation 1.200e-02
## InjuryNatureAngina Pectoris 1.700e-02
## InjuryNatureAsbestosis -4.000e-03
## InjuryNatureAsphyxiation 5.000e-03
## InjuryNatureBlack Lung 6.000e-03
## InjuryNatureBurn 2.500e-02
## InjuryNatureCancer 3.000e-03
## InjuryNatureCarpal Tunnel Syndrome 2.700e-02
## InjuryNatureConcussion 1.900e-02
## InjuryNatureContagious Disease 3.000e-03
## InjuryNatureContusion 2.500e-02
## InjuryNatureCrushing 3.300e-02
## InjuryNatureDermatitis 1.800e-02
## InjuryNatureDislocation 2.300e-02
## InjuryNatureDust Disease, NOC 1.100e-02
## InjuryNatureElectric Shock 1.400e-02
## InjuryNatureForeign Body 1.900e-02
## InjuryNatureFracture 2.200e-02
## InjuryNatureFreezing 1.900e-02
## InjuryNatureHearing Loss Or Impairment 9.000e-03
## InjuryNatureHeat Prostration -1.600e-02
## InjuryNatureHernia 7.000e-03
## InjuryNatureInfection 1.500e-02
## InjuryNatureInflammation 2.700e-02
## InjuryNatureLaceration 3.000e-02
## InjuryNatureLoss of Hearing 1.300e-02
## InjuryNatureMental Disorder -1.200e-02
## InjuryNatureMental Stress -2.300e-02
## InjuryNatureMultiple Injuries Including Both Physical and Psychological -4.000e-03
## InjuryNatureMultiple Physical Injuries Only -7.000e-03
## InjuryNatureMyocardial Infarction 1.300e-02
## InjuryNatureNo Physical Injury -3.000e-03
## InjuryNatureNon-Standard Code 2.300e-02
## InjuryNatureNot Available 3.200e-02
## InjuryNaturePoisoning?Chemical (Other Than Metals) 1.000e-02
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 1.600e-02
## InjuryNaturePuncture -5.600e-02
## InjuryNatureRadiation 1.800e-02
## InjuryNatureRespiratory Disorders 1.400e-02
## InjuryNatureRupture 1.900e-02
## InjuryNatureSeverance 1.300e-02
## InjuryNatureSilicosis 1.200e-02
## InjuryNatureSprain 9.500e-02
## InjuryNatureStrain 2.600e-02
## InjuryNatureSyncope -5.000e-03
## InjuryNatureVascular -9.000e-03
## InjuryNatureVDT-Related Disease 2.500e-02
## InjuryNatureVision Loss 1.400e-02
## BodyPartRegionLower Extremities -6.920e-01
## BodyPartRegionMultiple Body Parts 1.308e+00
## BodyPartRegionNeck -1.120e-01
## BodyPartRegionNon-Standard Code -6.500e-02
## BodyPartRegionTrunk -2.590e-01
## BodyPartRegionUpper Extremities -6.240e-01
## Pr(>|t|)
## (Intercept) 0.946
## OtherPaid <2e-16
## Total_Incurred_Cost_Claim <2e-16
## IndemnityPaid <2e-16
## ClaimStatus 0.767
## GenderMale 0.121
## GenderNot Available 0.746
## ClaimantTypeMedical Only 0.114
## ClaimantTypeReport Only 0.634
## InjuryNatureAll Other Specific Injuries, Noc 0.990
## InjuryNatureAmputation 0.990
## InjuryNatureAngina Pectoris 0.987
## InjuryNatureAsbestosis 0.997
## InjuryNatureAsphyxiation 0.996
## InjuryNatureBlack Lung 0.995
## InjuryNatureBurn 0.980
## InjuryNatureCancer 0.998
## InjuryNatureCarpal Tunnel Syndrome 0.978
## InjuryNatureConcussion 0.985
## InjuryNatureContagious Disease 0.998
## InjuryNatureContusion 0.980
## InjuryNatureCrushing 0.974
## InjuryNatureDermatitis 0.986
## InjuryNatureDislocation 0.981
## InjuryNatureDust Disease, NOC 0.992
## InjuryNatureElectric Shock 0.989
## InjuryNatureForeign Body 0.985
## InjuryNatureFracture 0.982
## InjuryNatureFreezing 0.985
## InjuryNatureHearing Loss Or Impairment 0.993
## InjuryNatureHeat Prostration 0.988
## InjuryNatureHernia 0.995
## InjuryNatureInfection 0.988
## InjuryNatureInflammation 0.978
## InjuryNatureLaceration 0.976
## InjuryNatureLoss of Hearing 0.990
## InjuryNatureMental Disorder 0.991
## InjuryNatureMental Stress 0.982
## InjuryNatureMultiple Injuries Including Both Physical and Psychological 0.996
## InjuryNatureMultiple Physical Injuries Only 0.995
## InjuryNatureMyocardial Infarction 0.990
## InjuryNatureNo Physical Injury 0.998
## InjuryNatureNon-Standard Code 0.981
## InjuryNatureNot Available 0.974
## InjuryNaturePoisoning?Chemical (Other Than Metals) 0.992
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 0.987
## InjuryNaturePuncture 0.956
## InjuryNatureRadiation 0.986
## InjuryNatureRespiratory Disorders 0.988
## InjuryNatureRupture 0.985
## InjuryNatureSeverance 0.990
## InjuryNatureSilicosis 0.990
## InjuryNatureSprain 0.924
## InjuryNatureStrain 0.979
## InjuryNatureSyncope 0.996
## InjuryNatureVascular 0.993
## InjuryNatureVDT-Related Disease 0.980
## InjuryNatureVision Loss 0.989
## BodyPartRegionLower Extremities 0.489
## BodyPartRegionMultiple Body Parts 0.191
## BodyPartRegionNeck 0.911
## BodyPartRegionNon-Standard Code 0.949
## BodyPartRegionTrunk 0.796
## BodyPartRegionUpper Extremities 0.532
##
## (Intercept)
## OtherPaid ***
## Total_Incurred_Cost_Claim ***
## IndemnityPaid ***
## ClaimStatus
## GenderMale
## GenderNot Available
## ClaimantTypeMedical Only
## ClaimantTypeReport Only
## InjuryNatureAll Other Specific Injuries, Noc
## InjuryNatureAmputation
## InjuryNatureAngina Pectoris
## InjuryNatureAsbestosis
## InjuryNatureAsphyxiation
## InjuryNatureBlack Lung
## InjuryNatureBurn
## InjuryNatureCancer
## InjuryNatureCarpal Tunnel Syndrome
## InjuryNatureConcussion
## InjuryNatureContagious Disease
## InjuryNatureContusion
## InjuryNatureCrushing
## InjuryNatureDermatitis
## InjuryNatureDislocation
## InjuryNatureDust Disease, NOC
## InjuryNatureElectric Shock
## InjuryNatureForeign Body
## InjuryNatureFracture
## InjuryNatureFreezing
## InjuryNatureHearing Loss Or Impairment
## InjuryNatureHeat Prostration
## InjuryNatureHernia
## InjuryNatureInfection
## InjuryNatureInflammation
## InjuryNatureLaceration
## InjuryNatureLoss of Hearing
## InjuryNatureMental Disorder
## InjuryNatureMental Stress
## InjuryNatureMultiple Injuries Including Both Physical and Psychological
## InjuryNatureMultiple Physical Injuries Only
## InjuryNatureMyocardial Infarction
## InjuryNatureNo Physical Injury
## InjuryNatureNon-Standard Code
## InjuryNatureNot Available
## InjuryNaturePoisoning?Chemical (Other Than Metals)
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury)
## InjuryNaturePuncture
## InjuryNatureRadiation
## InjuryNatureRespiratory Disorders
## InjuryNatureRupture
## InjuryNatureSeverance
## InjuryNatureSilicosis
## InjuryNatureSprain
## InjuryNatureStrain
## InjuryNatureSyncope
## InjuryNatureVascular
## InjuryNatureVDT-Related Disease
## InjuryNatureVision Loss
## BodyPartRegionLower Extremities
## BodyPartRegionMultiple Body Parts
## BodyPartRegionNeck
## BodyPartRegionNon-Standard Code
## BodyPartRegionTrunk
## BodyPartRegionUpper Extremities
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 2.742e-09 on 55932 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.494e+29 on 63 and 55932 DF, p-value: < 2.2e-16Time To Process Claims
regresion2 <- lm(tiempo_de_procesamiento_days ~ BodyPart + BodyPartRegion + InjuryNature + ClaimantType + ClaimantAge_at_DOI, data = base_act_4_6)
summary(regresion2)##
## Call:
## lm(formula = tiempo_de_procesamiento_days ~ BodyPart + BodyPartRegion +
## InjuryNature + ClaimantType + ClaimantAge_at_DOI, data = base_act_4_6)
##
## Residuals:
## Min 1Q Median 3Q Max
## -20884.3 -634.0 -208.5 473.5 10497.0
##
## Coefficients: (6 not defined because of singularities)
## Estimate
## (Intercept) 202.18631
## BodyPartAnkle 255.55145
## BodyPartArtificial Appliance -33.75461
## BodyPartBody Systems and Multiple Body Systems -75.28881
## BodyPartBrain -72.62472
## BodyPartButtocks 66.33402
## BodyPartChest 198.05993
## BodyPartDisc-Trunk 321.51754
## BodyPartEar(S) 88.90459
## BodyPartElbow 160.00558
## BodyPartEyes -5.80733
## BodyPartFacial Bones 182.23095
## BodyPartFinger(S) 284.24195
## BodyPartFoot 204.56940
## BodyPartGreat Toe -33.47004
## BodyPartHand 227.24357
## BodyPartHeart 192.92790
## BodyPartHip 244.46030
## BodyPartInsufficient Info to Properly Identify?Unclassified -113.85722
## BodyPartInternal Organs 702.47756
## BodyPartKnee 212.66548
## BodyPartLarynx 452.46540
## BodyPartLower Arm 60.14031
## BodyPartLower Back Area 276.35022
## BodyPartLower Leg 157.94919
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 151.46118
## BodyPartLungs -257.73944
## BodyPartMouth 250.39181
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) 388.62757
## BodyPartMultiple Head Injury 110.96365
## BodyPartMultiple Lower Extremities 370.87428
## BodyPartMultiple Neck Injury 170.46232
## BodyPartMultiple Trunk 496.12573
## BodyPartMultiple Upper Extremities 595.44895
## BodyPartNo Physical Injury 102.34640
## BodyPartNon-Standard Code 2399.26046
## BodyPartNose 198.74390
## BodyPartPelvis -68.47841
## BodyPartSacrum And Coccyx -135.67425
## BodyPartShoulder(S) 102.87217
## BodyPartSkull 206.20730
## BodyPartSoft Tissue-Head 3223.10998
## BodyPartSoft Tissue-Neck -126.43392
## BodyPartSpinal Cord-Trunk 123.72400
## BodyPartTeeth -185.91704
## BodyPartThumb 105.69789
## BodyPartToes 0.24793
## BodyPartTrachea 18.86028
## BodyPartUpper Arm 619.01825
## BodyPartUpper Back Area 105.02683
## BodyPartUpper Leg 122.95884
## BodyPartVertebrae 825.97829
## BodyPartWhole Body 1031.47950
## BodyPartWrist 223.46821
## BodyPartRegionLower Extremities NA
## BodyPartRegionMultiple Body Parts NA
## BodyPartRegionNeck NA
## BodyPartRegionNon-Standard Code NA
## BodyPartRegionTrunk NA
## BodyPartRegionUpper Extremities NA
## InjuryNatureAll Other Specific Injuries, Noc 1547.29324
## InjuryNatureAmputation 856.79393
## InjuryNatureAngina Pectoris -104.10030
## InjuryNatureAsbestosis 1286.63297
## InjuryNatureAsphyxiation 1125.87276
## InjuryNatureBlack Lung 880.23818
## InjuryNatureBurn 655.14182
## InjuryNatureCancer 1010.24554
## InjuryNatureCarpal Tunnel Syndrome 456.81459
## InjuryNatureConcussion 559.06841
## InjuryNatureContagious Disease 983.43927
## InjuryNatureContusion 692.62421
## InjuryNatureCrushing 389.90231
## InjuryNatureDermatitis 534.76655
## InjuryNatureDislocation 667.16129
## InjuryNatureDust Disease, NOC 621.71726
## InjuryNatureElectric Shock 832.73068
## InjuryNatureForeign Body 1004.96425
## InjuryNatureFracture 490.39241
## InjuryNatureFreezing 2005.08117
## InjuryNatureHearing Loss Or Impairment 1316.32884
## InjuryNatureHeat Prostration 674.35220
## InjuryNatureHernia 532.06112
## InjuryNatureInfection 544.23215
## InjuryNatureInflammation 572.95419
## InjuryNatureLaceration 641.20974
## InjuryNatureLoss of Hearing 1043.58625
## InjuryNatureMental Disorder 1666.04565
## InjuryNatureMental Stress 584.45954
## InjuryNatureMultiple Injuries Including Both Physical and Psychological 40.82780
## InjuryNatureMultiple Physical Injuries Only 204.58006
## InjuryNatureMyocardial Infarction 237.49453
## InjuryNatureNo Physical Injury 674.37018
## InjuryNatureNon-Standard Code 688.09248
## InjuryNatureNot Available -305.51910
## InjuryNaturePoisoning?Chemical (Other Than Metals) 1181.05551
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 516.36992
## InjuryNaturePuncture 622.28550
## InjuryNatureRadiation 1003.68270
## InjuryNatureRespiratory Disorders 781.05253
## InjuryNatureRupture 524.37594
## InjuryNatureSeverance 1768.20727
## InjuryNatureSprain 497.85551
## InjuryNatureStrain 625.51783
## InjuryNatureSyncope 742.82062
## InjuryNatureVascular 422.29803
## InjuryNatureVDT-Related Disease 689.44043
## InjuryNatureVision Loss 399.19480
## ClaimantTypeMedical Only -220.34761
## ClaimantTypeReport Only -178.01812
## ClaimantAge_at_DOI -0.06151
## Std. Error
## (Intercept) 627.68139
## BodyPartAnkle 55.19846
## BodyPartArtificial Appliance 398.72657
## BodyPartBody Systems and Multiple Body Systems 88.91171
## BodyPartBrain 533.15964
## BodyPartButtocks 94.72219
## BodyPartChest 60.77388
## BodyPartDisc-Trunk 73.97543
## BodyPartEar(S) 106.64049
## BodyPartElbow 61.67213
## BodyPartEyes 57.79008
## BodyPartFacial Bones 73.56724
## BodyPartFinger(S) 52.66390
## BodyPartFoot 56.59334
## BodyPartGreat Toe 109.99069
## BodyPartHand 52.86533
## BodyPartHeart 355.05363
## BodyPartHip 68.19487
## BodyPartInsufficient Info to Properly Identify?Unclassified 71.46757
## BodyPartInternal Organs 135.76771
## BodyPartKnee 51.44050
## BodyPartLarynx 885.24401
## BodyPartLower Arm 57.82462
## BodyPartLower Back Area 51.26376
## BodyPartLower Leg 58.51294
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 62.20155
## BodyPartLungs 92.72161
## BodyPartMouth 81.17905
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) 51.19265
## BodyPartMultiple Head Injury 55.94204
## BodyPartMultiple Lower Extremities 65.61772
## BodyPartMultiple Neck Injury 58.57630
## BodyPartMultiple Trunk 126.46046
## BodyPartMultiple Upper Extremities 62.39849
## BodyPartNo Physical Injury 78.29149
## BodyPartNon-Standard Code 128.14008
## BodyPartNose 85.24849
## BodyPartPelvis 117.14371
## BodyPartSacrum And Coccyx 166.19242
## BodyPartShoulder(S) 53.50359
## BodyPartSkull 162.73081
## BodyPartSoft Tissue-Head 887.76616
## BodyPartSoft Tissue-Neck 70.27669
## BodyPartSpinal Cord-Trunk 163.85519
## BodyPartTeeth 103.48633
## BodyPartThumb 58.63794
## BodyPartToes 80.87833
## BodyPartTrachea 340.74791
## BodyPartUpper Arm 63.62114
## BodyPartUpper Back Area 72.37912
## BodyPartUpper Leg 71.63079
## BodyPartVertebrae 364.25566
## BodyPartWhole Body 512.68417
## BodyPartWrist 54.46555
## BodyPartRegionLower Extremities NA
## BodyPartRegionMultiple Body Parts NA
## BodyPartRegionNeck NA
## BodyPartRegionNon-Standard Code NA
## BodyPartRegionTrunk NA
## BodyPartRegionUpper Extremities NA
## InjuryNatureAll Other Specific Injuries, Noc 626.14715
## InjuryNatureAmputation 675.83700
## InjuryNatureAngina Pectoris 689.68976
## InjuryNatureAsbestosis 647.78637
## InjuryNatureAsphyxiation 884.76722
## InjuryNatureBlack Lung 1085.61437
## InjuryNatureBurn 627.47248
## InjuryNatureCancer 740.53696
## InjuryNatureCarpal Tunnel Syndrome 628.47267
## InjuryNatureConcussion 631.69755
## InjuryNatureContagious Disease 632.55827
## InjuryNatureContusion 625.84888
## InjuryNatureCrushing 629.22164
## InjuryNatureDermatitis 627.05089
## InjuryNatureDislocation 629.56703
## InjuryNatureDust Disease, NOC 768.17403
## InjuryNatureElectric Shock 639.11585
## InjuryNatureForeign Body 626.76925
## InjuryNatureFracture 626.46290
## InjuryNatureFreezing 807.65388
## InjuryNatureHearing Loss Or Impairment 662.96788
## InjuryNatureHeat Prostration 636.84376
## InjuryNatureHernia 635.62416
## InjuryNatureInfection 631.16353
## InjuryNatureInflammation 627.38484
## InjuryNatureLaceration 625.98979
## InjuryNatureLoss of Hearing 670.28709
## InjuryNatureMental Disorder 747.26375
## InjuryNatureMental Stress 634.52534
## InjuryNatureMultiple Injuries Including Both Physical and Psychological 659.58882
## InjuryNatureMultiple Physical Injuries Only 626.95741
## InjuryNatureMyocardial Infarction 715.17178
## InjuryNatureNo Physical Injury 626.54476
## InjuryNatureNon-Standard Code 635.88464
## InjuryNatureNot Available 1083.23581
## InjuryNaturePoisoning?Chemical (Other Than Metals) 635.80977
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 656.17367
## InjuryNaturePuncture 626.15416
## InjuryNatureRadiation 666.12637
## InjuryNatureRespiratory Disorders 628.90677
## InjuryNatureRupture 642.08255
## InjuryNatureSeverance 672.60425
## InjuryNatureSprain 626.09014
## InjuryNatureStrain 625.90443
## InjuryNatureSyncope 635.27117
## InjuryNatureVascular 1083.19862
## InjuryNatureVDT-Related Disease 1083.68974
## InjuryNatureVision Loss 672.72667
## ClaimantTypeMedical Only 12.15975
## ClaimantTypeReport Only 27.45158
## ClaimantAge_at_DOI 0.03441
## t value
## (Intercept) 0.322
## BodyPartAnkle 4.630
## BodyPartArtificial Appliance -0.085
## BodyPartBody Systems and Multiple Body Systems -0.847
## BodyPartBrain -0.136
## BodyPartButtocks 0.700
## BodyPartChest 3.259
## BodyPartDisc-Trunk 4.346
## BodyPartEar(S) 0.834
## BodyPartElbow 2.594
## BodyPartEyes -0.100
## BodyPartFacial Bones 2.477
## BodyPartFinger(S) 5.397
## BodyPartFoot 3.615
## BodyPartGreat Toe -0.304
## BodyPartHand 4.299
## BodyPartHeart 0.543
## BodyPartHip 3.585
## BodyPartInsufficient Info to Properly Identify?Unclassified -1.593
## BodyPartInternal Organs 5.174
## BodyPartKnee 4.134
## BodyPartLarynx 0.511
## BodyPartLower Arm 1.040
## BodyPartLower Back Area 5.391
## BodyPartLower Leg 2.699
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 2.435
## BodyPartLungs -2.780
## BodyPartMouth 3.084
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) 7.591
## BodyPartMultiple Head Injury 1.984
## BodyPartMultiple Lower Extremities 5.652
## BodyPartMultiple Neck Injury 2.910
## BodyPartMultiple Trunk 3.923
## BodyPartMultiple Upper Extremities 9.543
## BodyPartNo Physical Injury 1.307
## BodyPartNon-Standard Code 18.724
## BodyPartNose 2.331
## BodyPartPelvis -0.585
## BodyPartSacrum And Coccyx -0.816
## BodyPartShoulder(S) 1.923
## BodyPartSkull 1.267
## BodyPartSoft Tissue-Head 3.631
## BodyPartSoft Tissue-Neck -1.799
## BodyPartSpinal Cord-Trunk 0.755
## BodyPartTeeth -1.797
## BodyPartThumb 1.803
## BodyPartToes 0.003
## BodyPartTrachea 0.055
## BodyPartUpper Arm 9.730
## BodyPartUpper Back Area 1.451
## BodyPartUpper Leg 1.717
## BodyPartVertebrae 2.268
## BodyPartWhole Body 2.012
## BodyPartWrist 4.103
## BodyPartRegionLower Extremities NA
## BodyPartRegionMultiple Body Parts NA
## BodyPartRegionNeck NA
## BodyPartRegionNon-Standard Code NA
## BodyPartRegionTrunk NA
## BodyPartRegionUpper Extremities NA
## InjuryNatureAll Other Specific Injuries, Noc 2.471
## InjuryNatureAmputation 1.268
## InjuryNatureAngina Pectoris -0.151
## InjuryNatureAsbestosis 1.986
## InjuryNatureAsphyxiation 1.273
## InjuryNatureBlack Lung 0.811
## InjuryNatureBurn 1.044
## InjuryNatureCancer 1.364
## InjuryNatureCarpal Tunnel Syndrome 0.727
## InjuryNatureConcussion 0.885
## InjuryNatureContagious Disease 1.555
## InjuryNatureContusion 1.107
## InjuryNatureCrushing 0.620
## InjuryNatureDermatitis 0.853
## InjuryNatureDislocation 1.060
## InjuryNatureDust Disease, NOC 0.809
## InjuryNatureElectric Shock 1.303
## InjuryNatureForeign Body 1.603
## InjuryNatureFracture 0.783
## InjuryNatureFreezing 2.483
## InjuryNatureHearing Loss Or Impairment 1.986
## InjuryNatureHeat Prostration 1.059
## InjuryNatureHernia 0.837
## InjuryNatureInfection 0.862
## InjuryNatureInflammation 0.913
## InjuryNatureLaceration 1.024
## InjuryNatureLoss of Hearing 1.557
## InjuryNatureMental Disorder 2.230
## InjuryNatureMental Stress 0.921
## InjuryNatureMultiple Injuries Including Both Physical and Psychological 0.062
## InjuryNatureMultiple Physical Injuries Only 0.326
## InjuryNatureMyocardial Infarction 0.332
## InjuryNatureNo Physical Injury 1.076
## InjuryNatureNon-Standard Code 1.082
## InjuryNatureNot Available -0.282
## InjuryNaturePoisoning?Chemical (Other Than Metals) 1.858
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 0.787
## InjuryNaturePuncture 0.994
## InjuryNatureRadiation 1.507
## InjuryNatureRespiratory Disorders 1.242
## InjuryNatureRupture 0.817
## InjuryNatureSeverance 2.629
## InjuryNatureSprain 0.795
## InjuryNatureStrain 0.999
## InjuryNatureSyncope 1.169
## InjuryNatureVascular 0.390
## InjuryNatureVDT-Related Disease 0.636
## InjuryNatureVision Loss 0.593
## ClaimantTypeMedical Only -18.121
## ClaimantTypeReport Only -6.485
## ClaimantAge_at_DOI -1.788
## Pr(>|t|)
## (Intercept) 0.747367
## BodyPartAnkle 3.68e-06
## BodyPartArtificial Appliance 0.932535
## BodyPartBody Systems and Multiple Body Systems 0.397123
## BodyPartBrain 0.891652
## BodyPartButtocks 0.483744
## BodyPartChest 0.001119
## BodyPartDisc-Trunk 1.39e-05
## BodyPartEar(S) 0.404464
## BodyPartElbow 0.009478
## BodyPartEyes 0.919956
## BodyPartFacial Bones 0.013251
## BodyPartFinger(S) 6.81e-08
## BodyPartFoot 0.000301
## BodyPartGreat Toe 0.760902
## BodyPartHand 1.72e-05
## BodyPartHeart 0.586874
## BodyPartHip 0.000338
## BodyPartInsufficient Info to Properly Identify?Unclassified 0.111140
## BodyPartInternal Organs 2.30e-07
## BodyPartKnee 3.57e-05
## BodyPartLarynx 0.609271
## BodyPartLower Arm 0.298326
## BodyPartLower Back Area 7.06e-08
## BodyPartLower Leg 0.006950
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 0.014897
## BodyPartLungs 0.005444
## BodyPartMouth 0.002041
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) 3.24e-14
## BodyPartMultiple Head Injury 0.047314
## BodyPartMultiple Lower Extremities 1.60e-08
## BodyPartMultiple Neck Injury 0.003616
## BodyPartMultiple Trunk 8.76e-05
## BodyPartMultiple Upper Extremities < 2e-16
## BodyPartNo Physical Injury 0.191137
## BodyPartNon-Standard Code < 2e-16
## BodyPartNose 0.019741
## BodyPartPelvis 0.558842
## BodyPartSacrum And Coccyx 0.414295
## BodyPartShoulder(S) 0.054524
## BodyPartSkull 0.205104
## BodyPartSoft Tissue-Head 0.000283
## BodyPartSoft Tissue-Neck 0.072014
## BodyPartSpinal Cord-Trunk 0.450205
## BodyPartTeeth 0.072418
## BodyPartThumb 0.071467
## BodyPartToes 0.997554
## BodyPartTrachea 0.955860
## BodyPartUpper Arm < 2e-16
## BodyPartUpper Back Area 0.146771
## BodyPartUpper Leg 0.086068
## BodyPartVertebrae 0.023361
## BodyPartWhole Body 0.044236
## BodyPartWrist 4.09e-05
## BodyPartRegionLower Extremities NA
## BodyPartRegionMultiple Body Parts NA
## BodyPartRegionNeck NA
## BodyPartRegionNon-Standard Code NA
## BodyPartRegionTrunk NA
## BodyPartRegionUpper Extremities NA
## InjuryNatureAll Other Specific Injuries, Noc 0.013473
## InjuryNatureAmputation 0.204895
## InjuryNatureAngina Pectoris 0.880026
## InjuryNatureAsbestosis 0.047019
## InjuryNatureAsphyxiation 0.203202
## InjuryNatureBlack Lung 0.417474
## InjuryNatureBurn 0.296448
## InjuryNatureCancer 0.172511
## InjuryNatureCarpal Tunnel Syndrome 0.467314
## InjuryNatureConcussion 0.376149
## InjuryNatureContagious Disease 0.120026
## InjuryNatureContusion 0.268433
## InjuryNatureCrushing 0.535487
## InjuryNatureDermatitis 0.393761
## InjuryNatureDislocation 0.289282
## InjuryNatureDust Disease, NOC 0.418323
## InjuryNatureElectric Shock 0.192603
## InjuryNatureForeign Body 0.108855
## InjuryNatureFracture 0.433753
## InjuryNatureFreezing 0.013047
## InjuryNatureHearing Loss Or Impairment 0.047096
## InjuryNatureHeat Prostration 0.289654
## InjuryNatureHernia 0.402560
## InjuryNatureInfection 0.388546
## InjuryNatureInflammation 0.361122
## InjuryNatureLaceration 0.305694
## InjuryNatureLoss of Hearing 0.119498
## InjuryNatureMental Disorder 0.025785
## InjuryNatureMental Stress 0.357006
## InjuryNatureMultiple Injuries Including Both Physical and Psychological 0.950644
## InjuryNatureMultiple Physical Injuries Only 0.744195
## InjuryNatureMyocardial Infarction 0.739831
## InjuryNatureNo Physical Injury 0.281786
## InjuryNatureNon-Standard Code 0.279214
## InjuryNatureNot Available 0.777912
## InjuryNaturePoisoning?Chemical (Other Than Metals) 0.063240
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury) 0.431322
## InjuryNaturePuncture 0.320317
## InjuryNatureRadiation 0.131885
## InjuryNatureRespiratory Disorders 0.214274
## InjuryNatureRupture 0.414117
## InjuryNatureSeverance 0.008570
## InjuryNatureSprain 0.426513
## InjuryNatureStrain 0.317617
## InjuryNatureSyncope 0.242292
## InjuryNatureVascular 0.696641
## InjuryNatureVDT-Related Disease 0.524652
## InjuryNatureVision Loss 0.552919
## ClaimantTypeMedical Only < 2e-16
## ClaimantTypeReport Only 9.01e-11
## ClaimantAge_at_DOI 0.073827
##
## (Intercept)
## BodyPartAnkle ***
## BodyPartArtificial Appliance
## BodyPartBody Systems and Multiple Body Systems
## BodyPartBrain
## BodyPartButtocks
## BodyPartChest **
## BodyPartDisc-Trunk ***
## BodyPartEar(S)
## BodyPartElbow **
## BodyPartEyes
## BodyPartFacial Bones *
## BodyPartFinger(S) ***
## BodyPartFoot ***
## BodyPartGreat Toe
## BodyPartHand ***
## BodyPartHeart
## BodyPartHip ***
## BodyPartInsufficient Info to Properly Identify?Unclassified
## BodyPartInternal Organs ***
## BodyPartKnee ***
## BodyPartLarynx
## BodyPartLower Arm
## BodyPartLower Back Area ***
## BodyPartLower Leg **
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) *
## BodyPartLungs **
## BodyPartMouth **
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) ***
## BodyPartMultiple Head Injury *
## BodyPartMultiple Lower Extremities ***
## BodyPartMultiple Neck Injury **
## BodyPartMultiple Trunk ***
## BodyPartMultiple Upper Extremities ***
## BodyPartNo Physical Injury
## BodyPartNon-Standard Code ***
## BodyPartNose *
## BodyPartPelvis
## BodyPartSacrum And Coccyx
## BodyPartShoulder(S) .
## BodyPartSkull
## BodyPartSoft Tissue-Head ***
## BodyPartSoft Tissue-Neck .
## BodyPartSpinal Cord-Trunk
## BodyPartTeeth .
## BodyPartThumb .
## BodyPartToes
## BodyPartTrachea
## BodyPartUpper Arm ***
## BodyPartUpper Back Area
## BodyPartUpper Leg .
## BodyPartVertebrae *
## BodyPartWhole Body *
## BodyPartWrist ***
## BodyPartRegionLower Extremities
## BodyPartRegionMultiple Body Parts
## BodyPartRegionNeck
## BodyPartRegionNon-Standard Code
## BodyPartRegionTrunk
## BodyPartRegionUpper Extremities
## InjuryNatureAll Other Specific Injuries, Noc *
## InjuryNatureAmputation
## InjuryNatureAngina Pectoris
## InjuryNatureAsbestosis *
## InjuryNatureAsphyxiation
## InjuryNatureBlack Lung
## InjuryNatureBurn
## InjuryNatureCancer
## InjuryNatureCarpal Tunnel Syndrome
## InjuryNatureConcussion
## InjuryNatureContagious Disease
## InjuryNatureContusion
## InjuryNatureCrushing
## InjuryNatureDermatitis
## InjuryNatureDislocation
## InjuryNatureDust Disease, NOC
## InjuryNatureElectric Shock
## InjuryNatureForeign Body
## InjuryNatureFracture
## InjuryNatureFreezing *
## InjuryNatureHearing Loss Or Impairment *
## InjuryNatureHeat Prostration
## InjuryNatureHernia
## InjuryNatureInfection
## InjuryNatureInflammation
## InjuryNatureLaceration
## InjuryNatureLoss of Hearing
## InjuryNatureMental Disorder *
## InjuryNatureMental Stress
## InjuryNatureMultiple Injuries Including Both Physical and Psychological
## InjuryNatureMultiple Physical Injuries Only
## InjuryNatureMyocardial Infarction
## InjuryNatureNo Physical Injury
## InjuryNatureNon-Standard Code
## InjuryNatureNot Available
## InjuryNaturePoisoning?Chemical (Other Than Metals) .
## InjuryNaturePoisoning?General (NOT OD or Cumulative Injury)
## InjuryNaturePuncture
## InjuryNatureRadiation
## InjuryNatureRespiratory Disorders
## InjuryNatureRupture
## InjuryNatureSeverance **
## InjuryNatureSprain
## InjuryNatureStrain
## InjuryNatureSyncope
## InjuryNatureVascular
## InjuryNatureVDT-Related Disease
## InjuryNatureVision Loss
## ClaimantTypeMedical Only ***
## ClaimantTypeReport Only ***
## ClaimantAge_at_DOI .
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 883.8 on 34349 degrees of freedom
## (21542 observations deleted due to missingness)
## Multiple R-squared: 0.1704, Adjusted R-squared: 0.1678
## F-statistic: 67.82 on 104 and 34349 DF, p-value: < 2.2e-164.AJUSTAR EL MODELO
Costs of Claims
regresion <- lm(Total_Paid_calc~OtherPaid + IndemnityPaid +Total_Incurred_Cost_Claim ,data=base_act_4_6)
summary(regresion)##
## Call:
## lm(formula = Total_Paid_calc ~ OtherPaid + IndemnityPaid + Total_Incurred_Cost_Claim,
## data = base_act_4_6)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.311e-07 0.000e+00 0.000e+00 0.000e+00 4.934e-07
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.146e-10 1.189e-11 9.644e+00 <2e-16 ***
## OtherPaid 1.000e+00 7.318e-16 1.366e+15 <2e-16 ***
## IndemnityPaid 1.000e+00 9.785e-16 1.022e+15 <2e-16 ***
## Total_Incurred_Cost_Claim 3.472e-17 4.843e-16 7.200e-02 0.943
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 2.77e-09 on 55992 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 5.134e+30 on 3 and 55992 DF, p-value: < 2.2e-16Time To Process Claims
regresion2 <- lm(tiempo_de_procesamiento_days ~ BodyPart + ClaimantType, data = base_act_4_6)
summary(regresion2)##
## Call:
## lm(formula = tiempo_de_procesamiento_days ~ BodyPart + ClaimantType,
## data = base_act_4_6)
##
## Residuals:
## Min 1Q Median 3Q Max
## -28081.6 -849.5 -119.0 576.6 11331.8
##
## Coefficients:
## Estimate
## (Intercept) 1002.1819
## BodyPartAnkle 322.3060
## BodyPartArtificial Appliance -0.6105
## BodyPartBody Systems and Multiple Body Systems 315.0659
## BodyPartBrain 61.4848
## BodyPartButtocks 49.0077
## BodyPartChest 317.9346
## BodyPartDisc-Trunk 479.5033
## BodyPartEar(S) 455.5269
## BodyPartElbow 112.3145
## BodyPartEyes 385.5396
## BodyPartFacial Bones 299.2545
## BodyPartFinger(S) 503.0461
## BodyPartFoot 329.3083
## BodyPartGreat Toe -117.4582
## BodyPartHand 394.6121
## BodyPartHeart -73.0009
## BodyPartHip 432.8207
## BodyPartInsufficient Info to Properly Identify?Unclassified 380.0168
## BodyPartInternal Organs 1154.9771
## BodyPartKnee 289.7935
## BodyPartLarynx -174.8605
## BodyPartLower Arm 16.4740
## BodyPartLower Back Area 430.5773
## BodyPartLower Leg 122.0593
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 146.8892
## BodyPartLungs -89.4470
## BodyPartMouth 647.5287
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) 636.8851
## BodyPartMultiple Head Injury 354.0325
## BodyPartMultiple Lower Extremities 764.7961
## BodyPartMultiple Neck Injury 265.5885
## BodyPartMultiple Trunk 783.4030
## BodyPartMultiple Upper Extremities 1179.0864
## BodyPartNo Physical Injury 273.5873
## BodyPartNon-Standard Code 2430.4420
## BodyPartNose 345.4083
## BodyPartPelvis -85.7689
## BodyPartSacrum And Coccyx -236.5589
## BodyPartShoulder(S) 12.0675
## BodyPartSkull 22.9813
## BodyPartSoft Tissue-Head 2809.8181
## BodyPartSoft Tissue-Neck -134.3200
## BodyPartSpinal Cord-Trunk -26.7734
## BodyPartTeeth -111.2717
## BodyPartThumb 117.5862
## BodyPartToes 275.1609
## BodyPartTrachea 140.4292
## BodyPartUpper Arm 830.5401
## BodyPartUpper Back Area 80.9959
## BodyPartUpper Leg 140.6244
## BodyPartVertebrae 644.2645
## BodyPartWhole Body 876.1514
## BodyPartWrist 298.0876
## ClaimantTypeMedical Only -154.6428
## ClaimantTypeReport Only -62.4011
## Std. Error
## (Intercept) 49.5561
## BodyPartAnkle 53.7020
## BodyPartArtificial Appliance 358.6766
## BodyPartBody Systems and Multiple Body Systems 81.9628
## BodyPartBrain 617.4217
## BodyPartButtocks 96.3325
## BodyPartChest 60.7077
## BodyPartDisc-Trunk 67.0868
## BodyPartEar(S) 91.5147
## BodyPartElbow 62.1020
## BodyPartEyes 54.2407
## BodyPartFacial Bones 72.0283
## BodyPartFinger(S) 51.7801
## BodyPartFoot 55.7742
## BodyPartGreat Toe 118.7902
## BodyPartHand 52.4309
## BodyPartHeart 255.9932
## BodyPartHip 67.4145
## BodyPartInsufficient Info to Properly Identify?Unclassified 69.0334
## BodyPartInternal Organs 125.5394
## BodyPartKnee 51.3693
## BodyPartLarynx 755.3329
## BodyPartLower Arm 58.6077
## BodyPartLower Back Area 51.0431
## BodyPartLower Leg 59.1066
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 62.4446
## BodyPartLungs 79.1904
## BodyPartMouth 77.8510
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) 50.7613
## BodyPartMultiple Head Injury 55.0940
## BodyPartMultiple Lower Extremities 64.4578
## BodyPartMultiple Neck Injury 58.5282
## BodyPartMultiple Trunk 119.8085
## BodyPartMultiple Upper Extremities 59.8866
## BodyPartNo Physical Injury 64.5025
## BodyPartNon-Standard Code 52.7917
## BodyPartNose 84.1956
## BodyPartPelvis 124.3108
## BodyPartSacrum And Coccyx 179.7131
## BodyPartShoulder(S) 54.0592
## BodyPartSkull 186.7012
## BodyPartSoft Tissue-Head 1067.1068
## BodyPartSoft Tissue-Neck 73.2923
## BodyPartSpinal Cord-Trunk 194.7216
## BodyPartTeeth 108.1936
## BodyPartThumb 58.1017
## BodyPartToes 78.8848
## BodyPartTrachea 358.6707
## BodyPartUpper Arm 59.7532
## BodyPartUpper Back Area 73.7573
## BodyPartUpper Leg 72.1173
## BodyPartVertebrae 380.0392
## BodyPartWhole Body 617.4217
## BodyPartWrist 54.1792
## ClaimantTypeMedical Only 11.5447
## ClaimantTypeReport Only 21.9601
## t value
## (Intercept) 20.223
## BodyPartAnkle 6.002
## BodyPartArtificial Appliance -0.002
## BodyPartBody Systems and Multiple Body Systems 3.844
## BodyPartBrain 0.100
## BodyPartButtocks 0.509
## BodyPartChest 5.237
## BodyPartDisc-Trunk 7.148
## BodyPartEar(S) 4.978
## BodyPartElbow 1.809
## BodyPartEyes 7.108
## BodyPartFacial Bones 4.155
## BodyPartFinger(S) 9.715
## BodyPartFoot 5.904
## BodyPartGreat Toe -0.989
## BodyPartHand 7.526
## BodyPartHeart -0.285
## BodyPartHip 6.420
## BodyPartInsufficient Info to Properly Identify?Unclassified 5.505
## BodyPartInternal Organs 9.200
## BodyPartKnee 5.641
## BodyPartLarynx -0.232
## BodyPartLower Arm 0.281
## BodyPartLower Back Area 8.436
## BodyPartLower Leg 2.065
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 2.352
## BodyPartLungs -1.130
## BodyPartMouth 8.318
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) 12.547
## BodyPartMultiple Head Injury 6.426
## BodyPartMultiple Lower Extremities 11.865
## BodyPartMultiple Neck Injury 4.538
## BodyPartMultiple Trunk 6.539
## BodyPartMultiple Upper Extremities 19.689
## BodyPartNo Physical Injury 4.242
## BodyPartNon-Standard Code 46.038
## BodyPartNose 4.102
## BodyPartPelvis -0.690
## BodyPartSacrum And Coccyx -1.316
## BodyPartShoulder(S) 0.223
## BodyPartSkull 0.123
## BodyPartSoft Tissue-Head 2.633
## BodyPartSoft Tissue-Neck -1.833
## BodyPartSpinal Cord-Trunk -0.137
## BodyPartTeeth -1.028
## BodyPartThumb 2.024
## BodyPartToes 3.488
## BodyPartTrachea 0.392
## BodyPartUpper Arm 13.900
## BodyPartUpper Back Area 1.098
## BodyPartUpper Leg 1.950
## BodyPartVertebrae 1.695
## BodyPartWhole Body 1.419
## BodyPartWrist 5.502
## ClaimantTypeMedical Only -13.395
## ClaimantTypeReport Only -2.842
## Pr(>|t|)
## (Intercept) < 2e-16
## BodyPartAnkle 1.96e-09
## BodyPartArtificial Appliance 0.998642
## BodyPartBody Systems and Multiple Body Systems 0.000121
## BodyPartBrain 0.920676
## BodyPartButtocks 0.610940
## BodyPartChest 1.64e-07
## BodyPartDisc-Trunk 8.95e-13
## BodyPartEar(S) 6.46e-07
## BodyPartElbow 0.070527
## BodyPartEyes 1.19e-12
## BodyPartFacial Bones 3.26e-05
## BodyPartFinger(S) < 2e-16
## BodyPartFoot 3.56e-09
## BodyPartGreat Toe 0.322772
## BodyPartHand 5.30e-14
## BodyPartHeart 0.775517
## BodyPartHip 1.37e-10
## BodyPartInsufficient Info to Properly Identify?Unclassified 3.71e-08
## BodyPartInternal Organs < 2e-16
## BodyPartKnee 1.70e-08
## BodyPartLarynx 0.816926
## BodyPartLower Arm 0.778643
## BodyPartLower Back Area < 2e-16
## BodyPartLower Leg 0.038921
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) 0.018661
## BodyPartLungs 0.258684
## BodyPartMouth < 2e-16
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) < 2e-16
## BodyPartMultiple Head Injury 1.32e-10
## BodyPartMultiple Lower Extremities < 2e-16
## BodyPartMultiple Neck Injury 5.70e-06
## BodyPartMultiple Trunk 6.26e-11
## BodyPartMultiple Upper Extremities < 2e-16
## BodyPartNo Physical Injury 2.22e-05
## BodyPartNon-Standard Code < 2e-16
## BodyPartNose 4.09e-05
## BodyPartPelvis 0.490225
## BodyPartSacrum And Coccyx 0.188074
## BodyPartShoulder(S) 0.823359
## BodyPartSkull 0.902035
## BodyPartSoft Tissue-Head 0.008463
## BodyPartSoft Tissue-Neck 0.066858
## BodyPartSpinal Cord-Trunk 0.890639
## BodyPartTeeth 0.303743
## BodyPartThumb 0.042996
## BodyPartToes 0.000487
## BodyPartTrachea 0.695409
## BodyPartUpper Arm < 2e-16
## BodyPartUpper Back Area 0.272148
## BodyPartUpper Leg 0.051188
## BodyPartVertebrae 0.090032
## BodyPartWhole Body 0.155890
## BodyPartWrist 3.77e-08
## ClaimantTypeMedical Only < 2e-16
## ClaimantTypeReport Only 0.004491
##
## (Intercept) ***
## BodyPartAnkle ***
## BodyPartArtificial Appliance
## BodyPartBody Systems and Multiple Body Systems ***
## BodyPartBrain
## BodyPartButtocks
## BodyPartChest ***
## BodyPartDisc-Trunk ***
## BodyPartEar(S) ***
## BodyPartElbow .
## BodyPartEyes ***
## BodyPartFacial Bones ***
## BodyPartFinger(S) ***
## BodyPartFoot ***
## BodyPartGreat Toe
## BodyPartHand ***
## BodyPartHeart
## BodyPartHip ***
## BodyPartInsufficient Info to Properly Identify?Unclassified ***
## BodyPartInternal Organs ***
## BodyPartKnee ***
## BodyPartLarynx
## BodyPartLower Arm
## BodyPartLower Back Area ***
## BodyPartLower Leg *
## BodyPartLumbar and/or Sacral Vertebrae (Vertebra NOC Trunk) *
## BodyPartLungs
## BodyPartMouth ***
## BodyPartMultiple Body Parts (Including Body Systems and Body Parts) ***
## BodyPartMultiple Head Injury ***
## BodyPartMultiple Lower Extremities ***
## BodyPartMultiple Neck Injury ***
## BodyPartMultiple Trunk ***
## BodyPartMultiple Upper Extremities ***
## BodyPartNo Physical Injury ***
## BodyPartNon-Standard Code ***
## BodyPartNose ***
## BodyPartPelvis
## BodyPartSacrum And Coccyx
## BodyPartShoulder(S)
## BodyPartSkull
## BodyPartSoft Tissue-Head **
## BodyPartSoft Tissue-Neck .
## BodyPartSpinal Cord-Trunk
## BodyPartTeeth
## BodyPartThumb *
## BodyPartToes ***
## BodyPartTrachea
## BodyPartUpper Arm ***
## BodyPartUpper Back Area
## BodyPartUpper Leg .
## BodyPartVertebrae .
## BodyPartWhole Body
## BodyPartWrist ***
## ClaimantTypeMedical Only ***
## ClaimantTypeReport Only **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1066 on 55317 degrees of freedom
## (623 observations deleted due to missingness)
## Multiple R-squared: 0.2412, Adjusted R-squared: 0.2405
## F-statistic: 319.8 on 55 and 55317 DF, p-value: < 2.2e-165.CONSTRUIR UN MODELO PREDICTIVO
Costs of Claims
datos <- data.frame(OtherPaid=1564.22,IndemnityPaid=2308.91,Total_Incurred_Cost_Claim=3873.13,Total_Paid_calc=3873.13)
predict(regresion,datos)## 1
## 3873.13datos## OtherPaid IndemnityPaid Total_Incurred_Cost_Claim Total_Paid_calc
## 1 1564.22 2308.91 3873.13 3873.13Time To Process Claims
datos2 <- data.frame(BodyPart="Shoulder(S)",ClaimantType="Indemnity",tiempo_de_procesamiento_days=2080)
predict(regresion2,datos2)## 1
## 1014.249datos## OtherPaid IndemnityPaid Total_Incurred_Cost_Claim Total_Paid_calc
## 1 1564.22 2308.91 3873.13 3873.136.VISUALIZACIÓN DE REGRESIÓN LINEAL
Costs of Claims
library(ggplot2)
ggplot(base_act_4_6, aes(x = OtherPaid, y = IndemnityPaid)) +
geom_point() + # Puntos de dispersión
geom_smooth(method = "lm", se = FALSE, color = "blue") + # Línea de regresión
labs(title = "Gráfico de Regresión Lineal",
x = "IndemnityPaid",
y = "OtherPaid") +
geom_point(data = datos, aes(x = IndemnityPaid, y = OtherPaid), color = "red") # Puntos de predicción en rojo## `geom_smooth()` using formula = 'y ~ x'
Time To Process Claims
library(ggplot2)
ggplot(base_act_4_6, aes(x = BodyPart, y =tiempo_de_procesamiento_days)) +
geom_point() + # Puntos de dispersión
geom_smooth(method = "lm", se = FALSE, color = "blue") + # Línea de regresión
labs(title = "Gráfico de Regresión Lineal",
x = "BodyPart",
y = "tiempo_de_procesamiento_days") +
geom_point(data = base_act_4_6, aes(x = BodyPart, y = tiempo_de_procesamiento_days), color = "red")## `geom_smooth()` using formula = 'y ~ x'## Warning: Removed 623 rows containing non-finite values (`stat_smooth()`).## Warning: Removed 623 rows containing missing values (`geom_point()`).
## Removed 623 rows containing missing values (`geom_point()`).