Complete the "Rate Category" column on the "Airline" worksheet. After completing the column do exploratory analysis of the airline data to determine how many Airlines fall under Category A$?$Use the table on the "Category" worksheet and a VLOOKUP function to complete the "Rate Category" column on the "Airline" worksheet. Use the Task $1$ worksheet as your work area for the exploratory analysis. Select your answer from the drop down in cell B$3).$
 

Record # Airline Year Cost Fuel Price Capacity Output Index Rate Category 1 United 1 $1,140,640 $106,650 0.534 0.953 2 United 2 $1,215,690 $110,307 0.532 0.987 3 United 3 $1,309,570 $110,574 0.548 1.092 4 United: 4 $1,511,530 $121,974 0.541 1.176 5 United 5 $1,676,730 $196,606 0.591 1.160 6 United 6 $1,823,740 $265,609 0.575 1.174 7 United 7 $2,022,890 $263,451 0.594 1.291 8 United 8 $2,314,760 $316,411 0.597 1.391 9 United 9 $2,639,160 $384,110 0.639 1.613 10 United 10 $3,247,620 $569,251 0.676 1.825 11 United 11 $3,787,750 $871,636 0.606 1.546 12 United 12 $3,867,750 $997,239 0.614 1.528 13 United 13 $3,996,020 $938,002 0.633 1.660 14 United 14 $4,282,880 $859,572 0.650 1.8221 15 United 15 $4,748,320 $823,411 0.626 1.936 16 American 1 $569,292 $103,795 0.491 0.521 17 American 2 $640,614 $111,477 0.473 0.535 18 American 3 $777,655 $118,664 0.503 0.655 19 American 4 $999,294 $114,797 0.513 0.792 20 American 5 $1,203,970 $215,322 0.567 0.843 21 American 22 American 23 American 6100 $1,358,100 $281,704 0.558 0.853 + 7 $1,501,350 $304,818 0.559 0.923 8 $1,709,270 $348,609 0.572 1.000 24 American 9 $2,025,400 $374,579 0.625 1.198 25 American 10 $2,548,370 $544,109 0.629 1.341 26 American 11 $3,137,740 $853,356 0.589 1.326 27 American 12 $3,557,700 $1,003,200 0.533 1.249 28 American 13 $3,717,740 $941,977 0.527 1.254 29 American 14 $3,962,370 $856,533 0.540 30 American 1.372 15 $4,209,390 $821,361 0.529 1.390 31 Delta 1 $286,298 $118,788 0.524 0.262 32 Delta 2 $309,290 $123,798 0.537 33 Delta 0.266 3 $342,056 $122,882 0.582 34 Delta 0.306 4 $374,595 $131,274 35 Delta 0.579 0.326 5 $450.037 $222.037 Data Dictionary 0.607 0.346 Airline Category Task 1 Task 2 teady Accessibility C