wk1-hw1-exp-table.xlsx
Sheet1
| WK1-HW1 | INCOME | | GAS | FOOD | UTIL | RENT | C-CARD | EXP TOT |
| JAN | 3500 | | 250 | 500 | 700 | 1400 | 1200 | 4050 |
| FEB | 3300 | | 225 | 600 | 650 | 1400 | 900 | 3775 |
| MAR | 3000 | | 260 | 550 | 600 | 1400 | 800 | 3610 |
| APR | 3500 | | 200 | 450 | 550 | 1400 | 600 | 3200 |
| MAY | 3600 | | 200 | 400 | 400 | 1400 | 450 | 2850 |
| JUN | 3800 | | 175 | 450 | 500 | 1400 | 450 | 2975 |
| JUL | 3800 | | 300 | 500 | 600 | 1400 | 900 | 3700 |
| ASUG | 4000 | | 250 | 500 | 700 | 1400 | 1000 | 3850 |
| SEP | 4100 | | 260 | 375 | 500 | 1400 | 850 | 3385 |
| OCT | 4200 | | 200 | 350 | 450 | 1400 | 1000 | 3400 |
| NOV | 4400 | | 250 | 400 | 500 | 1400 | 800 | 3350 |
| DEC | 4500 | | 270 | 600 | 600 | 1400 | 2000 | 4870 |
| TOTALS | 45700 | | 2840 | 5675 | 6750 | 16,800 | 10,950 | 43,015 |
| MEAN | 3808.3333333333 | | 237 | 473 | 563 | 1400 | 913 | 3585 |
| MEDIAN | 3800 | | 250 | 475 | 575 | 1400 | 875 | 3505 |
| MODE | 3500 | | 250 | 500 | 600 | 1400 | 900 | none |
| VARIANCE | 204469.696969696 | | 1338 | 6984 | 9148 | 0 | 166,875 | 288,875 |
| STD DEV | 452 | | 37 | 84 | 96 | 0 | 409 | 537 |