EECS 1520 Lecture Notes - Lecture 1: Spreadsheet, Confidence Interval, Scatter Plot

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: Steven Castellucci

Document Summary

If you don"t want this to happen, put a $ before the column and row number. =+c4 go down a few rows and now it will read = + c7 (absolute cell references: different formatting options, y=a(1-r)^2/x when typing this formula into excel the exponent needs to be in brackets. Excel functions: part 1 (video #2: sum function used to add up a range of values. =sum (as you start typing lots of functions will come up, click tab to select the one you want) Arguments additional data that functions require for computation. Sum(number 1, [number 2], ) example of an argument. Selecting values to sum: click and drag values close bracket and hit enter. Dialogue box gives you an area to enter your arguments (b3:g3), you can also click and drag to select the values you want to multiply: naming a range of cells. Select the range, enter name in name box.