Explore the spending amount by creating a pivot table for the categorical variables, and computing the average and standard deviation of spending in...

1.    Explore the spending amount by creating a pivot table for the categorical variables, and computing the average and standard deviation of spending in each category.

2.    Explore the relationship between spending and each of the two continuous predictors by creating two scatter plots (SPENDING vs. FREQ, and SPENDING vs. LAST UPDATE). Does there seem to be a linear relationship there?

3.    In order to fit a predictive model for SPENDING,