UGBA 104 Final Review Exam Questions and Answers

UGBA 104 Final Review Exam Questions and Answers Example of a Quantitative Variable - CORRECT ANSWER-Age, Income Example of a Categorical Variable - CORRECT ANSWER-Religion, Zip Code, Rent vs Own Example of a Binary Categorical Variable - CORRECT ANSWER-Rent vs Own, Paid vs Not What is the difference between Sorting and Filtering? - CORRECT ANSWER-Sort puts things in different orders whereas Filtering only shows the results you filtered for What are some of the uses of Conditional Formatting? - CORRECT ANSWERHighlights cells with rules: -Greater than/less than -Top X%, Bottom X% -Data Bars, Color Scales For a Categorical Variable, what is the difference between a Frequency Distribution, a Relative Frequency Distribution, and a Percent Frequency Distribution? - CORRECT ANSWER-Frequency Distribution = How often it shows up Relative Frequency Distribution = How often it shows up in total-- #times/total Percent Frequency Distribution = % of total that it makes up What is the difference between Excel's COUNT, SUM & AVERAGE functions? - CORRECT ANSWER-COUNT: number of times something shows up SUM: totals the numbers AVERAGE: takes the average of the numbers WHat is the difference between Excel's COUNTIF, SUMIF, & AVERAGEIF functions? - CORRECT ANSWER-COUNTIF: conditional counting SUMIF: conditional summation AVERAGEIF: conditional averaging What is the role of Bins when summarizing a quantitative variable with either a frequency distribution or histogram? - CORRECT ANSWER-Bins organize data so that it can be summarized into a frequency distri