MA508 Business Statistics - Assignment Help

Assignment Help on Data Analysis

Assignment Description

Students are required to produce an individual assignment using data provided. Data is available on BB108 Moodle shell. You need to use Business Statistics theory, concepts, tools and terminology that you have learnt from weeks 1 to 8 to analyse the data and to write up the assignment.

Data set [Job Satisfaction] is from a global corporation. Three hundred employees of the company globally have been surveyed regards their job satisfaction in the company.

The variables include:
1. ID
2. “Gender” 1= male or 2=female

Marital status (Married, single)
Age

Years of experience

City where they come from (areas coded from 1 to 5)
Region they come from (east, west, south, north)
Departments (1=IT, 2=Marketing, 3= Sales, 4= HR, 5= Finance 6=Innovation)
Salary (in thousands)

Job satisfaction score before training (1= extremely dissatisfied; 5=extremely satisfied)

Job satisfaction score after training (1= extremely dissatisfied; 5=extremely satisfied)
Life happiness score (1= extremely unhappy; 10=extremely happy)
Promoted (yes, No)

xiv. Organization relation and employee satisfaction survey (OR) (1 to 5)

Teamwork and employee satisfaction survey (TW) (1 to 5)

xvi. Information and employee satisfaction survey (INF) (1 to 5)

xvii. Job passion and self-evaluation employee satisfaction survey (JP) (1 to 5)

xviii. Work/Life balance and employee satisfaction survey (WLB) (1 to 5)

Assignment instructions:

Using statistical theory and applications to complete the tasks listed below. You are expected to submit a word document in PDF format and an Excel file which is used to carry out the data analysis.

Assignment structure and task:

Introduction– Introduce the business problems. (10 marks)
1. Describe the main objectives of the researchers who collected this dataset (1 marks)
2. Describe how you want to achieve these objectives in this assignment (1 marks)

List all statistical hypotheses you want to test in this assignment and indicate how the hypotheses are related to the research objective above.

(Note: you can put the hypotheses you are going to test in a table with names of the tests and purpose of the tests) (8 marks)

Hint: you should write this section after you finish all the following tasks.

Do you think Salary is gender-biased? (10 marks)
1. Formulate a statistical hypothesis to test the gender-unbiasedness of payment (2 marks)
2. Run the statistical test of the hypothesis (5 marks)

Conclude your test result (3 marks)

Do you think Salary is City area-dependent? (10 marks)
1. Formulate the test of equal Salary across all City areas (5 marks)
2. Run the ANOVA test (8 marks)

Interpret your results (3 marks)

Do you think the training improves the job satisfaction? (20 marks)
1. Formulate a statistical test to support your opinion (3 marks)
2. What is your null hypothesis and what is your alternative hypothesis? (2 marks)

What is your chosen significance level of the test? (1 mark)

Show your test workings (4 marks)
Critically Interpret the test result (2 marks)
Show an alternative way of test. (8 marks)
Do you think promotion is gender biased? (10 marks)
Create a two-way table of Gender and Promotion. (2 marks)
Formulate the statistical test of independence: the null hypothesis and the alternative hypothesis (2 marks)

Run the test (4 marks)

Interpret the results (2 marks)
Relationship between two numerical variables: does salary depend on age? (15 marks)
1. Create a scatter plot between Age and Salary and interpret the graphs (5 marks)
2. Run a regression of Salary on Age (5 marks)

Interpret the regression output (5 marks)

Relationship among many numerical variables: what determine the JSS after training? (15 marks)
1. Create 5 scatter plots between Job Satisfaction after Training and the 5 variables: OR, TW, INF, JP, and LWB respectively, and interpret the plots (5 marks)
2. Run a multiple regression to quantify the influences on the JSS (5 marks)