H A B D E G 1 Capital Credit Card Customers 2 3 File: Capital.xls 4 5 Column A: Customer Number 6 Column B: Credit Card Balance 7 Column C: Gender Code (1 = Male, 2 = Female) 8 9 2. [8] The marketing manager for the Capital Credit Union is considering developing an advertising campaign directed at female credit card customers. However, before continuing, she wants to know what the difference in average credit card balances is between male and female customers. She asked the database manager to select a random sample of 300 customers. These data are in the file Capital.- You may use Excel to develop necessary descriptive statistics or do them by hand. If you use Excel show your results. (a) [4] Use the sample data to construct a 95% confidence interval estimate for the difference in mean credit card balances for the difference in mean credit card balances for males and females. (b) [4] Interpret the interval estimate. Does there appear, from the interval, to be sufficient evidence to suggest a significant difference between male and female? H A B D E G 1 Capital Credit Card Customers 2 3 File: Capital.xls 4 5 Column A: Customer Number 6 Column B: Credit Card Balance 7 Column C: Gender Code (1 = Male, 2 = Female) 8 9 2. [8] The marketing manager for the Capital Credit Union is considering developing an advertising campaign directed at female credit card customers. However, before continuing, she wants to know what the difference in average credit card balances is between male and female customers. She asked the database manager to select a random sample of 300 customers. These data are in the file Capital.- You may use Excel to develop necessary descriptive statistics or do them by hand. If you use Excel show your results. (a) [4] Use the sample data to construct a 95% confidence interval estimate for the difference in mean credit card balances for the difference in mean credit card balances for males and females. (b) [4] Interpret the interval estimate. Does there appear, from the interval, to be sufficient evidence to suggest a significant difference between male and female