First two are problem. bottom two are the excel file to help solve.

Greg Metcalf works for a national credit card company, and he is performing a customer value analysis on a subset of credit card customers. In order to perform the RFM analysis on the customers, Greg has compiled the accompanying data file that contains the dates of the last transaction (LastTransactionDate), total number of transactions in 2017 and 2018 (Frequency), and total spending during 2017 and 2018 (Spending). a. Greg wants to calculate the number of days between January 1, 2022, and the last transaction date. Create a new variable "DaysSinceLast" that contains the number of days since the last transaction. (Hint: use the DATEDIF function if you are using Excel to complete this problem.) What is the average number of days since the last purchase for all the customers? Note: Round your answer to two decimal places. b. Create the RFM scores for each customer. How many customers have an RFM score of 455 ? What is their average spending? Note: Round "Average spending" to the nearest whole dollar amount. c. Create a new variable called "LogSpending" that contains the natural logarithms for the total spending during 2017 and 2018. Bin the logarithm values into 5 equal-interval groups. Label the groups using numbers 1 (lowest values) to 5 (highest values). How many observations are in group 4 ? d. Create a new variable called "AverageOrderSize" that contains the average spending per order. This is calculated by dividing total spending (Spending) by total number of transactions (Frequency) in 2017 and 2018. Bin the values of AverageOrderSize into 5 equal-interval groups. Label the groups using numbers 1 (lowest values) to 5 (highest values). How many observations are in group 4 ? e. Compare the number of observations in group 4 in parts c and d. Are the groupings the same or different? The groups in parts c and d are the same. The group in part c has fewer observations than the group in part d. The group in part c has more observations than the group in part d. One group has no observations, while the other group has 56 observations