Purpose: The purpose of this assignment requires you to understand the population & sample, identify the variable type, produce and interpret descriptive and inferential statistics and employ various...

Purpose: The purpose of this assignment requires you to understand the population & sample,
identify the variable type, produce and interpret descriptive and inferential statistics and
employ various graphical techniques to conduct quantitative research.
Suppose University A sent out a survey in 2017 to a random sample of 300 students in
Australian campuses and collected various information of them, including gender, birthday,
GPA, pulse rate, the child rank in the family, the number of children in the family, the number of
speed tickets, whether he/she is a smoker or not, the number of hours sleep per day, region,
whether he/she lives on campus or not and whether he/she is over twenty years old. The data is
reported in the Survey.xlsx data file.
(1) What is population University A is interested in?
(2) Use Microsoft Excel to conduct and present the appropriate graphic and descriptive analysis
on the following variables: GPA, birthday and the child rank in the family, interpret the
results, and prepare a report.
(3) Suppose University A also conducted the same survey in 2016, the proportion of rural
students was 0.20. 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.
Question 2 (60 marks)
Suppose you want to rent a two-bedroom apartment in Sydney and you are interested two
main suburbs (Suburb 1 and Suburb 2) and want to find out:
• whether the average rent in Suburb 1 is significantly higher than $450 per week
• whether the average rent in Suburb 1 is higher than that in Suburb 2
In order to find the answers, you determined to do a research and conduct quantitative
analysis. You are required to:
(1)Randomly select a sample of 50 apartments in Suburb 1and another 50 apartments in
Suburb 2 and record their rents. Thus, a total of 100 observations are recorded in your
dataset.
(2) What are populations you are interested in for each of the above two questions?