📚 Year 9 Edexcel Statistics: Comparing UK University Entry Requirements | 统计视角下的英国大学申请要求比较
In Year 9, students following the Edexcel Statistics course begin to develop essential skills in collecting, representing, and interpreting data. One real-world context where these skills become incredibly useful is in researching and comparing university entry requirements across the UK. By treating admission criteria—such as A-level grades, UCAS tariff points, and IELTS scores—as statistical data, you can transform a confusing list of numbers into clear, comparative insights that help you make smarter decisions about your future. This article will guide you through key Year 9 statistical concepts, from frequency tables to box plots, using actual-style university admission data so you can see how statistics turns information into power.
在 Year 9 阶段，学习 Edexcel 统计学课程的学生开始掌握收集、展示和解读数据的基本技能。一个非常实用的应用场景就是研究并比较英国不同大学的入学要求。只要将 A-level 成绩、UCAS 关税分、雅思分数等录取标准看作统计数据，你就能把一堆令人眼花缭乱的数字转化为清晰、可比的见解，从而更明智地规划自己的未来。本文将带着你，从频数表到箱线图，运用典型的大学录取数据，逐一演示 Year 9 的关键统计概念，让你亲身感受统计如何将信息转化为力量。
1. Collecting Data: Types of Entry Requirements | 数据收集：入学要求的分类
When we begin any statistical investigation, we must first identify the types of data we are dealing with. University entry requirements provide both qualitative and quantitative data. Qualitative data includes the name of the university, the course title, and whether an admissions test like the UCAT or LNAT is required. Quantitative data includes numerical values such as the typical A-level grade combination, the UCAS tariff points total, the required IELTS score, and even the percentage of applicants who receive offers. For Year 9 statistics, understanding whether data is categorical or numerical helps us decide which charts and averages to use later. For example, ‘A*AA’ is categorical even though it contains letters, but when converted to tariff points (e.g. 152 points), it becomes discrete numerical data that we can summarise with means and medians.
在任何统计调查开始时，我们首先要明确处理的数据类型。英国大学的入学要求既包含定性数据，也包含定量数据。定性数据包括大学名称、专业名称，以及是否需要 UCAT、LNAT 等入学考试；定量数据则包括典型的 A-level 成绩组合、UCAS 关税分总值、要求的雅思分数，甚至发放录取的比例等具体数值。在 Year 9 统计中，分辨数据是分类的还是数值的，能够帮助我们后续选择恰当的图表和平均值。例如，“A*AA”虽然包含字母，本质上是分类数据，但当它被转换为关税分（如 152 分）后就变成了离散数值数据，我们就可以计算平均数和中位数来概括它。
2. Organising Data in Frequency Tables | 用频数表整理入学要求
A frequency table is often the first step in organising raw data. Suppose we collected the typical A-level offer for 10 popular UK universities and converted each to UCAS tariff points. Our raw data might look like this: Oxford (A*A*A = 160), Cambridge (A*A*A = 160), Imperial (A*AA = 152), LSE (A*AA = 152), UCL (A*AA = 152), Warwick (A*AA = 152), Durham (AAA = 144), Bristol (AAA = 144), Manchester (AAA = 144), and Nottingham (AAB = 136).
频数表往往是整理原始数据的第一步。假设我们收集了 10 所热门英国大学的典型 A-level 录取要求，并将它们都转换成了 UCAS 关税分。原始数据可能是：牛津（A*A*A = 160）、剑桥（A*A*A = 160）、帝国理工（A*AA = 152）、伦敦政经（A*AA = 152）、伦敦大学学院（A*AA = 152）、华威（A*AA = 152）、杜伦（AAA = 144）、布里斯托（AAA = 144）、曼彻斯特（AAA = 144）和诺丁汉（AAB = 136）。
We can then construct a frequency table where the first column shows each distinct tariff point value (the ‘score’), the second column shows the tally, and the third shows the frequency. The table below summarises this neatly.
接着我们可以构建一个频数表，第一列列出所有不同的关税分（“分数”），第二列划记，第三列显示频数。下面的表格清晰地总结了这一点。
| Tariff Points (x) | Tally | Frequency (f) |
|---|---|---|
| 160 | II | 2 |
| 152 | IIII | 4 |
| 144 | III | 3 |
| 136 | I | 1 |
From this frequency table, we can instantly see that the most common tariff requirement is 152 points, which corresponds to A*AA offers. This quick summary is much clearer than scrolling through a long list.
从这张频数表，我们可以立刻看出最常见的关税分要求是 152 分，对应于 A*AA 的录取条件。这种简洁的概括比翻阅一长串名单清晰得多。
3. Bar Charts for Categorical Requirements | 分类要求的条形图
Once we have a frequency table, the next logical step in Edexcel Statistics is to draw a bar chart. A bar chart is ideal for displaying discrete categorical or numerical data like tariff points because the gaps between bars emphasise that each value is separate. Using the frequency table above, we can label the horizontal axis with ‘UCAS Tariff Points’ and the vertical axis with ‘Frequency’. We draw bars of equal width: a bar of height 2 at 136, height 3 at 144, height 4 at 152, and height 2 at 160. The chart immediately highlights the mode—152—and shows that the distribution is roughly symmetric but slightly skewed towards lower values.
有了频数表后，按照 Edexcel 统计学的思路，下一步自然是绘制条形图。条形图非常适合展示像关税分这样的离散数据或分类数据，因为条形之间的空隙强调每个值是独立的。利用上面的频数表，我们可以把横轴标为“UCAS 关税分”，纵轴标为“频数”，然后画出等宽的条形：在 136 处画高度为 1 的条，144 处高度 3，152 处高度 4，160 处高度 2。这张图立刻突出了众数——152，并显示出分布大致对称但略微向左偏斜。
Bar charts are particularly useful when comparing the entry requirements of different groups of universities. For instance, you could construct a multiple bar chart showing offers for Russell Group universities alongside those for non-Russell Group universities on the same axes, making it easy to see that Russell Group offers tend to cluster at higher tariff points.
在比较不同大学群体的入学要求时，条形图尤其有用。例如，可以绘制复式条形图，在同一坐标轴上同时展示罗素集团大学和非罗素集团大学的录取条件，这样便能直观地看出罗素集团大学的 Offer 往往集中在更高的关税分段。
4. Pie Charts: Visualising Proportions of IELTS Requirements | 饼图：可视化雅思要求比例
Not all admission criteria are based on tariff points; many international students must also meet English language requirements like IELTS scores. Suppose we collected the minimum IELTS overall band requirement for the same 10 universities and found the following: 7.5 (2 universities), 7.0 (4 universities), 6.5 (3 universities), and 6.0 (1 university). To show what proportion of these universities require each score, we can draw a pie chart. The angle for each sector is calculated by multiplying the relative frequency by 360°. For example, for a score of 7.0, the angle is (4/10) × 360° = 144°.
并非所有入学标准都以关税分为基础；许多国际学生还需满足雅思等英语语言要求。假设我们收集了相同 10 所大学的最低雅思总分要求，结果如下：7.5 分（2 所），7.0 分（4 所），6.5 分（3 所），6.0 分（1 所）。为了展示各分数段大学所占的比例，我们可以绘制饼图。每个扇形的圆心角用相对频率乘以 360° 计算得出。例如，7.0 分对应的角度为 (4/10) × 360° = 144°。
A pie chart makes it very clear that nearly half of these top universities demand at least 7.0 overall, while only a small fraction (10%) accept a 6.0. This visual summary can help a Year 9 student quickly understand the competitive landscape of English language requirements without getting lost in the numbers.
饼图能非常清楚地显示，这些顶尖大学中近半数要求总分不低于 7.0，而只有很小一部分（10%）接受 6.0。这种可视化概括可以帮助 Year 9 学生迅速把握英语语言要求的竞争格局，而不必在数字中迷失。
5. Measures of Central Tendency: Mean, Median, and Mode | 集中趋势量数：平均数、中位数与众数
One of the most important skills in Year 9 statistics is calculating and interpreting measures of central tendency. Returning to our tariff points data from 10 universities (136, 144, 144, 144, 152, 152, 152, 152, 160, 160), we can find the mean, median, and mode. The mean (average) is the sum of all values divided by the number of data points:
Year 9 统计中最核心的技能之一就是计算并解读集中趋势量数。回到我们那 10 所大学的关税分数据（136, 144, 144, 144, 152, 152, 152, 152, 160, 160），我们可以求出平均数、中位数和众数。平均数是将所有值相加再除以数据个数：
Mean = (136 + 144×3 + 152×4 + 160×2) ÷ 10 = 1496 ÷ 10 = 149.6 tariff points
The median is the middle value when data are ordered. With 10 values, the median lies between the 5th and 6th observations. Here both are 152, so the median is 152 tariff points. The mode is the most frequently occurring value, which is also 152 points (appearing 4 times). Together these three measures tell us that a ‘typical’ top university requires around 150 points, but the median and mode being slightly higher than the mean suggests a slight negative skew—a few lower-scoring courses pull the mean down.
中位数是数据按序排列后的中间值。有 10 个数据时，中位数位于第 5 和第 6 个观测值之间。这里的第 5 和第 6 个值都是 152，因此中位数为 152 关税分。众数是出现频率最高的值，同样是 152 分（出现 4 次）。这三个量数共同告诉我们，一所“典型”的顶尖大学要求大约 150 分，但中位数和众数略高于平均数，表明分布稍有负偏态——少数分数较低的专业拉低了平均数。
Choosing which average to use depends on the context. The mode is helpful when you want to know the most common offer (A*AA), while the median is robust against extreme values and gives a more representative ‘centre’ when data are skewed. The mean is useful if we want to compare total tariff point sums across different groups, but it can be influenced by outliers.
选择使用哪种平均数取决于上下文。如果你想知道最常见的录取条件，众数最为有用（A*AA）；当数据偏态时，中位数不易受极端值影响，能更代表“中心”水平。平均数则在比较不同群体的关税分总和时很有用，但容易受异常值干扰。
6. Range and Interquartile Range (IQR) | 极差与四分位距
Measures of average only tell part of the story; we also need to describe the spread or variability of requirements. The simplest measure of spread is the range, calculated as the maximum value minus the minimum. In our dataset, the highest tariff is 160 and the lowest is 136, so the range = 160 – 136 = 24 tariff points. This tells us that the entry requirements span a 24-point gap. However, the range is sensitive to a single extreme value and does not show how tightly the middle half of the data is clustered.
度量平均数只能说明部分问题，我们还需要描述录取要求的分散程度或变异性。最简单的离散度量是极差，由最大值减最小值计算得出。在我们的数据中，最高关税是 160，最低是 136，所以极差 = 160 – 136 = 24 个关税分。这告诉我们入学要求的跨度是 24 分。然而，极差容易受单个极值影响，无法反映中间一半数据的聚集程度。
That is why Year 9 introduces the interquartile range (IQR). First, we find the lower quartile (Q1) and upper quartile (Q3). Ordering the data: 136, 144, 144, 144, 152, 152, 152, 152, 160, 160. Using the (n+1)/4 rule, Q1 is at position 2.75, which is 144. Q3 is at position 8.25, which is three-quarters of the way between 152 and 160, giving Q3 = 154. The IQR = Q3 – Q1 = 154 – 144 = 10 tariff points. This small IQR tells us that the middle 50% of universities have very similar requirements, clustering tightly around the median.
因此，Year 9 引入了四分位距（IQR）。首先找出下四分位数 Q1 和上四分位数 Q3。将数据排序：136, 144, 144, 144, 152, 152, 152, 152, 160, 160。使用 (n+1)/4 规则，Q1 位于第 2.75 个位置，对应值为 144；Q3 位于第 8.25 个位置，即 152 到 160 之间四分之三处，得出 Q3 = 154。于是 IQR = Q3 – Q1 = 154 – 144 = 10 关税分。这个较小的 IQR 表明，中间 50% 的大学录取要求非常相似，紧密聚集在中位数附近。
Comparing range and IQR helps us understand the uniformity of admissions. A small IQR indicates that most top universities maintain a high but consistent bar, whereas a large range might signal that some courses or universities within the group are outliers, perhaps offering more flexible entry routes.
比较极差和 IQR 有助于我们理解录取要求的一致性。较小的 IQR 表示大多数顶尖大学都维持着高而一致的门槛；而较大的极差则可能说明该群体中某些专业或大学是异常值，或许提供了更灵活的入学路径。
7. Box Plots for Comparing Distributions | 箱线图比较录取分布
A box plot (or box-and-whisker diagram) is a powerful visual tool that combines the median, quartiles, and range in one diagram. Using our tariff points, we can draw a box plot where the box spans from Q1 = 144 to Q3 = 154, with a vertical line inside the box marking the median at 152. The ‘whiskers’ extend to the minimum (136) and maximum (160). This single graphic compactly shows the central tendency and spread.
箱线图（或箱须图）是一种强大的可视化工具，它将中位数、四分位数和极差融合在一张图里。利用我们的关税分数据，可以绘制箱线图，箱体从 Q1 = 144 跨至 Q3 = 154，箱内一条竖线标示出中位数 152。“须”则延伸到最小值 136 和最大值 160。这一张图便紧凑地展示了数据的集中趋势和离散程度。
Box plots become even more useful when we compare two groups. Imagine we split our 10 universities into Russell Group (Oxford, Cambridge, Imperial, LSE, UCL, Warwick) and non-Russell Group (Durham, Bristol, Manchester, Nottingham). For the Russell Group, the tariff points are 160, 160, 152, 152, 152, 152. Minimum = 152, Q1 = 152 (since lower half is 152,152,152), median = 152, Q3 = 160, maximum = 160. Its box plot would show a very short box between 152 and 160, with the median possibly at 152, indicating extremely tight clustering. For the non-Russell Group, data are 144, 144, 144, 136. After sorting: 136, 144, 144, 144, Q1 = 140? Let’s calculate properly: n=4, using (n+1)/4, Q1 at position 1.25, between 136 and 144 → 138; Q3 at position 3.75, between 144 and 144 → 144. The box plot for non-Russell Group would show a wider spread relative to their fewer members. Placing the two box plots side by side immediately reveals that Russell Group universities demand higher and less variable tariff points than non-Russell Group ones. This kind of comparative analysis is a key expectation in Edexcel Statistics.
当比较两组数据时，箱线图的优势更加凸显。假设我们将这 10 所大学分为罗素集团（牛津、剑桥、帝国理工、LSE、UCL、华威）和非罗素集团（杜伦、布里斯托、曼彻斯特、诺丁汉）。罗素集团的关税分数据为：160, 160, 152, 152, 152, 152。最小 = 152，Q1 = 152，中位数 = 152，Q3 = 160，最大 = 160。其箱线图会呈现一个从 152 到 160 的极短箱体，中位数可能落在 152，表明极其紧密的聚类。非罗素集团数据为 144, 144, 144, 136，排序后 136, 144, 144, 144，Q1 约 138，Q3 为 144。它的箱线图展现出了相对更宽的离散度。将两个箱线图并排放置，一眼就能看出罗素集团大学要求更高、变异更小的特点。这种对比分析正是 Edexcel 统计学考查的重点之一。
8. Cumulative Frequency and Percentiles | 累积频率与百分位数
Cumulative frequency diagrams are introduced in Year 9 to help answer questions like ‘How many universities require fewer than 150 tariff points?’ or ‘What tariff points mark the top 20% of offers?’. We start with our frequency table and calculate cumulative frequency: 136 → 1, 144 → 1+3=4, 152 → 4+4=8, 160 → 8+2=10. Plotting these points (upper class boundary for ungrouped data) and joining them with a smooth curve produces a cumulative frequency graph. From this graph, we can estimate the median at the 5th value (50th percentile), which we already know is 152, and we can also find other percentiles.
Year 9 引入累积频率图，用来回答类似“有多少所大学要求低于 150 关税分？”或“录取分数前 20% 所对应的关税分是多少？”的问题。我们先从频数表出发，计算累积频率：136 → 1，144 → 1+3=4，152 → 4+4=8，160 → 8+2=10。将上述点（对于未分组数据用上界限）在坐标系中标出，并用平滑曲线连接，即得累积频率曲线。从图中可以估计出第 5 个值对应的中位数（第 50 百分位数），我们已知是 152，同时也能找到其他百分位数。
For example, the 90th percentile would be at cumulative frequency 9 (since 90% of 10). Reading off the graph gives a tariff of approximately 160. This means that only 10% of these universities have requirements at or above 160 points—the very top tier. Conversely, the 25th percentile (lower quartile) is at cumulative frequency 2.5, which on the graph corresponds to about 144 points. Interpreting percentiles in the context of university applications helps you gauge where a particular grade combination stands in the competitive landscape.
例如，第 90 百分位数的累积频率为 9（因为 10 的 90%）。从图上读取对应关税分大约为 160，这意味着只有 10% 的这些大学要求达到或超过 160 分——这是最顶级的梯队。反过来，第 25 百分位数（下四分位）的累积频率为 2.5，图上对应约 144 分。在大学申请背景下解读百分位数，能帮助你判断某个成绩组合在竞争环境中所处的位置。
9. Scatter Graphs: Exploring Correlation Between Tariff and IELTS | 散点图：探索关税分与雅思成绩的相关性
Bivariate data analysis is another exciting area of Year 9 statistics. We might ask: is there a relationship between the A-level tariff points a university demands and its minimum IELTS score? We can gather data pairs for our 10 universities. Plotting tariff points on the horizontal axis (x) and IELTS on the vertical axis (y), we might see points like (160, 7.5) for Oxford, (152, 7.0) for Imperial, (144, 6.5) for Manchester, and (136, 6.0) for Nottingham. By drawing a scatter graph, we can observe whether higher tariff points tend to be paired with higher IELTS scores.
双变量数据分析是 Year 9 统计学中另一项引人入胜的内容。我们可能会问：一所大学要求的 A-level 关税分与其最低雅思分数之间是否存在关联？我们可以为 10 所大学收集成对的数据。将关税分作为横轴 (x)，雅思分数作为纵轴 (y)，我们会看到诸如牛津 (160, 7.5)、帝国理工 (152, 7.0)、曼彻斯特 (144, 6
Published by TutorHao | Year 9 统计 Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导Cancel reply