Question: 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

 e. Take the variables from #2d that have a significant correlatione. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!