Qmb 3302 - Study guides, Class notes & Summaries

Counts the number of cells within a range that meet the given criteria - =COUNTIF(range, criteria) Sorting data and calculating cumulative proportions. - Pareto Analysis Multiple criteria in the same row are logically joined by "and," while criteria in rows are joined by "or." - Advanced Filter When you are performing an advanced filter, where do you enter the range for the dataset? - List range cell range containing one row of labels and at least one additional row underneath th...

Heatmaps can be used to quickly understand correlated variables in a dataset - true how do you insert comments into a python code cell? - #comment Imagine we have a dataframe, df, what would the following code do? [ ] . - looks for labels in the list below, what position is the first number (the number 8) in? my_list[8, 6, 3, 5, 6] - none/error in the list below, what position is the number 2 in? my_list = [9, 2, 1, 3, 4] - 1 Matplotlib is built on top of seaborn (uses seaborn code) - fa...