Business Analytics II Project
Ashtonjh
dataForCostAnalysisProject.xlsxSheet1
| Remote Sensor Labor Test Time | |||
| Time in Minutes | |||
| Obseration# | Type | Functional-Test | Sensor-Test |
| AE35 | 3 | 1.4 | 0.9 |
| AE36 | 4 | 0.6 | 1.5 |
| AE37 | 1 | 1 | 2.9 |
| AE38 | 1 | 2 | 1.15 |
| AE39 | 1 | 1.9 | 2.65 |
| AE40 | 3 | 1 | 0.5 |
| AE41 | 1 | 1.5 | 3.4 |
| AE42 | 2 | 1.6 | 2.65 |
| AE43 | 2 | 1.1 | 2.65 |
| AE44 | 3 | 1.8 | 0.5 |
| AE45 | 1 | 1.6 | 0.75 |
| AE46 | 1 | 1.4 | 2.9 |
| AE47 | 1 | 1.5 | 0.35 |
| AE48 | 2 | 1.4 | 1.35 |
| AE49 | 4 | 1 | 2 |
| AE50 | 4 | 1.2 | 0.1 |
| AE51 | 1 | 2.4 | 1.15 |
| AE52 | 1 | 1.9 | 3.5 |
| AE53 | 1 | 1.4 | 2.15 |
| AE54 | 4 | 2.4 | 2.65 |
| AE55 | 2 | 1 | 1 |
| AE56 | 3 | 1.5 | 1.1 |
| AE57 | 1 | 1.4 | 3.35 |
| AE58 | 2 | 1.7 | 1.6 |
| AE59 | 2 | 1.6 | 2.3 |
| AE60 | 4 | 1.3 | 1.7 |
| AE61 | 2 | 1.5 | 1.7 |
| AE62 | 1 | 1.9 | 1.5 |
| AE63 | 3 | 1.9 | 1.9 |
| AE64 | 1 | 1.1 | 1.9 |
| AE65 | 1 | 1.5 | 2.1 |
| AE66 | 3 | 1.4 | 1.9 |
| AE67 | 2 | 2.9 | 2.4 |
| AE68 | 3 | 0.6 | 2.1 |
| AE69 | 2 | 2 | 0.85 |
| AE70 | 2 | 1 | 2.9 |
| AE71 | 4 | 1.5 | 2.15 |
| AE72 | 1 | 1.6 | 2 |
| AE73 | 2 | 1.9 | 3.9 |
| AE74 | 1 | 2.9 | 1.25 |
| AE75 | 1 | 0.6 | 1.35 |
| AE76 | 1 | 3 | 2.35 |
| AE77 | 3 | 1.5 | 2 |
| AE78 | 1 | 1.5 | 0.85 |
| AE79 | 2 | 1.9 | 3 |
| AE80 | 3 | 2.5 | 0.5 |
| AE81 | 4 | 0.6 | 0.35 |
| AE82 | 4 | 1.4 | 3.15 |
| AE83 | 1 | 1.9 | 0.6 |
| AE84 | 1 | 1.6 | 1.15 |
| AE85 | 1 | 3.9 | 0.1 |
| AE86 | 3 | 2.4 | 2.5 |
| AE87 | 3 | 1 | 0.9 |
| AE88 | 3 | 1.4 | 1.1 |
| AE89 | 1 | 1.4 | 1.5 |
| AE90 | 3 | 1.4 | 2 |
| AE91 | 1 | 1.5 | 3.1 |
| AE92 | 2 | 2.9 | 3.2 |
| AE93 | 2 | 0.6 | 0.6 |
| AE94 | 1 | 1 | 2.5 |
| AE95 | 4 | 1 | 3.1 |
| AE96 | 3 | 4.4 | 2.4 |
| AE97 | 3 | 1.9 | 1.35 |
| AE98 | 2 | 1 | 0.9 |
| AE99 | 4 | 2.4 | 0.1 |
| AR0 | 2 | 1.5 | 2.65 |
| AR1 | 4 | 1.4 | 0.1 |
| AR2 | 3 | 2.6 | 0.9 |
| AR3 | 3 | 2.4 | 2.25 |
| AR4 | 4 | 1 | 2.1 |
| AR5 | 3 | 1.4 | 1.35 |
| AR6 | 1 | 1.4 | 1.9 |
| AR7 | 4 | 1.4 | 0.9 |
| AR8 | 1 | 1.4 | 0.9 |
| AR9 | 4 | 2.4 | 0.9 |
| AR10 | 4 | 1.4 | 3.15 |
| AR11 | 2 | 0.6 | 0.5 |
| AR12 | 3 | 1 | 0.5 |
| AR13 | 1 | 1 | 0.5 |
| AR14 | 3 | 1.1 | 1.15 |
| AR15 | 2 | 0.6 | 1.6 |
| AR16 | 1 | 1.4 | 2.15 |
| AR17 | 2 | 2.4 | 1.15 |
| AR18 | 4 | 3.5 | 0.85 |
| AR19 | 3 | 1.9 | 3.4 |
| AR20 | 1 | 2.9 | 1.35 |
| AR21 | 4 | 2.5 | 1.4 |
| AR22 | 4 | 1.3 | 1.4 |
| AR23 | 4 | 1.3 | 1.6 |
| AR24 | 2 | 1.8 | 1.4 |
| AR25 | 4 | 1.3 | 1.85 |
| AR26 | 1 | 1.4 | 0.1 |
| AR27 | 2 | 1.5 | 0.1 |
| AR28 | 3 | 1.6 | 2.75 |
| AR29 | 1 | 1.7 | 2.5 |
| AR30 | 2 | 1.4 | 0.6 |
| AR31 | 2 | 0.6 | 2.1 |
| AR32 | 2 | 3.1 | 1.6 |
| AR33 | 3 | 1.4 | 0.9 |
| AR34 | 1 | 2 | 1.5 |
