Airlines

The dataset consists of data for

multiple airlines across different years.

Each row represents a specific

combination of an airline and a year

providing information about associated

cost$,$ fuel prices, capacity, output

index.

Applying appropriate analysis

techniques, answer the following five

questions.

$11\mathrm{.}1$ 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

Can someone help with the formulas for this!