Business & Management Statistics

Business & Management Statistics

Task 1: [35 Marks] The file “Resit_Survey_Data.xls” contains the data of an anonymous survey. Click on the red triangles, within the spreadsheet, to see details of each variable. The purpose of this report is to: • Describe the sample • Investigate whether factors such as gender, type of student and age influence the distance travelled to get to university during term time. The report should contain quantitative information, summary statistics and appropriate charts and tables. The marking scheme is as follows: • Report Structure and Presentation o Introduction and summary o Structure, layout, use of spell checker, charts and tables in text o Conclusion • Analysis o Description of the data. [5 marks] [5 marks] [5 marks] [10 marks] o Investigation of factors affecting the amount the distance travelled to get to university during term. Assignment Brief Page 2 of 6 [10 marks] This document is for Coventry University students for their own use in completing their assessed work for this module and should not be passed to third parties or posted on any website. Any infringements of this rule should be reported to acreg.fbl@coventry.ac.uk [Continued on next page] Task 2 [35 Marks] A company wishes to understand how sales are influenced by the price of its product. To do this, the company randomly chooses 13 UK cities and offers the product at different prices. The result are shown in the table below: City Price London 3.40 Birmingham 4.92 Manchester 5.12 Derby 4.36 Edinburgh 6.32 Glasgow 9.33 Cardiff 8.93 Belfast 11.78 Portsmouth 7.90 Bristol 10.89 Leicester 7.35 Brighton 8.32 Newcastle 5.17 (£) Sales 104 96 106 92 73 55 83 43 87 54 88 68 78 1. Conduct linear regression analysis. • Perform, using Excel, Data Analysis Pack, Regression function, the regression analysis. 2. Produce the scatterplot including a fitted regression line. 3. Write the regression equation using the results of the excel table. 4. Determine & interpret the slope. 5. Determine & interpret the intercept. 6. Determine and interpret the R-Squared value? [5 marks] [5 marks] [4 marks] [3 marks] [3 marks] [5 marks] [3 marks] [3 marks] 7. Give predictions for volume of sales when the price of the product is set to: a. £4.60 b. £8.30 8. Explain why the predicted sales volume in question 7. above is just an estimate Assignment Brief Page 3 of 6 [4 marks] This document is for Coventry University students for their own use in completing their assessed work for this module and should not be passed to third parties or posted on any website. Any infringements of this rule should be reported to acreg.fbl@coventry.ac.uk [Continued on next page] Task 3 (30 Marks) A company wants to determine the relationship between the company’s advertising expenditure and its sales revenue. If the relationship is a strong one, then the company will be able to forecast the sales revenue for a given advertising expenditure. The following data has been collected over the last nine years. Use the table to answer the questions: Advertising (£000’s) Sales (£000’s) 11.76 54.864 21.51 83.191 17.64 87.041 16.89 84.202 14.26 78.404 12.32 58.645 25.29 98.663 20.63 92.642 23.99 103.204