finaldata.xls
Sheet1
| carnumber | numberofcylinders | country | milespergallon | weightinlbs | price | transmission | cost | profit | poweredaxles | XYZcar |
| 1 | 4 | 1 | 32 | 3190 | 18700 | 2 | 14082.7998046875 | 4617.2001953125 | 2 | 1 |
| 2 | 4 | 2 | 33 | 3042 | 23400 | 2 | 18765.0390625 | 4634.9609375 | 2 | 0 |
| 3 | 4 | 3 | 38 | 3572 | 22500 | 1 | 17928.640625 | 4571.359375 | 1 | 0 |
| 4 | 4 | 1 | 39 | 2888 | 17700 | 1 | 13046.5595703125 | 4653.4404296875 | 1 | 1 |
| 5 | 4 | 2 | 45 | 3777 | 26000 | 1 | 21453.240234375 | 4546.759765625 | 1 | 0 |
| 6 | 4 | 3 | 39 | 3208 | 25600 | 1 | 20984.9609375 | 4615.0390625 | 1 | 0 |
| 7 | 4 | 1 | 41 | 3393 | 24000 | 1 | 19407.16015625 | 4592.83984375 | 1 | 0 |
| 8 | 4 | 1 | 45 | 4652 | 23500 | 1 | 19058.240234375 | 4441.759765625 | 1 | 0 |
| 9 | 4 | 1 | 47 | 3495 | 22200 | 1 | 17619.400390625 | 4580.599609375 | 1 | 0 |
| 10 | 6 | 2 | 37 | 3208 | 26000 | 2 | 21384.9609375 | 4615.0390625 | 1 | 0 |
| 11 | 6 | 3 | 36 | 4344 | 31000 | 2 | 26521.279296875 | 4478.720703125 | 1 | 0 |
| 12 | 6 | 1 | 35 | 2617 | 28000 | 2 | 23314.0390625 | 4685.9609375 | 1 | 0 |
| 13 | 6 | 2 | 38 | 2535 | 27100 | 1 | 22404.19921875 | 4695.80078125 | 1 | 0 |
| 14 | 6 | 3 | 28 | 6500 | 24600 | 4 | 20380 | 4220 | 3 | 0 |
| 15 | 6 | 1 | 33 | 2701 | 28900 | 2 | 24224.119140625 | 4675.880859375 | 2 | 1 |
| 16 | 6 | 4 | 34 | 2396 | 29300 | 2 | 24587.51953125 | 4712.48046875 | 3 | 0 |
| 17 | 6 | 5 | 32 | 4037 | 19500 | 2 | 14984.4404296875 | 4515.5595703125 | 1 | 0 |
| 18 | 6 | 1 | 29 | 3600 | 18600 | 2 | 14032 | 4568 | 4 | 0 |
| 18 | 6 | 2 | 39 | 3756 | 21300 | 1 | 16750.720703125 | 4549.279296875 | 1 | 0 |
| 20 | 6 | 5 | 40 | 3300 | 21800 | 1 | 17196 | 4604 | 1 | 0 |
| 21 | 6 | 3 | 36 | 3102 | 19900 | 2 | 15272.240234375 | 4627.759765625 | 1 | 0 |
| 22 | 6 | 1 | 37 | 2085 | 14500 | 1 | 9750.2001953125 | 4749.7998046875 | 1 | 1 |
| 23 | 6 | 1 | 33 | 3323 | 22700 | 2 | 18098.759765625 | 4601.240234375 | 2 | 0 |
| 24 | 8 | 4 | 33 | 3968 | 28000 | 2 | 23476.16015625 | 4523.83984375 | 3 | 0 |
| 25 | 8 | 5 | 28 | 4652 | 33400 | 3 | 28958.240234375 | 4441.759765625 | 4 | 0 |
| 26 | 8 | 1 | 27 | 5949 | 41500 | 4 | 37213.87890625 | 4286.12109375 | 4 | 1 |
| 27 | 8 | 2 | 36 | 4400 | 25600 | 2 | 21128 | 4472 | 1 | 0 |
| 28 | 8 | 3 | 33 | 3933 | 22800 | 2 | 18271.9609375 | 4528.0390625 | 1 | 0 |
| 29 | 8 | 4 | 31 | 3612 | 23400 | 3 | 18833.439453125 | 4566.560546875 | 1 | 0 |
| 30 | 8 | 5 | 34 | 3578 | 24500 | 1 | 19929.359375 | 4570.640625 | 1 | 0 |
VeeMarie22
