Bank manager is interested to know what proportion ofcustomerswait more than 6 minutes before they get to a teller Her teamhas collected data on 1000 customers and the data is available in this file Bank Wait Time xlsx Based on this data what is the average proportion of customers who wait more than 6 minutes What is the upper value of 95 confidence interval for the average proportionof customers who wait more than 6 minutes before getting to a teller What is the margin of error for the 95 confidence interval of proportion of customers who wait more than 6 minutes before they get to a teller Wait Time 3 76 3 51 2 85 2 79 2 90 4 98 5 57 0 41 4 34 4 18 11 24 3 30 4 35 5 47 2 87 6 85 7 17 1 45 6 55 9 03 4 66 6 55 5 21 4 14 8 98 6 02 3 76 0 92 7 60 6 70 3 37 1 46 9 66 8 26 5 61 6 15 6 76 7 73 4 63 0 20 4 75 8 66 2 85 8 34 8 50 11 35 5 04 6 44 8 71 12 56 4 20 2 22 5 47 7 03 10 34 2 91 5 72 1 79 2 68 2 49 3 98 4 65 5 31 6 35 5 35 3 71 6 47 11 58 4 99 4 47 7 57 5 41 5 30 4 09 5 23 6 85 3 57 7 38 5 39 7 09 1 03 6 75 7 83 4 79 0 43 7 74 5 74 8 29 1 74 3 34 7 64 2 36 3 98 6 05 7 09 4 14 3 62 2 28 4 96 2 06 5 56 6 82 8 52 4 91 7 20 2 75 11 82 6 05 7 61 5 75 4 02 4 65 4 26 9 19 8 13 4 92 1 99 10 03 2 87 5 04 8 70 3 44 6 31 2 81 6 75 8 91 5 53 8 42 11 12 5 20 3 21 9 13 8 77 4 07 7 27 7 04 6 87 4 60 5 52 7 92 8 69 6 93 7 68 7 58 1 45 7 79 5 83 8 37 5 48 9 01 10 00 6 68 6 26 5 93 5 49 7 20 3 24 6 47 3 81 2 82 8 15 4 60 8 45 0 67 4 82 2 49 5 72 4 21 1 35 9 14 1 08 3 42 6 18 4 83 2 13 3 69 0 67 5 65 5 97 0 60 8 10 0 81 3 06 5 14 1 57 8 17 8 11 8 10 3 55 6 48 5 73 6 99 2 29 2 20 9 66 4 42 5 16 8 84 4 70 8 10 8 09 1 83 4 95 7 76 6 97 4 16 3 37 7 32 2 91 4 69 2 65 5 30 6 21 4 19 8 62 4 84 5 27 8 27 6 75 7 62 11 40 5 48 8 65 2 81 4 68 2 47 4 90 2 14 4 70 11 87 5 45 0 63 4 76 2 52 7 43 3 60 8 35 7 72 3 28 4 84 6 84 8 38 10 41 3 32 8 91 5 00 4 88 2 73 3 41 5 59 5 44 4 51 6 05 4 84 9 86 8 40 5 65 10 12 6 78 1 91 3 90 5 07 2 21 5 07 3 55 5 91 9 19 4 71 5 47 10 62 3 24 11 59 3 25 6 96 5 03 6 55 7 50 6 94 8 56 3 37 0 48 7 92 4 03 6 31 6 93 3 57 4 72 4 12 7 08 5 12 8 43 5 04 9 79 7 61 5 52 5 25 3 78 0 41 3 33 6 25 7 02 5 85 4 46 5 25 5 13 6 74 3 50 6 69 9 31 3 24 6 74 9 92 9 97 1 97 6 38 3 38 10 05 5 64 7 22 6 35 5 36 4 60 5 89 6 38 2 88 5 36 9 26 5 55 6 20 4 59 4 68 6 91 5 90 7 76 7 68 5 06 5 75 7 28 6 97 5 55 9 19 5 42 1 49 7 58 4 25 6 56 6 47 0 69 7 18 5 26 7 71 1 55 5 29 7 60 7 58 6 58 3 61 4 92 7 49 7 92 7 01 5 46 7 72 7 89 7 02 7 83 7 79 5 87 8 09 1 42 7 58 7 32 1 78 8 54 4 86 8 42 6 08 1 63 9 14 5 74 2 72 8 39 4 03 6 86 6 95 9 89 3 84 8 15 4 88 3 64 4 72 6 47 4 33 5 87 5 13 5 91 7 27 3 73 6 25 4 69 1 11 8 49 8 09 5 71 5 34 4 88 13 82 4 74 6 66 0 50 6 68 5 09 1 75 4 21 8 54 5 56 5 78 3 78 1 76 10 05 6 50 3 74 1 90 11 29 4 71 7 78 6 48 8 18 9 66 4 81 5 22 4 29 1 68 6 65 7 76 3 71 9 77 6 12 4 70 4 23 6 84 4 99 5 81 8 92 3 95 8 11 5 30 4 66 5 54 2 49 10 05 3 26 7 27 4 76 4 62 8 94 2 96 7 05 4 95 2 67 5 15 3 77 6 39 7 01 2 63 10 81 2 86 7 31 3 90 7 26 8 16 6 29 1 73 3 32 7 24 6 25 3 14 4 69 7 49 1 72 5 30 4 10 3 22 0 52 4 01 3 75 6 36 4 14 3 74 8 20 3 37 3 08 0 37 5 29 5 55 8 13 7 01 6 44 8 03 4 76 5 86 3 37 1 76 4 51 5 88 2 53 4 11 4 89 3 35 8 14 9 92 4 30 9 09 5 38 10 46 6 00 3 85 0 01 3 18 5 28 5 20 8 41 2 41 4 88 5 86 5 55 4 30 6 77 4 34 2 81 2 32 8 54 3 83 4 35 2 80 5 79 4 88 2 89 8 18 7 02 1 91 7 52 12 83 9 27 2 11 4 39 3 81 7 86 7 23 4 92 4 71 5 39 3 86 7 52 7 04 5 28 5 66 4 01 5 95 5 54 4 50 2 00 2 00 1 90 7 35 3 05 5 48 6 14 5 92 5 84 3 91 6 54 7 58 3 43 6 14 8 37 3 68 4 78 4 95 7 88 7 01 3 45 9 09 7 47 3 55 3 38 9 85 5 19 5 60 6 15 4 00 6 27 5 72 4 24 8 08 9 44 2 33 0 50 5 65 6 11 1 30 6 22 9 08 3 23 6 60 4 99 1 08 5 96 4 17 2 26 4 86 1 14 1 33 0 43 3 61 4 92 5 32 9 69 5 37 5 76 3 65 6 40 3 49 9 16 5 29 4 46 2 35 6 47 0 04 7 60 6 42 5 65 2 48 7 23 7 58 6 66 7 43 4 99 6 23 4 71 5 50 1 51 6 58 4 37 4 71 2 64 6 90 4 20 5 04 1 74 5 59 4 40 2 84 3 40 3 38 3 62 13 79 8 07 1 85 7 32 1 56 2 78 4 22 4 06 4 34 5 94 4 65 9 50 2 66 8 03 6 55 5 70 4 45 0 10 3 50 9 69 2 95 5 18 8 13 4 29 7 46 6 84 7 72 7 71 5 63 7 20 2 06 3 55 4 00 6 58 5 58 3 92 5 90 4 04 11 09 6 65 5 54 7 60 6 48 3 21 10 72 11 19 5 79 3 39 6 08 8 41 5 87 6 14 6 15 5 97 2 86 3 45 5 59 3 30 6 52 4 79 4 87 4 96 7 19 5 58 6 89 7 45 6 94 5 62 6 42 2 75 3 45 4 99 7 46 4 51 3 40 11 18 2 97 7 64 6 53 5 11 4 36 6 93 7 29 4 53 7 00 7 12 2 51 6 40 8 38 3 85 8 26 8 31 6 20 10 24 2 41 6 31 0 05 4 44 5 54 4 33 3 32 4 01 5 54 2 63 5 83 3 94 2 14 4 76 7 10 8 67 5 08 3 57 8 42 7 17 4 94 6 72 4 23 8 08 4 37 3 29 4 92 7 36 7 41 5 31 7 20 8 15 2 29 10 72 3 05 6 31 3 67 8 18 8 48 9 10 5 26 4 34 5 44 7 38 9 20 7 45 6 99 5 71 4 36 4 98 8 43 4 53 6 29 5 57 8 87 5 17 4 64 4 37 9 17 4 15 3 98 7 70 3 51 3 02 6 80 8 80 5 04 2 45 7 43 7 03 3 17 9 99 6 66 5 09 5 86 3 72 8 28 0 33 8 56 6 35 7 79 7 75 3 66 1 53 1 35 2 57 8 53 7 17 8 17 5 10 5 76 5 61 7 22 9 02 3 02 6 36 8 86 6 37 4 54 4 87 5 90 9 40 4 23 9 18 7 57 7 62 12 38 3 25 5 94 4 17 7 54 7 35 5 15 2 28 2 57 5 86 8 28 3 60 4 62 6 23 5 22 7 69 6 30 5 78 3 07 3 67 5 76 6 69 7 36 4 26 7 28 3 90 5 70 8 71 4 12 0 15 5 39 6 58 4 40 4 14 3 77 4 05 7 37 3 21 7 16 8 24 0 14 6 79 7 52 9 23 3 78 5 95 8 02 6 40 8 04 6 35 10 41 6 04 2 11 4 63 4 53 10 44 7 33 6 26 3 01 5 04 9 24 1 87 5 12 3 19 4 61 4 89 6 30 1 18 9 60 7 19 4 27 6 18 6 58 5 37 1 69 7 33 3 65 7 55 7 10 0 85 2 87 3 42 3 25 3 64 4 25 4 84 7 13 6 05 7 26 5 84 5 24 7 11 7 72 6 18 4 85 4 79 3 16 5 57 10 74 8 95 3 61 0 65 7 21 7 10 2 36 1 66 5 25 6 50 7 46 2 53 8 54 11 33 7 21 7 83 4 36 7 71 5 48 2 95 2 01 0 95 4 91 4 20 10 11 5 33 4 13 7 43 2 56 3 90 2 79 7 32 2 43 8 35 4 06 3 48 6 94 5 95 6 39 7 27 4 09 9 16 3 03 0 88 1 80 5 07

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 17, 2024

