Department of Finance and Economics Qatar University Business Statistics I (STAT 220) Group Mini Project - fall2017 Due on Wednesday December 27, 2017 Use the data from the Excel file Xr02_54 concerning the survey of the Business school graduates. Use the pivot table function in Excel and the different rules of probability to solve the questions. A survey of Business school graduates undertaken by a university placement office asked, among other questions, in which area each person was employed. The areas of employment included. 1. Accounting 2. Finance 3. General management 4. Marketing/Sales 5. Other Additional questions were asked, and the responses were recorded in the following way: ____________________________________________________________________ Column Variable _____________________________________________________________________ 1 Identification Number 2 Area 3 Gender ( 1=Female, 2=Male) 4 Job Satisfaction (4= very, 3=Quite, 2= Little, 1=None) _____________________________________________________________________ 1- Do female and male graduates differ in their areas of employment? If so, how? 2- Are area of employment and job satisfaction related? 3- Are gender and area of employment related? 4- Are gender and Job satisfaction related? Note: Select your own groups. The minimum number of students per group is twoand the maximum is four. Each group should submit one HARD Copy in class on December 27, 2017. Email submissions will NOT be accepted.