Question
You suspect that your Toronto customer support team may take less time to serve each customer on average than your Montreal team. You gathered a
You suspect that your Toronto customer support team may take less time to serve each customer on average than your Montreal team. You gathered a sample from each group, included in the Excel file. Assume that you know the standard deviation for each population (2.6 for Toronto, 3.7 for Montreal). For this question, perform your calculation using the formulasdo not use the Analysis Toolpak tools.
Part a) Calculate a 95% confidence interval for the difference between population means.
Part b) You suspect that the population mean Toronto is less than for Montreal. Perform a hypothesis test, using the p-value method, at a 90% confidence level. Show all parts of the hypothesis test, including your hypotheses, identification/calculation of the necessary values, your test-statistic calculation, your p-value calculation, and your conclusion.
excel data :
Toronto
13
20
17
17
13
17
13
10
19
22
19
17
19
16
16
20
17
18
19
19
18
22
22
14
19
16
19
16
17
19
13
17
20
10
12
15
19
17
17
19
14
17
17
12
19
17
20 18
19
16
15
20
15
23
16
15
17
18
12
17
13
19
montreal data
17
20
13
14
22
25
20
25
17
20
28
13
18
23
22
10
19
21
17
20
23
22
24
11
24
22
18
13
21
22
15
14
23
15
15
24
14
18
18
21
21
17
15
21
16
22
15
25
16
25
9
19
13
12
18
23
24
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started