Scribd
Upload
22 views2 pages

Basic Data Visualization

The document presents a monthly budget breakdown for various categories including housing, bills, food, personal expenses, transport, and health from January to December. It includes instructions to calculate total expenditures for each month and visualize the data using bar and line charts. Additionally, it highlights the need to identify the highest expenditure category for June.

Uploaded by

Er Deep Shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
22 views2 pages

Basic Data Visualization

The document presents a monthly budget breakdown for various categories including housing, bills, food, personal expenses, transport, and health from January to December. It includes instructions to calculate total expenditures for each month and visualize the data using bar and line charts. Additionally, it highlights the need to identify the highest expenditure category for June.

Uploaded by

Er Deep Shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Month Housing Bills & Utilities Food & Dining Personal Auto & Transport Health & Fitness

ansport Health & Fitness Total


Jan £ 800.00 £ 210.00 £ 400.00 £ 100.00 £ 100.00 £ 60.00
Feb £ 800.00 £ 180.00 £ 350.00 £ 100.00 £ 125.00 £ 70.00
Mar £ 800.00 £ 170.00 £ 420.00 £ 100.00 £ 120.00 £ 60.00
Apr £ 800.00 £ 160.00 £ 400.00 £ 120.00 £ 100.00 £ 60.00
May £ 800.00 £ 150.00 £ 420.00 £ 100.00 £ 100.00 £ 80.00
Jun £ 800.00 £ 150.00 £ 380.00 £ 100.00 £ 130.00 £ 60.00
Jul £ 800.00 £ 150.00 £ 420.00 £ 120.00 £ 100.00 £ 60.00
Aug £ 800.00 £ 150.00 £ 420.00 £ 100.00 £ 100.00 £ 80.00
Sep £ 800.00 £ 150.00 £ 400.00 £ 120.00 £ 110.00 £ 60.00
Oct £ 800.00 £ 170.00 £ 420.00 £ 100.00 £ 100.00 £ 60.00
Nov £ 800.00 £ 200.00 £ 390.00 £ 120.00 £ 100.00 £ 50.00
Dec £ 800.00 £ 220.00 £ 400.00 £ 100.00 £ 115.00 £ 60.00
Instructions
Calculate the total expenditure for each month
Visualize the total expenditure proportions for the 12 month [Hint: use Bar chart]
Visualize how the bills & utilities countably changed over the year [Hint use line chart]
Visualize which expenditure category was the highest in Jun

You might also like