Question 1 (13 marks) Suppose Australian government sent out a survey in 2016 to a random sample of Australian workers and collected various information of them, including gender, age, marital status, the number of hours watching TV each day, ethnicity, years of education, occupation, the number of hours spent on housework, the number of hours worked per week, work situation last week, income, satisfaction with life and travel time to work. The data is reported in the What_Analysis.xls data file.
(1) What is population Australian government interested in?
(2) Use Microsoft Excel to conduct and present the appropriate graphic and descriptive analysis on two variables: income and ethnicity, interpret the results, and prepare a report.
(3) Suppose Australian government also conducted the same survey in 2015, the proportion of Australian workers who are satisfied with life was 0.65. They would like to know if this proportion has decreased. • What is the appropriate statistics used here to test it? • What are the null and alternative hypotheses for this test? • Produce the test results using Microsoft Excel, interpret it and make a final conclusion.
(4) Suppose Australian government also conducted the same survey in 2015, the average years of education Australian workers obtained was 10.8. They would like to know if this has changed. • What is the appropriate statistics used here to test it? • What are the null and alternative hypotheses for this test? • Produce the test results using Microsoft Excel, interpret it and make a final conclusion.
Question 2 (7 marks) Suppose you want to buy a two-bedroom apartment in Sydney and you are interested two main suburbs (Suburb 1 and Suburb 2) but you don’t know which one has higher average price. So you determined to do a research and see whether there is a significant difference of market price in these two suburbs. You are required to: (1) Randomly select a sample of 50 properties in Suburb 1and another 50 properties in Suburb 2 and record their market prices. Thus, a total of 100 observations are recorded in your dataset. (2) What are populations you are interested in? (3) Conduct your analysis using hypothesis testing method. Note: Check the conditions for the test identified. (4) What conclusion you can make from the results for your decision making? Note: • You need to replace Suburb 1 and Suburb 2 with real suburbs in Sydney, for example, NEW TOWN and HURSTVILLE. • The price information can be collected in the website (e.g. http://www.realestate.com.au/buy). • You need to submit your dataset together with your individual assignment.