Question
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 |
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