BUSINESS STATISTICS COURSEWORK ASSIGNMENT
WORTH 25% OF THE MODULE’S MARKS
RELEASED ON 8 MAY 2012
HAND-IN DEADLINE : WEEK OF 22 MAY
DATE AND TIME TO BE ANNOUNCED.
| INSTRUCTIONS
Refer to the Scheme of Work (on Blackboard) for details of how the Learning Outcomes for the module are assessed in this assignment.
This assignment and graph paper are available on Blackboard. |
| ACADEMIC IMPROPRIETY
This is an individual piece of work. You are liable to be awarded a zero mark (and fail the entire stage of your programme) if any part of your assignment is plagiarised. You should understand that all alleged plagiarism is pursued vigorously.
Read the current student handbook, on the I drive, concerning Academic Impropriety especially plagiarism, collusion and cheating!!
Take note of the policy on Late Submission of assessed coursework and Personal Mitigating Circumstances (PMCs).
If you refer to the ideas of other writers you must always acknowledge your source, including those from the Internet. The Harvard referencing style is to be used.
HAND-IN |
| The assignment must be printed single-sided, not double-sided. It must include spreadsheet outputs where requested. It must have page numbers.
Complete an assignment front sheet to indicate your name, enrolment number and lecturer (John Flynn). Attach it to the front of this assignment before submission. |
|
| Context | |
You have recently joined International Distinctive Hotels Ltd (IDH) as an assistant to the Marketing Manager of a chain of hotel restaurants. Your predecessor left the company in a re-organisation and you have inherited some data collected on 30 restaurants in a recent survey of overseas franchises.
The 14 variables are detailed below; the units of some of these variables are in thousands of pounds, while others are in percentages. Be careful!
It is recommended that you work through the Excel Recipe cards in Buglear’s book to prepare the work.
You should show any formulae used and any ‘methodology’ i.e. working out. You may use any calculator or computer. If you merely supply an answer, which is incorrect, without the method then you will be penalised.
When using Excel, you may need to check that it has got Tools/Data Analysis. If not, click on Tools/Add-Ins and then select Analysis ToolPak which will bring in the statistical analysis functions. Use the Homework file on Blackboard to help you.
Section A
Investigate the Gross Sales variable (‘SALES’) of the restaurants :
(i) Calculate the mean, median, range and standard deviation of the actual data.
(ii) Construct an appropriate frequency distribution and cumulative frequency diagram.
You can do this part by hand using graph paper which is available on Blackboard.
(iii) Estimate the median and Inter-Quartile Range from your diagrams.
(iv) Write a brief report (half page of A4 maximum) which analyses the gross sales of the restaurants by comparing the results of the actual data in part (i) and from the distribution in part (ii).
Section B
The profit made by a restaurant can be determined by subtracting the costs of Advertising, Goods sold and Wages from the Gross sales.
(i) Demonstrate the calculation of estimated profit for one of the restaurants.
Describe how the calculation processes in part (i) could be automated using Excel to produce a column showing PROFIT information for each restaurant.
(ii) Provide a spreadsheet printout showing the results.
State the most profitable and the least profitable of the restaurants.
Section C
Cross-tabulate the Sizes of the restaurant by the Type of Food. This may be best by hand!
Produce a table of the results and a barchart. Explain the findings.
Section D
Produce an analysis of the correlations between the 3 variables : Outlook, Number of seats and Sales.
Use the spreadsheet to draw a scatter graph of the relationship between Sales and Seats. The scatter graph must show the linear trend line, the equation of the line and the value of R-squared. Explain the findings in a brief report which analyses these results.
HINTS
- Spaces in the dataset represent missing data e.g. Restaurant 3. Do not assume that this missing data has a value of zero.
- Refer any difficulties to your tutor in the class.
- A report style is preferred to a “narrative” approach. The length of report should be about 8-10 sides of A4. Do not use appendices.
- Spreadsheet printouts should be incorporated using ‘Cut and Paste’.
- It is essential to word-process this assignment.
- Refer any difficulties to your tutor. If you have problems getting access to Excel, inform your tutor.
- DO NOT LEAVE THIS ASSIGNMENT UNTIL THE LAST MINUTE. YOU MAY FIND THAT IT TAKES LONGER THAN YOU THINK! START NOW!!!
Indicative breakdown of marks
Section A
(i) Statistics of data 5%
(ii) Frequency distribution, ogive 10%
(iii) Median & IQR from ogive 5%
(iii) Comments in the form of a report 10% 30%
Section B
(i) Profit calculation 5%
Description of calculation processes 5%
(ii) Excel printout and results 10% 20%
Section C
Cross-tabulation 5%
Table and Barchart 10% 15%
Section D
Correlations 5%
Scatter graph 5%
Line, equation and R-squared 10% 20%
Report style/general presentation and quality of communication 15%
- This includes page numbers, diagrams, histograms, tables etc. which must be correctly coded in academic format e.g. “Table 3”, “Figure 5” and be cross-referenced in the main part of the report.
- The use of a brief Introduction and Conclusion are encouraged.
- Page Numbers and Sub-headings within each section are essential.
- You will be penalised if you have made little attempt to check spelling, punctuation and grammar. There is no excuse for incorrect spelling when you have a word-processor.
Total 100%
DATASET
|
ID |
OUT LOOK |
SALES |
COST GOOD |
WAGES |
ADS |
TYPE FOOD |
SEATS |
OWNER |
FT. EMPL |
PT. EMPL |
SIZE |
|
1 |
3 |
1410 |
85 |
10 |
5 |
1 |
34 |
2 |
0 |
4 |
1 |
|
2 |
5 |
800 |
50 |
25 |
5 |
3 |
120 |
2 |
35 |
13 |
3 |
|
3 |
3 |
207 |
48 |
20 |
1 |
1 |
0 |
||||
|
4 |
5 |
1016 |
40 |
36 |
1 |
3 |
200 |
3 |
20 |
40 |
3 |
|
5 |
3 |
60 |
50 |
30 |
20 |
3 |
80 |
3 |
2 |
4 |
1 |
|
6 |
3 |
309 |
52 |
18 |
2 |
2 |
80 |
1 |
6 |
14 |
2 |
|
7 |
2 |
960 |
54 |
22 |
2 |
3 |
0 |
3 |
7 |
40 |
3 |
|
8 |
3 |
150 |
70 |
20 |
10 |
2 |
220 |
3 |
3 |
18 |
2 |
|
9 |
4 |
56 |
40 |
20 |
10 |
2 |
44 |
1 |
0 |
2 |
1 |
|
10 |
6 |
250 |
33 |
30 |
2 |
1 |
55 |
3 |
10 |
15 |
2 |
|
11 |
4 |
275 |
50 |
25 |
5 |
2 |
85 |
3 |
10 |
3 |
2 |
|
12 |
5 |
150 |
30 |
30 |
0 |
1 |
77 |
3 |
4 |
13 |
2 |
|
13 |
4 |
325 |
45 |
25 |
5 |
3 |
125 |
3 |
20 |
6 |
3 |
|
14 |
5 |
110 |
50 |
30 |
20 |
2 |
65 |
2 |
2 |
10 |
1 |
|
15 |
3 |
250 |
50 |
30 |
4 |
2 |
90 |
3 |
4 |
12 |
2 |
|
16 |
3 |
550 |
48 |
22 |
2 |
2 |
100 |
3 |
13 |
6 |
2 |
|
17 |
1 |
100 |
35 |
25 |
0 |
1 |
50 |
3 |
0 |
6 |
1 |
|
18 |
3 |
32 |
35 |
10 |
2 |
1 |
30 |
1 |
3 |
0 |
1 |
|
19 |
7 |
366 |
42 |
25 |
1 |
2 |
150 |
3 |
12 |
40 |
3 |
|
20 |
5 |
70 |
50 |
7 |
2 |
2 |
50 |
3 |
3 |
2 |
1 |
|
21 |
3 |
531 |
46 |
30 |
1 |
3 |
72 |
3 |
1 |
39 |
3 |
|
22 |
4 |
225 |
50 |
40 |
0 |
1 |
43 |
1 |
10 |
4 |
2 |
|
23 |
3 |
108 |
2 |
0 |
8 |
1 |
|||||
|
24 |
3 |
100 |
86 |
14 |
0 |
3 |
0 |
1 |
3 |
2 |
1 |
|
25 |
4 |
50 |
30 |
1 |
1 |
3 |
20 |
1 |
2 |
Restaurant dataset
The data has the following characteristics :
ColumnName Description
1 ID Identification number of restaurant
*2 OUTLOOK Values 1,2,3,4,5,6,7 denoting “very unfavourable” to “very
favourable”.
3 SALES Gross sales in £1,000s
4 COSTGOOD Cost of goods sold as a percentage of sales.
5 WAGES Cost of wages as a percentage of sales.
6 ADS Advertising as a percentage of sales.
*7 TYPEFOOD 1 = fast food, 2 = supper club, 3 = other.
8 SEATS Number of seats in dining area.
*9 OWNER 1 = sole proprietor, 2 = partnership, 3 = corporation
10 FT.EMPLE Number of full‑time employees.
11 PT.EMPL Number of part‑time employees.
*12 SIZE Size of restaurant:
1 = Small 2 = Medium 3 = Large
Notice the difference between those variables which relate to measurements in Pounds or percentages, and the * variables which are measured (or categorised) on a ‘nominal’ scale or an ‘ordinal’ scale. The categories are then expressed as 1, 2, 3, etc. They can be used as a basis of classification to create TABLES.
LD04
But you can order it from our service and receive complete high-quality custom paper. Our service offers Statistics essay sample that was written by professional writer. If you like one, you have an opportunity to buy a similar paper. Any of the academic papers will be written from scratch, according to all customers’ specifications, expectations and highest standards.”
