EECS 1520 Lecture 6: Week-02.3

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: John Hofbauer

Document Summary

Three different types of formulas (in h6, h12, h18) Changing values on a spreadsheet everything instantly updated. Insert row/column rest of spreadsheet adjusted. Generality of formulas one produces wrong answer after new column inserted. (why?) Shape of x, y and xy is the same. =x*y formula does row-by-row element pair multiplication. Multiple worksheets: factor out parameters to a separate sheet. What parts are built-in functions inter-worksheet cell references. Change parameters (velocity, angle) until you hit the desired target. Change data in the cell(s), graph instantly updated (what if analysis) New functions and operations introduced: ^, exp, tan, cos. Rand() function produces a random number in [0,1) Multiply by 6 to turn interval into [0,6) Divide interval into 6 sub-intervals: [0,1), [1,2), [2,3), [3,4), [4,5), [5,6) Associate 1 with interval [0,1), 2 with interval [1,2), etc. How? use conversion function (can you use other functions?) Countif count the number of occurrences of a specified value.