Final project
Sheet1
| LIVING AS A SCHOOL NURSE | ||||||||||||||||
| NURSE IN SCHOOL X | ||||||||||||||||
| JOB TITLE | HOURLY WAGE | MONTHLY SALARY | ANNUAL INCOME | |||||||||||||
| Lincensed Practising Nurse (LPN) Y hospital | $19.20 | $ 3,456.00 | $ 41,472.00 | |||||||||||||
| Licensed Practical Nurse (LPN) Job 2 Memorial Hospital | $19 | $ 3,420.00 | 41040 | |||||||||||||
| Licensed Practical Nurse (LPN) Job 3 Carmel Rehab center | $19.25 | $ 3,465.00 | $ 41,580.00 | |||||||||||||
| Average Salary | $19.15 | $3,447.00 | $41,364.00 | |||||||||||||
| MONTH | MONTHLY EXPENSES | Total Monthly | Wages Left After | Yearly expenses | Annual Income Yearly | |||||||||||
| Electricity | Telephone | Gasoline | Groceries | Entertainment | Rent | Child Care | Car Payment | Car Insurance | Cable | Credit Card | Gifts | |||||
| January | $90 | $45 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $90 | $85 | $3,195 | 252 | $3,195 | 38169 |
| February | $90 | $40 | $120 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $90 | $70 | $3,195 | 252 | $6,390 | 34974 |
| March | $92 | $60 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $100 | $45 | $3,182 | 265 | $9,572 | 31792 |
| April | $300 | $35 | $100 | $120 | $100 | $1,200 | $600 | $450 | $150 | $115 | $115 | $50 | $3,335 | 112 | $12,907 | 28457 |
| May | $115 | $55 | $100 | $320 | $300 | $1,200 | $600 | $450 | $150 | $115 | $100 | $50 | $3,555 | -108 | $16,462 | 24902 |
| June | $100 | $55 | $100 | $120 | $450 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,440 | 7 | $19,902 | 21462 |
| July | $100 | $50 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,135 | 312 | $23,037 | 18327 |
| August | $100 | $50 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,135 | 312 | $26,172 | 15192 |
| September | $170 | $50 | $100 | $120 | $90 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,145 | 302 | $29,317 | 12047 |
| October | $80 | $50 | $100 | $120 | $350 | $1,200 | $600 | $450 | $150 | $115 | $45 | $50 | $3,310 | 137 | $32,627 | 8737 |
| November | $75 | $50 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,110 | 337 | $35,737 | 5627 |
| December | $100 | $50 | $200 | $220 | $100 | $1,200 | $600 | $450 | $150 | $115 | $105 | $50 | $3,340 | 107 | $39,077 | 2287 |
| Subtotal | $1,412 | $590 | $1,320 | $1,740 | $2,290 | $14,400 | $7,200 | $5,400 | $1,800 | $1,380 | $895 | $650 | $39,077 | |||
| Average Expense | $117.67 | $49.17 | $110.00 | $145.00 | $190.83 | $1,200.00 | $600.00 | $450.00 | $150.00 | $115.00 | $74.58 | $54.17 | $3,256.42 | 190.58 |
LIVING THE LIFE OF A SCHOOL NURSE
Rent-Gifts Data
| MONTH | Rent | Child Care | Car Payment | Car Insurance | Cable | Credit Card | Gifts | Low Outlier | Start | Box Bottom | Mid Line | Box Top | End | High Outlier | Neg Start | Neg End | Low Whisker | Q1 | Q2(Median) | Q3 | High Whisker | XL2007 Err Bars | Outliers | |
| January | 1200 | 600 | 450 | 150 | 115 | 90 | 85 | January | ERROR:#N/A | 17.5 | 102.5 | 47.5 | 375 | 633.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 85 | 102.5 | 150 | 525 | 1158.75 | 1200 | |
| February | 1200 | 600 | 450 | 150 | 115 | 90 | 70 | February | ERROR:#N/A | 32.5 | 102.5 | 47.5 | 375 | 633.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 70 | 102.5 | 150 | 525 | 1158.75 | 1200 | |
| March | 1200 | 600 | 450 | 150 | 115 | 100 | 45 | March | ERROR:#N/A | 62.5 | 107.5 | 42.5 | 375 | 626.25 | 1200 | ERROR:#N/A | ERROR:#N/A | 45 | 107.5 | 150 | 525 | 1151.25 | 1200 | |
| April | 1200 | 600 | 450 | 150 | 115 | 115 | 50 | April | ERROR:#N/A | 65 | 115 | 35 | 375 | 615 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 115 | 150 | 525 | 1140 | 1200 | |
| May | 1200 | 600 | 450 | 150 | 115 | 100 | 50 | May | ERROR:#N/A | 57.5 | 107.5 | 42.5 | 375 | 626.25 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 107.5 | 150 | 525 | 1151.25 | 1200 | |
| June | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | June | ERROR:#N/A | 32.5 | 82.5 | 67.5 | 375 | 663.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 82.5 | 150 | 525 | 1188.75 | 1200 | |
| July | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | July | ERROR:#N/A | 32.5 | 82.5 | 67.5 | 375 | 663.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 82.5 | 150 | 525 | 1188.75 | 1200 | |
| August | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | August | ERROR:#N/A | 32.5 | 82.5 | 67.5 | 375 | 663.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 82.5 | 150 | 525 | 1188.75 | 1200 | |
| September | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | September | ERROR:#N/A | 32.5 | 82.5 | 67.5 | 375 | 663.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 82.5 | 150 | 525 | 1188.75 | 1200 | |
| October | 1200 | 600 | 450 | 150 | 115 | 45 | 50 | October | ERROR:#N/A | 37.5 | 82.5 | 67.5 | 375 | 663.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 45 | 82.5 | 150 | 525 | 1188.75 | 1200 | |
| November | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | November | ERROR:#N/A | 32.5 | 82.5 | 67.5 | 375 | 663.75 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 82.5 | 150 | 525 | 1188.75 | 1200 | |
| December | 1200 | 600 | 450 | 150 | 115 | 105 | 50 | December | ERROR:#N/A | 60 | 110 | 40 | 375 | 622.5 | 1200 | ERROR:#N/A | ERROR:#N/A | 50 | 110 | 150 | 525 | 1147.5 | 1200 |
Rent-Gifts Data7
| MONTH | Rent | Child Care | Car Payment | Car Insurance | Cable | Credit Card | Gifts | Low Outlier | Start | Box Bottom | Mid Line | Box Top | End | High Outlier | Neg Start | Neg End | Low Whisker | Q1 | Q2(Median) | Q3 | High Whisker | XL2007 Err Bars | Outliers | |||
| January | 1200 | 600 | 450 | 150 | 115 | 90 | 85 | Rent | ERROR:#N/A | 0 | 1200 | 0.1 | 0 | 0 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | 1200 | 1200 | 1200 | 1200 | 1200 | ERROR:#N/A | |||
| February | 1200 | 600 | 450 | 150 | 115 | 90 | 70 | Child Care | ERROR:#N/A | 0 | 600 | 0.1 | 0 | 0 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | 600 | 600 | 600 | 600 | 600 | ERROR:#N/A | |||
| March | 1200 | 600 | 450 | 150 | 115 | 100 | 45 | Car Payment | ERROR:#N/A | 0 | 450 | 0.1 | 0 | 0 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | 450 | 450 | 450 | 450 | 450 | ERROR:#N/A | |||
| April | 1200 | 600 | 450 | 150 | 115 | 115 | 50 | Car Insurance | ERROR:#N/A | 0 | 150 | 0.1 | 0 | 0 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | 150 | 150 | 150 | 150 | 150 | ERROR:#N/A | |||
| May | 1200 | 600 | 450 | 150 | 115 | 100 | 50 | Cable | ERROR:#N/A | 0 | 115 | 0.1 | 0 | 0 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | 115 | 115 | 115 | 115 | 115 | ERROR:#N/A | |||
| June | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | Credit Card | ERROR:#N/A | 5 | 50 | 20 | 30 | 15 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | 45 | 50 | 70 | 100 | 115 | ERROR:#N/A | |||
| July | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | Gifts | 45 | 0 | 50 | 0.1 | 0 | 0 | 85 | ERROR:#N/A | ERROR:#N/A | 50 | 50 | 50 | 50 | 50 | 85 | 70 | 45 | |
| August | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | |||||||||||||||||||
| September | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | |||||||||||||||||||
| October | 1200 | 600 | 450 | 150 | 115 | 45 | 50 | |||||||||||||||||||
| November | 1200 | 600 | 450 | 150 | 115 | 50 | 50 | |||||||||||||||||||
| December | 1200 | 600 | 450 | 150 | 115 | 105 | 50 |
Sheet3
CHART
3195 3195 3182 3335 3555 3440 3135 3135 3145 3310 3110 3340 January February March April May June July August September October November December 3195 3195 3182 3335 3555 3440 3135 3135 3145 3310 3110 3340
GRAPHS
| Total Monthly | |||||||||||||
| Electricity | Telephone | Gasoline | Groceries | Entertainment | Rent | Child Care | Car Payment | Car Insurance | Cable | Credit Card | Gifts | ||
| January | $90 | $45 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $90 | $85 | $3,195 |
| February | $90 | $40 | $120 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $90 | $70 | $3,195 |
| March | $92 | $60 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $100 | $45 | $3,182 |
| April | $300 | $35 | $100 | $120 | $100 | $1,200 | $600 | $450 | $150 | $115 | $115 | $50 | $3,335 |
| May | $115 | $55 | $100 | $320 | $300 | $1,200 | $600 | $450 | $150 | $115 | $100 | $50 | $3,555 |
| June | $100 | $55 | $100 | $120 | $450 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,440 |
| July | $100 | $50 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,135 |
| August | $100 | $50 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,135 |
| September | $170 | $50 | $100 | $120 | $90 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,145 |
| October | $80 | $50 | $100 | $120 | $350 | $1,200 | $600 | $450 | $150 | $115 | $45 | $50 | $3,310 |
| November | $75 | $50 | $100 | $120 | $150 | $1,200 | $600 | $450 | $150 | $115 | $50 | $50 | $3,110 |
| December | $100 | $50 | $200 | $220 | $100 | $1,200 | $600 | $450 | $150 | $115 | $105 | $50 | $3,340 |
| Subtotal | $1,412 | $590 | $1,320 | $1,740 | $2,290 | $14,400 | $7,200 | $5,400 | $1,800 | $1,380 | $895 | $650 | $39,077 |
| MONTH | Total Monthly | ||||||||||||
| January | 3195 | ||||||||||||
| February | 3195 | ||||||||||||
| March | 3182 | ||||||||||||
| April | 3335 | ||||||||||||
| May | 3555 | ||||||||||||
| June | 3440 | ||||||||||||
| July | 3135 | ||||||||||||
| August | 3135 | ||||||||||||
| September | 3145 | ||||||||||||
| October | 3310 | ||||||||||||
| November | 3110 | ||||||||||||
| December | 3340 | ||||||||||||
| Electricity | Telephone | Gasoline | Groceries | Entertainment | Rent | Child Care | Car Payment | Car Insurance | Cable | Credit Card | Gifts | ||
| Subtotal | 1412 | 590 | 1320 | 1740 | 2290 | 14400 | 7200 | 5400 | 1800 | 1380 | 895 | 650 |
Total Monthly January February March April May June Ju ly August September October November December 3195 3195 3182 3335 3555 3440 3135 3135 3145 3310 3110 3340
MONTH
EXPENSES
BAR GRAPH FOR SUB-TOTAL EXPENSES
Subtotal Electricity Telephone Gasoline Groceries Entertainment Rent Child Care Car Payment Car Insurance Cable Credit Card Gifts 1412 590 1320 1740 2290 14400 7200 5400 1800 1380 895 650
EXPENSES
SUB-TOTAL EXPENSES
BAR GRAPH
Electricity January February March April May June July August September October November December 90 90 92 300 115 100 100 100 170 80 75 100 Telephone January February March April May June July August September October November December 45 40 60 35 55 55 50 50 50 50 50 50 Gasoline January February March April May June July August September October November December 100 120 100 100 100 100 100 100 100 100 100 200 Groceries January February March April May June July August September October November December 120 120 120 120 320 120 120 120 120 120 120 220 Entertainment January February March April May June July August September October November December 150 150 150 100 300 450 150 150 90 350 150 100 Rent January February March April May June July August September October November December 1200 1200 1200 1200 1200 1200 1200 1200 1200 1200 1200 1200 Child Care January February March April May June July August September October November December 600 600 600 600 600 600 600 600 600 600 600 600 Car Payment January February March April May June July August September October November December 450 450 450 450 450 450 450 450 450 450 450 450 Car Insurance January February March April May June July August Septembe r October November December 150 150 150 150 150 150 150 150 150 150 150 150 Cable January February March April May June July August September October November December 115 115 115 115 115 115 115 115 115 115 115 115 Credit Card January February March April May June July August September October November December 90 90 100 115 100 50 50 50 50 45 50 105 Gifts January February March April May June July August September October November December 85 70 45 50 50 50 50 50 50 50 50 50
MONTH
VALUE