MEAN AND MEDIAN

 

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

“The presented piece of writing is a good example how the academic paper should be written. However, the text can’t be used as a part of your own and submitted to your professor – it will be considered as plagiarism.

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

Please  Click on the  below links to Chat Now  or fill the Order Form !
order-now-new                          chat-new (1)