Spreadsheet: 836163d1689147434-linear-regression-only-on-filtered-range-regression-sample
Sheet: ALL Ann APP Salary No HIgh

6.93 | 117516.52 | Regression Analysis - All APPs Post Annual Salary |  |  |  | NOTES:
12.9 | 146016.2588235294 |  |  |  |  | Regression Analysis: Y =mx + b
13.7 | 128320.5 | Line Estimate | m | b
15.26 | 126000 | y=mx+b |  | 107900.3160677471 |  | Y = Wages
15.5 | 137831.6615384615 |  |  | 122399.2147479258 |  | x = YOE input variable
31.8 | 139791.74 | INPUT |  |  |  | b = the intercept is the point at which the regression line intersects the y-axis. It represents the predicted value of the dependent variable (y) when the independent variable (x) is zero.
 |  | YOE  = x | Output = y | Wage Increase |  | m = The rate of change in y for each unit change in x.
 | 122399.2147479258 | 6 |  | 0
Verification.
 |  | INPUT
 |  | Dataset
FTE | Division | Actual Wages | YOE | Wages Adj for Increase @ 1.0fte
1 | PLASTIC SURGERY |  | 0.3 | 106618.15
1 | DERMATOLOGY |  | 1 | 110000
1 | GENERAL PEDIATRICS |  | 1.8 | 103000
1 | PEDIATRIC SURGERY |  | 1.9 | 108680
1 | NEUROSURGERY |  | 2.3 | 114970.78
1 | OTOLARYNGOLOGY |  | 2.3 | 111108.9
0.6 | PULMONOLOGY |  | 2.3 | 106582.4666666667
1 | CVICU |  | 2.7 | 108000
1 | HOSPITALISTS |  | 2.8 | 104500
1 | ORTHOPAEDICS |  | 2.8 | 110864.05
1 | CARDIOLOGY |  | 3.1 | 107051.62
1 | HEMATOLOGY ONCOLOGY |  | 3.1 | 106288.39
1 | ORTHOPAEDICS |  | 3.1 | 111940.4
1 | OTOLARYNGOLOGY |  | 3.1 | 111665.4
1 | GASTROENTEROLOGY |  | 3.2 | 113413.85
1 | HEMATOLOGY ONCOLOGY |  | 3.2 | 106641.29
1 | PLASTIC SURGERY |  | 3.2 | 107816.52
1 | NEUROLOGY |  | 3.3 | 113861.11
1 | CVICU |  | 3.5 | 114746.58
1 | CRITICAL CARE |  | 3.8 | 110000
1 | GASTROENTEROLOGY |  | 3.9 | 111562.5
1 | GASTROENTEROLOGY |  | 4.1 | 118505.09
1 | NEUROSURGERY |  | 4.2 | 120590.74
1 | CRITICAL CARE |  | 4.4 | 112350
1 | NEPHROLOGY |  | 4.4 | 106739.32
1 | CVICU |  | 4.5 | 112000
1 | HEMATOLOGY ONCOLOGY |  | 4.5 | 111108.9
1 | PEDIATRIC SURGERY |  | 4.5 | 114823.56
1 | CVICU |  | 4.8 | 124116.18
1 | PLASTIC SURGERY |  | 4.8 | 108548.36
1 | PEDIATRIC SURGERY |  | 4.9 | 123592.43
1 | CRITICAL CARE |  | 5 | 112508.55
1 | CRITICAL CARE |  | 5.1 | 112350
1 | CRITICAL CARE |  | 5.1 | 112350
1 | PEDIATRIC SURGERY |  | 5.4 | 119120.68
1 | CRITICAL CARE |  | 5.5 | 116689.93
1 | CVICU |  | 5.7 | 120579.12
1 | CVICU |  | 5.7 | 119531.5
1 | PEDIATRIC SURGERY |  | 5.7 | 114301.37
0.8 | HEMATOLOGY ONCOLOGY |  | 6 | 115546.625
1 | HEMATOLOGY ONCOLOGY |  | 6.1 | 115546.36
1 | TRAUMA |  | 6.1 | 121160.14
1 | GASTROENTEROLOGY |  | 6.4 | 114563.35
1 | HOSPITALISTS |  | 6.4 | 112278.36
1 | DEVELOPMENTAL PEDS |  | 6.5 | 116621.4
1 | TRAUMA |  | 6.8 | 126994.71
0.5 | CARDIOLOGY |  | 6.93 | 117516.52
1 | PEDIATRIC SURGERY |  | 7 | 107000
1 | RADIOLOGY |  | 7 | 120000
1 | CARDIOLOGY |  | 7.04 | 117973.19
1 | HEMATOLOGY ONCOLOGY |  | 7.2 | 117818.61
1 | PEDIATRIC SURGERY |  | 7.3 | 114639
1 | GENERAL PEDIATRICS |  | 7.4 | 130408.69
1 | CVICU |  | 7.5 | 124738.52
1 | HEMATOLOGY ONCOLOGY |  | 7.5 | 119732.97
1 | GASTROENTEROLOGY |  | 7.6 | 113973.51
0.8 | CHILD ADVOCACY |  | 8.4 | 123723.6
1 | GASTROENTEROLOGY |  | 9 | 121537.68
1 | PLASTIC SURGERY |  | 9.1 | 121474.5
1 | ORTHOPAEDICS |  | 9.2 | 127442.98
0.9 | PULMONOLOGY |  | 9.2 | 129341.9777777778
1 | ORTHOPAEDICS |  | 9.3 | 127442.98
1 | HEMATOLOGY ONCOLOGY |  | 9.4 | 122439.13
0.8 | CARDIOLOGY |  | 9.45 | 104867.5
1 | DERMATOLOGY |  | 9.5 | 122884.93
1 | URGENT CARE |  | 9.5 | 114950
1 | PULMONOLOGY |  | 9.7 | 127045.38
1 | CHILD ADVOCACY |  | 10 | 122772.38
1 | PEDIATRIC SURGERY |  | 10.1 | 124209.41
1 | NEUROLOGY |  | 11.2 | 123723.6
1 | TRAUMA |  | 11.4 | 137683.4
1 | CVICU |  | 11.6 | 128591.1
1 | CHILD ADVOCACY |  | 11.8 | 120246.85
1 | OTOLARYNGOLOGY |  | 12 | 127436.76
1 | HEMATOLOGY ONCOLOGY |  | 12.2 | 128839.1
1 | PULMONOLOGY |  | 12.3 | 131430.7
1 | CHILD ADVOCACY |  | 12.6 | 126273
0.85 | ENDOCRINOLOGY |  | 12.9 | 146016.2588235294
1 | HEMATOLOGY ONCOLOGY |  | 13 | 135082.97
1 | OTOLARYNGOLOGY |  | 13.4 | 127257.7
1 | CVICU |  | 13.6 | 148209.73
1 | CARDIOLOGY |  | 13.62 | 128284.18
0.5 | HEMATOLOGY ONCOLOGY |  | 13.7 | 128320.5
1 | CVICU |  | 14.1 | 128771.98
0.8 | NEUROSURGERY |  | 14.3 | 125631.2125
1 | PEDIATRIC SURGERY |  | 14.4 | 139981.93
1 | CARDIOLOGY |  | 14.46 | 129025.11
1 | CRITICAL CARE |  | 14.5 | 138914.21
1 | PEDIATRIC SURGERY |  | 14.5 | 130625
0.5 | CARDIOLOGY |  | 15.26 | 126000
1 | DEVELOPMENTAL PEDS |  | 15.3 | 134649.3
1 | ORTHOPAEDICS |  | 15.3 | 147869.29
0.65 | GENERAL PEDIATRICS |  | 15.5 | 137831.6615384615
1 | OTOLARYNGOLOGY |  | 15.8 | 137918.04
1 | CARDIOLOGY |  | 16.68 | 133019.4
1 | TRAUMA |  | 17.2 | 136257.75
1 | CVICU |  | 17.5 | 133359.77
1 | HOSPITALISTS |  | 17.6 | 145521.84
0.9 | HEMATOLOGY ONCOLOGY |  | 18 | 137832.3777777778
1 | NEUROLOGY |  | 18.5 | 132500
1 | GASTROENTEROLOGY |  | 19.7 | 128029.21
1 | CARDIOLOGY |  | 20.85 | 153673.52
1 | CARDIOLOGY |  | 21.15 | 135661.05
1 | PALLIATIVE CARE |  | 22.8 | 147957.28
1 | HEMATOLOGY ONCOLOGY |  | 23.3 | 141802.32
1 | UROLOGY |  | 24.4 | 144240.31
1 | NEUROSURGERY |  | 24.5 | 150968.84
1 | UROLOGY |  | 24.6 | 143209.74
1 | NEUROLOGY |  | 25.7 | 142399.18
1 | CRITICAL CARE |  | 26.3 | 152557.46
1 | GASTROENTEROLOGY |  | 27.2 | 145567.93
1 | UROLOGY |  | 28.3 | 143300.85
0.9 | PULMONOLOGY |  | 29.6 | 151265.9888888889
1 | GENETICS |  | 30.5 | 144661.44
0.5 | GASTROENTEROLOGY |  | 31.8 | 139791.74