Scribd Logo
Upload

Welcome to Scribd!

  • 86 views

    Excel Assignment

    Uploaded by

    api-433012475
    Monthly spending chart shows categories of groceries, gas, rent & utilities, leisure, and medical for 12 months. Groceries averaged $245.5 and rent & utilities averaged $691.5 per month. Overall monthly spending averaged $1,134.31 with 61.8% of months spending above this amount and 21.9% spending $1100 or more.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Excel Assignment

    Uploaded by

    api-433012475
    86 views4 pages
    Monthly spending chart shows categories of groceries, gas, rent & utilities, leisure, and medical for 12 months. Groceries averaged $245.5 and rent & utilities averaged $691.5 per month. Overall monthly spending averaged $1,134.31 with 61.8% of months spending above this amount and 21.9% spending $1100 or more.

    Original Title

    excel assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Monthly spending chart shows categories of groceries, gas, rent & utilities, leisure, and medical for 12 months. Groceries averaged $245.5 and rent & utilities averaged $691.5 per month. Overall monthly spending averaged $1,134.31 with 61.8% of months spending above this amount and 21.9% spending $1100 or more.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    86 views4 pages

    Excel Assignment

    Uploaded by

    api-433012475
    Monthly spending chart shows categories of groceries, gas, rent & utilities, leisure, and medical for 12 months. Groceries averaged $245.5 and rent & utilities averaged $691.5 per month. Overall monthly spending averaged $1,134.31 with 61.8% of months spending above this amount and 21.9% spending $1100 or more.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 4

    Monthly Spending Chart

    1400

    15
    25
    1200 0
    20
    189 60 30 101
    20 210 49
    168 60
    60 96 105 0
    0 10
    1000 84
    103 94 102
    102

    800

    751
    710 769
    689 719 724 654 632
    621 619 656 754
    600

    400
    31
    38 48
    35 42 35 42 45
    33 52 36
    47
    200
    272 301
    250 248 236 261 256 253 245
    220 224
    180

    0
    Janua ry Februa ry March Apri l May June Jul y August September October November December

    Groceries Gas Rent & Util i ties Li es ure Medi cal


    Zach Regan
    Excel Application Assignment
    Wednesday, October 31, 2018

    Monthly Budge
    January February March April May June
    Groceries 250 248 236 261 272 220
    Gas 35 42 33 38 48 52
    Rent & Utilities 621 619 656 689 710 719
    Liesure 102 103 94 96 189 105
    Medical 60 0 10 20 15 60

    Total 1068 1012 1029 1104 1234 1156


    Average 213.6 202.4 205.8 220.8 246.8 231.2
    Percentage 8.0% 7.5% 7.7% 8.2% 9.2% 8.6%
    nthly Budget
    July August September October November December Total
    180 256 301 224 253 245 2946
    47 35 31 36 42 45 484
    754 769 751 724 654 632 8298
    210 49 101 168 84 102 1403
    25 30 0 20 0 60 300

    1216 1139 1184 1172 1033 1084 13431


    243.2 227.8 236.8 234.4 206.6 216.8 223.9
    9.1% 8.5% 8.8% 8.7% 7.7% 8.1%
    Average Percentage
    245.5 21.9% Spending $1100/month or more
    40.3 3.6% Spending Under $1100
    691.5 61.8% Spending Above Average On Subject
    116.9 10.4%
    25.0 2.2%

    You might also like