Part B: Credit Cards Background Information (30 marks) Refer to the file PART B - Credit Cards Data.xlsx to answer all questions in Part B. The source of the data is https://www.kaggle.com/datasets/whenamancodes/credit-card-customers- prediction filtered for the existing customers only. This dataset contains a random sample of credit card customers from a bank. It contains information on customers' age, salary, marital status, credit card limit, credit card category, etc. It is used to analyse various aspects of transactions. Hover your cursor over the variable names in the dataset to see a description of the variables. Instructions: You are required to create a new column labelled Credit_Limit_Category as follows: Credit limit at most $2000 as "Low" Credit limit greater than $2000 and at most $10,000 as "Medium" Credit limit greater than $10,000 and at most $20,0000 as "High" Credit limit greater than $20,000 as Very High" (Hints: There are 1029 and 1080 customers in the "Low" and "Very High" credit limit categories, respectively.) Question 1 (15 marks) a) Based on the categories above, compare the distribution of the variable total transaction amount (Total_Trans_Amt) between married and single customers with (i) Low credit limit (ii) Very High credit limit Use appropriate measures such as summary statistics and histograms to discuss typical values of central tendency measures shape of the distributions b) Using the credit limits and marital statuses in (a), does the single or married customer group show more variability in the transaction amount? Support your answer with a suitable explanation and all variability measures. Note: In your answers, use appropriate evidence and provide contextual interpretations for all measures discussed. Question 2 (8 marks) For customers who have a very high credit limit, compare the average total transaction amounts (Total_Trans Amt) between male and female customers who are married and single. In your discussion, include: 1. A description of differences in average transaction amounts by gender. 2. Are your observations in (1) true for married and single customers? 3. Your discussion should also include information on which group (e.g. married female, single male, etc.) has the highest and lowest average transaction amount, with possible reasons for the differences. Aid your answer with an appropriate pivot table as evidence to support your discussion. Remember to format your table. Question 3 (7 marks) We wish to compare the percentage frequency of gender for the four credit limit categories you established initially. What are the main differences in gender within each credit limit category? Discuss these differences and include a pivot table and an appropriate graph to support your answer.