In this homework assignment, I am expecting you to be able to merge data sets. Please refer to Assignment $\backslash$#$2$ for an explanation of the data set that has $42,694$ customers who have purchased an item in the last $12$ months. This time the data was split into the following two data sets:

Data Set $\backslash$#$1$: Brightspace $>$ Course Materials $>$ Content $>$ HW Assignments $>$ Email Test$1.$csv

Data Set $\backslash$#$2$: Brightspace $>$ Course Materials $>$ Content $>$ HW Assignments $>$ Email Test$2.$csv

There is a separate data set that describes the e$-$mail campaign the customer received:

$-\backslash (1/2\backslash )$ were randomly chosen to receive an e$-$mail campaign featuring Men's merchandise.

$-\backslash (1/2\backslash )$ were randomly chosen to receive an e$-$mail campaign featuring Women's merchandise. Observe the following dataset that describes the type of email received associated with each customer:

Data Set $\backslash$#$3$: Brightspace $>$ Course Materials $>$ Content $>$ HW Assignments $>$ Email Indicator.csv

Please complete parts $($a$)$ through $($c$)$ in SAS, SPSS and Excel.

a$)$ Please merge both the Email Test$1$ and Email Test$2$ data sets into one file.

b$)$ Merge the variable information from the Email Indicator dataset to the dataset in part $\backslash$#$1.$

c$)$ Which e$-$mail campaign performed the best, the Men's version, or the Women's version? Why? Did the campaigns perform different when measured across different metrics, like Visitors, Conversion, and Total Spend?