Data Analysis

139 views 7:20 am 0 Comments July 4, 2023

Research Report Assessment

Semester 1, 2021

Due Date: 11:59 30th May

The data for the Assignment can be found in the file Research Report Assessment (2021-01).xlsx on Blackboard

The Problem

FringeTech is an information technology / electrical engineering company that employs thousands of people Australia wide. Recently management decided to ask employees to carry out a series of three tests based around firm procedures, general knowledge and a general intelligence test. All employees were then awarded a score out of 225.

Information on 150 employees is given in the file Research Report Assessment (2021-01).xlsx. The table below provides an example of the results showing outcomes for the first 10 employees along with other data collected on them to give an indication of the information available.

Table 1: Sample Results

Employee Number Test Result Gender Income ($000) Higher Degree (Y=1, N=0) Age GPA
1 163 F 94.1 0 21 3.07
2 148 F 69.4 1 30 2.82
3 163 M 83.1 1 30 2.89
4 142 F 81.7 0 26 3.02
5 173 F 72.1 0 31 2.98
6 168 F 90.1 0 29 3.02
7 178 M 95.4 0 35 3.04
8 154 M 128.2 1 49 3.55
9 155 F 84.4 1 39 3.35
10 163 F 77.5 0 29 2.9

Variables included in this dataset are:

Test Result: Total Score over the three tests
Gender: Male or Female
Income: Annual income in ($000)
Higher Degree: Employees with a Degree above a bachelors (Masters, PhD etc) are Yes = 1. All employees in the data set have at least a bachelor’s degree.
Age: Years
GPA: Score out of 4. GPA’s have been standardised because of the variety of systems in Australia and globally

You have been asked to provide a report to management on the results of the test, and factors which affect both performance and income levels. In coming to your conclusions you will be considering issues around test scores, hiring practices and income effects:

Tags: , , , , , , , , , ,