Group Work

To hit the "20 marks" mark, your report needs to move beyond just listing numbers. You should aim for a professional, analytical tone that tells a story about the data.

Here is a recommended structure that balances statistical rigor with business insight.

1. Executive Summary (The "So What?")

Start with a brief paragraph summarizing the overall health of the restaurant sample.

• Key Insight: Are most restaurants performing well, or is there a wide gap between the "stars" and the "strugglers"?

• Purpose: State that this overview evaluates operational efficiency and adherence to standards.

2. Sales and Profitability: Financial Performance

This section requires a mix of central tendency and dispersion.

• Statistics to Use: Mean and Median sales, Standard Deviation (to show if performance is consistent across locations), and Range.

• Visuals: A Histogram for sales distribution and a Scatter Plot showing the relationship between Sales and Profit.

• Analysis: * Shape: Is the distribution "Right-Skewed" (a few high-earning flagship stores pulling up the average)?

  • Center: Does the Median significantly differ from the Mean? If so, the "average" restaurant might not be as profitable as it looks.

  • Spread: High variability suggests inconsistent customer demand or management quality.

3. Ownership Structure: Operational Models

How are these restaurants owned (e.g., Franchised vs. Corporate)?

• Statistics to Use: Frequency counts and percentages.

• Visuals: A Pie Chart or Stacked Bar Chart.

• Analysis: * Compare the profitability of different ownership types. Does one model consistently outperform the other?

  • Explain why this matters: "Franchised outlets show higher variability in compliance, suggesting a need for tighter oversight."

4. Hygiene Ratings: Safety & Reputation

Hygiene is a categorical variable (often 1–5), so treat it differently.

• Statistics to Use: Mode (the most common rating) and Median.

• Visuals: A Bar Chart showing the frequency of each rating.

• Analysis:

  • Key Features: Identify the percentage of restaurants falling below the "acceptable" threshold (e.g., ratings of 3 or lower).

  • Business Impact: Relate these ratings back to sales. Do cleaner restaurants make more money? (Hint: Usually, yes).

HYGIENE: Official Food Standards Agency hygiene rating

1 = Very Good (rating of 5)

2 = Good (rating of 4)

3 = Rating of 3 or less

Results

• The Mean is 1.208: "Very Good" is the most frequent rating. The largest single group of restaurants in your sample is hitting the highest possible safety standard.

• The Median is 1: When you line up all 50 restaurants from best to worst, the one in the middle (the 25th/26th restaurant) is still a "1."

• The Conclusion: This means that at least 50% (and likely more) of your restaurants have achieved the highest hygiene rating.

• The "Bulk": Most of your data is "piled up" at the low end of the scale (Rating 1).

• The "Skew": The few restaurants that performed poorly (Rating 3) are pulling the Mean away from the Median.

• The Math: Your Median is 1, but because you have some 2s and 3s, your Mean will be something higher (like 1.4). When the Mean is greater than the Median, the distribution is Right-Skewed (also called Positively Skewed).

  nothh
  HYGIENE	Count of HYGIENE
  1	408
  2	80
  3	12
  Grand Total	500

5. Compliance with Guidelines: Brand Consistency

This measures how well the restaurants follow the "Company Playbook."

• Statistics to Use: Mean compliance score and an Interquartile Range (IQR) to identify outliers.

• Visuals: A Box Plot is perfect here to show the "typical" range and highlight any extreme underperformers (outliers).

• Analysis:

  • Spread: A tight box plot shows the brand is consistent. A wide one suggests a "wild west" scenario where some managers are ignoring the rules.

MYSTERY: Internal compliance rating from “mystery shopper” visits

1 = Fully compliant with the company's guidelines

2 = Generally compliant with the company's guidelines

3 = Not compliant with the company's guidelines

Note: “mystery shoppers” are hired by the company to verify whether restaurants comply with the company’s guidelines. Restaurants may hurt the brand's reputation by not following its guidelines.

Results

Mean: 1.734

2 - 1 = 1 (IQR)

Medium: 2

You have a "moderate" spread. It means that even your "typical" restaurants aren't all hitting the same mark. There is a noticeable gap between your "Top 25%" (the Q3) and your "Bottom 25%" (the Q1).

"With a Median of 2 and an IQR of 1, the 'Company Playbook' is being applied inconsistently. The middle 50% of the sample spans two full categories of compliance. This lack of a tight 'Center' suggests that management needs to focus on standardizing operations to move the IQR closer to 0 at the 'Fully Compliant' level."

If your Median is 2, and the Mean is 1.734:

• This shows a "Left Skew."

• Analysis: The "typical" restaurant is only "Generally Compliant" (2), but a few high-performing stars (1s) are helping the average look slightly better.

• Writing Tip: "The average compliance score of 1.734 is slightly better than the Median (2), suggesting a few high-performing units are offsetting a generally mediocre standard across the sample."

Because 1 is the best possible score, a Mean of 1.734 tells us the average restaurant is not fully compliant

• The Insight: The restaurants are better at Hygiene (Median 1) than they are at Company Guidelines (Mean 1.734).

• The Analysis: "Interestingly, while hygiene standards are consistently 'Very Good' (Median: 1), internal compliance shows more variability (Mean: 1.734). This suggests that while managers prioritize legal food safety requirements, they are slightly less rigorous with internal brand guidelines."

Recommended Formatting Tips

• Headings: Use clear headings for each of the four pillars mentioned above.

• The "Rule of Three": For every graph you include, ensure you describe its Shape (symmetry), Center (average), and Spread (consistency).

• Data Callouts: Use Bold Text for specific figures (e.g., "The average profit margin was 12.4%...").

Would you like me to help you draft the specific wording for one of these sections, or perhaps explain how to interpret a specific statistical measure (like Standard Deviation) in a business context?