Part 2: Add the Missed Payments" information from "Source 3" to "Full Set" We have observed an anomaly in the "Missed Payment" field. In the Source 3 worksheet, curren customer has no missed payments, their value for that field is "NONE". We want to add a new co called "Missed Payments 2" to convert the string value of "NONE" to a numeric value of o. Use th function to do this. Once you do the transformation, use the VLOOKUP() function to bring the da the Missed Payments 2 column into the "Full Set" worksheet. Question: Write the data transformation rule for the missed payment field (list the syntax of th function and explain the criteria you used to transform the data). [5 points) Part 3: Add the "Country" information from "Source 3" to "Full Set" We have observed a lack of consistency in the "Country" field. Notice that "United States" string represented in several different ways. Choose one of those representations and transform the remaining "Country" data so that the value for the United States is consistent across all custome Create "Country 2 column and use it to hold the transformed data. Use an IF() statement to tra the data. Then use the VLOOKUP() function to bring the data into the "Full Set" worksheet. Question: Write the data transformation rule for the country field (list the syntax of the IF() fun and explain the criteria you used to transform the data). [5 points) 1 Customer Name Original Credit Line Missed Payments Country Country 2. 2 Allan Strate $10,000.00 1 USA United States 3 Cathrine Delamater $20,000.00 3 USA United States 4 Christin Tillinghast $8,000.00 5 United States United States 5 Daniela Becknell $10,000.00 o United States United States 6. Darryl Manuelito $10,000.00 O US United States 7 Eleanor Aburto $10,000.00 O Canada Canada 8 Elnora Willison $20,000.00 3 US United States 9 Erik Vire $0.00 O US United States 10 Eve Haak $5,000.00 o United States United States 11 Jamie Sabat $5,000.00 O Canada Canada 12 Jamie Woodbridge $5,000.00 5 USA United States 13 Julio Willard $10,000.00 O USA United States 14 Kisha Grauer $7,500.00 O USA United States 15 Leota Vonderheide $7,500.00 3 USA United States 16 Lonnie Ludy $10,000.00 2 USA United States 17 Max Kindle $10,000.00 O USA United States 18 Milagros Fehrenbach $0.00 O USA United States 19 Odessa Smith $20,000.00 O USA United States 20 Roslyn Plott $20,000.00 OUS United States 21 Roxie Prewitt $20,000.00 3 US United States 22 Suzan Plock $7,500.00 O US United States 23 Tyrone Hine $20,000.00 2 US United States Source 1 Source 2 Full Set Lookups Source 3 Part 2: Add the Missed Payments" information from "Source 3" to "Full Set" We have observed an anomaly in the "Missed Payment" field. In the Source 3 worksheet, curren customer has no missed payments, their value for that field is "NONE". We want to add a new co called "Missed Payments 2" to convert the string value of "NONE" to a numeric value of o. Use th function to do this. Once you do the transformation, use the VLOOKUP() function to bring the da the Missed Payments 2 column into the "Full Set" worksheet. Question: Write the data transformation rule for the missed payment field (list the syntax of th function and explain the criteria you used to transform the data). [5 points) Part 3: Add the "Country" information from "Source 3" to "Full Set" We have observed a lack of consistency in the "Country" field. Notice that "United States" string represented in several different ways. Choose one of those representations and transform the remaining "Country" data so that the value for the United States is consistent across all custome Create "Country 2 column and use it to hold the transformed data. Use an IF() statement to tra the data. Then use the VLOOKUP() function to bring the data into the "Full Set" worksheet. Question: Write the data transformation rule for the country field (list the syntax of the IF() fun and explain the criteria you used to transform the data). [5 points) 1 Customer Name Original Credit Line Missed Payments Country Country 2. 2 Allan Strate $10,000.00 1 USA United States 3 Cathrine Delamater $20,000.00 3 USA United States 4 Christin Tillinghast $8,000.00 5 United States United States 5 Daniela Becknell $10,000.00 o United States United States 6. Darryl Manuelito $10,000.00 O US United States 7 Eleanor Aburto $10,000.00 O Canada Canada 8 Elnora Willison $20,000.00 3 US United States 9 Erik Vire $0.00 O US United States 10 Eve Haak $5,000.00 o United States United States 11 Jamie Sabat $5,000.00 O Canada Canada 12 Jamie Woodbridge $5,000.00 5 USA United States 13 Julio Willard $10,000.00 O USA United States 14 Kisha Grauer $7,500.00 O USA United States 15 Leota Vonderheide $7,500.00 3 USA United States 16 Lonnie Ludy $10,000.00 2 USA United States 17 Max Kindle $10,000.00 O USA United States 18 Milagros Fehrenbach $0.00 O USA United States 19 Odessa Smith $20,000.00 O USA United States 20 Roslyn Plott $20,000.00 OUS United States 21 Roxie Prewitt $20,000.00 3 US United States 22 Suzan Plock $7,500.00 O US United States 23 Tyrone Hine $20,000.00 2 US United States Source 1 Source 2 Full Set Lookups Source 3