HI6007 Group Assignment
MS Excel must be used to perform any calculations/graphical presentations as required in this assignment
Question 1 7 marks
Below you are given the examination scores of 20 students (data set also provided in accompanying MS Excel file).
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).
Compute the coefficient of determination and fully interpret its meaning. Be very specific.
Question 3 6 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).
- As the statistical consultant to Allied, what would you advise them? Use a .05 level of
significance. (3 marks)
Question 4 9 marks
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 random sample of 7 weeks follows. Use Excel’s Regression Tool to answer the following questions (data set also provided in accompanying MS Excel file).
Determine if competitor’s price and advertising is individually significantly related to
sales. Use α = 0.10.(2 marks)