(Answered):Week 4 Case Study Excel . . . .

Question Description

You manage human relations for your company. One of your sales managers has retired, leaving an opening in the organization. You are considering two different employees for the position. Both are highly qualified, so you have decided to evaluate their sales performance for the past year.

Using the attached spreadsheet create and calculate the following in Microsoft® Excel®:

1. Determine the range of values in which you would expect to find the average weekly sales for the entire sales force in your company 90% of the time, and calculate the following:
   • The impact of increasing the confidence level to 95%
   • The impact of
     OR

      

     PayPal Gateway not configured

     OR

      

     PayPal Gateway not configured