Solved by: AllAcademicHelp.com
Previous answers to this question 27: 16 7 3 0 1
HI6007 T22018 Group Assignment Page 1HI6007 Group AssignmentDue End of Week 10WORTH 30%(Maximum 5 students in the group)MS Excel must be used to perform any calculations/graphical presentations asrequired in this assignmentQuestion 1 7 marksBelow you are given the examination scores of 20 students (data set also provided inaccompanying MS Excel file).52 99 92 86 8463 72 76 95 8892 58 65 79 8090 75 74 56 99a. Construct a frequency distribution, cumulative frequency distribution, relativefrequency distribution, cumulative relative frequency distribution and percentfrequency distribution for the data set using a class width of 10. (5 marks)
b. Construct a histogram showing the percent frequency distribution of the examinationscores. Comment on the shape of the distribution. (2 marks)
Question 2 8 marksShown below is a portion of a computer output for a regression analysis relating supply (Y inthousands of units) and unit price (X in thousands of dollars).ANOVAdf SSRegression 1 354.689Residual 39 7035.262Coefficients Standard ErrorIntercept 54.076 2.358X 0.029 0.021a. What has been the sample size for this problem? (1 mark)b. Determine whether or not supply and unit price are related. Use α = 0.05. (2 marks) 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.(2 marks)d.Compute the coefficient of correlation and explain the relationship between supply andunit price. (2 marks)e. Predict the supply (in units) when the unit price is $50,000. (1 mark)HI6007 T22018 Group Assignment Page 2
Question 3 6 marksAllied Corporation wants to increase the productivity of its line workers. Four differentprograms have been suggested to help increase productivity. Twenty employees, making upa sample, have been randomly assigned to one of the four programs and their output for aday’s work has been recorded. You are given the results below (data set also provided inaccompanying MS Excel file).Program A Program B Program C Program D150 150 185 175130 120 220 150120 135 190 120180 160 180 130145 110 175 175a. Construct an ANOVA table. (3 marks)b. As the statistical consultant to Allied, what would you advise them? Use a .05 level ofsignificance. (3 marks)Question 4 9 marksA company has recorded data on the weekly sales for its product (y), the unit price of thecompetitor’s product (x1), and advertising expenditures (x2). The data resulting from arandom sample of 7 weeks follows. Use Excel’s Regression Tool to answer the followingquestions (data set also provided in accompanying MS Excel file).Week Price Advertising Sales1 .33 5 202 .25 2 143 .44 7 224 .40 9 215 .35 4 166 .39 8 197 .29 9 15a. What is the estimated regression equation? Show the regression output. (2 marks)b. Determine whether the model is significant overall. Use α = 0.10. (2 marks)c. Determine if competitor’s price and advertising is individually significantly related tosales. Use α = 0.10. (2 marks)d.e.Based on your answer to part (c), drop any insignificant independent variable(s) andre-estimate the model. What is the new estimated regression equation? (2 marks)Interpret the slope coefficient(s) of the model from part (d). (1 marks)HI6007 T22018 Group Assignment Page 3
The post HI6007 T22018 Group Assignment, MS Excel must be used to perform any calculations/graphical presentations as required in this assignment appeared first on .
Do you need any assistance with this question?Send us your paper details nowWe’ll find the best professional writer for you!
READY TO PLACE AN ORDER