Instructions: You are required to type up your entire assignment, including any equations. If you are using Word, you should use the equation editor for any maths notation. Copy and paste relevant...

Instructions:

1. You are required to type up your entire assignment, including any equations. If you are using Word, you should use the equation editor for any maths notation.


2. Copy and paste relevant Excel outputs while discussing your answer in the text. Do not put all Excel outputs at the end of the document.


3. Answer all questions in the given order; i.e., 1(a), 1(b), etc. Keep your answers clear, brief, and concise.


4. Convert and submit your assignment in pdf, which must be uploaded to the Turnitin assignment box on Canvas.


5. Data used in this assignment are in the spreadsheetSurvey of_graduates.xlsx.


6. This assignment carries a weight of 30% towards your final mark for BUS110.


7. You need to submit (1) pdf file and (2) Excel spreadsheet with all your workings.

Data ID numberAreaGenderSatisfactionSearchSalary 1113151 2413238 3513451 4112552 5213249 6213254 7312245 8112551 9412252 10113248 11112257 12411149 13314145 14113251 15411249 16113256 17511134 18412345 19512637 20112152 21411247 22112250 23311246 24412247 25211158 26412344 27113255 28411235 29414142 30211262 31211153 32112243 33112449 34313441 35412245 36111262 37511545 38111157 39211364 40112151 41112455 42412548 43513345 44312141 45212253 46413340 47413154 48411244 49411252 50313243 51113150 52311341 53111152 54512337 55114244 56213351 57412238 58311648 59212349 60112148 61113447 62111144 63113257 64112246 65312334 66213248 67112148 68111247 69313147 70413637 71411447 72112144 73312245 74213153 75414247 76411142 77311636 78413449 79414645 80111144 81412139 82311141 83411545 84211155 85112156 86112154 87212158 88111350 89112256 90213137 91212253 92211252 93512346 94113151 95411441 96412342 97211254 98211155 99413139 100413444 101413244 102412350 103512136 104112155 105313242 106412348 107411347 108512147 109212258 110112252 111413435 112112251 113412643 114112153 115312341 116513238 117211243 118112248 119411444 120111144 121512339 122311145 123111155 124121255 125122542 126512136 127123250 128412249 129122551 130411146 131212153 132222447 133413649 134222159 135122353 136221359 137123253 138422245 139311445 140122158 141424251 142123245 143222160 144421442 145423449 146223144 147311246 148222239 149323242 150514250 151524137 152223254 153222155 154422442 155121444 156523236 157522144 158121161 159321237 160221153 161221246 162221160 163221265 164123443 165122149 166422148 167522536 168423241 169222151 170222159 171122240 172321643 173423351 174223153 175322238 176522433 177122252 178123160 179322148 180121147 181123251 182424150 183222153 184421140 185421252 186122146 187221249 188423447 189421343 190122442 191421645 192422243 193522335 194323254 195221451 196123454 197221141 198222245 199523338 200121340 201322244 202322144 203521543 204222245 205423144 206424346 207423446 208522634 209221263 210122249 211422242 212321249 213522446 214523244 215422348 216221245 217421242 218523346 219321152 220521232 221422138 222322440 223422233 224221146 225123251 226222255 227321244 228222246 229122149 230321348 231121259 232221546 233222159 234122146 235321235 236122144 237423243 238122154 239321141 240121151 241323647 242221144 243522226 244221158 245221546 246322245 247522129 248123160 249121149 250323249 251423448 252122254 253121245 Assessment Extension Application Form BUS110 Statistics Data Analysis Assignment Date Due: Sunday, July 17, 2022 by 11:59 pm (Week 7) Instructions: 1. You are required to type up your entire assignment, including any equations. If you are using Word, you should use the equation editor for any maths notation. 2. Copy and paste relevant Excel outputs while discussing your answer in the text. Do not put all Excel outputs at the end of the document. 3. Answer all questions in the given order; i.e., 1(a), 1(b), etc. Keep your answers clear, brief, and concise. 4. Convert and submit your assignment in pdf, which must be uploaded to the Turnitin assignment box on Canvas. 5. Data used in this assignment are in the spreadsheet Survey of_graduates.xlsx. 6. This assignment carries a weight of 30% towards your final mark for BUS110. 7. You need to submit (1) pdf file and (2) Excel spreadsheet with all your workings. In this assignment, you will examine employment data obtained through a survey of business school graduates undertaken by a university placement office. The data is contained in the file Survey of_graduates.xlsx and contains the following columns (variables): Variable Description Area Area of employment: 1 = Accounting, 2 = Finance, 3 = General management, 4 = Marketing/Sales, 5 = Other Gender 1 = Female, 2 = Male Satisfaction Job satisfaction: 4 = very, 3 = quite, 2 = little, 1 = none Search Number of weeks job searching Salary $thousands Random Sample Before you begin your analysis, you are required to take a random sample of size 100 from the 253 cases in the file. Use the file Sample-Generator.xlsx to do this. Your answers to the questions below are to be based on your sample of 100 cases. Make sure to keep a safe copy of your sample since you cannot use Sample-Generator to reproduce the first sample. Question 1: Variable List a. Using the variables listed in the table above, state for each variable whether it is qualitative or quantitative. b. If it is qualitative, state whether it is nominal or ordinal, and if it is quantitative, state whether it is discrete or continuous. Question 2: Histogram a. Create a histogram showing the distribution of salaries. b. Calculate the skewness coefficient and comment upon the shape of the distribution: is it symmetric? If it is not, is it positively or negatively skewed? c. State which central measure would be best to use to describe the centre of this distribution, and the reason(s) why. Question 3: Descriptive Statistics a. Prepare a table that shows the 5-number summary and standard deviation of salary for the five work areas. b. Construct side-by-side boxplots for the salaries. Briefly comment upon any differences you observe in salaries for each work site. Question 4: Pivot Table and Bar Chart a. Construct a pivot table that shows satisfaction for each area of employment. Place satisfaction in the rows, area in the columns and a count of job satisfaction in the body of the table. b. Obtain a second pivot table by converting the frequencies in each column into relative frequencies in each column (right click on any number in the table, then choose Show Values as % of Column Total). c. If the business school graduate wanted to get most satisfaction from their job, based on the information in the table, which area of employment should they choose? d. Construct a bar chart comparing the distribution of males and females in all areas of employment. e. Do employment areas differ in percentage of female/male graduates? If yes, how? Question 5: Conclusion From the tasks above, you should have some idea of the employment of business school graduates. Write a short paragraph summarising your main findings.