The data are stored in the Excel file: ExamMarks.xlsx which is on iLearn. Use this data file to complete Question 2.
Each part of this question must be labelled and must be presented in order and must be neatly word processed. Untidy work wll not be marked. Each part (a., b. and c.) should be answered by a different student from your group. Each part of this question uses a different section of the data set which should be extracted (either by sorting the data or splitting the worksheet). Each part asks about the difference between average marks for a particular group of students. Since the worksheet contains data on both English and Mathematics marks, each part should address both English and Mathematics marks (ie. one hypothesis test on English marks and one hypothesis on Mathematics marks for each part). Minitab output for these analyses, along with any other appropriate graphical output, should be cut and pasted neatly into the space provided for each part. Please note that output that is not clearly labelled will not receive any marks (eg. Group 1 is not a clear label whereas Co-educational School is a clear label). On the following page provided for each part, a report on these analyses should be written up. One report only is required for each part, with the report addressing both English and Mathematics scores in regard to the Research Question. Reports should follow the format described in the report writing document on iLearn, with particular attention to the section ‘A Short Guide to Report Writing for STAT170 students’. Each report will have an Introduction, a Methods section, a Results section and a Conclusion as outlined in the report writing document. Reports should not be more than one A4 page in length.
Research Questions for Q2:
Part a Report
Introduction:
The main objective of this section is to determine wehthe there is a significant difference in the average marks on standardised exams change significantly between Years 7 and 11. The average marks scores by the students in boys only shool is 54.87813 in year 7 and 57.11384 in year 11.
Methods:
In order to test the claim, we perform independent sample t test. Here, the independent variable is the class 7 and class 11 and the dependent variable is the standardized scores. Since two groups are independent, we can perform independent sample t test
Results:
The value of t test statistic is -0.91825 and its corresponding p – value is 0.3607 > 0.5, indicating that there is a sufficient evidence to reject the claim
Conclusion:
Here, we fail to support the claim that there is a significant difference in the average marks on standardised exams change significantly between Years 7 and 11
Part b Output:
Part b Report
Introduction:
The main objective of this section is to determine wehthe the average marks on standardised exams forstudents at Government schools different to the average marks for students at Independent schools. The average marks scores by the students in government schools is 60.83673 and 58.35 in independent schools.
Methods:
In order to test the claim, we perform independent sample t test. Here, the independnet variable is the government school and independent school and the dependent variable is the standardized scores. Since two groups are independent, we can perform independent sample t test
Results:
The value of t test statistic is 0.9744 and its corresponding p – value is 0.3323 > 0.5, indicating that there is a sufficient evidence to reject the claim
Conclusion:
Here, we fail to support the claim that there is a significant difference in the average marks on standardised exams for students at Government schools different to the average marks for students at Independent schools
Part c Output:
Part c Report
Introduction:
The main objective of this section is to determine wehthe average marks on standardised exams for for students at boys only schools different to the average marks for students at girls only schools at year 7. The average marks scores by the students in boys schools is 54.87813 and 59.67 in girls schools.
Methods:
In order to test the claim, we perform independent sample t test. Here, the independent variable is the boys only school and girls only school and the dependent variable is the standardized scores. Since two groups are independent, we can perform independent sample t test
Results:
The value of t test statistic is -2.022 and its corresponding p – value is 0.0457 < 0.5, indicating that there is a sufficient evidence to support the claim
Conclusion:
Here, we support the claim that there is a significant difference in the average marks on standardised exams for for students at boys only schools different to the average marks for students at girls only schools at year 7
1,212,718Orders
4.9/5Rating
5,063Experts
Turnitin Report
$10.00Proofreading and Editing
$9.00Per PageConsultation with Expert
$35.00Per HourLive Session 1-on-1
$40.00Per 30 min.Quality Check
$25.00Total
FreeGet
500 Words Free
on your assignment today
Get
500 Words Free
on your assignment today
Request Callback
Doing your Assignment with our resources is simple, take Expert assistance to ensure HD Grades. Here you Go....
Lock in your expert now.
Pay the rest only after you're 100% satisfied.
Why this is a no-brainer: