Question 1 

Suppose University A sent out a survey in 2014 to a random sample of 280 students in Australian campuses and collected various information of them, including gender, birthdayGPA, 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.

 

  • What is sample and population University A is interested in?

 

  • Use Microsoft Excel to conduct and present the appropriate graphic and descriptive analysis on two variables: hourssleep and birthday, interpret the results, and prepare a report.

 

  • Suppose University A also conducted the same survey in 2013, the proportion of rural students was 0.30. 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.

 

  • Suppose University A also conducted the same survey in 2013, the average time students spent in sleep per day was 8 hours. They would like to know if this has increased.
    • 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.

 

For a custom-written paper, place your order now!

What We Offer
• On-time delivery guarantee
• PhD-level professionals
• Automatic plagiarism check
• 100% money-back guarantee
• 100% Privacy and Confidentiality
• High Quality custom-written papers

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Related Model Questions

Feel free to peruse our college and university model questions. If any our our assignment tasks interests you, click to place your order. Every paper is written by our professional essay writers from scratch to avoid plagiarism. We guarantee highest quality of work besides delivering your paper on time.

Grab your Discount!

25% Coupon Code: SAVE25
get 25% !!