In ICE #9, If we “full join” KMPG’s Sales Order file with Shipments file using Sales Order ID, we keep the records (observations) that are only in both Sales Order file and Shipments file.

In the KPMG revenue case (ICE #9), we first filtered observations for shipments made in 2017 and the “aggregated” sales transactions by TerritoryID, Shipping Month, and whether the sale is related to the new product (#7123).  We then outputted this data as a csv file. The grouped data has 5*12*2 = 120 observations.

Machine learning generates predictions by evaluating thousands (if not millions) of if-then statements. 

All else equal, a higher true positive rate is associated with what? Select all the apply. 

What of the following are true statements regarding select statements? Select all that apply.

Which of the following statements accurately describes a relational database? Select all that apply. 

Which of the following are true regarding joins? Select all that apply.

Data types define what kind of information is stored in a particular column (variable). What data type would you use to store a manager’s name? 

Which type of visual is useful for comparing the numerical distribution of a variable across different categories? 

Which visualizations depict the full numerical distribution of a single variable? Select all that apply.