📚 Year 9 OCR Statistics: Comparing UK University Entry Requirements | 英国大学申请要求对照分析
In Year 9 Statistics, you learn how to collect, represent and analyse data to make sense of the world. One real-world application is comparing the entry requirements for different UK universities. By using statistical tools like averages, measures of spread and probability, you can make more informed decisions about higher education. This article explores how to compare university offers using the statistical methods you study in OCR Year 9 Statistics.
在九年级统计课程中，你学习如何收集、展示和分析数据，从而理解世界。一个实际应用是比较不同英国大学的入学要求。通过使用平均数、离散度量和概率等统计工具，你可以对高等教育做出更明智的决定。本文探索如何使用OCR九年级统计学中的方法来比较大学录取要求。
1. Understanding UCAS Tariff and A-Level Grades | 理解 UCAS 分数与 A-Level 等级
UK universities often express their entry requirements in terms of A-Level grades, such as AAA, AAB or ABB. Some courses also refer to the UCAS Tariff, which converts grades and qualifications into a numerical score. For A-Levels, an A* grade is typically worth 56 tariff points, A is 48, B is 40, C is 32, D is 24 and E is 16. Understanding these values is the first step in making statistical comparisons.
英国大学通常用A-Level等级来表达入学要求，例如AAA、AAB或ABB。一些课程还参考UCAS分数体系，它将等级和资格转换为数值分数。就A-Level而言，A*通常值56个分数点，A值48，B值40，C值32，D值24，E值16。理解这些数值是进行统计比较的第一步。
In Year 9, we simplify by assigning a scale from 6 for A* down to 1 for E. This makes it easier to calculate means and ranges later. Although real universities look at specific subjects and conditions, our scaled scores allow us to practise statistical techniques on a small dataset.
在九年级，我们简化处理，为A*赋6分，依次递减至E为1分。这让我们稍后更容易计算平均值和极差。尽管真实的大学会考察具体科目和条件，但我们的分数标度能让我们在一个小数据集上练习统计技术。
2. Collecting Entry Requirement Data | 收集录取要求数据
Imagine you are researching Economics degree courses at 14 UK universities. You record the typical A-Level offer made to applicants. The table below shows the offers and the total UCAS tariff points for three A-Levels. This is your raw data for analysis.
假设你正在研究14所英国大学的经济学学位课程。你记录下向申请者发出的典型A-Level录取要求。下表显示了三门A-Level的录取要求及对应的UCAS总分。这就是你要分析的原始数据。
| University | Typical Offer | UCAS Points (3 A-Levels) |
|---|---|---|
| Oxford | A*AA | 152 |
| Cambridge | A*A*A | 160 |
| Imperial | A*AA | 152 |
| LSE | A*AA | 152 |
| UCL | A*AA | 152 |
| Warwick | AAA | 144 |
| Durham | AAB | 136 |
| Bath | AAB | 136 |
| Manchester | AAB | 136 |
| Nottingham | ABB | 128 |
| Reading | ABB | 128 |
| Surrey | BBB | 120 |
| Leicester | BBB | 120 |
| Hull | BCC | 104 |
Note that these are typical offers and can vary depending on the year, the applicant's background and specific course requirements. For our statistical exercise, we treat them as fixed data points.
请注意，这些是典型录取要求，会根据年份、申请者背景以及具体课程要求而变化。在本次统计练习中，我们将它们视为固定的数据点。
3. Converting Grades to Numerical Scores | 将等级转换为数值分数
, E = 1. For a typical offer of AAB, the score is 5 + 5 + 4 = 14. We can then compute the average grade score per A-Level by dividing by three. This gives us a single number to compare courses.
为了计算平均值，我们首先将每个三门等级录取要求转换为一个数值分数。我们使用简化的标度：A* = 6，A = 5，B = 4，C = 3，D = 2，E = 1。对于典型录取要求AAB，分数为5+5+4 = 14。然后我们可以除以三，得到每门A-Level的平均等级分。这样我们就得到了一个可以比较课程的数字。
rial = 5.33, LSE = 5.33, UCL = 5.33, Warwick = 5.00, Durham = 4.67, Bath = 4.67, Manchester = 4.67, Nottingham = 4.33, Reading = 4.33, Surrey = 4.00, Leicester = 4.00, Hull = 3.33.
将这一转换应用到我们数据集，得到以下每门A-Level平均分：牛津 5.33，剑桥 6.00，帝国理工 5.33，伦敦政经 5.33，伦敦大学学院 5.33，华威 5.00，杜伦 4.67，巴斯 4.67，曼彻斯特 4.67，诺丁汉 4.33，雷丁 4.33，萨里 4.00，莱斯特 4.00，赫尔 3.33。
These average scores form the main dataset for our statistical investigation. They are continuous numerical data, so we can calculate a range of summary statistics.
这些平均分构成了我们统计研究的主要数据集。它们是连续型数值数据，因此我们可以计算一系列汇总统计量。
4. Frequency Distribution of Entry Requirements | 录取要求的频数分布
Grouping the average scores into intervals helps us see the pattern. We can create a grouped frequency table with intervals of 5.00–5.99, 4.00–4.99, etc. Here is the distribution:
将平均分按区间分组有助于我们看清分布模式。我们可以制作一个组距频数表，区间为5.00–5.99、4.00–4.99等。以下是分布情况：
| Average Score Interval | Frequency |
|---|---|
| 5.00 – 5.99 | 6 |
| 4.00 – 4.99 | 5 |
| 3.00 – 3.99 | 2 |
| 6.00 – 6.99 | 1 |
From the table we see that the modal class is the 5.00–5.99 interval, containing six universities. This suggests that most selective universities ask for grades around A*AA or AAA equivalent.
从表中可以看出，众数所在组为5.00–5.99区间，包含六所大学。这表明大多数顶尖大学要求相当于A*AA或AAA的等级。
Frequency distributions allow us to quickly identify where the bulk of the data lies, and they form the basis for drawing histograms in later years.
频数分布使我们能够快速识别数据主体所在位置，也为今后学习直方图打下基础。
5. Visualising with Bar Charts | 使用条形图进行可视化
A bar chart is useful to display the frequency of each score interval. We can draw a bar chart with the intervals on the horizontal axis and frequency on the vertical axis. The heights of the bars clearly show that the 5.00–5.99 bar is the tallest, followed by 4.00–4.99.
条形图对于展示每个分数区间的频数非常有用。我们可以以区间为横轴，频数为纵轴绘制条形图。条形的高度清晰地显示出5.00–5.99的条最高，其次是4.00–4.99。
If we plot the actual average scores without grouping, a bar chart for individual universities can compare them directly. For example, Cambridge at 6.00 stands out as the highest, while Hull at 3.33 is the lowest. Such visuals make it easy to spot outliers.
如果我们不分组绘制各个大学的平均分条形图，则可以直接比较它们。例如，剑桥以6.00分显得最高，而赫尔以3.33分最低。这种可视化能让你轻易发现异常值。
Remember that in statistics, the choice of chart matters. Bar charts work well for categorical or discrete groups, while histograms are used for continuous grouped data.
请记住，在统计学中选择合适的图表很重要。条形图适用于分类或离散分组数据，而直方图则用于连续的分组数据。
6. Mean, Median and Mode of Entry Scores | 录取分数的平均数、中位数和众数
5.33 + 5.33 + 5.33 + 5.00 + 4.67 + 4.67 + 4.67 + 4.33 + 4.33 + 4.00 + 4.00 + 3.33 = 66.32. Dividing by 14 gives a mean of approximately 4.74.
利用这14个平均分，我们可以计算三种集中趋势度量。平均数是所有分数之和除以14。总和为66.32，除以14得到平均数约为4.74。
The median is the average of the 7th and 8th values: (4.67 + 4.67)/2 = 4.67. The mode is the most frequent value, which is 5.33 and 4.67 (both appear four times). This is a bimodal distribution.
为求中位数，我们将分数从小到大排序。中位数是第7和第8个值的平均数：(4.67 + 4.67)/2 = 4.67。众数是出现频率最高的值，5.33和4.67各出现四次，所以这是双峰分布。
Important formula for mean:
Mean = (x₁ + x₂ + … + xₙ) ÷ n
Comparing the mean (4.74) and the median (4.67) shows they are close, suggesting the distribution is fairly symmetric, with a slight pull from the high Cambridge score.
对比平均数4.74和中位数4.67，可以看出它们很接近，表明分布相当对称，但受到了剑桥高分的轻微牵拉。
7. Comparing Groups: Russell Group vs Non-Russell Group | 比较组别：罗素集团与非罗素集团
m are Russell Group members (8 universities). The remaining six (Bath, Manchester, Reading, Surrey, Leicester, Hull) may not all be Russell Group (Manchester is actually Russell Group, but let's adjust: actually Manchester is Russell Group. To keep the example balanced, let' am (9). Non-Russell: Bath, Reading, Surrey, Leicester, Hull (5). That gives 9 and 5. But I'll keep as originally stated for simplicity? I' LSE, UCL, Warwick, Durham, Nottingham) and 6 Non-Russell (Bath, Manchester as non-Russell? Manchester is Russell Group, so should be in Russell. Let' : Bath, Reading, Surrey, Leicester, Hull (5). Then compute means. The scores: Russell: 5.33, 6.00, 5.33, 5.33, 5.33, 5.00, 4.67, 4.67, 4.33. Non-Russell: 4.67, 4.33, 4.00, 4.00, 3.33. Calculate Russell mean = 51.99/9 ≈ 5.78; Non-Russell mean = 20.33/5 ≈ 4.07. That's a big difference. I'll use this realistic grouping. So I'll define Russell Group as those 9, Non-Russell as 5. I'll update the text accordingly.
罗素集团是由24所英国顶尖大学组成的联盟。在我们的列表中，牛津、剑桥、帝国理工、伦敦政经、伦敦大学学院、华威、杜伦、曼彻斯特和诺丁汉是罗素集团成员（9所）。其余五所（巴斯、雷丁、萨里、莱斯特、赫尔）为非罗素集团。我们可以比较两组的平均录取分数。
es, the mean is (4.67+4.33+4.00+4.00+3.33)/5 = 4.07. Clearly, Russell Group courses demand higher grades on average.
罗素集团大学的平均分为(5.33+6.00+5.33+5.33+5.33+5.00+4.67+4.67+4.33)/9 = 5.78。非罗素集团大学的平均分为(4.67+4.33+4.00+4.00+3.33)/5 = 4.07。很明显，罗素集团课程平均要求更高的等级。
Comparing groups using the mean helps you see structural differences in the higher education landscape. However, we should also consider the spread within each group.
通过平均数比较组别有助于你看到高等教育格局的结构性差异。不过，我们还应该考虑每个组内部的离散程度。
8. Measures of Spread: Range and Interquartile Range | 离散度量：极差与四分位距
the difference between the highest and lowest values. For the whole dataset, Range = 6.00 – 3.33 = 2.67. For Russell Group, Range = 6.00 – 4.33 = 1.67. For Non-Russell, Range = 4.67 – sell Group has a wider spread because it includes Cambridge with its extremely high offer.
极差是最高值与最低值之差。整个数据集的极差为6.00 – 3.33 = 2.67。罗素集团的极差为6.00 – 4.33 = 1.67，非罗素集团为4.67 – 3.33 = 1.34。罗素集团离散更广，因为它包含了录取要求极高的剑桥。
A better measure of spread that is not affected by outliers is the interquartile range (IQR). To find the IQR, we need the lower quartile (Q1) and upper quartile (Q3). The ordered dataset has 14 values: Q1 is the median of the lower half (first 7 values): 3.33, 4.
Published by TutorHao | Year 9 统计 Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图