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
N-Z.
(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.
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.
ECON7300: Statistical Project Assignment (Part I), Semester 1, 2023
Part B 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.
1. 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.
(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 rating
(rating) of the four flavours? 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 of flavour differ in the mean rating. Use a 5% level of significance. Follow
all the necessary procedure to perform the test.
2. 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.