INSY 2299 Study Guide - Final Guide: Line Chart, Histogram, Business Logic
Document Summary
Max = will give you largest value in array =max(d10:d13) If = performs logic test, what to do if true, what to do if false =if(d10>70, true , Use if in tax situations, if net income is greater than 0, tax= net income * tax rate, else. You can also use the max function =max(d10, 0) for tax situations. Absolute referencing = unchanged reference signified by $" ex. (when you drag it will always refer to a1, and not adjust) Relative referencing = default, referencing relative to original position. Pie chart- relative pieces of a whole. A mathematical representation of the essential characteristics of a business problem or situation used to ask what if questions for the purposes of making predictions and decisions . Decision variables + uncontrollables the model outcomes. We use simulation models to make predictions about the world, without experimentation or manipulation (bc that is too expensive, time consuming, dangerous)