->Below is "Launch"(Other than column A, all cells are empty)

Column A

Thank you very much for the help!

B D A 1 Weekly lunch expenditure (in dollars) 2 R2 6+200 3 77 4 223 5 188 6 176 7 95 8 139 9 89 10 217 11 76 12 77 13 148 14 251 15 244 16 281 17 126 18 244 19 83 20 79 21 247 22 179 23 114 24 273 171 26 283 27 241 28 215 29 201 30 113 31 247 32 244 33 138 34 245 35 279 36 131 25 A B C D 244 141 207 109 212 281 262 255 179 66 176 293 232 37 38 39 40 41 42 43 44 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 182 174 285 247 285 207 124 256 142 217 218 92 120 93 209 140 216 243 265 216 98 137 245 B D 175 107 123 81 240 226 129 221 228 149 93 235 277 269 196 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 146 129 264 188 292 100 249 112 133 125 213 159 273 149 257 276 142 85 285 251 65 A B C D 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 266 88 135 193 87 254 239 252 75 148 287 244 252 211 278 71 291 283 281 260 269 136 257 84 281 191 284 248 256 224 127 142 282 103 198 136 137 138 139 140 141 142 143 144 A B D 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 277 176 285 142 77 296 256 160 243 229 81 289 236 168 162 176 287 257 225 151 237 279 243 66 81 152 139 193 192 268 104 172 221 281 148 189 Lunch Troul A B (2 D E 181 182 183 184 185 186 187 188 189 190 191 192 193 194 276 218 113 296 274 247 169 71 61 160 117 186 147 124 169 71 267 276 214 281 195 196 197 198 199 200 201 202 203 204 120 205 206 207 208 209 210 211 212 213 214 215 216 143 177 166 189 224 191 217 242 161 226 280 158 205 143 237 A C D 217 218 239 208 231 219 163 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 178 148 131 212 97 205 216 265 152 76 248 245 94 185 81 96 169 128 212 247 222 99 278 163 207 160 97 140 229 227 257 260 244 245 246 247 248 249 250 251 252 Lunch Travel + A B D E 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 215 259 240 235 292 261 217 172 10000 75 224 151 111 274 289 92 91 209 194 192 181 Question 14 In this question, you should refer to the worksheet Lunch" in the file IC2.xlsx. Below are the steps for constructing a normal probability plot. You need to calculate and replace the value of Cell A2 by using the formula (R X 6+200. R=8] a) Column A shows the Weekly lunch expenditure (in $) of a group of employees in ABC company. However, a record is problematic (A2 is not problematic). Identify and describe the problematic record in Column A and remove the problematic record from the column. (5 marks) The cleaned data in Column A are to be copied to and ranked in Column B. Positions are to be assigned to the ranked data and shown in Column C. b) Write down the formula to be entered exactly in the cell D (20+R) to show the probability for the data corresponding to the iw position in Column C. Your answer should be able to auto-fill to the other cells in Column D. [R=8] (5 marks) c) Write down the formula to be entered exactly in the cell E(50-R) to show the Z-value of the data corresponding to the probability in Column D. Your answer should be able to auto-fill to the other cells in Column E. [R=8] (5 marks) d) Write down the values in the following cells: (Correct your answer to 4 decimal places) R=8](5 marks) Celle Value D(170+R) E(150+R*3) e) Comments on the normal probability plot constructed using the columns created above. (5 marks) B D A 1 Weekly lunch expenditure (in dollars) 2 R2 6+200 3 77 4 223 5 188 6 176 7 95 8 139 9 89 10 217 11 76 12 77 13 148 14 251 15 244 16 281 17 126 18 244 19 83 20 79 21 247 22 179 23 114 24 273 171 26 283 27 241 28 215 29 201 30 113 31 247 32 244 33 138 34 245 35 279 36 131 25 A B C D 244 141 207 109 212 281 262 255 179 66 176 293 232 37 38 39 40 41 42 43 44 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 182 174 285 247 285 207 124 256 142 217 218 92 120 93 209 140 216 243 265 216 98 137 245 B D 175 107 123 81 240 226 129 221 228 149 93 235 277 269 196 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 146 129 264 188 292 100 249 112 133 125 213 159 273 149 257 276 142 85 285 251 65 A B C D 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 266 88 135 193 87 254 239 252 75 148 287 244 252 211 278 71 291 283 281 260 269 136 257 84 281 191 284 248 256 224 127 142 282 103 198 136 137 138 139 140 141 142 143 144 A B D 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 277 176 285 142 77 296 256 160 243 229 81 289 236 168 162 176 287 257 225 151 237 279 243 66 81 152 139 193 192 268 104 172 221 281 148 189 Lunch Troul A B (2 D E 181 182 183 184 185 186 187 188 189 190 191 192 193 194 276 218 113 296 274 247 169 71 61 160 117 186 147 124 169 71 267 276 214 281 195 196 197 198 199 200 201 202 203 204 120 205 206 207 208 209 210 211 212 213 214 215 216 143 177 166 189 224 191 217 242 161 226 280 158 205 143 237 A C D 217 218 239 208 231 219 163 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 178 148 131 212 97 205 216 265 152 76 248 245 94 185 81 96 169 128 212 247 222 99 278 163 207 160 97 140 229 227 257 260 244 245 246 247 248 249 250 251 252 Lunch Travel + A B D E 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 215 259 240 235 292 261 217 172 10000 75 224 151 111 274 289 92 91 209 194 192 181 Question 14 In this question, you should refer to the worksheet Lunch" in the file IC2.xlsx. Below are the steps for constructing a normal probability plot. You need to calculate and replace the value of Cell A2 by using the formula (R X 6+200. R=8] a) Column A shows the Weekly lunch expenditure (in $) of a group of employees in ABC company. However, a record is problematic (A2 is not problematic). Identify and describe the problematic record in Column A and remove the problematic record from the column. (5 marks) The cleaned data in Column A are to be copied to and ranked in Column B. Positions are to be assigned to the ranked data and shown in Column C. b) Write down the formula to be entered exactly in the cell D (20+R) to show the probability for the data corresponding to the iw position in Column C. Your answer should be able to auto-fill to the other cells in Column D. [R=8] (5 marks) c) Write down the formula to be entered exactly in the cell E(50-R) to show the Z-value of the data corresponding to the probability in Column D. Your answer should be able to auto-fill to the other cells in Column E. [R=8] (5 marks) d) Write down the values in the following cells: (Correct your answer to 4 decimal places) R=8](5 marks) Celle Value D(170+R) E(150+R*3) e) Comments on the normal probability plot constructed using the columns created above