LO1. Appreciate the Role of Quantitative Methods for Business Analysis, Planning and Performance Measurement

MN4083: Understanding and Managing Data

Coursework One (Autumn 2026/27) – Worth 100% of the Module Mark

Deadline: Friday, 18 December 2026, before 3 p.m. GMT

NB: Coursework 1 consists of two parts. All tasks in both parts need to be attempted.

Part 1

Task 1: Sample Data [15 marks]

A travel comparison website collected data on the nightly rates (£) of 62 hotel rooms across three popular UK tourist destinations. The data have been made available in the Excel file named “MN4083 Coursework Data” under the tab labelled Task 1.

Required for Task 1 (Covered in week 3. Comments for Task 1 should not exceed 50 words)

  1. Using the ungrouped data for Task 1, calculate the sample mean and sample standard deviation to summarise the room-rate data. Values should be rounded to 2 decimal places. Present your statistics in a table. Copy the table into your Word document. The Excel formulae used should also be shown.
  2. Prepare a short interpretation (max. 50 words) of the sample statistics found under (1) above. Write your comments in the context of the data and include the unit of measurement (£).

Task 2: Networking [25 marks]

A hotel management company is preparing a newly refurbished hotel for its grand opening. The project consists of eight activities, each with a specific duration stated in days. For example, the installation of guest room furnishings can only begin after the room refurbishment has been completed. Information on the eight activities is outlined in the precedence table (Table 1) below.

Table 1 – Precedence Table

Activity

Preceding Activity

Duration (Days)

A

-

3

B

A

4

C

A

6

D

B

4

E

B, C

1

F

C

1

G

D, E, F

2

H

F, G

2

Construct the network diagram using the standard node layout introduced in the lecture (each node shows Activity, EST and EFT on the top row and Duration, LST and LFT on the bottom row). NB: Do not use methods other than those used in the lectures for this module.

Activity

EST

EFT

Duration

LST

LFT

Figure 1 – Network Diagram (complete the template in the Excel file, Task 2 tab, and copy into your work)

Required for Task 2 (Covered in week 8. Comments for Task 2 should not exceed 50 words)

  1. With reference to Table 1 and using the template, complete the network diagram by going through the forward and backward passes. The template has been made available in the Excel file named “MN4083 Reassessment Data” under the tab labelled Task 2. NB: An image of a hand-drawn network diagram will not receive marks. Copy the network diagram into your Word file.
  2. With reference to the network diagram created under (1) above, identify the critical path and state the duration of the project.
  3. The hotel is scheduled to open to guests on Monday, 30 November 2026 and all preparations must be completed by 5pm on Friday, 27 November 2026. Work cannot commence until 8am on Monday, 9 November 2026. Saturday and Sunday are non-working days. In addition, the project team cannot work on Thursday, 13 November 2026 due to a mandatory staff training event. If the activities start on time at 8am on Monday, 9 November, can the hotel be fully prepared for opening by 5pm on Friday, 27 November? State the completion calendar date and whether the project can be completed on time.

Task 3: Probability [10 marks]

A hotel chain conducted a customer survey and found that 40% of all guests were travelling for business purposes. Of the leisure guests, 60% were first-time visitors to the hotel. In total, 70% of business guests had previously stayed at the hotel.

A contingency table template has been made available in the Excel file named “MN4083 Reassessment Data” under the tab labelled Task 3. NB: An image of a hand-drawn contingency table will not receive marks. Copy the completed contingency table into your Word file.

Required for Task 3 (Covered in week 9)

  1. Construct a contingency table by using the information above. All values in the contingency table should be shown as proportions and not percentages. (Figure 2 – Contingency Table: use the template in the Excel file, Task 3 tab, and copy into your work.)
  2. Based on the contingency table prepared under (1) above, what is the probability that a randomly selected guest is travelling for leisure purposes and is a returning guest? Ensure you state the probability problem fully in your response, using only the notation adopted on MN4083. Express your final answer as a proportion (to 3 decimal places).

Task 4: Relationships [10 marks]

The equation below predicts a guest’s Overall Satisfaction Score based on the Service Quality Score.

Regression equation

Overall Satisfaction Score = 12 + 0.8 Service Quality Score

Coefficient of Determination

84%

Minimum Service Quality Score

05

Maximum Service Quality Score

22

Minimum Overall Satisfaction Score

06

Maximum Overall Satisfaction Score

30

Required for Task 4 (Covered in week 5. Comments for Task 4 should not exceed 100 words)

  1. Interpret the above regression equation in context (interpret the intercept and gradient).
  2. Given that x = Service Quality Score and y = Overall Satisfaction Score, interpret the coefficient of determination stated above in context.
  3. Predict the Overall Satisfaction Score when the Review Score is 23.
  4. State whether your prediction is based on interpolation or extrapolation and state the evidence on which you have based your choice.

Task 5: Frequencies [15 marks]

