Instructions: Complete the following problems within the MS Excel File. You should show process steps where applicable to receive credit. Include your Last Name and ID in each tab page. Submit your completed Microsoft Excel file via blackboard in the assignment. Due date January 16, 2021, at 11:59PM As an engineer your company is manufacturing a 3D printed Ball Joint connector. One of the critical to quality requirements for this 3D printed part is the outer diameter (OD) of the lower end. The Lower OD specification limit is 25.00 mm, and the upper specification limit is 27.00 mm. See part drawing below: You select a sample of n = 240 parts from a 1,000 pars lot manufactured during the second shift. The test technician measured the outer diameter of each part and recorded it in a spreadsheet. OD of the lower end of the 3D Printed Part ENGI 2270 SEC 23 Special Assignment [Central Tendency & Dispersion] Page 2 of 2 Determine: 1. Establish by using excel formula basic statistics of the n = 240 sample of measured OD (first tab of the excel file). Also select what type of statistics has been requested (i.e., central tendency vs dispersion) by selecting it from the dropdown at the left of the resulting value. 2. Generate 2 charts/graphs from the n = 240 sample of measured OD and explain your takeaways from the charts and interpretation. Document this in the excel file. Second tab of the excel file.

Format Painter BA = Es F Merge & Center $ - % , 6.0 00 000 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Forums Clipboard Clea Font Alignment Number Cells H3 for F G H ENGI 2270 R2 Special Assignment Due on October 3rd, 2021 at 11:59 PM Student Name: Student ID: Resulting Value (inches Measure Type A B C D E 1 RAW DATA of Outer Diameter (OD) from 3D Printed Parts 2 Specimen No. OD Measured (inches) Lower Spec Limit Target Upper Spec Limit 3 1 25.94 25.00 26.00 27.00 4 25.63 25.00 26.00 27.00 5 25.39 25.00 26.00 2700 6 25.50 25.00 26.00 2700 7 26.37 25.00 26.00 27.00 8 25.62 2500 26.00 27.00 9 25.38 25.00 26.00 27.00 10 25.86 25.00 26.00 27.00 11 26.92 25.00 26.00 27.00 12 25.97 25.00 26.00 27.00 13 26.34 25.00 26.00 27.00 14 12 26.66 25.00 26.00 27.00 15 13 26.98 25.00 26.00 27.00 16 14 26.90 25.00 26.00 27 00 17 25.71 25.00 26.00 27.00 18 16 26.32 2500++ 26.00 27.00 19 17 25.33 25.00 26.00 27.00 20 26.67 25.00 26.00 27 00 21 25.39 25.00 26.00 27.00 22 26.24 25.00 26.00 27.00 23 21 25.39 25.00 26.00 27.00 (1) student Last Name Student ID (2) student Last Name_Student No I o ovo AWN Basic Statistics Mean Standard Deviation Median Mode Q1 (P25) 02 (P50) Q3 (P75) Range Min Max Variance B C D 24 22 F G 25 26 23 24 25 26 27 28 29 30 3 B 27 28 29 83 34 IN 2 Z 2 2 8 8 8 8 8 8 8 5 8 8 8 7 7 7 F 35 25.87 26.03 25.36 25.07 26.76 26.92 25.57 25.10 26.34 25.13 26.56 25.26 25.48 26.49 25.09 25.44 25.31 26.01 26.62 26.01 26.16 26.27 25.39 2500 25.00 25.00 25.00 25.00 25.00 2500 25.00 25.00 25.00 25.00 2500 25.00 25.00 25.00 25.00 25.00 2500 25.00 25.00 25 00 25.00 25.00 26.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 2600 26.00 26.00 26.00 26.00 27 00 27.00 27.00 27 00 27.00 27.00 2700 2700 27.00 27.00 27.00 27.00 2700 27.00 27.00 27.00 27.00 27.00 27.00 27 00 27.00 27.00 27.00 36 37 34 35 86 37 88 39 40 41 42 43 44 40 41 42 43 44 45 46 (1) student Last Name Student ID (2) student Last Name Student D E F G 44 47 45 46 48 49 47 50 48 51 26.00 26.00 26.00 26.00 26.00 26.00 2600 26.00 26.00 28.00 52 25.00 25.00 25.00 25.00 25.00 2500 25.00 2500 2500 2500 25.00 25.00 2500 2500 53 25.39 25.58 25.54 26.34 25.95 26.63 25.86 25.66 25.00 26.69 25.68 25.08 25.75 25.29 25.61 26.36 25.19 51 54 55 56 2600 57 55 27.00 27.00 27.00 27.00 27.00 2700 27.00 2700 27.00 27.00 27.00 27.00 27.00 27.00 27.00 2700 27.00 27.00 2700 27.00 27.00 27.00 27.00 58 59 60 25.00 61 62 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 25.00 25.00 25.00 25.00 63 61 26.15 64 62 26.97 65 26.92 25.00 66 64 26.84 25.00 67 65 26.40 25.00 68 66 26.42 25.00 (1) student Last Name Student ID (2) student Last Name_Student + READY B C D E F 67 65 66 68 69 70 69 72 73 74 75 76 6 72 73 74 75 76 o 8 8 8 8 8 8 8 v a I 8 8 8 8 8 i 26.40 26.42 25.91 25.05 26.18 26.05 26.17 25.48 26.56 26.93 25.66 26.55 26.94 26.17 25.57 25.30 25.40 25.40 26.15 26.62 26.34 25.07 25.13 78 25.00 25.00 25.00 2500 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 26.00 26.00 26.00 26.00 26.00 2600 26.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 2700 27.00 27.00 2700 27.00 27.00 27.00 27.00 27.00 27.00 2700 27.00 27.00 27.00 27.00 27.00 79 80 81 79 82 83 84 82 85 86 87 26.00 88 86 26.00 26.00 89 (1) student Last Name Student ID (2) student Last Name Student JX A B E F G 89 90 91 92 93 87 88 89 90 91 92 93 94 95 96 94 95 96 97 98 99 25.13 25.28 26.05 26.55 25.13 25.10 25.87 25.82 26.14 26.71 25.07 25.91 26.37 25.47 27.00 26.46 25.58 25.17 25.74 26.68 25.16 26.25 100 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 2500 25.00 25.00 25.00 25.00 2500 25.00 2500 25.00 25.00 25.00 26.00 26.00 26.00 26.00 26.00 26.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 2600 26.00 26.00 98 99 100 101 102 103 2700 27.00 2700 27.00 27.00 2700 27.00 27.00 2700 2700 27.00 27.00 27.00 27.00 27.00 27.00 27 00 27.00 27.00 27 00 27.00 27.00 2700 101 102 103 104 105 106 104 107 7 8 9 14 15 16 21 22 23 28 29 30 108 109 105 106 107 108 109 110 111 25.89 Clipboard 12 Font Alignment S H74 fc A B c E F G 112 110 26.80 113 26.97 25.69 114 25.00 25.00 25.00 25.00 25.00 111 112 113 114 115 D 26.00 26.00 26.00 26.00 26.00 26.00 115 25.89 116 117 118 116 25.43 25.85 26.98 26.91 26.09 26.00 119 117 120 118 121 119 122 120 25.95 26.58 26.27 123 121 124 27.00 27.00 27.00 27.00 27.00 2700 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27 00 27.00 27.00 27.00 27 00 27.00 2700 27 00 25.94 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 122 123 124 125 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 2500 25.00 25.00 25.00 25.00 2500 126 127 128 125 126 127 26.64 25.22 26.69 26.31 26.03 25.29 26.55 26.00 25.74 25.68 129 180 131 132 128 129 180 131 132 26.00 26.00 26.00 26.00 2600 133 184 (student Last Name Student ID (2) student Last Name Student BE Number 22 H74 X & fix X fr I> B C D E F. 134 G 135 132 133 134 136 25.00 25.00 25.00 25.00 25.00 137 185 138 139 136 137 138 139 25.68 26.80 25.20 25.88 25.93 26.34 25.41 26.87 25.09 26.77 26.88 25.00 140 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 25.00 141 142 140 25.00 25.00 25.00 142 141 144 142 145 143 25.27 25.00 25.00 25.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27 00 27.00 27.00 27.00 27.00 146 144 26.41 25.86 147 145 25.00 148 146 26.26 26.00 26.00 26.00 26.00 26.00 26.00 149 147 25.00 25.00 25.00 25.00 25.75 150 148 26.00 151 149 152 150 25.00 26.00 26.00 153 13 0 26.66 25.94 25.91 26.41 25.59 151 152 153 154 154 25.00 25.00 2500 2500 155 26.00 26.00 26.00 156 26.85 (student Last Name Student ID (2) student Last Name Student B C D E F 156 G G 157 158 159 160 161 162 163 164 165 166 167 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 26.85 26.01 25.69 25.02 26.06 25.38 26.17 26.60 25.11 26.74 26.41 26.70 25.07 26.99 25.21 25.92 26.53 25.78 26.82 26.92 25.82 26.15 26.90 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 2600 26.00 26.00 26.00 26.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 27.00 2700 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 168 169 170 171 172 173 174 175 176 177 178 (1) student Last Name Student ID 12 student Last Nama Studiant A B C D E 178 F 176 G 179 177 180 181 182 183 184 185 186 187 188 189 26.90 26.60 25.99 25.38 26.53 25.26 25.49 26.71 26.74 26.72 26.46 25.04 25.08 25.80 26.22 25.29 25.14 25.84 26.49 26.14 26.13 25.58 26.91 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 198 194 195 196 197 198 2500 25.00 25.00 2500 25.00 25.00 2500 2500 2500 2500 25.00 25.00 25.00 25.00 25.00 25.00 2500 25.00 25.00 25.00 25.00 25.00 25.00 2600 2600 26.00 26.00 2600 2600 26.00 2600 2600 26.00 2600 26.00 26.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26,00 27.00 27.00 2700 27.00 27.00 2700 2700 27.00 2700 2700 27.00 27 00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 190 191 192 193 194 195 196 197 198 199 200 (1)student Last Name Student ID (2)student Last Name_Student A B C D E F 200 201 202 208 204 205 206 207 208 209 210 211 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 26.91 26.65 25.55 26.19 25.51 25.57 26.97 25.53 26.37 26.76 25.34 25.50 26.22 25.04 25.77 26.82 26.50 25.54 25.76 26.66 26.43 27.00 25.40 2500 2500 25.00 2500 2500 25.00 25.00 25.00 25.00 25.00 2500 2500 25.00 2500 2500 25.00 25.00 25.00 25.00 25.00 25.00 25 00 25.00 26.00 26.00 2600 26.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 27.00 27.00 27.00 27.00 2700 27.00 2700 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 212 213 214 215 216 217 218 219 220 221 222 (student Last Name_Student ID (2)student Last Name_Student 221 222 27.00 25.40 26.34 25.50 26.00 26.00 26.00 223 224 26.00 225 26.33 26.00 226 227 228 229 219 220 221 222 223 224 225 226 227 228 229 280 231 232 283 234 285 230 231 25.00 2500 2500 25.00 25.00 2500 2500 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 2500 25.00 25.00 25.00 25.00 232 27.00 27.00 27.00 27.00 27.00 27.00 2700 27.00 27.00 27.00 27 00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 27.00 25.87 25.34 26.45 26.19 25.65 26.50 26.26 25.74 26.26 25.41 26.19 25.86 25.36 25.01 26.99 25.36 25.11 233 234 26.00 26.00 2600 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 2600 236 237 288 286 240 237 288 239 240 241 een Name Sudent ID py student Last Name Student