AutoSave OFF OFF ROSU- Lab instruction - Compatibility Mode Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments X A Times New... v 24 "A Aav A vev 21 Aabbcode Aabhcode: AaBbccDc Aalbcende AaBb Bbcende Anrhede Paste BIU au X X A A - Normal Nu Sparing Heading Hing Title Subtitle Sublemen Dictate Styles Pare Lab Instruction 1) Which department has the highest average salary? 2) Which department has the highest number of full professors? 3) Create a column for the professor's full name 4) How many professors were hired each year? 5) Create bubble chart with Y= Year, X = Number of professor hire, and the bubble size being the average salary like the example below Professor Year Salary 2003 1997 100 12: 1975 1970 0 9 6 Num offisson 6) What is the average salary, for male professor in accounting Page 1 of 2 163 words English (United States + 100% AutoSave OFF OFF ROSU- Lab instruction - Compatibility Mode Home Insert Draw Design Layout References Share Comments Mailings Review View Tell me v 21 X C Times New... v 24 ~ A Aav A Aabbcode AabhcodeAaBbccc Aalbcende AaBb A BECEDAE Anrhede Paste B u x x A = = Nam! Nu Sparing reading Haning Title Subtitle Sublemen Y Dictate Styles Pare whose salary is above the university average? 7) What is the correlation coefficient between Years of Employment (till Year 2000) and Salary? 8) Please create a scatter plot with X being the Years of Employment (till Year 2000) and Y being the Salary? 9) Someone in the school complained there is gender-based discrimination salary, excluding effects of the salary differences with regard to professor rank and department. The school board wants to investigate into this claim. What insights can you get from this data in support of this investigation? 1 Page 2 of 2 163 words LE English (United States) + 100% Faculty Data Home Insert Page Layout Formulas Data Review View Share AutoSum" AY MS Sans Serit ~ Al A h Wron Text Currency X [G Fill Paste y A BIU -- Merge & Center $ % 2 Format Insert Delete Conditional Format Cell Formatting as Table Styles Clear v Sort & Filter Find & Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left oft? Yes No Activate M N P a R S T U V Subscription Required to edit and Save Start your free one month trial of Microsoft 365 or Sign in to activate an existing subscription. G1 fx SALARY D C F H I J L L 1 LASTNAME FIRSTNAME DEPARTMENT RANK YEARHRED BEX SALARY 2 Smith Alicia Accounting Full Prot nyeg F S49,805 3 Jacobson Andrew Management Full Prot 1971 M S55,281 4 Cererecli Angels Finance Asociate 1978 F S44,212 5 Nelson Beth Finance Full Prot 1977 F $52,839 6 Coats ell Accounting Asaktan 1990 M S45,871 7 JACKSON Carole Acouring Instructor 1992 F 833,781 8 Uressatte Chary Accouring Instructor 1987 F $36,582 9 Doeska Chary Accounting Full Prot 1978 F $52, 105 10 Woker Christine Accouring such 1983 F $44,919 11 Mikkola Claudia Financa Associate 1976 F 545,281 12 Downs anon Accounting Associate 1982 M S48,887 13 Nelson Dale Accouring Full Prot 1988 M $54,678 14 True David Accounting Full Prot 1986 M 553,81 15 Blackwel Dean France Instructor 1992 M 16 Scheia Earl Management Instructor 1999 M 837,389 17 Ringerald Edmond Management Asociate 1990 M S48,757 18 Pothenborge James Management Full Prot 1960 M $81,781 19 Smythe Jarico Management Associate 1986 F F 545,887 20 Young Jell Management Assistant 1980 M S43,513 21 Lu Jim Accouring instructor 1950 M $39,881 22 Weeks Jocia Francs Instructor 1988 F $33,052 23 Guralne Karen Finang AU 1979 F S48,000 24 Lens Karl Management Associate 1979 M 548,887 25 Rou Katherine Management Agent 1988 F S42,911 26 Log Kel Firance Assistant 1964 M S41,000 27 Neumann Kenneth Financa Instructor 1988 M S35,881 28 Maca Kevin Management Assistant 1989 M S42.500 29 Arderson Kristen Accounting Assistant 1988 F F 543,165 30 Stewart MAIR Accounting Arabant 1986 M S47,618 31 Pais Mary Finance Instructor 1993 F $27,000 32 Parker Mathew Accounting Full Prot 1974 M 557,892 33 Falnem Murray Finance Associate 1989 M S48.000 34 Weaver Robert Accouring Full Prot 1976 M $55,775 35 Ball Robin Accounting Instructor 1987 F 875,723 36 Chin Roger Acouring Full Prol 1991 M $59,281 37 Paloma Shery Accounting Associate 1988 F 545,617 Sheet1 + # 2 - + 100% Faculty Data Home Insert Page Layout Formulas Data Review View Share X G Calibri (Body) v 12 AutoSum ~ A " General 2 Wrap Text Merge & Center Fill Pastc av A -- Insert BIU $ % Format Delete Conditional Format Cell Formatting as Table Styles Clear v Sort & Filter Find & Select Yes No Activate M N O P a R S T U V Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left oft? Subscription Required to edit and Save Start your free one month trial of Microsoft 365 or sign in to activate an existing subscription. G44 fx A C D E F H J K L 11 Mikko Claudia Finance Axual 1976 F F 12 Downs atton Accounting Associate 1982 M 546,887 13 Neon DAA Accounting Full Prof 1988 M $54,578 14 True David Accounting Full Prot 1986 M $63,181 15 Pickel Dean Franca Instructor 1992 M S37,797 16 Schelo Earl Management Instructor 1989 M $37,389 17 Pizgerald Edmond Management Associate 1950 M 549,767 18 Fothanbange James | Management Full Prof 1990 M S81,781 19 Smythe Jurica Mariagerrent Assu 1986 F S48,887 20 Ycung Jet Management Asahan 1950 M 543.513 21 lu lim Accouring Instructor 1980 M $38.881 22 Weeks Jucie Finance Instructor 19es F $33,062 23 Garatan KAN France Associate 1979 F F S45,000 24 LNB kai Maringen en sociale 1979 M S18,387 25 Bordeau Katherine Management Assistant 1986 F 842,311 26 Les Kel Finance Artan 1994 M S41,000 27 Neuen Kenneth Finance Instructor 19 M $35,381 $ 28 Mac Kevin Management Assistant 1999 M 542,500 29 Anderson Klan Accounting Asllant 1988 F S43155 30 Stewart Mark Accountng Assistant 1986 M S47,618 31 Fais Mary Financa Instructor 1993 F $27.000 32 Parker Mathew Acouring Full Prol 1974 M $57,892 33 Halpem Murray Finance Associate 1989 M $48.000 34 Vaavar Robert Accounting Full Prot 1978 M S55.775 35 Dall Robin Accounting Instructor 1987 F S75,723 36 Chin Roger Accountng Full Prot 1991 M 559,281 37 Paleo Shery Accounting Associate 1918 F S45,617 38 Mo Kaye Susan Management Instructor 19es F F $33,679 29 Smith Tam Financa Full Prot 1972 M S57,167 40 Fil Trevor Marinyengiruclur 1991 M 835,590 41 Garabin Wandy Management Instructor 1994 F 828,GOD 42 GAD Xiaoming Management Full Prof 1982 M 555.829 43 44 45 46 47 11 Sheet1 + # - + 100%