This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: HW1 – Excel Project ED370 – Fall 2008 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 then press enter. with the mouse, type in a minus sign, and select cell C2 with the mouse then press enter....
View Full Document
This note was uploaded on 10/17/2009 for the course EC 370 taught by Professor Staff during the Spring '08 term at University of Oregon.
- Spring '08