LO1. Apply basic probability and other quantitative techniques in a business context
Faculty of Business and Law Assignment Brief
Text Box: Module Title: Business
Management Statistics
Module Code: 107SAM
Assignment Number and Weighting CW
2 (50%) Resit
Assignment Title Coursework
2
Module learning outcomes being
assessed: |
LO1. Apply basic probability and other quantitative techniques in a business context. |
LO2. Analyse realistic management problems based on analysis of data sets and case materials. |
LO3. Apply the techniques studied to interpret and communicate findings on data analysis. |
This assignment is an individual assignment.
Your coursework consists of the following three tasks with tasks 1 and 2 based on the results of a survey. Some similar tasks will be performed in seminars with the tutors’ guidance. However, some parts of these tasks will require independent study.
As well as submitting the coursework as a word report for all three tasks you MUST also submit an excel spreadsheet containing the analysis which you have used in your word report.
Task 1
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 type of type of accommodation students stay in 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.
o Investigation of factors affecting choice of term time accommodation.
Task 2
A company wishes to understand how sales are influenced by the price of its product. To do this, the company randomly chooses 12 UK cities and offers the product at different prices. The results are shown in the table below:
City |
Price (£) |
Sales |
London |
2.24 |
100 |
Birmingham |
4.63 |
88 |
Manchester |
3.41 |
94 |
Derby |
3.54 |
84 |
Edinburgh |
6.22 |
56 |
Glasgow |
7.12 |
49 |
Cardiff |
4.76 |
76 |
Belfast |
7.52 |
34 |
Portsmouth |
4.21 |
79 |
Bristol |
6.29 |
46 |
Leicester |
4.92 |
80 |
Newcastle |
5.17 |
63 |
- £3.50
- £5.80
Task 3
Advertising (£000`s) |
Sales (£000`s) |
10.85 |
50.234 |
20.55 |
80.997 |
17.18 |
86.363 |
15.99 |
84.016 |
13.58 |
75.381 |
12.28 |
56.342 |
24.76 |
98.123 |
19.72 |
92.489 |
23.63 |
102.249 |
- £14,000
- £17,500
.