Excel Spreadsheet Homework Help!!!

  Part 1: to be completed in Excel® You influence Human Relations for your union. One of your sales influencers has single, leaving an hole. You are because two opposed employees for the position. Twain are very-much fitted, so you enjoy firm to evaluate their sales work for the gone-by year. Using the Week 4 Basis Set, cause and proportion the forthcoming in Excel®: Determine the dispose of values in which you would forebode to perceive the medium weekly sales for the perfect sales intensity in your union 90% of the duration, and proportion the forthcoming: The contact of increasing the assurance plane to 95% The contact of increasing the scantling bulk to 150, inflated the selfselfsame medium and model disconnection, but recognizeing the assurance plane to last at 90% Based on the proportiond assurance interim for weekly sales on the scantling of 50 reps at a 90% assurance plane, proportion the forthcoming: Both reps' medium weekly work, highlighting if it is main than the population medium In arrange to peculiarize who to raise, peculiarize whether there is a statistically opposed medium weekly sales between Sales Rep A and Sales Rep B by doing the forthcoming: Create vain and choice theory statements that would recognize you to peculiarize whether their sales work is statistically opposed or not. Use a sensation plane of .05 to influence a t-test of rebellious scantlings to parallel the medium weekly sales of the two candidates. Calculate the p-value. Considering the peculiar you did not raise, do the forthcoming: Determine whether this person's medium weekly sales are main than the medium weekly sales for the 50 sales reps whose basis you used to educe assurance interims. Create vain and choice theory statements that would recognize you to peculiarize whether this person's weekly medium sales are main than the scantling of Sales Reps. Use a sensation plane of .05 to influence a t-test of rebellious scantlings to parallel the medium weekly sales of twain. Calculate the p-value.