20 Mar Question 1 (8 marks)Suppose University A sent out
Question 1 (8 marks)Suppose University A sent out a survey in 2018 to a random sample of students in Australiancampuses and collected various information of them, including gender, birthday, GPA, pulserate, the child rank in the family, the number of children in the family, the number of speedtickets, whether he/she is a smoker or not, the number of hours sleep per day, region, whetherhe/she lives on campus or not and whether he/she is over twenty years old. The data is reportedin the Survey.xlsx data file.(1) What is the population University A is interested in? (1 mark)(2) Use Microsoft Excel to conduct and present the appropriate graphic and descriptive resultson each of the following variables: GPA, Smoker and the child rank in the family, interpretand analyze these descriptive results, and prepare a summary report. (3 marks)(3) Suppose University A also conducted the same survey in 2017, the proportion of urbanstudents was 0.15. They would like to know if this proportion has changed. You are requiredto : (4 marks) Identify the appropriate test Establish the null and alternative hypotheses for this test Produce the test results using Microsoft Excel, interpret it and make a final conclusion Write a report on itQuestion 2 (12 marks)Suppose you want to rent a two-bedroom apartment in Sydney and are interested in two mainsuburbs (Suburb 1 and Suburb 2). You determine to do a research, select a random sampleand conduct quantitative analyses so that you can use conclusions to make the final decision.The following are two questions you want to examine:1) whether the average rent in Suburb 1 (or Suburb 2) is significantly higher than $450per week.2) whether the average rent in Suburb 1 is higher than that in Suburb 2You are required to:1) Identify populations you are interested in for each of the above two questions.2) Randomly select a sample of 50 apartments in Suburb 1 and another 50 apartments inSuburb 2 and record their rents. Thus, a total of 100 observations are recorded in yourdataset.3) Based on the above sample you collected, produce results using Microsoft Excel,conduct your analyses following detailed steps for HYPOTHESIS TESTING ANDESTIMATION method and summarize your results in a report.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.