Answer all the questions in this case, using Excel spreadsheet. and submit your Excel file to Blackboard. Answer the following questions:Required Tasks:

• Develop bar charts showing the mean and median current account balance by gender of the caller.
• Develop bar charts showing the mean and median current account balance by gender of the account holder.
• Construct a scatter diagram showing current balance on the horizontal axis and past due amount on the vertical axis.
• Compute the key descriptive statistics for the center and for the variation in current account balance broken down by gender of the caller, gender of the account holder, and nature of the call.
• Repeat task 4 but compute the statistics for the past due balances.
• Compute the coefficient of variation for current account balances for male and female account holders.
• Develop frequency and relative frequency distributions for the gender of callers, gender of account holders, and nature of the calls.
• Develop joint frequency and joint relative frequency distributions for the account holder gender by whether or not the account has a past due balance.

E Case 3.2 National Call Center Candice Worthy and Philip Hanson are day-shift supervi- By the time they reached their office, Candice and Philip had out- sors at National Call Center's Austin, Texas, facility. lined some of the key tasks that they needed to do. (o> National provides contract call center services for a number of companies, including banks and major retail companies. Candice Required Tasks: and Philip have both been with the company for slightly more than 1. Develop bar charts showing the mean and median current account balance by gender of the caller. Q five years, having joined National right after graduating with bach- elor's degrees from the University of Texas. As they walked down 2. Develop bar charts showing the mean and median current the hall together after the weekly staff meeting, the two friends account balance by gender of the account holder. were discussing the assignment they were just handed by Mark 3. Construct a scatter diagram showing current balance on the Gonzales, the division manager. The assignment came out of a dis- horizontal axis and past due amount on the vertical axis. cussion at the meeting in which one of National's clients wanted a 4. Compute the key descriptive statistics for the center and for report describing the calls being handled for them by National. the variation in current account balance broken down by Mark had asked Candice and Philip to describe the data in a file gender of the caller, gender of the account holder, and nature called National Call Center and produce a report that would both of the call. BJ graphically and numerically analyze the data. The data are for a 5. Repeat task 4 but compute the statistics for the past due sample of 57 calls and for the following variables: balances. 6. Compute the coefficient of variation for current account Account Number balances for male and female account holders. AA 7. Develop frequency and relative frequency distributions for Caller Gender the gender of callers, gender of account holders, and nature Account Holder Gender of the calls. 8. Develop joint frequency and joint relative frequency Past Due Amount distributions for the account holder gender by whether or not the account has a past due balance. Current Account Balance 9. Write a report to National's client that contains the results for tasks 1-8 along with a discussion of these statistics and Nature of Call (Billing Question or Other) graphs. X 120StatCrunch Applets * Edit Data Stat Graph Help Row Account Numb Caller Gender Account Holdeast Due Amou Current Amoun Was this a Billi 4348291 40.35 82.85 Yes 6008516 O -129.67 No 17476479 76.38 No 13846306 99.24 No 21393711 37.98 Yes 18712654 40.89 Yes 10 00 19432077 -93.16 No 19205946 95.21 Yes 10 8679852 121.79 No 11 12762185 0 No 12 4139796 386.77 0 Yes 13 17139670 0 102.03 No 14 8979191 83.36 150.84 Yes 15 7280135 54.57 Yes 16 6707912 O No 17 21520203 46.98 No 18 85623 78.41 Yes 19 9356536 142.95 Yes 20 17405616 51.83 Yes 21 20898785 145.8 217.86 Yes 22 19731969 26.08 No 23 12784685 90.7 181.67 Yes 24 20085243 0 1.12 YesStatCrunch * Applets Edit Data Stat * Graph Help Row Caller Gender Account Holdeast Due Amou Current Amoun Was this a Billi var 25 -18.13 No 26 2.13 No 27 0 No 28 70.89 116.54 Yes 29 0 No 30 40.26 82.65 Yes 31 O 58.82 No 32 O 57.54 Yes 33 27.03 No 34 31.99 Yes 35 -60.98 Yes 36 0 No 37 52.49 No 38 O 58.16 No 39 59.83 135.41 Yes 40 40.79 No 41 108.08 No 42 O 99.48 No 43 184.49 184.49 Yes 44 71.75 Yes 45 0 No 46 51.63 151.92 Yes 47 0 168.71 No 48 4.62 YesStatCrunch Applets Edit Data * Stat Graph * Help Row Caller Gender Account Holdeast Due Amou Current Amoun Was this a Billi Vai 49 O 65.93 No 50 53.97 No 51 2 59.07 No 52 313.78 No 53 39.75 144.48 No 54 Yes 55 0 No 56 Yes 57 50.64 58.55 Yes 58 33.83 68.68 Yes 59 60