You manage Human Relations for your company. One of your sales managers has retired, leaving an opening. 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 Week 4 Data Set, create and calculate the following in Excel®: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 increasing the sample size to 150, assuming the same mean and standard deviation, but allowing the confidence level to remain at 90%Based on the calculated confidence interval for weekly sales on the sample of 50 reps at a 90% confidence level, calculate the following:Both reps’ average weekly performance, highlighting if it is greater than the population meanIn order to decide who to promote, determine whether there is a statistically different average weekly sales between Sales Rep A and Sales Rep B by doing the following:Create null and alternative hypothesis statements that would allow you to determine whether their sales performance is statistically different or not.Use a significance level of .05 to conduct a t-test of independent samples to compare the average weekly sales of the two candidates.Calculate the p-value.Considering the individual you did not promote, do the following:Determine whether this person’s average weekly sales are greater than the average weekly sales for the 50 sales reps whose data you used to develop confidence intervals.Create null and alternative hypothesis statements that would allow you to determine whether this person’s weekly average sales are greater than the sample of Sales Reps.Use a significance level of .05 to conduct a t-test of independent samples to compare the average weekly sales of both.Calculate the p-value.Please use this info below, this is the data you will need to use to complete the assignment. I also attached the spread sheet, use week 4 data to complete the assignment.
SAMPLE OF WEEKLY SALES
Sales
Rep #
AverageWeekly
Sales($)
Week #
Weekly Sales($) –
Rep A
Weekly Sales($) –
Rep B
1
1228
1
4657
5839
2
7374
2
6133
2602
3
1055
3
3438
2830
4
1859
4
7394
4763
5
3938
5
4327
3740
6
1692
6
2552
2315
7
569
7
7063
1599
8
4059
8
7844
1629
9
3689
9
6898
2416
10
607
10
4003
2107
11
1370
11
6884
4237
12
3735
12
4007
6322
13
3305
13
7214
3710
14
7228
14
2358
5890
15
6279
15
7745
5119
16
1671
16
1337
5184
17
5708
17
1052
3439
18
2569
18
6056
4828
19
4163
19
1495
3667
20
1519
20
3530
3518
21
7734
21
4749
6073
22
784
22
3833
5566
23
6766
23
7869
4555
24
7261
24
4541
5867
25
5034
25
6882
6039
26
7115
26
3868
1032
27
6291
27
5934
4834
28
6287
28
4447
3687
29
2080
29
5504
5500
30
7621
30
5554
4659
31
1047
32
6517
33
5172
34
3876
35
5429
36
4538
37
3786
38
2510
39
4863
40
7246
41
1175
42
641
43
4269
44
7034
45
3406
46
2256
47
3182
48
5178
49
4428
50
1189
attached is the data sheet you will need to use as well, its the same as above date. please only use week 4 data
“
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
