ADM 1370 Lecture Notes - Lecture 4: Dependent And Independent Variables

27 views3 pages

Document Summary

Logical tests: result of these functions is a logical value (true or false) ~ ex: comparison operators that can be used in logical tests are: Equals = ; less than < ; less than or equal to <= ; greater than > ; greater than or equal to >= ; not equal to < > Logical functions: result of these functions is a logical value (true or false) (cid:862)- and, - or, - not(cid:863) Allows you to test the condition of more than just 1 criterion (condition) Only returns true if all tested values are true. Returns a true value if any of logical conditions are true & a false value if all logical conditions are false. Used when you want to make sure a value is not equal to 1 particular value. Conditional functions: result may be a specified value or a calculated value. Countifs, sumifs, averageifs (to be used when multiple criteria are to be tested)

Get access

Grade+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers
Class+
$30 USD/m
Billed monthly
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
7 Verified Answers

Related Documents

Related Questions