Bank manager is interested to know what proportion ofcustomerswait more than 6 minutes before they get to a teller.Her teamhas collected data on 1000 customers

Bank manager is interested to know what proportion ofcustomerswait more than 6 minutes before they get to a teller.Her teamhas collected data on 1000 customers and the data is available in this file:Bank_Wait_Time.xlsx

Based on this data what is the average proportion of customers who wait more than 6 minutes?

What is the upper value of 95% confidence interval for the average proportionof customers who wait more than 6 minutes before getting to a teller?

What is the margin of error for the 95% confidence interval of proportion of customers who wait more than 6 minutes before they get to a teller?

Wait Time
3.76
3.51
2.85
2.79
2.90
4.98
5.57
0.41
4.34
4.18
11.24
3.30
4.35
5.47
2.87
6.85
7.17
1.45
6.55
9.03
4.66
6.55
5.21
4.14
8.98
6.02
3.76
0.92
7.60
6.70
3.37
1.46
9.66
8.26
5.61
6.15
6.76
7.73
4.63
0.20
4.75
8.66
2.85
8.34
8.50
11.35
5.04
6.44
8.71
12.56
4.20
2.22
5.47
7.03
10.34
2.91
5.72
1.79
2.68
2.49
3.98
4.65
5.31
6.35
5.35
3.71
6.47
11.58
4.99
4.47
7.57
5.41
5.30
4.09
5.23
6.85
3.57
7.38
5.39
7.09
1.03
6.75
7.83
4.79
0.43
7.74
5.74
8.29
1.74
3.34
7.64
2.36
3.98
6.05
7.09
4.14
3.62
2.28
4.96
2.06
5.56
6.82
8.52
4.91
7.20
2.75
11.82
6.05
7.61
5.75
4.02
4.65
4.26
9.19
8.13
4.92
1.99
10.03
2.87
5.04
8.70
3.44
6.31
2.81
6.75
8.91
5.53
8.42
11.12
5.20
3.21
9.13
8.77
4.07
7.27
7.04
6.87
4.60
5.52
7.92
8.69
6.93
7.68
7.58
1.45
7.79
5.83
8.37
5.48
9.01
10.00
6.68
6.26
5.93
5.49
7.20
3.24
6.47
3.81
2.82
8.15
4.60
8.45
0.67
4.82
2.49
5.72
4.21
1.35
9.14
1.08
3.42
6.18
4.83
2.13
3.69
0.67
5.65
5.97
0.60
8.10
0.81
3.06
5.14
1.57
8.17
8.11
8.10
3.55
6.48
5.73
6.99
2.29
2.20
9.66
4.42
5.16
8.84
4.70
8.10
8.09
1.83
4.95
7.76
6.97
4.16
3.37
7.32
2.91
4.69
2.65
5.30
6.21
4.19
8.62
4.84
5.27
8.27
6.75
7.62
11.40
5.48
8.65
2.81
4.68
2.47
4.90
2.14
4.70
11.87
5.45
0.63
4.76
2.52
7.43
3.60
8.35
7.72
3.28
4.84
6.84
8.38
10.41
3.32
8.91
5.00
4.88
2.73
3.41
5.59
5.44
4.51
6.05
4.84
9.86
8.40
5.65
10.12
6.78
1.91
3.90
5.07
2.21
5.07
3.55
5.91
9.19
4.71
5.47
10.62
3.24
11.59
3.25
6.96
5.03
6.55
7.50
6.94
8.56
3.37
0.48
7.92
4.03
6.31
6.93
3.57
4.72
4.12
7.08
5.12
8.43
5.04
9.79
7.61
5.52
5.25
3.78
0.41
3.33
6.25
7.02
5.85
4.46
5.25
5.13
6.74
3.50
6.69
9.31
3.24
6.74
9.92
9.97
1.97
6.38
3.38
10.05
5.64
7.22
6.35
5.36
4.60
5.89
6.38
2.88
5.36
9.26
5.55
6.20
4.59
4.68
6.91
5.90
7.76
7.68
5.06
5.75
7.28
6.97
5.55
9.19
5.42
1.49
7.58
4.25
6.56
6.47
0.69
7.18
5.26
7.71
1.55
5.29
7.60
7.58
6.58
3.61
4.92
7.49
7.92
7.01
5.46
7.72
7.89
7.02
7.83
7.79
5.87
8.09
1.42
7.58
7.32
1.78
8.54
4.86
8.42
6.08
1.63
9.14
5.74
2.72
8.39
4.03
6.86
6.95
9.89
3.84
8.15
4.88
3.64
4.72
6.47
4.33
5.87
5.13
5.91
7.27
3.73
6.25
4.69
1.11
8.49
8.09
5.71
5.34
4.88
13.82
4.74
6.66
0.50
6.68
5.09
1.75
4.21
8.54
5.56
5.78
3.78
1.76
10.05
6.50
3.74
1.90
11.29
4.71
7.78
6.48
8.18
9.66
4.81
5.22
4.29
1.68
6.65
7.76
3.71
9.77
6.12
4.70
4.23
6.84
4.99
5.81
8.92
3.95
8.11
5.30
4.66
5.54
2.49
10.05
3.26
7.27
4.76
4.62
8.94
2.96
7.05
4.95
2.67
5.15
3.77
6.39
7.01
2.63
10.81
2.86
7.31
3.90
7.26
8.16
6.29
1.73
3.32
7.24
6.25
3.14
4.69
7.49
1.72
5.30
4.10
3.22
0.52
4.01
3.75
6.36
4.14
3.74
8.20
3.37
3.08
0.37
5.29
5.55
8.13
7.01
6.44
8.03
4.76
5.86
3.37
1.76
4.51
5.88
2.53
4.11
4.89
3.35
8.14
9.92
4.30
9.09
5.38
10.46
6.00
3.85
0.01
3.18
5.28
5.20
8.41
2.41
4.88
5.86
5.55
4.30
6.77
4.34
2.81
2.32
8.54
3.83
4.35
2.80
5.79
4.88
2.89
8.18
7.02
1.91
7.52
12.83
9.27
2.11
4.39
3.81
7.86
7.23
4.92
4.71
5.39
3.86
7.52
7.04
5.28
5.66
4.01
5.95
5.54
4.50
2.00
2.00
1.90
7.35
3.05
5.48
6.14
5.92
5.84
3.91
6.54
7.58
3.43
6.14
8.37
3.68
4.78
4.95
7.88
7.01
3.45
9.09
7.47
3.55
3.38
9.85
5.19
5.60
6.15
4.00
6.27
5.72
4.24
8.08
9.44
2.33
0.50
5.65
6.11
1.30
6.22
9.08
3.23
6.60
4.99
1.08
5.96
4.17
2.26
4.86
1.14
1.33
0.43
3.61
4.92
5.32
9.69
5.37
5.76
3.65
6.40
3.49
9.16
5.29
4.46
2.35
6.47
0.04
7.60
6.42
5.65
2.48
7.23
7.58
6.66
7.43
4.99
6.23
4.71
5.50
1.51
6.58
4.37
4.71
2.64
6.90
4.20
5.04
1.74
5.59
4.40
2.84
3.40
3.38
3.62
13.79
8.07
1.85
7.32
1.56
2.78
4.22
4.06
4.34
5.94
4.65
9.50
2.66
8.03
6.55
5.70
4.45
0.10
3.50
9.69
2.95
5.18
8.13
4.29
7.46
6.84
7.72
7.71
5.63
7.20
2.06
3.55
4.00
6.58
5.58
3.92
5.90
4.04
11.09
6.65
5.54
7.60
6.48
3.21
10.72
11.19
5.79
3.39
6.08
8.41
5.87
6.14
6.15
5.97
2.86
3.45
5.59
3.30
6.52
4.79
4.87
4.96
7.19
5.58
6.89
7.45
6.94
5.62
6.42
2.75
3.45
4.99
7.46
4.51
3.40
11.18
2.97
7.64
6.53
5.11
4.36
6.93
7.29
4.53
7.00
7.12
2.51
6.40
8.38
3.85
8.26
8.31
6.20
10.24
2.41
6.31
0.05
4.44
5.54
4.33
3.32
4.01
5.54
2.63
5.83
3.94
2.14
4.76
7.10
8.67
5.08
3.57
8.42
7.17
4.94
6.72
4.23
8.08
4.37
3.29
4.92
7.36
7.41
5.31
7.20
8.15
2.29
10.72
3.05
6.31
3.67
8.18
8.48
9.10
5.26
4.34
5.44
7.38
9.20
7.45
6.99
5.71
4.36
4.98
8.43
4.53
6.29
5.57
8.87
5.17
4.64
4.37
9.17
4.15
3.98
7.70
3.51
3.02
6.80
8.80
5.04
2.45
7.43
7.03
3.17
9.99
6.66
5.09
5.86
3.72
8.28
0.33
8.56
6.35
7.79
7.75
3.66
1.53
1.35
2.57
8.53
7.17
8.17
5.10
5.76
5.61
7.22
9.02
3.02
6.36
8.86
6.37
4.54
4.87
5.90
9.40
4.23
9.18
7.57
7.62
12.38
3.25
5.94
4.17
7.54
7.35
5.15
2.28
2.57
5.86
8.28
3.60
4.62
6.23
5.22
7.69
6.30
5.78
3.07
3.67
5.76
6.69
7.36
4.26
7.28
3.90
5.70
8.71
4.12
0.15
5.39
6.58
4.40
4.14
3.77
4.05
7.37
3.21
7.16
8.24
0.14
6.79
7.52
9.23
3.78
5.95
8.02
6.40
8.04
6.35
10.41
6.04
2.11
4.63
4.53
10.44
7.33
6.26
3.01
5.04
9.24
1.87
5.12
3.19
4.61
4.89
6.30
1.18
9.60
7.19
4.27
6.18
6.58
5.37
1.69
7.33
3.65
7.55
7.10
0.85
2.87
3.42
3.25
3.64
4.25
4.84
7.13
6.05
7.26
5.84
5.24
7.11
7.72
6.18
4.85
4.79
3.16
5.57
10.74
8.95
3.61
0.65
7.21
7.10
2.36
1.66
5.25
6.50
7.46
2.53
8.54
11.33
7.21
7.83
4.36
7.71
5.48
2.95
2.01
0.95
4.91
4.20
10.11
5.33
4.13
7.43
2.56
3.90
2.79
7.32
2.43
8.35
4.06
3.48
6.94
5.95
6.39
7.27
4.09
9.16
3.03
0.88
1.80
5.07