Part A Sebastian Schnauzer manages workflow in Accounts Receivable (AR) at BBT. Much of customer billing is automated, but there are exceptions. Exceptions require manual processing by AR staff. Sebastian would like to improve processing rates. After extensive analysis, he has determined that a pre-processing step will reduce processing time. To test out his theory, he ran a pilot test over the past two Mondays. On the first Monday (two weeks ago), the staff used the old process. On last Monday, they used the new process that included the new preprocessing step. To make the test fair, he sorted the records to ensure that each staff member received the same number of each type of exception on each of the two test days. However, he did not attempt to balance the number of each type of exception between staff members. For example, new customer record exception is called E1. Sally received the same proportion of E1 records last Monday as she did two weeks ago. Given that different types of exceptions require different processing time, Sebastian expected that staff output would vary signicantly. Here are the results of each test. 1. Compare the mean of each test using a two tailed t-test {see the example on C3}. Based on this test, do you think that preprocessing is helpful? 2. Use a two-tailed paired t-test to determine if the there is a significant difference between the two methods. 3. What do you recommend? If the tests gave different results, explain why. Part B BBT Managers are concerned that morale is suffering after the CEO created a number of new restrictive policies. One of the main complaints is lack of transparency. Employees believe that the CEO is making life harder on them out of spite rather than for sound business reasons. Managers believe that improving communication will help. They are conducting an experiment to see if sending a summary report that contains aggregate performance metrics and customer complaint statistics will improve em pioyee understanding of the problems the CEO is facing. To test this hypothesis, employees in two similarly-sized departments were selected for the experiment. Department 1 is the control group. They did not receive the report. Department 2 is the Treatment group. They did receive the report. Survey Question Employee morale is excellent at BBT. (strongly disagree) 1 2 3 4 5 6 7 (strongly disagree) 4. Does the report signicantly improve morale? Use ANOVA to ascertain whether or not the treatment worked. In your answer, please interpret the results and comment on the overall impact of the plan. Instructions! Use the data in the accompanying file to answer the four questions. Put the answers to the questions in the textboxes provided on the two spreadsheets