Subject Code : TSTA602
Country : Australia
Assignment Task

 

DATA DESCRIPTION
(A FICTITIOUS DATASET DESIGNED FOR THE ASSIGNMENT ONLY)
A consulting firm randomly selected 150 young employees in Tasmania. These selected employees answered questions and undertook a standard IQ test and a KW test. The KW test examines respondents’ knowledge about the duties in their workplaces and the knowledge about the Australian and Tasmanian labour markets. Respondents’ answers are entered a spreadsheet where each column represents a variable. These variables include:
1. wage: monthly earnings in dollars
2. hours: average weekly working hours
3. IQ: IQ score
4. KW: knowledge of work score
5. educ: years of education
6. exper: years of work experience
7. tenure: years with the current employer
8. age: age in years
9. marriage: marriage status
10. gender: female or male
11. urban: =Y if lives in urban areas
=N if lives in rural areas
12. sibs: the number of siblings
13. brthord: birth order, e.g. =2 means he/she is the second child in the family.
14. meduc: mother’s education
15. feduc: father’s education
The missing values are shown by a “.” in the cells.

Questions:
1. Read the provided raw data carefully to check whether all respondents have provided information for each variable. Explain what you have done to manage the missing data. Clearly indicate the final number of observations (respondents) you will use in the following analysis. Submit an electronic copy of the Excel spreadsheet of the final dataset together with your assignment. All your following analysis should be based on this final dataset.
 

2. Pick up two numerical variables and two categorical variables and then describe each of them one by one. Use appropriate tables/graphs and numerical measures to help you describe the distribution of the variables.

3. It’s often asked what factors relate to IQ score and KW score. Look through your data and first pick up one numerical variable that you think may relate to IQ score. Explain why you pick up this variable. Then use an appropriate graph and an appropriate numerical measure to discuss the empirical relationship between IQ score and this numerical variable. Repeat the same exercise for the relationship between KW score and a numerical variable to which you think KWmay relate.
 

4. You want to look at the relationship between gender and wages. However, you notice that gender is a categorical variable and wage is a numerical variable. One way to work on two different types of variables is to transform one variable to the type of the other. You decide to generate a categorical variable based on the level of wage, and this categorical variable has two values, “high” and “low”. For example, you choose a threshold value for wage, and if a respondent’s wage is no less than the threshold value, you enter “high” and enter “low” otherwise.

a. Describe in detail how you have decided the threshold value for generating the new categorical variable for the level of wage. Then use an appropriate graph to present this variable. (Hint: you may choose to use an appropriate numerical measure of wage as the threshold value).

 

This TSTA602 - Accounting & Finance Assignment has been solved by our Accounting & Finance experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

  • Uploaded By : Brett
  • Posted on : May 01st, 2019
  • Downloads : 133

Whatsapp Tap to ChatGet instant assistance