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 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
Get step-by-step solutions from verified subject matter experts

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 at 95% confidence. Make sure to show your line-fit plots and labels for each variable.