A hotel chain surveyed guests staying at three types of properties: Luxury Hotels, Mid-Range Hotels, and Budget Hotels. Guests were asked whether they would not recommend the hotel, would recommend the hotel, or had already shared positive feedback with others. The results are summarised in the crosstab below. The table has been made available in the Excel file named “MN4083 Reassessment Data” under the tab labelled Task 5. Copy the table into your Word file, alongside your commentary.

Hotel Type

Would Not Recommend

Would Recommend

Shared Positive Feedback

Row Total

Luxury

10%

30%

60%

100%

Mid-range

20%

50%

30%

100%

Budget

50%

35%

15%

100%

Required for Task 5 (Covered in week 2. Comments for Task 5 should not exceed 200 words)

  1. Interpret the data in context – With reference to the crosstab, describe the key differences in guest advocacy across the three hotel types. Prepare a minimum of two insightful comments based on the findings from the table. Interpretations should be written in the context of hotel guest experiences.
  2. Comments on implications – What do these differences suggest about guest satisfaction and the likelihood of generating positive word-of-mouth recommendations across the different hotel categories?
  3. Make a recommendation – If you were the Operations Director of the hotel chain and had a limited budget for service improvements, which hotel type would you prioritise for improvement? Justify your recommendation using evidence from the table to support your explanation.

Task 6: Relationships [15 marks]

A hotel group is investigating factors that influence guest demand and competitive behaviour across its properties. The team collected two sets of data.

  1. Online Reviews and Occupancy Rates: The team monitored the average number of positive online reviews received each week and the corresponding weekly room occupancy rates across its hotels. The analysis produced a correlation coefficient of r = 0.98.
  2. Occupancy Rates and Competitor Discounts: The team also measured hotel occupancy rates and the level of discounting offered by competing hotels in the same area (measured as the percentage reduction from standard room rates). The analysis produced a correlation coefficient of r = –0.86.

Required for Task 6 (Covered in week 5. Comments for Task 6 should not exceed 400 words)

  1. Interpret the correlation of r = 0.98 between positive online reviews and occupancy rates. What does this result suggest about the relationship, and what business implications might it have for hotel management?
  2. Interpret the correlation of r = –0.86 between occupancy rates and competitor discounts. What does this result suggest about competitor behaviour, and what strategic considerations should hotel managers keep in mind when responding to competitive pricing pressures?

NOTE: Up to 10 marks are awarded for coursework management and professional presentation. Each task should start on a fresh page.

Guidelines and Instructions – All Tasks

  1. This individual coursework consists of six tasks. You must attempt and complete all tasks. Company names, where provided, are fictitious. The word limit for this coursework is 800 to 1000 words. For tasks 1, 2, 3 and 5, download the “MN4083 Data” Excel file from WebLearn. Data sets are not provided for tasks 4 and 6. Tasks need to be clearly labelled; each task should start on a fresh page; tables and graphs must be numbered and titled. Calculation methods should not be described: where required, comment on the meaning or significance of the calculated / presented values only.
  2. Task 1: calculate descriptive statistics using Excel and present them in a table. Task 2: complete the network diagram template in Excel to reveal the critical path and duration, and state the completion calendar date (hand-drawn diagrams receive zero marks). Task 3: construct a contingency table using proportions and state the probability problem in full using correct notation. Task 4: interpret the equation and r² in context and make, and comment on, a prediction. Task 5: interpret the cross-tabulation with at least two insightful comments, comment on satisfaction and word-of-mouth, and identify which hotel type should be prioritised. Task 6: interpret two correlation coefficients, their implications and possible business responses. All comments must be written in context with units stated consistently.
  3. Comment on the facts only: avoid speculations and generalisations. Comments should be supported by the evidence (Excel output), where appropriate.
  4. Adopt a formal, professional language (third person, impersonal) throughout; avoid ‘I’, ‘you’, ‘we’, ‘my’, etc.
  5. Required Excel output, i.e. tables and graphs, needs to be copied into your report and presented alongside the comments.
  6. The overall word limit of this coursework is 600 to 800 words and should be adhered to. Word limits for individual tasks are stated next to the requirements of that task. Words contained in tables, graphs and titles do not count towards the word limit.
  7. All work, including calculations, should be attempted on your own and comments and interpretations should be written in your own words.
  8. Academic Misconduct – This is an individual assignment. Collusion, plagiarism, copying, outsourcing or any other form of cheating will lead to a proportionate mark reduction or more severe penalties.
  9. This is an ONLINE WEBLEARN (Turnitin) submission. The deadline is Friday, 18 December 2026 before 3pm GMT (UK time). Late submissions will not be marked.
  10. All output must be saved as a single Word document (or PDF) and uploaded to WebLearn (Turnitin), with a cover page showing your student number.
  11. Originality scores can change (increase) as more pieces of work are submitted.
  12. Do not use Safari to upload your work to WebLearn; use Chrome or Firefox instead.
  13. Complete tasks as soon as the relevant material has been covered and submit work-in-progress via Turnitin whenever you complete an additional task.

