Question
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.
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.
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.
[10 marks]
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started