Excel Guide - Project 1

Excel Guide - Project 1 - HW1 Excel Project EC370 Fall 2008...

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

View Full Document Right Arrow Icon
HW1 – Excel Project EC370 – Fall 2008 1 The purpose of this assignment is to learn how to enter basic mathematical formulas in excel and create graphs. The data are estimates of the ratio of financial obligations (required payments on outstanding mortgage and consumer debt, automobile lease payments, rental payments, homeowners’ insurance, property tax payments, etc.) to personal disposable income. The figures in the data set are percentages (i.e. 17.3 = 17.3%). 1) Download “US Financial Obligations.xls” from Blackboard and open the file. 2) First, let’s figure out how much worse off renters are in terms of financial obligations. In cell D2, enter the formula “ = B2 – C2” and hit enter. You can double click on the square shown (and circled) in the screenshot and Excel will populate the remaining rows (it keeps going until the data in the immediately adjacent cells – column C – run out). Note: Excel takes formulas interactively with the mouse so rather than type the target cells for your formula you can just type “=”, select cell B2 with the mouse, type in a minus sign, and select cell C2 with the mouse.
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 / 4

Excel Guide - Project 1 - HW1 Excel Project EC370 Fall 2008...

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