Normalize the following two columns of data. Remember to normalize or standardize data you find the z-score: (x - mean)/sd. Note each column will have its own mean & standard deviation.

Age Income ($)

25 49,000

56 1,56,000

65 99,000

32 1,92,000

41 39,000

49 57,000

Use the Excel formulas =AVERAGE() and =STDEV.S. What is the mean and standard deviation of the new columns of data? Make a scatterplot on excel using the old data. Make sure to add x and y axis labels.Also, make a new scatterplot with the new data. Make sure to add x and y axis labels. Compare them.