HI6007 T12018 Group Assignment Page 1
HOLMES INSTITUTE
FACULTY OF HIGHER EDUCATION
HI6007 Group Assignment
Due End of Week 10
WORTH 30%
(Maximum 5 students in the group)
MS Excel must be used to perform any calculations/graphical presentations as
equired in this assignment
Question XXXXXXXXXXmarks
Below you are given the examination scores of 20 students (data set also provided in
accompanying MS Excel file).
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
a. Construct a frequency distribution, cumulative frequency distribution, relative
frequency distribution, cumulative relative frequency distribution and percent
frequency distribution for the data set using a class width of 1 XXXXXXXXXX5 marks)
. Construct a histogram showing the percent frequency distribution of the examination
scores. Comment on the shape of the distribution. XXXXXXXXXX2 marks)
Question 2 XXXXXXXXXX8 marks
Shown below is a portion of a computer output for a regression analysis relating supply (Y in
thousands of units) and unit price (X in thousands of dollars).
ANOVA
df SS
Regression XXXXXXXXXX
Residual XXXXXXXXXX
Coefficients Standard E
or
Intercept XXXXXXXXXX
X XXXXXXXXXX
a.
What has been the sample size for this problem? XXXXXXXXXX1 mark)
. Determine whether or not demand and unit price are related. Use α = XXXXXXXXXXmarks) Determine whether or not demand and unit price are related. Use α = 0.05.
c.
Compute the coefficient of determination and fully interpret its meaning. Be very specific.
XXXXXXXXXX2 marks)
d.
Compute the coefficient of co
elation and explain the relationship between supply and
unit price. XXXXXXXXXX2 marks)
e. Predict the supply (in units) when the unit price is $50,000. XXXXXXXXXX1 mark)
HI6007 T12018 Group Assignment Page 2
Question 3 XXXXXXXXXX6 marks
Allied Corporation wants to increase the productivity of its line workers. Four different
programs have been suggested to help increase productivity. Twenty employees, making up
a sample, have been randomly assigned to one of the four programs and their output for a
day's work has been recorded. You are given the results below (data set also provided in
accompanying MS Excel file).
Program A Program B Program C Program D
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
a. Construct an ANOVA table. XXXXXXXXXX3 marks)
.
As the statistical consultant to Allied, what would you advise them? Use a .05 level of
significance. XXXXXXXXXX3 marks)
Question XXXXXXXXXXmarks
A company has recorded data on the weekly sales for its product (y), the unit price of the
competitor's product (x1), and advertising expenditures (x2). The data resulting from a
andom sample of 7 weeks follows. Use Excel's Regression Tool to answer the following
questions (data set also provided in accompanying MS Excel file).
Week Price Advertising Sales
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
a.
What is the estimated regression equation? Show the regression output XXXXXXXXXXmarks)
. Determine whether the model is significant overall. Use α = 0.1 XXXXXXXXXX2 marks)
c.
Determine if competitor’s price and advertising is individually significantly related to
sales. Use α = 0.10. XXXXXXXXXX2 marks)
d.
e.
Based on your answer to part (c), drop any insignificant independent variable(s) and
e-estimate the model. What is the new estimated regression equation? XXXXXXXXXXmarks)
Interpret the slope coefficient(s) of the model from part (d). XXXXXXXXXX1 marks)