Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Short Course In Automorphic Functions

Authors: Joseph Lehner

1st Edition

0486799921, 9780486799926

More Books

Students also viewed these Mathematics questions

Question

Where do the authors work?

Answered: 1 week ago

Question

I was partially responsible.

Answered: 1 week ago