In excel in a continuous manner please encode the following data

The statistical computation should be done using ANOVA

Run ANOVA

Interpret the result

A travel industry magazine received several reports from international travelers about the quality of in-flight service on various carriers from the United States to Europe. Before writing a feature story, the magazine decided to get the services of a researcher to study the perspectives and reactions of travelers.The researcher selected passengers who had current impressions of the meal service, comfort, and friendliness of a major carrier.Three airlines were chosen and 20 passengers were selected for each airline. The respondents were requested to rate the services of the airlines.This is known as Rating 1.After sometime, the same respondents were again asked if there was an improvement in the services provided by the airline companies. This is labeled as Rating 2.The following codes were used:

Airline : 1 = Delta; 2 = Lufthansa; 3 = KLM

Class: 1 = Economy; 2 = Business

Magazine Survey on Flight Continuation... Rating 1 Rating 2 Airline Class Rating 1 Rating 2 Airline Class 40 36 1 1 52 65 2 2 28 28 1 1 70 80 IN 2 36 30 1 1 73 79 2 32 28 1 1 72 38 2 2 60 40 1 1 73 89 IN IN 12 14 1 71 72 32 26 1 1 55 58 2 NN 36 30 1 58 67 NN 44 38 81 85 36 35 78 80 W N 40 42 2 92 95 68 49 IN 56 60 W 20 24 1 2 64 70 3 33 35 IN 72 78 65 40 2 48 65 W 40 36 52 70 W INN 51 29 1 64 79 3 25 24 68 81 37 23 IN 76 69 W W 44 41 2 56 78 56 67 2 88 92 3 NNN + 48 58 79 85 64 78 NNN 92 94 w w w 56 68 88 93 UNN 28 69 2 73 90 32 74 2 58 57 42 55 2 81 85 40 55 95 95 3 N NN NN 61 80 1 58 57 W 58 78 2 1 78 33 3 N