| |
Exercise 2.2
Monthly Expenses for Two Person Family.
| Monthly
Expense |
Amount |
| Mortgage |
$1,075 |
| Utilities |
$275 |
| Medical Insurance |
$175 |
| Car Insurance |
$150 |
| Car Payments |
$625 |
| Food/Beverage |
$600 |
| Entertainment |
$300 |
| Other |
$250 |
Complete the following:
- Construct a pie graph using Excel to visualize the information with percentages.
- What is the largest monthly expense?
- What is the least monthly expense?
- What percentage does the monthly expense Entertainment occupy?
- What is the total amount of money spent in one month?
- What information does the pie chart give us quickly?
- What is the advantage of presenting this data in a pie chart?
Upon completion of this exercise, please show your results to your
teacher for approval.
|