Please provide pictures of software output using excel

9-8 12.46 A study was done to determine whether the re gender of the credit card holder was an important fac- tor in generating prot for a. certain credit card com- pany. The variables considered were income, the num- ber of family members, and the gender of the card holder. The data are as follows: ice loo: gas Family Prot Income Gender Members 157 45 ,000 M 1 #181 55, 000 M 2 -253 45,800 M 4 158 38,000 M 3 '75 75,000 M 4 202 99,750 M 4 -451 28,000 M 1 146 39,000 M 2 89 54,350 M 1 -357 32,500 M 1 522 36,750 F 1 78 42,500 F 3 5 34,250 F 2 177 36,750 F 3 123 24,500 F , 2 251 27,500 - F i 1 56 18,000 L r F' 1 453 24,500 r a F 1 288 88,750 Ff 1 104 19,750 _ , IEF'i : 2 (a) Fit a linear regression: mhdel "115mg the variables available. Based on the tted model, would the company prefer male or female customers? (b) Would you say that income was an important face tor in explaining the variability in prot