UGBA 104 Midterm Exam Questions and Answers 100% Verified

UGBA 104 Midterm Exam Questions and Answers 100% Verified calculate outliers IQR method - CORRECT ANSWER-IQR below; Q1 - 1.5 * IQR IQR above; Q3 + 1.5 * IQR how to calculate percentiles - CORRECT ANSWER-percentile (L) = (n+1) * P/100 calculate z score outlier - CORRECT ANSWER-(value-mean)/SD rule of thumb for z score outlier - CORRECT ANSWER-above or below 3 SDs away which outlier method is more lenient - CORRECT ANSWER-z score, it goes further from mean than the IQR method ie the IQR gives a z score less than 3 cross tabulation - CORRECT ANSWER-a table or matrix that shows the relationship between two or more variables, often through frequency index - CORRECT ANSWER-designates variables used rows and columns summary - CORRECT ANSWER-which variables are analyzed in the table/ what the numbers show aggregation - CORRECT ANSWER-the function applied to valuation summary can be sum, mean, mode, etc what does sort function do - CORRECT ANSWER-sorts by column; headers values, small to large, custom ordinal values what does filter function do - CORRECT ANSWER-arrows on headers; gives lists, check particular values, hide some how to write function of higher or lower - CORRECT ANSWER-=countif(column of data, ""&value) how to create pivot table - CORRECT ANSWER-insert -- pivot table how to do k means clustering - CORRECT ANSWER-datamining tab -- cluster -- k means what type of data should you use for k means clustering - CORRECT ANSWER-non discrete, continuous dat