Homework7_fall09

Homework7_fall09 - Homework 7: Using Excel for Data...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Homework 7: Using Excel for Data Management and Analysis © (12-point homework quiz on this assignment will be Thursday, November 19) The Problem Your expenses for this semester have turned out to be more than you expected. You would like to analyze your expenses to see where you may be spending more than you have budgeted. You would also like to see whether or not your expenses have increased or decreased over time. Use the new skills you have acquired in managing data in Excel to track and analyze your expenses to help you figure out how you might be able to cut expenses for next semester. Expenses Worksheet (make this the 2 nd worksheet in the workbook) 1. Create a list of real or contrived personal expense data that spans any 4 consecutive calendar months. 2. Your list should contain at least 40 entries of expenditures. 3. Be sure to include attributes of expenditures that you wish to use for your analysis (payee, date, category, etc.). 4. Include at least 5 different categories of expenses (food, utilities, travel, housing, etc.).
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Homework7_fall09 - Homework 7: Using Excel for Data...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online