MODULE 14AAE ASSIGNMENT 1, ASSIGNMENT 2, ASSIGNMENT 3

Order Description This is a three in one module coursework, had not so pleasant experience with one of the last writer and had to request of the coursework to be rewritten twice, but the other two writer did excellent job. will like to avoid that particular writer. I will appreciate if careful attention is given to the examiners requirements. A lot of documents will be attached to give a good insight and provide almost all required information but not all will be needed to complete the 3 questions. Module M14AAE: Flight Deck Design Coventry University: Academic Year 2016/2017 © Coventry University 2017 ASSIGNMENT THREE – Correlation and Regression (15% of module mark) You will find an Excel data file entitled ‘Salary Vs Experience Data File (AY 16-17)’. In this (fictitious) data file are salary (in k Euros) and experience (in years) from 236 European pilots. Also included is the pilot’s rank (Captain or First Officer). 1. Perform a simple, linear regression to predict salary (Y axis) from years of experience (X axis). To do this you will need to go to the ‘DATA’ tab in Excel and the find the regression procedure under the DATA ANALYSIS sub menu (top right). If it does not appear on your menus you may need to load this procedure into Excel. 2. You need to report the equation for the line; regression coefficient; amount of variance accounted for by the regression equation and report if it is significant (or not). Following this, briefly interpret the results of your analysis. 3. On the basis of your results, how much would you estimate that a pilot with 19 years of experience should earn? Use ‘Sort and Filter (right had side on the Home Tab). 4. Is the correlation between salary and experience higher for Captains or First Officers? For each sub-sample report the correlation values, degrees of freedom and indicate if the result is significant at an alpha level of 0.01. How much of the variance is accounted for by the relationship between salary and experience in each case? Hint: Filter by rank and run the correlation procedure twice – you will also need to look in the tables at the back of Coolican for critical values of r! Module M14AAE: Flight Deck Design Coventry University: Academic Year 2016/2017 © Coventry University 2017 Report requirements Students are required to complete and submit online by 11.55pm (GMT) on Friday 10th March 2017. The word limit is 500 words (plus 10%, not including references). If you go exceed the word limit by more than 10% a penalty might be imposed (please refer to your Faculty Postgraduate Handbook). Any work submitted late will be marked as 0 unless a short/long deferral request has been granted.