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).

Group AssignmentQuestion 2                                                                                                                                                            8 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).

  1. Compute the coefficient of determination and fully interpret its meaning. Be very specific.

(2 marks)

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).

  1. 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).

  1. Determine if competitor’s price and advertising is individually significantly related to

sales. Use α = 0.10.(2 marks)