Recent Question/Assignment
STATS1900 Business Statistics
Minor Assignment
Date Due: Refer to Course Description
Total Marks: 20 marks Worth: 10% of final assessment
This assignment requires an amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late!! Each question carefully describes what you are required to do so please follow these carefully!
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.xls 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 150 from the 253 cases in the file. Use the file Sample-Generator-101.xls to do this. Your tutor will show you how this can be done in EXCEL. Your answers to the questions below are to be based on your sample of 150 cases. Make sure to keep a safe copy of your sample since you cannot use Sample-Generator-101 to reproduce the first sample. Provide a printout of the data in your sample, with ID numbers in ascending order.
Task 1: Variable List: Using the variables listed in the table above state for each variable whether it is qualitative or quantitative, if it is qualitative state whether it is nominal or ordinal, and if it is quantitative state whether it is discrete or continuous.
Task 2: Histogram: Create a histogram showing the distribution of salaries. Comment upon the shape of the distribution: is it symmetric? If it is not, is it positively or negatively skewed? Are there any outliers present? If so, are they of particular interest?
State which central measure would be best to use to describe the centre of this distribution, and the reason(s) why.
Task 3: Descriptive Statistics: Prepare a simple summary table that shows the average and standard deviation of salary for the five work areas. Construct side-by-side boxplots for the salaries. Briefly comment upon any differences you observe in salaries for each work area.
Task 4: Pivot Table and Bar Chart: 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. 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 Summarize Values as % of column totals).
If a 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?
Construct a bar chart comparing the distribution of males and females in all areas of employment.
Do employment areas differ in percentage of female/male graduates? If yes, how?
Conclusion: From the tasks above, you should have some idea of the employment of business school graduates. In this section you should write a short paragraph summarising your main findings.
Total Marks = 20
Worth 10%
Minor Assignment
Date Due: Refer to Course Description
Total Marks: 20 marks Worth: 10% of final assessment
This assignment requires an amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late!! Each question carefully describes what you are required to do so please follow these carefully!
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.xls 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 150 from the 253 cases in the file. Use the file Sample-Generator-101.xls to do this. Your tutor will show you how this can be done in EXCEL. Your answers to the questions below are to be based on your sample of 150 cases. Make sure to keep a safe copy of your sample since you cannot use Sample-Generator-101 to reproduce the first sample. Provide a printout of the data in your sample, with ID numbers in ascending order.
Task 1: Variable List: Using the variables listed in the table above state for each variable whether it is qualitative or quantitative, if it is qualitative state whether it is nominal or ordinal, and if it is quantitative state whether it is discrete or continuous.
Task 2: Histogram: Create a histogram showing the distribution of salaries. Comment upon the shape of the distribution: is it symmetric? If it is not, is it positively or negatively skewed? Are there any outliers present? If so, are they of particular interest?
State which central measure would be best to use to describe the centre of this distribution, and the reason(s) why.
Task 3: Descriptive Statistics: Prepare a simple summary table that shows the average and standard deviation of salary for the five work areas. Construct side-by-side boxplots for the salaries. Briefly comment upon any differences you observe in salaries for each work area.
Task 4: Pivot Table and Bar Chart: 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. 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 Summarize Values as % of column totals).
If a 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?
Construct a bar chart comparing the distribution of males and females in all areas of employment.
Do employment areas differ in percentage of female/male graduates? If yes, how?
Conclusion: From the tasks above, you should have some idea of the employment of business school graduates. In this section you should write a short paragraph summarising your main findings.
Total Marks = 20
Worth 10%
Looking for answers ?
Recent Questions
Program: Master of Information SystemsAssessment 1: Portfolio 1 (Session 2 Topic: Input, Processing andOutput) Semester 2: Block 8-2024Course Code: MBIS4003 Course Title: Software Development Total Marks:...AssessmentAssessment item 2—Assignment 2Due date 11:45pm on Sunday, 24Nov.2024Weighting 35%Length Not applicableObjectivesThis assessment item relates to the unit learning outcomes numbers 1, 2 and 3 as...Plan, construct and write a long-form essay on a particular area of media research that interests you. Using an established theoretical framework, explain how your research offers new insights into the...DescriptionIn this assessment, you are required to demonstrate that you understand how an Older Adult can develop mental health problems associated with cognitive decline leading to cognitive impairment...School of Engineering, Design and Built EnvironmentENGR7008 Fire Engineering Design and AssessmentAssignment 4: Peer Review of Fire Engineering ReportASSIGNMENT 4PEER REVIEW OF A FIRE ENGINEERING REPORTSee...Structural Analysis Etask 5The aim of this assessment task is to evaluate the appropriate use of the Force Method and Moment Distribution Method for structural analysis• Please download the eTask4 from...Purpose:The purpose of this task is for the student to demonstrate how to create a holistic plan of care that is person-centred, trauma-informed, and recovery-oriented in focus.Description:In this written...Show All Questions