For the global data workflow (Exercise #6), we combined the “automation global data” as the left input and “global data entity list” as the right input using the Alteryx join tool (using entity ID and entity number). Which of the following are true? Select all that apply. 

After cleaning data with Tableau Prep Builder, we can output the final cleaned data as a CSV file.

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

In ICE #9 “join2” we left join our “join1” table and the customer invoices table using the InvoiceID variable. If instead we use a inner join, we find that 1 observation is excluded from the join1 table. This means that there must be a sales order from join1 where InvoiceID is null. 

In ICE #9 “join4” we combine the join3 table and the customer master table using the variable CustID and in inner join. This results in a table with 1,168 observations. If we instead link this tables using a left join and the TerritoryID variable, we get a table with 18,937 observations. In this joined table, there are observations where the customerID from the join3 table does not equal the customerID from the customer master table. 

What critical input do Agarwal et al. argue is becoming “cheap” (i.e., reduced cost) and is relevant to this course on data analytics and machine learning?

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.