UBGA 104 Midterm 1 Study Guide Exam with Updated Q&A

UBGA 104 Midterm 1 Study Guide Exam with Updated Q&A sumproduct - CORRECT ANSWER-(range,range) sum of the products of matched up values in ranges 5 steps in formulating a linear program - CORRECT ANSWER-1. Understand the decision problem. 2. Define the decision variables. 3. Express the objective as a linear function of the decision variables. 4. Express each constraint as a linear inequality. 5. Identify all upper and lower bounds on the decision variables. Flaw of averages - CORRECT ANSWER-Estimate based on the assumption that average conditions will occur is always wrong. Don't use averages when computing averages, average after computation. round - CORRECT ANSWER-(cellreference,number of digits to round to) psinormal - CORRECT ANSWER-(average, SD) psioutput() - CORRECT ANSWER-+ at the end of a cell to show this is the ultimate output cell resulting from the R