ECON7300: Statistical Project Assignment (Part I), Semester 1, 2023
Instruction:
(A) Questions in this paper should be answered by students whose surnames fall within the range
(B) Use the Excel files ¡®Dataset9 and Dataset10¡¯ to answer questions asked in Part A and
¡®Dataset11¡¯and ¡®Dataset12¡¯ to answer questions asked in Part B.
(C) A heavy penalty will be applied if your answers are not based on datasets assigned to you.
Code Help
ECON7300: Statistical Project Assignment (Part I), Semester 1, 2023
Part A: Note: for questions in Part A assume that the three assumptions underlying ANOVA (i.e., randomness and independence, normality, and homogeneity of variance) are met. Use the closest degrees of freedom for the denominator to get critical value from F-table.
(1) Using Dataset9 test at a 5% level of significance if there is any evidence of a significant difference in the average birth weight (bweight) in grams for children in three groups defined by the mother¡¯s educational background (medu). Follow all the necessary steps to perform the test and verify your results using Excel/PHStat. Note: in your data, the variable ¡°medu¡± is coded 1 for mothers who completed primary education, 2 for mothers who completed secondary education and 3 for mothers who completed tertiary education.
(2) If your results in (1) indicate that it is appropriate, use the Tukey-Kramer procedure to determine which groups of medu differ in average birth weight (bweight). Use a 5% level of significance. Follow all the necessary steps to perform the test and verify your results using Excel/PHStat.
(3) Using Dataset10 test at a 5% level of significance if there is any evidence of a significant difference in the average weekly wages (wgs) for employees in four groups defined by their occupation (occ). Follow all the necessary steps to perform the test and verify your results using Excel/PHStat. Note: in your data, the variable ¡°occ¡± is coded 1 for professionals, 2 for labourers, 3 for managers, and 4 for machinery operators.
(4) If your results in (3) indicate that it is appropriate, use the Tukey-Kramer procedure to determine which groups of occ differ in average weekly wages (wgs). Use a 5% level of significance. Follow all the necessary steps to perform the test and verify your results using Excel/PHStat.
Programming Help, Add QQ: 749389476
ECON7300: Statistical Project Assignment (Part I), Semester 1, 2023
(a) (b) (c)
Note: for questions in Part B assume that the three assumptions underlying ANOVA (i.e., randomness and independence, normality, and homogeneity of variance) are met. Use the closest degrees of freedom for the denominator to get critical value from F-table.
A company producing sports-themed beverage and food products has developed four new drink flavours and would like to conduct a taste test to collect data on customers¡¯ preferences. Five people were asked to rate each flavour on a scale 1-50. The data are saved in ¡®Dataset11¡¯. Hint: the variable person is the blocking variable. Drink flavour is coded 1 if fruit punch, 2 if cool blue, 3 if fierce grape, and 4 if lemon-lime.
Based on the information given, answer the following questions.
At the 5% level of significance, was blocking effective? Follow all the necessary steps and verify your results using Excel/PHStat.
Using a 5% level of significance, is there a significance difference in the mean rating (rating) of the four flavours? Follow all the necessary steps to perform the test.
If your results in (b) indicate that it is appropriate, use the Tukey procedure to determine which groups of flavour differ in the mean rating. Use a 5% level of significance. Follow all the necessary procedure to perform the test.
Inspire Training and Education Department (ITED) conducts project management training courses throughout Brisbane. The department has developed three 150-point practice examinations meant to simulate the certification exams given by the Project Management Institute (PMI). ITED wants to know if the three exams will yield the same or different mean scores. To test this a random sample of 9 people who have been through the project management training are asked to take the three tests. The order the tests are taken is randomised and the scores are recorded and saved in ¡®Dataset12¡¯. Hint: the variable student is the blocking variable.
Based on the information given, answer the following questions.
(a) At the 5% level of significance, was blocking effective? Follow all the necessary steps and verify your results using Excel/PHStat.
(b) Using a 5% level of significance, is there a significance difference in the mean exam score of the three exam types? Follow all the necessary steps to perform the test.
(c) If your results in (b) indicate that it is appropriate, use the Tukey procedure to determine which groups differ in the mean exam score. Use a 5% level of significance. Follow all the necessary procedure to perform the test.
Computer Science Tutoring