What We Look For

  • Clear interpretations of all statistical analyses (comment on what the values imply without speculating);
  • Graphs and tables with figure / table numbers, informative titles, appropriate labelling and units stated;
  • Accurate calculations where required (equations stated in the context of the data);
  • Comments written in the context of the meaning of the data or analysis;
  • Appropriate use of Excel functions, as evidenced by the output.

90% of the available marks are allocated for content and 10% for coursework management and professional presentation.

How Your Coursework Will Be Marked (Indicative Mark Scheme)

Task

Marking points

Marks

Task 1 – Sample Data

Correct sample mean (3) and standard deviation (3); insightful interpretation of mean (2) and standard deviation (2) in context (2); rounding to 2 d.p. (1), £ unit stated (1), formulae provided (1)

15

Task 2 – Networking

Correct network using template, not hand-drawn (9), legend (1); correct forward (3) and backward pass (3); critical path (2) and duration (2); correct date (3) and statement on completion on time (2)

25

Task 3 – Probability

Correct and complete contingency table showing proportions (6); correct probability (2), notation used (1), answer as a proportion (1)

10

Task 4 – Prediction

Gradient (1) and intercept (1) in context; coefficient of determination in context (3); correct prediction with equation (3); interpolation/extrapolation identified (1) with evidence (1)

10

Task 5 – Frequencies

Two insightful interpretations (up to 2×4); implications for word-of-mouth (up to 2); recommendation (up to 3) justified with evidence (up to 2)

15

Task 6 – Relationships

Two correlation coefficients correctly interpreted (2×3) with direction / linear / strength (1); realistic business implications (up to 4) and strategic considerations (up to 4)

15

Coursework Management

Each task on a fresh page (2); comments in context (2); professional presentation (up to 3); evidence presented and cross-referenced, tables/graphs numbered and titled (up to 3)

10

Total

 

100

NOTE: Writing ‘in context’ means discussing findings in relation to the specific scenario. For example, rather than “the mean is 12”, write “On average, a consumer spends £12 on chocolates in a typical week”.

Learning Outcomes

Successful completion of this coursework demonstrates an ability to:

  • LO1. Appreciate the role of quantitative methods for business analysis, planning and performance measurement;
  • LO2. Use Excel facilities to transform data into information to facilitate problem solving and business decision making;
  • LO3. Apply structured quantitative techniques to generate reliable output for business analysis;
  • LO4. Demonstrate an understanding of basic statistics and modelling techniques and be able to interpret and communicate findings.

Sample Answer (Preview)

The following is a partial sample answer showing the approach, structure and referencing expected for this brief. It covers approximately 25–30% of the full coursework (800–1,000 words). Sources are cited in Harvard style.

Task 2: Networking

Table 2 – Forward and backward pass results (days)

Activity

Duration

EST

EFT

LST

LFT

Float

A

3

0

3

0

3

0

B

4

3

7

3

7

0

C

6

3

9

4

10

1

D

4

7

11

7

11

0

E

1

9

10

10

11

1

F

1

9

10

10

11

1

G

2

11

13

11

13

0

H

2

13

15

13

15

0

The critical path is A – B – D – G – H, giving a minimum project duration of 15 working days. Activities C, E and F each carry one day of float, so a delay of more than one day to any of them would extend the hotel opening preparations.

Starting at 8am on Monday 9 November 2026, and excluding weekends and the one-day staff training event in the first week (dated in the brief as Thursday 13 November; 13 November 2026 falls on a Friday, but either date removes one working day), the fifteenth working day ends at 5pm on Monday 30 November 2026. The preparations therefore cannot be completed by the 5pm Friday 27 November deadline; the project would finish one working day late, on the opening day itself.

Task 3: Probability

Figure 2 – Contingency table of guests by purpose of travel and visit status (proportions)

 

First-time (F)

Returning (R)

Total

Business (B)

0.120

0.280

0.400

Leisure (L)

0.360

0.240

0.600

Total

0.480

0.520

1.000

The probability that a randomly selected guest is travelling for leisure and is a returning guest is P(L ∩ R) = 0.240. In other words, around one in four guests is a returning leisure traveller, which indicates a meaningful base of repeat leisure custom that the hotel chain could target with loyalty offers.

[End of preview] The remaining sections are included in the full solution, which is available on order. They cover the Task 1 descriptive statistics table with Excel formulae and interpretation, the regression interpretation and prediction (Task 4), the crosstab interpretation and recommendation (Task 5), and the two correlation interpretations with business implications (Task 6).

References

Curwin, J., Slater, R. and Eadson, D. (2013) Quantitative Methods for Business Decisions. 7th edn. Andover: Cengage Learning.

Field, A. (2024) Discovering Statistics Using IBM SPSS Statistics. 6th edn. London: SAGE.

Morris, C. (2012) Quantitative Approaches in Business Studies. 8th edn. Harlow: Pearson.

Oakshott, L. (2020) Essential Quantitative Methods: For Business, Management and Finance. 7th edn. London: Red Globe Press.

100% Plagiarism Free & Custom Written, Tailored to your instructions