Excel Spreadsheet Homework Help!!!


 

Part 1: to be completed in Excel®

You control Human Relations for your audience. One of your sales controlrs has lonely, leaving an chink. You are regarding two contrariant employees for the lie. Twain are extremely adapted, so you feel ruled to evaluate their sales work for the departed year.

Using the Week 4 Grounds Set, create and calculate the subjoined in Excel®:

  1. Determine the collocate of values in which you would await to experience the mediocre weekly sales for the unimpaired sales nerve in your audience 90% of the era, and compute the subjoined:
    • The impression of increasing the faith plane to 95%
    • The impression of increasing the illustration magnitude to 150, ostentatious the identical moderation and rule failure, but remiting the faith plane to tarry at 90%
  2. Based on the computed faith season for weekly sales on the illustration of 50 reps at a 90% faith plane, compute the subjoined:
    • Both reps' mediocre weekly work, highlighting if it is superior than the population moderation
  3. In manage to enumerate who to exalt, enumerate whether there is a statistically contrariant mediocre weekly sales betwixt Sales Rep A and Sales Rep B by doing the subjoined:
    • Create vain and choice theory statements that would remit you to enumerate whether their sales work is statistically contrariant or not.
    • Use a judgment plane of .05 to pass a t-test of defiant illustrations to assimilate the mediocre weekly sales of the two candidates.
    • Calculate the p-value.
  4. Considering the single you did not exalt, do the subjoined:
    • Determine whether this person's mediocre weekly sales are superior than the mediocre weekly sales for the 50 sales reps whose grounds you used to enucleate faith seasons.
    • Create vain and choice theory statements that would remit you to enumerate whether this person's weekly mediocre sales are superior than the illustration of Sales Reps.
    • Use a judgment plane of .05 to pass a t-test of defiant illustrations to assimilate the mediocre weekly sales of twain.
    • Calculate the p-value.