This is in order please help

3.7 confidence interval is 37 2.8 39 1.5 (3) Create a new confidence interval (with 90% confidence) for the population mean of checkout times (in minutes). (To two decimal 40 2.2 41 0.5 places) The TINVO function returns a value of 42 2.2 Note: Population standard deviation is NOT known. 43 2.8 (4) Use the same confidence interval from question 3 to answer the 44 2.4 following question. (To two decimal places) The margin of error for 45 3.9 46 3.4 this confidence interval is 47 0.4 48 3.3 49 3 50 1.9 51 3.6 52 23 53 3 54 1.5 55 2.2 56 1.2 57 2.3 58 3.8 4.6 60 2.8 61 3.1 62 3.1 63 1.5 64 4.3 65 1.2 66 4.2 67 3.4 68 4 1.6 70 71 2.7 72 73 1.3\fM25 X V 962.200888603547 A B C D E F G H K M N O P Q R S T U V A Number of correct estimates of the population mean Confidence 95% Simulated population mean: 1000 Simulated population variance: unknown 0 Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6 Sample 7 Sample 8 Sample 9 Sample 10 Sample 11 Sample 12 Sample 13 Sample 14 Sample 15 Sample 16 Sample 17 Sample 18 Sample 19 Sample 20 Sample 2 point estimate of mean Independent Lab Assessment Questions 5 sample standard deviation 6 sample size Fill in the formulas on the left, and propogate them all the way to the right. Make sure the lock in your cells (absolute reference) when needed. ie) confidence level. 7 standard error 8 (5) Compute the confidence interval (with 95% confidence) for the mean for each of the 100 random, normally distributed samples shown on the NORMAL worksheet. (To two decimal places) the TINV() function returns a 9 confidence coefficient value of for each interval. 10 alpha (6) Compute the confidence interval (with 95% confidence) for the mean for each of the 100 random, normally 11 t a/2 (use TINV) distributed samples shown on the NORMAL worksheet. (To zero decimal places) the number of confidence 12 intervals that do NOT include the simulated population mean is (7) Compute the confidence interval (with 95% confidence) for the mean for each of the 100 random, normally 13 margin of error distributed samples shown on the NORMAL worksheet. List all the sample NUMBERS (just the numbers) that 14 have a confidence interval that do NOT include the simulated population mean. (Note there may be more spaces 15 lower confidence limit 16 upper confidence limit MGTS students: the population is normally distributed with a mean is 1000 and you are not given any information about the standard deviation Is the CI based on this In Rows 15 and 16, use conditional formatting to highlight (fill cell with color) all lower Cl limits that exceed 1000, and all upper sample a "correct CI limits that are less than 1000 [i.e., highlight the interval estimates that are incorrect and do not "contain" the true population 17 estimate"? mean]. No No No No No No No No No No No 18 19 2022 Sample Data: Simulation of 100 random samples of size n = 25 from a normal population with mean = 1000 23 observation # Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 |Sample 6 |Sample 7 S Sample 8 Sample 9 Sample 10 Sample 11 Sample 12 Sample 13 Sample 14 Sample 15 |Sample 16 Sample 17 Sample 18 Sample 19 Sample 20 24 978.46 1001.34 1026.78 1022.89 989.66 1036.57 1049.42 964.24 1041.51 1010.47 944.70 979.07 1062.02 896.89 1065.39 906.91 925.2 1072.13 974.24 968. 25 950.75 1018.45 974.41 972.30 931.52 1112.87 970.61 975.60 972.83 957.73 946.49 962.20 923.69 976.23 1020.65 1009.85 1027.15 880.63 1005.13 1016.5 957.60 1063.38 981.3 26 938.80 931.09 1019.00 1028.30 937.08 929.92 197.30 1000.96 1017.56 92.27 992.46 1040.57 994.27 995.06 1002.29 191.14 837.57 990.01 951.3 27 1050.33 1053.87 929.08 944.93 1037.29 932.91 1119.04 1013.53 1019.07 1045.43 16.36 1037.40 1101.83 1051.61 981.82 961.17 1032.4 1006.10 28 1053.40 1052.45 976.43 1035.2 1047.86 958.96 1000.4 971.09 1015.08 913.87 1014.5 990.51 1033.3 897.55 995.26 1065.73 941.79 1036.54 1018.10 873.70 1009.77 940.61 1003.2 29 993.58 105.76 189.71 938.74 959.10 1021.34 1034.75 993.81 1053.53 998.12 013.25 36.91 1083.07 940.94 1032.21 963.96 1110.07 085.36 1003.99 1043.21 972.89 904.91 979.43 905.96 924.75 958.44 1057.91 1018.49 981.26 1006.53 985.04 1064.02 1096.61 989.94 1079.34 1023. 30 992.15 31 954.90 895.06 976.51 998.44 1043.56 1032.56 1017.00 963.64 920.85 061.46 993.4 956.92 988.93 1032.6 962.59 1007.44 927.19 1068.74 859.46 935.92 9 964.96 910.36 985.98 1022.57 929.53 1054.95 1023.17 1029.35 1020.53 1008.91 985.41 1015.64 985.29 1016.06 1098.48 985.1 32 1072.49 64.88 966.06 1033.05 33 10 1009.76 1034.58 996.93 1004.38 966.49 967.18 1036.80 955.30 1085.43 989.10 1032.99 937.29 923.84 969.44 975.12 1111.35 1035.13 1092.7 1100.93 943.02 34 11 1042.13 987.59 73.52 1019.95 999.84 1009.37 1102.95 874.96 969.47 1030.43 968.49 992.33 1005.19 1077.07 985.41 985.01 942.37 1087.92 1096.29 1032.6 12 099 56 32.94 1047.39 1001.41 1065.34 198.86 1020.65 955.59 1004.54 934.52 1067.92 1004.96 962.81 003.7 1040.83 954.87 1074.28 922.21 1021.41 915.9 35 36 13 1034.38 1045.28 1029.87 1050.7 919.80 1072.30 1024.26 949.62 982.18 1040.29 960.60 1041.15 879.40 994.60 1001.87 1014.20 1006.53 988.86 952.93 961.1 37 14 954.29 59.01 997.73 1003.51 96.28 1042.01 1019.15 952.26 949.25 1040.55 1065.58 1012.78 1011.03 981.01 1006.37 1 102.35 1013.69 1001.12 981.6 1035.76 191.3 38 15 946.63 930.72 1035.52 1051.81 1053.39 1010.55 1085.64 972.57 933.33 970.31 997.07 1010.91 1024.96 1058.09 1067.18 967.30 1029.33 1042.08 1026.16 39 16 989 44 994.11 1016.43 1021.64 931.16 915.24 1012.49 1070.62 1016.92 928.54 1021.38 1021.74 966.74 1001.86 1041.54 1063.35 1043.17 1041.93 940.16 989.96 17 964.81 990.62 954.52 1022.48 980.15 936.77 981.37 1122.35 1000.72 982.75 920.13 972.84 1044.70 1007.39 1053.89 999.00 930.23 928.77 916.59 1015.28 40 18 1011.42 937.75 1027.38 1014.11 1043.29 1071.87 1025.89 1037.42 1005.04 963.66 1032.87 958.78 914.69 1037.00 1019.06 1099.62 958.07 938.56 1001.91 1038.5 19 1091.89 1026.97 1032.90 1082.68 1012.10 1020.41 1015.17 183.22 998.33 1033.68 994.93 970.85 943.31 1022.71 957.11 979.68 1027.95 1057.27 1096.14 62.6 922.83 1029.66 43 20 989 33 1094.93 971.59 1040.98 64.83 1000.95 1041.47 990.14 972.60 970.48 1004.16 1016.60 1032.60 1027.29 1055.33 1052.49 947.71 1017.88 44 21 944.48 975.67 1012.84 977.45 1022.04 1030.45 1050.02 994.13 1046.87 988.65 927.81 1035.34 984.00 1063.33 1011.40 948.30 1039.05 1034.85 972.59 1013.1 45 22 948.03 941.86 1011.36 948.92 1024.23 1007.09 1016.16 1014.57 1046.39 1057.12 1014.85 192.65 934.33 984.17 992.93 938.10 958.3 931.61 948.97 1017.96 46 23 994.37 1000.15 959.17 939.62 948.86 1035.73 963.65 1095.07 1020.72 976.58 981.57 941.70 1084.05 975.49 994.50 1002.88 1052.18 1025.98 1064.49 1049.2 47 24 1073.59 1015.22 904.01 1030.64 968.00 1 153.53 1006.2 1048.60 1109.51 1008.17 926.75 972.25 1001.49 993.42 1017.35 952.84 999.4 1001.43 1019.44 1033.5 48 25 1100.58 930.42 1013.24 57.90 995.76 985.68 977.81 973.37 1041.57 963.38 951.80 877.03 1082.40 909.86 1016.91 1110.15 1060.16 1016.44 1013.16 1028.8X V 962.200888603547 AD AE AF AG AH Al AJ AK AL AM AN AO AP AQ W X Y Z AA AB AC Sample 21 Sample 22 Sample 23 Sample 24 Sample 25 Sample 26 Sample 27 Sample 28 Sample 29 Sample 30 Sample 31 Sample 32 Sample 33 Sample 34 Sample 35 |Sample 36 Sample 37 Sample 38 Sample 39 Sample 40 Sample 41 Sample 42 1036.82 1015.04 1062.7 971.0 1065.85 1060.09 971.18 1062.42 1030.92 994.19 976.05 1079.38 899.21 1011.14 1074.77 1075.92 1046.00 1094.33 944.86 959.99 1005.77 1002.53 993.72 1016.23 886.89 1013.51 1010.70 1050.07 1007.78 963.16 978.01 991.78 966.46 1061.90 1034.05 950.57 994.17 919.14 1042.33 1108.48 1041.77 985.35 1024.80 1018.98 193.29 957.56 978.27 988.34 976.75 1076.92 1003.24 968.67 946.78 946.40 1101.86 970.96 1000.71 963.46 1098.56 933.0 1056.03 957.64 1014.88 991.55 985.67 1092.41 1018.10 959.36 1019.70 1107.85 954.71 1077.83 978.02 1002.08 981.14 1035.87 1083.30 932.38 955.43 909.11 1009.67 1018.57 1123.29 1059.09 946.71 1064.01 1004.82 1041.02 959.42 993.92 993.62 1075.18 1009.48 971.70 1117.35 1018.16 924.75 944.29 1120.39 1000.63 986.21 1053.92 982.37 1036.39 989.06 1012.85 903.62 949.82 1068.20 1011.22 964.07 1012.69 969.59 1037.62 1041.76 185.50 1043.13 954.82 1026.55 1038.39 85.46 979.86 1037.57 948.26 1038.6 1047.60 1028.77 1061.46 1002.45 1027.60 1050.84 882.16 1032.95 989.08 954.19 1063.85 55.44 1116.47 929.32 977.58 1000.02 980.15 1053.43 965.58 1013.61 1006.8 971.62 1057.49 980.79 1042.06 970.03 969.9 1047.63 1003.63 933.06 1014.91 997.18 1017.52 1001.2 1015.73 963.52 1014.40 950.40 884.32 1044.22 984.52 957.37 986.29 1031.53 1038.04 982.09 961.75 938.33 1012.79 994.79 886.39 939.30 875.64 1058.41 55.06 965.29 987.92 1012.48 988.44 911.26 1035.99 1055.24 1052.84 938.88 1054.34 1102.45 963.41 1145.29 1012.02 962.59 1110.02 919.55 1050.8 993.54 944.33 1052.34 991.57 1042.83 1053.35 954.92 973.26 1004.39 900.66 1017.97 1086.47 1034.23 1054.66 978.00 957.52 975.66 1030.64 1074.66 965.08 964.03 1086.10 949.40 988.09 1044.93 1077.07 984.14 1008.14 965.15 1030.39 992.41 941.03 956.55 197.60 922.54 1009.46 359.66 939.35 956.60 994.87 990.64 1055.88 934.21 1002.29 1005.66 902.79 973.48 1026.60 963.45 1025.35 1043.70 1001.16 945.72 1086.62 953.35 1012.22 976.50 931.45 1043.73 1012.73 1033.78 1112.58 1076.45 992.30 972.25 1090.55 1004.31 988.48 972.09 1031.56 1051.74 199.52 900.77 966.62 1136.30 985.19 942.86 986.31 144.53 1044.60 992.68 1065.21 968.42 933.37 1081.78 1021.90 955.48 990.64 1076.89 1116.94 191.88 1045.3 992.65 1104.77 994.35 969.43 925.57 1012.17 1039.88 1037.52 105.29 1044.52 1009.09 951.76 985.74 980.22 957.35 959.79 032.37 942.65 1075.48 1055.83 1016.02 1000.90 988.53 1003.67 1040.66 978.36 1017.15 1030.57 1016.61 974.87 1045.79 935.50 1090.04 976.71 1029.50 1013.75 1020.81 1069.66 1034.51 981.82 999.76 1045.01 952.74 1059.57 1021.72 972.15 1045.2 1014.30 1045.12 1099.15 940.27 980.55 1021.63 965.63 1019.96 965.39 1037.1 1008.70 1033.79 1052.3 864.3 1028.57 974.14 975.89 1043.08 1058.94 941.85 952.07 1025.49 1023.46 1052.39 1116.70 1126.68 934.77 1052.75 1022.29 1011.68 967.06 991.96 917.65 978.74 1021.01 1076.08 990.63 942.03 1003.69 1038.52 1021.36 996.52 912.54 1029.70 1083.23 1013.65 1011.15 187.22 990.16 979.86 910.85 1040.91 1057.87 998.12 989.12 940.54 900.68 966.17 967.32 986.13 1057.17 1032.57 1104.16 1048.18 1035.66 996.19 1002.81 979.52 1079.37 998.83 1025.20 978.63 1048.48 919.81 1035.69 994.4 1019.18 1009.45 1041.00 935.64 1083.01 1080.34 1043.03 991.62 980.87 1048.70 910.26 993.79 1029.01 954.72 929.04 1034.41 197.14 908.93 1032.18 977.89 991.21 21.59 969.39 953.36 1051.63 942.72 1000.37 908.99 1009.51 1042.16 1016.78 1093.82 1068.22 980.30 977.41 1048.48 1017.71 1033.24 1047.15 1083.44 962.78 1025.79 947.60 998.81 1006.22 1023.82 899.90 976.01 987.78 1007.53 926.87 922.54 958.06 1069.14 998.89 927.28 1026.95 1025.93 1001.71 1041.39 1070.95 1017.82 1020.25 963.17 1029.05 1052.28 997.39 1007.20 1049.90 1033.50 975.77 1008.52 1031.48 1031.62 1111.91 1022.30 959.37 1014.94 996.55 1034.69 1008.47 899.67 1055.74 1008.94 1016.93 1036.57 986.79 1073.70 393.1 982.45 1117.47 947.83 1071.54 911.61 1015.41 1036.20 1012.85 1083.09 1047.70 986.99 951.24 1000.87 923.91 932.34 933.08 1059.12 1006.35 1013.37 955.60 1064.96 1036.85 991.88 961.96 967.31 957.94 923.03 914.16 929.71 966.07 1032.70 964.34 944.42 1044.71 1116.36 974.73 1046.10 986.66 971.05 990.30 964.33 1018.09 1023.98 1065.88 981.47 1020.59 973.45 1027.63 NAME TEMPLATE CHECKOUT NORMAL +X Y 962.200888603547 AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM Sample 43 Sample 44 Sample 45 Sample 46 Sample 47 Sample 48 Sample 49 Sample 50 Sample 51 Sample 52 Sample 53 Sample 54 Sample 55 Sample 56 Sample 57 Sample 58 Sample 59 Sample 60 Sample 61 Sample 62 Sample 63 Sample 64 970.29 950.11 1010.33 1029.17 975.27 980.88 1044.33 943.26 963.88 1040.23 1060.28 1021.21 1010.66 954.91 991.65 1020.72 955.34 928.76 965.79 1099.12 968.58 1061.40 1002.96 1029.33 982.53 989.76 1033.04 996.12 945.57 967.85 923.44 1102.86 967.42 1046.29 1107.69 970.99 997.69 1042.69 1105.36 961.04 950.98 1002.08 1052.69 966.61 985.31 1038.60 1021.05 954.43 953.97 997.22 1039.89 998.28 967.55 1010.56 993.38 1005.80 916.97 912.29 985.94 989.45 996.01 978.10 1076.79 972.42 1076.87 1025.36 977.20 1066.04 1081.47 906.84 1074.53 1089.39 1016.12 1135.09 989.20 966.12 1087.72 965.02 996.18 938.49 936.37 967.08 975.13 985.29 1012.46 1024.02 1013.62 1025.53 926.44 1012.36 940.73 1025.65 1028.5 984.62 1035.70 983.02 952.87 1033.50 1105.86 927.59 1060.69 971.13 1043.36 1090.14 961.88 1092.75 1003.95 1053.20 936.76 987.83 945.64 964.52 1060.57 942.3 970.17 1001.34 988.55 986.18 992.08 1033.95 1022.82 942.95 940.67 1007.93 943.28 1036.47 963.17 984.25 992.78 1031.50 924.82 1061.26 1036.17 1011.80 1023.02 900.13 1039.69 1045.01 937.73 1009.88 955.52 1016.18 1143.79 1051.33 1042.03 1036.93 1061.80 986.66 1058.97 944.55 1019.51 1004.87 964.94 997.59 1041.37 1060.22 987.08 1044.02 979.55 934.20 980.98 1058.53 980.5 991.01 973.30 947.29 987.63 963.07 990.98 1056.72 1022.89 1013.95 887.13 1088.32 1053.37 1043.40 992.93 397.77 1001.01 917.35 932.18 964.98 990.71 1042.09 1007.42 949.64 1025.27 1030.57 970.24 987.12 25.51 997.69 1056.09 1017.34 1014.40 949.45 1022.85 979.10 1036.09 1025.44 1006.11 995.01 1011.72 962.71 1046.12 966.16 1028.19 994.66 955.32! 1001.15 980.70 1061.17 937.38 986.89 1058.07 981.64 1025.70 960.68 1071.93 1051.53 982.70 976.66 982.87 887.42 1020.78 1017.96 981.79 992.52 985.30 1039.19 1099.21 997.81 992.84 990.21 1000.81 1057.08 982.22 973.63 971.49 990.10 1035.42 1063.54 963.36 888.87 983.86 977.18 993.13 394.7 1063.94 1042.63 1066.83 947.63 964.67 1013.68 1056.42 1009.73 1025.35 1095.66 1031.22 1028.24 975.98 985.40 956.25 978.71 970.13 874.34 1003.47 995.20 981.80 914.67 1032.92 965.61 1040.50 1075.45 1063.29 946.06 1010.79 1002.14 917.71 1010.47 1032.97 877.50 984.31 934.49 928.05 984.88 995.64 958.68 1000.82 951.03 1016.96 877.34 1030.69 1082.01 1050.49 1052.11 961.76 909.49 1152.30 1054.6 1015.18 1091.76 1011.03 1025.03 940.45 961.01 1001.43 950.86 1013.68 1037.12 1015.81 1085.3 905.09 1058.46 1041.88 936.78 928.10 1037.16 1005.56 915.62 983.21 1006.65 945.77 1022.14 1009.90 1029.52 1065.11 1015.00 1022.73 1018.16 1073.33 1050.19 937.21 913.10 982.76 1010.08 939.54 968.8 955.65 1054.61 971.22 1065.37 965.44 1006.46 975.00 1003.30 979.73 953.12 969.51 988.17 1015.37 1071.01 970.34 1020.44 355.47 1004.01 1022.83 973.89 1100.35 1016.24 945.35 963.37 1008.88 1026.19 978.99 996.00 32.99 965.83 864.31 1021.08 1054.87 947.57 1036.69 1011.25 1051.98 985.24 1038.57 993.40 1052.81 1097.64 984.11 910.24 1003.19 1085.23 1003.69 912.61 1048.90 1062.77 1010.68 1041.24 955.51 1055.04 868.99 984.15 994.86 988.39 1016.41 1038.20 1017.56 934.99 962.54 1076.75 942.01 966.56 986.72 941.13 1034.10 943.65 1011.47 1021.19 1056.00 936.80 1112.24 1022.47 1040.18 1051.7 951.23 928.40 940.53 973.78 1031.11 1077.65 1081.9 932.27 1000.31 69.99 1062.80 1037.09 1038.95 1037.14 91.30 1108.9 1097.8 1040.04 971.23 1019.72 1000.95 1089.83 970.89 1006.39 932.62 1038.34 1019.28 1004.11 1076.79 990.53 1037.69 912.26 1007.47 1039.12 929.72 1049.28 995.12 1056.42 986.60 973.63 994.97 1077.83 980.46 1055.19 1030.96 994.44 980.70 1041.96 1004.63 992.86 1030.95 965.99 1048.59 977.10 1020.29 940.86 965.74 943.59 1038.16 947.42 1126.77 988.39 977.06 1002.78 981.08 1027.73 986.98 971.23 963.66 1033.5 975.13 998.29 980.41 954.95 943.61 971.63 969.10 954.74 1027.92 961.35 953.27 928.16 1088.93 984.53 1057.56 1029.36 1086.43 925.35 979.74 897.52 1015.19 932.41 919.60 959.54 1009.85 999.03 1014.29 985.73 1105.33 1084.49 1028.86 913.51 1036.16 986.74 1082.71 1065.28 1043.88 990.31 960.10 1012.08 1038.57 1094.22 967.31 1034.87 1061.27 989.70 924.21 1062.71 957.35 938.81 1046.24 935.59 961.38 1079.95 955.67 1020.15 1043.57 1031.29 946.95 1052.83 1060.24 1052.81 983.78 1082.56X V fx 962.200888603547 CH CI BN BO BP BQ BR BS BT BU BV BW BX BY BZ CA CB CC CD CE CF CG Sample 65 Sample 66 Sample 67 Sample 68 Sample 69 Sample 70 Sample 71 Sample 72 Sample 73 Sample 74 Sample 75 Sample 76 Sample 77 Sample 78 Sample 79 Sample 80 Sample 81 Sample 82 Sample 83 Sample 84 Sample 85 Sample 86 987.30 1025.53 1015.9 023.73 1047.95 399.85 962.52 1027.19 959.26 1030.28 923.87 1096.48 952.30 969.11 896.37 1040.51 989.63 951.12 54.52 993.95 1064.05 1012.7 1036.17 923.48 974.84 1008.40 1026.09 1025.70 1050.81 1030.64 938.25 972.94 891.72 1040.72 1045.05 1019.68 1127.55 954.32 956.03 982.88 890.10 1022.33 1111.91 984.76 1062.34 1040.87 342.61 942.25 984.60 1019.17 1057.15 953.32 1013.70 887.33 914.55 1021.11 1045.74 977.30 977.26 1093.86 909.21 1004.96 977.16 984.78 1008.00 1027.93 1043.06 950.97 950.77 1020.19 933.45 981.73 984.48 1037.7 1091.27 996.25 1007.58 997.74 1018.23 984.75 900.27 998.16 1005.57 1022.52 1075.31 868.99 980.86 1086.08 1019.27 864.76 989.59 987.13 980.49 1017.31 990.18 992.76 1035.83 1011.07 995.05 954.84 980.72 969.2 998.01 1030.9 984.68 1006.7 974.61 1049.99 1036.07 963.6 916.51 991.57 1062.09 1040.44 985.52 1056.69 1024.15 1022.83 953.56 993.90 961.15 1058.09 975.60 986.57 1015.19 945.73 1024.19 949.49 1016.59 987.12 998.53 1017.89 1065.05 951.43 992.02 875.64 1103.43 886.79 1005.14 944.77 951.33 927.38 1005.69 994.48 999.52 973.60 1064.80 960.47 1075.75 961.83 966.99 966.30 951.18 1025.14 989.75 987.78 1003.88 976.81 1023.22 953.82 956.92 989.84 1095.40 1098.99 993.70 020.34 984.45 1115.68 1072.53 910.85 1030.2 030.69 1010.31 1027.43 858.23 1076.99 1013.34 986.65 025.53 1005.76 1087.76 1019.32 995.93 1064.72 956.73 927.94 914.88 950.17 1019.05 995.15 978.71 1045.80 88.95 1062.13 102.08 1031.59 941.30 986.91 1055.28 943.01 1057.09 945.43 918.51 915.40 1039.58 939.23 1052.42 1059.46 974.07 961.57 976.62 1041.37 1003.25 1075.58 957.43 1011.22 992.27 1016.62 1061.38 1074.24 999.40 102.57 1005.90 1006.43 1014.62 973.52 978.06 904.32 1009.8 990.64 1014.26 1024.86 1007.58 31.74 967.28 1005.04 1024.67 1011.30 974.58 906.16 982.47 1090.83 983.80 1019.37 1053.25 993.86 1005.37 1013.71 1121.75 1041.23 1073.26 953.38 54.24 983.25 984.61 1008.65 1110.68 977.93 979.79 954.39 1001.94 892.69 981.62 965.23 1031.51 995.44 1041.00 969.39 1067.86 1052.86 1021.96 918.70 1021.91 972.07 962.90 1059.52 985.5 973.83 978.59 968.17 1043.28 991.95 1002.09 1012.17 959.67 1055.00 947.3 970.92 992.17 980.42 1038.64 1009.01 1026.82 1092.16 948.46 975.08 975.94 1004.01 1020.2 892.77 920.71 941.93 964.61 1043.26 967.73 961.81 1002.47 939.35 923.02 940.62 924.26 983.81 893.70 1046.58 981.72 1058.17 999.99 1085.12 1000.42 1093.11 955.77 982.17 1045.46 1014.60 1074.31 1029.23 924.60 1013.22 1016.55 913.94 1032.75 1002.03 1059.55 978.62 880.96 980.27 989.51 1085.83 1009.28 914.65 929.69 1066.55 971.32 925.96 869.11 1032.66 941.07 913.34 945.99 1025.88 1015.20 968.80 1030.84 038.88 981.17 1037.45 1026.56 925.59 1051.39 981.87 978.45 962.59 009.90 995.24 985.84 959.16 96.20 999.19 1011.00 1000.98 1006.47 969.93 1008.25 1027.66 933.17 1008.59 1028.60 1007.88 1006.72 971.78 1011.21 1047.48 960.79 1009.93 1056.18 1000.89 1017.68 1061.69 981.53 973.66 1074.00 1031.6 195.77 1010.66 1007.01 990.95 963.83 955.61 961.91 986.95 1018.48 967.49 1055.79 1017.87 949.24 1027.24 997.79 954.95 1003.96 904.63 1030.74 938.65 1045.93 1028.76 1028.11 1052.05 896.21 987.30 1034.48 1008.76 1071.38 1031.43 984.50 1014.77 1024.76 1032.43 982.73 055.55 1015.48 1083.67 005.26 189.12 960.73 917.06 1052.40 1 101.56 949.50 1078.64 952.91 1010.94 927.11 928.21 981.77 1010.58 980.39 966.57 1061.28 1014.09 1098.58 999.73 1103.37 956.17 1021.74 952.19 1012.09 1046.70 961.32 996.58 1051.02 999.05 967.38 979.84 992.76 939.55 1039.44 1030.75 996.5 1016.56 949.32 1019.41 965.03 1050.89 1009.16 970.35 1002.11 961.09 1068.17 1030.7 950.70 1077.51 1031.26 994.02 974.07 995.58 911.68 1019.98 1044.36 1033.90 1067.37 985.29 1089.89 948.31 1005.49 1044.73 961.70 944.11 944.60 915.83 1027.60 1006.56 1072.99 985.28 1059.28 92.09 953.43 1012.30 992.16 1014.11 1039.46 989.56 1051.90 1023.90 1069.94 938.62 911.24 1023.32 957.04 1022.33 1016.92 1023.92 1068.50 905.71 1057.40 991.45 1146.37 1004.68 1050.56 1032.73 1014.78 968.29 961.80 922.34 1019.50 974.15 981.30 1050.72 1089.91 1034.25 1024.27 967.60 936.98 981.64 975.05 1010.91 918.09 952.57 007.10 1041.07 199.93 1048.97X v fx 962.200888603547 CJ CK CL CM CN CO CP CQ CR CS CT CU CV CW Sample 87 Sample 88 Sample 89 Sample 90 Sample 91 Sample 92 Sample 93 Sample 94 Sample 95 Sample 96 Sample 97 Sample 98 Sample 99 Sample 100 912 45 1057.85 1007.96 1116.76 1002.41 954.90 1062.20 1039.78 947.41 941.12 902.00 986.63 1051.26 1050.77 988.25 1088.25 1039.19 1043.14 1078.79 988.21 991.69 995.53 989.84 1036.70 1002 38 918.80 925.08 1037.69 988.35 1025.59 1043.74 1029.69 950.15 1102.51 1017.81 972.19 1110.42 1054.29 939.45 1063.61 1067.68 971.78 995.27 914.21 1010.12 1074.68 929.36 966.40 1032.18 964.54 986.74 1042.76 1075.50 886.74 968.13 1062.64 1002.14 953.34 915.38 1025.64 929.50 927.42 1027.59 973.11 1000.93 937.11 1024.56 933.19 930.68 895.43 1012 81 1074.73 987.98 1033.55 993.47 1014.34 995.92 1081.16 1012.81 954.35 1053.43 1099.76 997.62 1079.48 1057 20 1042.33 1042.56 980.64 1051.13 928.65 976.13 892.88 1004.45 1164.00 988.85 1019.33 979.81 907.38 993.65 1008.53 1123.45 986.93 1010.42 901.50 1017.34 1025.10 966.27 1026.23 1007.65 936.25 980.25 1043.88 1038.47 973.48 899.33 1002.70 1092.47 989.10 982.85 959.28 985.20 1054.48 1009.58 1 107.04 1015.10 940.55 1055.94 1043.42 993.09 1006.08 1006.11 912.60 976.35 910.42 973.00 1008.97 961.04 995.30 1047.78 1084.62 940.18 969.65 941.35 965.79 998.01 1003.16 1048.64 909.96 968.10 1078.07 1041.71 948.31 1163.20 956.97 918.44 945.33 937.19 1036.75 1053.30 1001.04 1048.62 991.54 947.90 965.28 988.08 1006.62 1040.38 1043.81 1034.80 1106.19 1023.71 1023.65 957.20 958.30 1037.97 923.80 975.52 975.60 978.63 1068.56 1011.13 1037.47 965.89 1000.18 923.66 873.79 1133.95 1090.06 1008.35 1037.15 909.80 982.67 963.76 1061.18 943.57 972.88 1012.82 964.36 1037.99 949.44 1001.21 913.72 1081.39 982.81 969.30 1064.90 901.73 1070.41 1095.66 1003.96 938.30 968.03 972.33 958.29 1012.15 948.29 987.16 920.89 1087.71 1053.99 935.93 1034.62 1010.33 994.98 963.74 988.59 1063.07 980.36 1067.07 907.25 925.15 1036.04 1033.15 1016.35 1052 93 1121.16 976.86 902.57 1020.90 970.21 985.12 908.69 959.49 1020.88 1039.73 959.58 974.81 946.60 924.44 923.10 941.72 968.30 960.11 1010.40 1003.57 1010.53 921.65 966.78 1024.40 957.23 946.49 1021.69 948.60 1007.76 939.30 1002.58 1066.61 938.34 1082.62 1037.68 1029.59 1028.22 993.27 1116.59 923.54 993.02 1054.50 978.79 829.95 994.31 1097.28 1045.90 979.57 968.99 1001.96 1028.64 1026.74 957.41 954.27 1053.35 987.01 960.94 996.55 1080.96 915.17 082.35 1014.57 971.12 986.76 911.04 1022.34 918.47 1021.24 969.63 1002.58 1048.40 987.86 1013.11 983.90 1008.13 867.39 991.03 932.47 976.18 997.76 1002 22 924.73 959.18 1022.15 984.87 949.46 1108.85 975.39 943.93 1017.70 939.34 1001.78 1064.09 970.55 939.66 996.30 1114.75 1015.73 1038.60 1032.35 964.47 1050.31 947.86 1016.06 987.10 1042.69 1068.95 1014.34 1054.16 969.96 1006.28 1028.55 938.32 946.08 969.19C5 X Name of variable A B C 1 Step 1: Is Population standard deviation known? If it is, follow col b (Use Normal distribution) 2 If not, follow col c (Use t distribution) Confidence Interval 4 Population standard deviation known Population standard deviation NOT known 5 Name of variable Name of variable Level of confidence (a percentage) Level of confidence (a percentage) 6 or confidence coefficient (a decimal) or confidence coefficient (a decimal) 7 alpha level (a decimal) alpha level (a decimal) 8 Sample size Sample size 9 Population standard deviation Sample standard deviation 10 Point estimate of the population mean Point estimate of the population mean 11 Standard error of the mean Standard error of the mean 12 Za/2 (use NORMSINV for these values)* t a/2 (use TINV for these values)* 13 Margin of error Margin of error 14 Lower confidence limit Lower confidence limit 15 Upper confidence limit Upper confidence limit 16 17 18Observation # Checkout times Checkout times Mean 2.928472 NON Standard Error 0.078512 Median 3.1 Mode 2.2 Standard Deviation 0.942149 Sample Variance 0.887645 Kurtosis -0.18634 Skewness 0.47025 Range 4.5 00 00 Minimum 0.4 Maximum 4.9 wwwWWN Sum 421.7 Count 144 Confidence Level(95.0%) 0.155195 3.2 3.7 Assume that the checkout times (minutes) shown in Column B are a random sample 2.1 selected from a normal population with: 2.3 For questions 1 & 2: a known population standard deviation equal to 1.0 2 minute. 2.2 3.7 For questions 3 & 4: an unknown population standard deviation. 4.2 3.2 With this in mind, create 2 confidence intervals to answer the questions. You can copy 0.9 Independent Lab Assessment Questions 3.7 (1) Create a confidence interval (with 95% confidence) for the 2.2 population mean of checkout times (in minutes). (To two decimal places) The average checkout time is between _ minutes 3.7 ( lower limit) and minutes ( upper limit). NwwwN! Note: Population standard deviation is known (1 minute) (2) Use the same confidence interval from question 1 to answer the 6 following question. (To two decimal places) The standard error for the