use excel. X University has contacted us in an effort to better understand the o
ID: 3329889 • Letter: U
Question
use excel.
X University has contacted us in an effort to better understand the outcome of business students seeking a Bachelor of Business degree in Australia. In particular, they wish to seek what is a larger driver of student outcomes, student satisfaction with their program or the prerequisites of students arriving at the university. We have collected information on the average salary of business graduates from 39 universities across Australia.
1. Your supervisor recently stated that historically, universities set a minimum ATAR entrance score of 70 for their business programs. Yet she believes that the minimum score is falling. Test her claim at the 1% level of significance.
2.what other factors would have influenced graduate salary? Provide a couple possible examples and indicate their predicted relationship with graduate salary if they were included.
3.Given that student enrolment varies across universities, does this table indicate the true population distribution of graduate salaries of business students? Explain and if not, describe a sampling procedure that could lead to more accurate results.
Business School Salary Satisfaction ATAR G8 ATN VIC QLD SA NSW WA OTHER Australian Catholic University 37251 84 59 0 0 1 0 0 0 0 0 Australian National University 50385 80 82 1 0 0 0 0 0 0 1 Bond University 41729 86 50 0 0 0 1 0 0 0 0 Charles Darwin University 55675 83 60 0 0 0 0 0 0 0 1 Charles Sturt University 55136 79 65 0 0 1 0 0 0 0 0 CQUniversity 49456 84 52 0 0 0 1 0 0 0 0 Curtin University 42062 81 70 0 1 0 0 0 0 1 0 Deakin University 41551 86 53 0 0 1 0 0 0 0 0 Edith Cowan University 44343 89 55 0 0 0 0 0 0 1 0 Federation University Australia 41638 82 50 0 0 1 0 0 0 0 0 Flinders University 41464 84 60 0 0 0 0 1 0 0 0 Griffith University 40960 84 59 0 0 0 1 0 0 0 0 James Cook University 39881 81 49 0 0 0 1 0 0 0 0 La Trobe University 39612 82 50 0 0 1 0 0 0 0 0 Macquarie University 40692 80 80 0 0 0 0 0 1 0 0 Monash University 43928 85 82 1 0 1 0 0 0 0 0 Murdoch University 42078 76 70 0 0 0 0 0 0 1 0 Queensland University of Technology 43006 89 62 0 1 0 1 0 0 0 0 RMIT University 41897 75 70 0 1 1 0 0 0 0 0 Southern Cross University 44297 79 61 0 0 0 0 0 1 0 0 Swinburne University of Technology 39930 87 60 0 0 1 0 0 0 0 0 University of Adelaide 42946 80 80 1 0 1 0 0 0 0 0 University of Canberra 47485 82 68 0 0 0 0 0 0 0 1 University of Melbourne 57296 86 95 1 0 1 0 0 0 0 0 University of New England 55778 88 73 0 0 0 0 0 1 0 0 University of New South Wales 49665 78 96 1 0 0 0 0 1 0 0 University of Newcastle 45869 84 61 0 0 0 1 0 0 0 0 University of Notre Dame Australia 43728 84 70 0 0 0 0 0 0 1 0 University of Queensland 43860 83 81 0 0 0 1 0 0 0 0 University of South Australia 42939 88 65 0 1 0 0 1 0 0 0 University of Southern Queensland 52027 83 59 0 0 0 1 0 0 0 0 University of Sydney 52414 77 95 1 0 0 0 0 1 0 0 University of Tasmania 44345 75 65 1 0 0 0 0 0 0 1 University of Technology, Sydney 41782 84 69 0 1 0 0 0 1 0 0 University of the Sunshine Coast 34000 89 52 0 0 0 0 0 1 0 0 University of Western Australia 49003 79 80 1 0 0 0 0 0 1 0 University of Wollongong 46703 91 70 0 0 0 0 0 1 0 0 Victoria University 36321 73 50 0 0 1 0 0 0 0 0 Western Sydney University 40806 84 65 0 0 0 0 0 1 0 0Explanation / Answer
1) One sample ttest on ATAR score gives us p = 3.8800e-29 and the confidence interval lies between 62.2935
70.6808. Thus the supervisor's claim is correct.
2) I think we must have taken class performance, debating, oratory and group discussion skills into account too.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.