DAT 325 Project Three Template
Data Validation
File Names Table
Perform the following data validation on each of the import, existing, and merge data
tables.
● The COUNT of rows in each table. You should reconcile these counts to make
sure the number of rows you inserted made it into the merged table.
Excel Files
Source File Anomalies Import Existing Merge Data
Data Data
Count 205 4 203 795 998
● Use the identified variable for your chosen data set as listed below to determine
MIN, MAX and AVERAGE for each table:
Data Set: Supermarket
Variable: Gross Income by location
Determine the MIN, MAX, and AVERAGE in your uploaded table, the MIN, MAX,
and AVERAGE in the existing table before you inserted the new rows, and the
MIN, MAX, and AVERAGE in the existing table after you insert new rows.
Data Validation
File Names Table
Perform the following data validation on each of the import, existing, and merge data
tables.
● The COUNT of rows in each table. You should reconcile these counts to make
sure the number of rows you inserted made it into the merged table.
Excel Files
Source File Anomalies Import Existing Merge Data
Data Data
Count 205 4 203 795 998
● Use the identified variable for your chosen data set as listed below to determine
MIN, MAX and AVERAGE for each table:
Data Set: Supermarket
Variable: Gross Income by location
Determine the MIN, MAX, and AVERAGE in your uploaded table, the MIN, MAX,
and AVERAGE in the existing table before you inserted the new rows, and the
MIN, MAX, and AVERAGE in the existing table after you insert new rows.
