Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

e. Take the variables from #2d that have a significant correlation with Overall Satisfaction and use Excels Data Analysis tool to run a Regression Analysis

image text in transcribede. Take the variables from #2d that have a significant correlation with Overall Satisfaction and use Excels Data Analysis tool to run a Regression Analysis at 95% confidence. Make sure to show your line-fit plots and labels for each variable.
Overall Satisfaction Price Ticketing Baggage Handling Comfort In-flight Service
Overall Satisfaction 1.000000
Price 0.870815 1.000000
Ticketing 0.840143 0.791073 1.000000
Baggage Handling 0.024489 0.003292 -0.172141 1.000000
Comfort -0.315245 -0.291548 -0.070663 -0.356319 1.000000
In-flight Service -0.879247 -0.756867 -0.769555 0.020072 0.248935 1
Table C8-2: Aggregate Satisfaction for Omega Airlines, and Satisfaction Scores for Variables Overall Sati Ticketing ggage Handl Comfort In-flight Service Price 4 3 8 10 9 98 6 5 6 8 5 70 9 7 4 2 45 5 4 5 7 5 66 2 4 10 89 4 8 91 6 6 8 5 72 10 5 5 58 2. 10 10 88 6 8 93 6 6 5 5 7 68 10 2 7 6 59 8 7 72 9 2 7 8 71 3 6 9 8 80 2 1 3 10 95 6 5 7 9 80 6 5 8 7 90 8 5 7 8 71 7 10 2 4. 6 67 7 1 7 5 57 6 8 10 91 10 9 4 6 4 49 4 8 5 6 65 4 3 8 8 84 5 7 6 7 8 71 5 4. 5 6 6 77 7 8 9 79 4 2 7 10 86 C Table C8-2: Aggregate Satisfaction for Omega Airlines, and Satisfaction Scores for Variables Overall Sati Ticketing ggage Handl Comfort In-flight Service Price 4 3 8 10 9 98 6 5 6 8 5 70 9 7 4 2 45 5 4 5 7 5 66 2 4 10 89 4 8 91 6 6 8 5 72 10 5 5 58 2. 10 10 88 6 8 93 6 6 5 5 7 68 10 2 7 6 59 8 7 72 9 2 7 8 71 3 6 9 8 80 2 1 3 10 95 6 5 7 9 80 6 5 8 7 90 8 5 7 8 71 7 10 2 4. 6 67 7 1 7 5 57 6 8 10 91 10 9 4 6 4 49 4 8 5 6 65 4 3 8 8 84 5 7 6 7 8 71 5 4. 5 6 6 77 7 8 9 79 4 2 7 10 86 C

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

Be Audit You Can Be

Authors: Awesome Auditor

1st Edition

1659095700, 978-1659095708

More Books

Students also viewed these Accounting questions