Solved by verified expert:Hi i need this problems solve in excel.. file is attached please complete the work in excel Sample T testConfidence intervals
midterm_exam_mba674_study.xlsx
Unformatted Attachment Preview
Store and Regional Sales Database
Sales Region
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
North
North
North
North
North
North
North
North
Units Sold
28
30
9
30
35
39
28
3
38
25
27
33
8
8
10
8
8
8
9
9
8
18
18
20
38
30
3
30
32
33
25
5
26
28
27
29
18
20
4
12
24
36
29
11
Week Ending
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
3.
a) Conduct a two sample T-test to see if the average num
units sold is the same or different for the South and North
Regions.
b) Is there a difference between the two regions
How do you know?
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
38
21
24
30
27
25
23
80
82
75
65
24
55
55
57
47
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
to see if the average number of
nt for the South and North
n the two regions for units sold?
Store and Regional Sales Database
ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
Store No.
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
Sales Region
Item No.
South
2005
South
2005
South
2005
South
3006
South
3006
South
3006
South
6050
South
6050
South
6050
South
8500
South
8500
South
8500
South
2005
South
2005
South
2005
South
3006
South
3006
South
3006
South
6050
South
6050
South
6050
South
8500
South
8500
South
8500
South
2005
South
2005
South
2005
South
3006
South
3006
South
3006
South
6050
South
6050
South
6050
South
8500
South
8500
South
8500
North
2005
North
2005
North
2005
North
3006
North
3006
North
3006
North
6050
North
6050
Item Description
Unit Price Units Sold
24″ Monitor
229
28
24″ Monitor
229
30
24″ Monitor
229
9
Wireless Keyboard
19,95
30
Wireless Keyboard
19,95
35
Wireless Keyboard
19,95
39
PC Mouse
8,95
28
PC Mouse
8,95
3
PC Mouse
8,95
38
Laptop
849,95
25
Laptop
849,95
27
Laptop
849,95
33
24″ Monitor
229
8
24″ Monitor
229
8
24″ Monitor
229
10
Wireless Keyboard
19,95
8
Wireless Keyboard
19,95
8
Wireless Keyboard
19,95
8
PC Mouse
8,95
9
PC Mouse
8,95
9
PC Mouse
8,95
8
Laptop
849,95
18
Laptop
849,95
18
Laptop
849,95
20
24″ Monitor
229
38
24″ Monitor
229
30
24″ Monitor
229
3
Wireless Keyboard
19,95
30
Wireless Keyboard
19,95
32
Wireless Keyboard
19,95
33
PC Mouse
8,95
25
PC Mouse
8,95
5
PC Mouse
8,95
26
Laptop
849,95
28
Laptop
849,95
27
Laptop
849,95
29
24″ Monitor
229
18
24″ Monitor
229
20
24″ Monitor
229
4
Wireless Keyboard
19,95
12
Wireless Keyboard
19,95
24
Wireless Keyboard
19,95
36
PC Mouse
8,95
29
PC Mouse
8,95
11
Week Ending
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
4
4
4
4
5
5
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
6
6
7
7
7
7
7
7
7
7
7
7
7
7
8
8
8
8
8
8
8
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
PC Mouse
8,95
Laptop
849,95
Laptop
849,95
Laptop
849,95
24″ Monitor
229
24″ Monitor
229
24″ Monitor
229
Wireless Keyboard
19,95
Wireless Keyboard
19,95
Wireless Keyboard
19,95
PC Mouse
8,95
PC Mouse
8,95
PC Mouse
8,95
Laptop
849,95
Laptop
849,95
Laptop
849,95
24″ Monitor
229
24″ Monitor
229
24″ Monitor
229
Wireless Keyboard
19,95
Wireless Keyboard
19,95
Wireless Keyboard
19,95
PC Mouse
8,95
PC Mouse
8,95
PC Mouse
8,95
Laptop
849,95
Laptop
849,95
Laptop
849,95
24″ Monitor
229
24″ Monitor
229
24″ Monitor
229
Wireless Keyboard
19,95
Wireless Keyboard
19,95
Wireless Keyboard
19,95
PC Mouse
8,95
PC Mouse
8,95
PC Mouse
8,95
Laptop
849,95
Laptop
849,95
Laptop
849,95
24″ Monitor
229
24″ Monitor
229
24″ Monitor
229
Wireless Keyboard
19,95
Wireless Keyboard
19,95
Wireless Keyboard
19,95
PC Mouse
8,95
38
21
24
30
27
25
23
80
82
75
65
24
55
55
57
47
24
85
56
52
58
69
35
39
44
78
88
99
34
36
35
49
47
48
45
42
45
55
57
55
18
17
23
22
18
22
14
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
92
93
94
95
96
8
8
8
8
8
East
East
East
East
East
6050
6050
8500
8500
8500
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
8,95
8,95
849,95
849,95
849,95
16
17
32
28
30
November
December
October
November
December
4.
a) Compute a 95% confidence interval for the
mean of “Units Sold.”
You can use any method (but only do ONE!!):
Method 1: Use descriptive statistics
Method 2: Confidence.t function
Method 3:
t.inv function &
standard error = SD / SQRT ( N)
b) Explain what the confidence interval means
…
Purchase answer to see full
attachment
