📚 Year 9 SQA Statistics: A Comparative Look at UK University Entry Requirements | Year 9 SQA 统计：英国大学申请要求对照
When you begin researching universities, you quickly realise that entry requirements vary enormously from one course to another. Statistics gives us a powerful toolkit to compare these requirements in a structured way. By collecting, organising and analysing entry tariff data, you can make better decisions about where to apply and what grades to aim for. This article explores how Year 9 SQA Statistics skills – from calculating averages to drawing box plots – can be used to compare UK university entry requirements and plan your future pathway.
当你开始研究大学时，很快就会发现不同课程的入学要求差异很大。统计学为我们提供了一套强大的工具，可以有条理地比较这些要求。通过收集、整理和分析入学积分数据，你可以更明智地决定申请哪里以及把目标定在什么成绩。本文探讨如何运用 Year 9 SQA 统计学技能——从计算平均数到绘制箱线图——来比较英国大学的入学要求，并规划你未来的升学路径。
1. Understanding UCAS Tariff Points and Scottish Highers | 理解 UCAS 积分与苏格兰 Highers
r A is worth 56 points, B is 48, C is 40, and D is 32. A Higher A gives 33 points, B is 27, C is 21, and D is 15. This system allows us to treat grades from different qualification types as numbers, making statistical analysis possible. For example, a typical Scottish university conditional offer of AAAB at Higher translates to 33 + 33 + 33 + 27 = 126 tariff points.
为了公平地比较入学要求，英国大学采用一种通用货币，叫做 UCAS 积分。对于 SQA 资格，一个 Advanced Higher A 记 56 分，B 48 分，C 40 分，D 32 分。一个 Higher A 记 33 分，B 27 分，C 21 分，D 15 分。这套体系让我们可以把不同资格类型的成绩视为数字，从而进行统计分析。比如，苏格兰大学一个典型的有条件录取通知要求 Higher AAAB，换算后是 33 + 33 + 33 + 27 = 126 个 tariff 积分。
2. Collecting Data: Gathering Entry Requirement Samples | 收集数据：获取入学要求样本
In a statistical investigation, the first step is to define your population and collect a sample. Suppose we are interested in entry requirements for competitive courses such as Law, Medicine or Engineering. We visited the official websites of ten well-known UK universities and recorded the typical total UCAS tariff points needed for entry. Our sample includes a mix of Scottish and English institutions to reflect the choices Year 9 students might explore.
在统计调查中，第一步是明确总体并收集样本。假设我们对法律、医学或工程等竞争性课程的入学要求感兴趣。我们访问了十所英国知名大学的官方网站，并记录了入学所需的典型 UCAS 总积分。我们的样本包括苏格兰和英格兰的院校，以反映 Year 9 学生可能探索的选择。
| University | Typical Offer (Qualification) | Total Tariff Points |
|---|---|---|
| University of Oxford | A*A*A (A-level) | 160 |
| University of Cambridge | A*AA (A-level) | 152 |
| Imperial College London | A*AA (A-level) | 152 |
| University of Edinburgh | AAAB (Higher) | 126 |
| UCL | AAA (A-level) | 144 |
| University of Glasgow | AABB (Higher) | 120 |
| University of Manchester | ABB (A-level) | 128 |
| University of Aberdeen | BBBB (Higher) | 108 |
| University of Strathclyde | BBCC (Higher) | 96 |
| University of Warwick | AAA (A-level) | 144 |
This table provides raw data for our statistical comparison. Notice how Scottish Highers offers are expressed in terms of four subjects, while A-level offers typically involve three subjects. By converting everything to tariff points, we can compare them on the same scale.
这张表格为我们的统计比较提供了原始数据。注意苏格兰 Highers 的录取要求通常涉及四门科目，而 A-level 要求通常只涉及三门。通过将所有要求转换为积分，我们可以在同一尺度上进行比较。
3. Organising Data: Frequency Tables and Grouping | 整理数据：频数表与分组
Once we have a list of values, we can organise them into a frequency table. This helps us see patterns quickly. For the ten universities, we can group tariff points into intervals of 20. Below is a grouped frequency table.
一旦获得了数值列表，我们就可以将它们整理成频数表。这有助于我们快速发现规律。对于这十所大学，我们可以将积分按每 20 分为一组。下面是分组频数表。
| Tariff Point Group | Tally | Frequency |
|---|---|---|
| 90 - 109 | // | 2 |
| 110 - 129 | /// | 3 |
| 130 - 149 | // | 2 |
| 150 - 169 | /// | 3 |
The table shows a bimodal-like pattern, with clusters both in the lower 110-129 range and the higher 150-169 range. This reflects the difference between Scottish Highers-based requirements and highly selective A-level offers.
该表显示出类似双峰的分布模式，在较低的 110-129 区间和较高的 150-169 区间各有一簇。这反映了基于苏格兰 Highers 的要求和高选拔性 A-level 录取要求之间的差异。
4. Visualising Requirements: Bar Charts and Histograms | 可视化入学要求：条形图与直方图
We can draw a bar chart where each bar represents an individual university, with the height equal to its tariff points. This makes it easy to spot the highest and lowest requirements at a glance. Alternatively, a histogram of the grouped data uses bar area to represent frequency in each interval. Since our intervals are equal in width, the histogram would show the tallest bar for 110-129 and 150-169 groups.
我们可以绘制条形图，每个条形代表一所大学，其高度等于该校的积分要求。这样一眼就能看出最高和最低的要求。此外，分组数据的直方图用条形面积表示每个区间的频数。由于区间宽度相等，直方图会显示出 110-129 和 150-169 组条形最高。
In SQA Statistics, you must label axes clearly. The horizontal axis would show 'University' or 'Tariff Point Group', and the vertical axis would show 'UCAS Tariff Points' or 'Frequency'. Always give a title, such as 'Comparison of UK University Entry Tariffs'.
在 SQA 统计中，你必须清楚地标注坐标轴。横轴显示“大学”或“积分分组”，纵轴显示“UCAS 积分”或“频数”。始终给出标题，如“英国大学入学积分比较”。
5. Measures of Central Tendency: Mean Entry Tariff | 集中趋势量数：平均入学积分
1330. Mean = 1330 ÷ 10 = 133.0 points. This average gives a general idea of the typical tariff level across these universities.
样本的平均积分通过将所有十个值相加再除以 10 得到。总和 = 160 + 152 + 152 + 126 + 144 + 120 + 128 + 108 + 96 + 144 = 1330。平均数 = 1330 ÷ 10 = 133.0 分。这个平均数能让人大致了解这些大学的一般积分水平。
ave 10 values (even number), the median is halfway between the 5th and 6th values: (128 + 144) ÷ 2 = 136.0 points. The median is slightly higher than the mean, suggesting the distribution is a little negatively skewed by the lower values.
中位数是将数据排序后位于中间的值。从小到大排列：96, 108, 120, 126, 128, 144, 144, 152, 152, 160。由于有 10 个数值（偶数个），中位数是第 5 和第 6 个数的中间值：(128 + 144) ÷ 2 = 136.0 分。中位数略高于平均数，表明分布因较低值的影响而略有负偏态。
6. Measures of Spread: Range and Interquartile Range | 离散程度量数：极差与四分位距
there is a considerable gap between the least and most demanding entry offers in our list.
极差是最简单的离散量数。极差 = 最大值 - 最小值 = 160 - 96 = 64 个积分。这告诉我们列表中要求最低和最高的录取条件之间存在相当大的差距。
6, 128 → Q1 = 120. The upper quartile (Q3) is the median of the second half: 144, 144, 152, 152, 160 → Q3 = 152. IQR = Q3 - Q1 = 152 - 120 = 32 points. This means the middle 50% tariffs within a 32-point band, which is relatively modest compared to the overall range.
为了获得更稳健的认识，我们计算四分位距（IQR）。下四分位数 (Q1) 是前半部分数据的中位数：96, 108, 120, 126, 128 的中位数为 120。上四分位数 (Q3) 是后半部分数据的中位数：144, 144, 152, 152, 160 的中位数为 152。IQR = Q3 - Q1 = 152 - 120 = 32 分。这意味着中间 50% 的大学入学积分在一个 32 分的带宽内，与总体极差相比相对较小。
7. Using Averages to Categorise Universities: Safety, Match and Reach | 利用平均数给大学分类：保底、匹配和冲刺
When applying through UCAS, students often use the concepts of 'safety', 'match' and 'reach' s. A safety choice might be a university where the entry tariff is at least one IQR below your score (130 - 32 = 98 points) – ersity would require a tariff at least one IQR above (130 + 32 = 162 points), pointing towards Oxford (160).
在通过 UCAS 申请时，学生经常使用“保底”、“匹配”和“冲刺”院校的概念。借助我们的统计汇总，你可以设定合理的界限。假设你的预测成绩换算成 130 个 tariff 积分。保底院校可以是入学积分比你至少低一个 IQR 的学校（130 - 32 = 98 分）——比如思克莱德大学或阿伯丁大学。匹配院校的积分应接近你的分数，如爱丁堡大学（126）或曼彻斯特大学（128）。冲刺院校则至少比你高一个 IQR（130 + 32 = 162 分），指向牛津大学（160）。
This rule-of-thumb uses statistical spread to make the application strategy more data-driven. It is important to remember that entry requirements can change yearly, so always check the latest information.
这条经验法则利用统计离散程度使申请策略更加以数据为驱动。要记住入学要求每年都可能变化，所以始终要查看最新信息。
8. Scatter Graphs: Entry Requirements vs University Ranking | 散点图：入学要求与大学排名
We can also investigate the relationship between entry tariff and university ranking. Using a simplified rank from 1 (top) to 10, and plotting the tariff points of our ten universities, we often see a downward trend: higher-ranked universities tend to have higher entry requirements. However, this relationship is not perfect. Edinburgh (rank 5) has 126 points, while Manchester (rank 6) has 128 points – a slight deviation.
我们还可以探究入学积分与大学排名之间的关系。使用从 1（最高）到 10 的简化排名，标绘十所大学的积分点，我们通常会看到一种下降趋势：排名越高的大学往往入学要求也越高。但这种关系并非绝对。爱丁堡大学（排名第 5）要求 126 分，而曼彻斯特大学（排名第 6）要求 128 分——略有出入。
In a scatter graph, we plot rank on the x-axis and tariff on the y-axis. Plotting points (1,160), (2,152), (3,152), (4,144), (5,126), (6,128), (7,144), (8,120), (9,108), (10,96) reveals a moderate negative correlation. The line of best fit would slope downwards, but its steepness would depend on the chosen universities.
在散点图中，我们将排名标在 x 轴，积分标在 y 轴。标出点 (1,160), (2,152), (3,152), (4,144), (5,126), (6,128), (7,144), (8,120), (9,108), (10,96) 可以看出中等程度的负相关关系。最佳拟合线会向下倾斜，但其陡峭程度取决于所选的大学。
9. Box Plots: Visualising the Spread of Two Groups | 箱线图：直观比较两组的离散情况
A box plot (or box-and-whisker diagram) is ideal for comparing distributions. Let us split our sample into two groups: 'Russell Group competitive' universities (Oxford, Cambridge, Imperial, UCL, Edinburgh, Manchester, Warwick) and 'non-Russell or less competitive' for the remainder (Glasgow, Aberdeen, Strathclyde). We can draw parallel box plots to compare their entry tariff distributions.
箱线图（或称盒须图）非常适合比较分布。我们可以把样本分成两组：“罗素集团竞争型”大学（牛津、剑桥、帝国理工、UCL、爱丁堡、曼彻斯特、华威），以及其余“非罗素或竞争相对较弱”的大学（格拉斯哥、阿伯丁、思克莱德）。我们可以绘制并列箱线图来比较它们的入学积分分布。
1 = 128, Median = 144, Q3 = 152, Max = 160. This box plot would show a box from 128 to 152 with a median line at 144, and a whisker extending to 160. The less competitive group: 120, 108, 96. Min = 96, Q1 = 102 (midpoint), Median = 108, Q3 = 114, Max = 120. The box plot clearly reveals that the competitive group has much higher tariffs and also a wider spread.
竞争型组：数值为 160, 152, 152, 144, 126, 128, 144。排序：126, 128, 144, 144, 152, 152, 160。五数综合：最小值 = 126，Q1 = 128，中位数 = 144，Q3 = 152，最大值 = 160。这个箱线图会显示从 128 到 152 的箱体，中位线在 144，触须延伸到 160。相对较弱组：120, 108, 96。最小值 = 96，Q1 = 102（中点），中位数 = 108，Q3 = 114，最大值 = 120。箱线图清楚地显示竞争型组不但积分更高，而且分布也更广。
10. Probability and Predicted Grades: Meeting a Conditional Offer | 概率与预测成绩：达到有条件录取
at Higher). A Year 9 student might not yet have exact predicted grades, but they can look at historical data from their school: last year, 30 out of 50 students with similar mock results went on to achieve 126 points or more. The relative frequency probability of success is 30/50 = 0.6, or 60%.
统计学也能帮助你估计达到录取条件的可能性。假设爱丁堡大学的有条件录取要求 126 个积分（Higher AAAB）。一个 Year 9 的学生可能还没有确切的预测成绩，但他们可以查看学校的历史数据：去年，具有类似模拟考试成绩的 50 名学生中有 30 人最终取得了 126 分或更高。成功的相对频率概率是 30/50 = 0.6，即 60%。
If a student applies to two independent choices – say Edinburgh (126) and Glasgow (120) – and the probability of meeting each offer is estimated as 0.6 and 0.75 respectively, the probability of meeting at least one firm offer can be calculated using the 'at least one' rule from probability. This type of reasoning turns exam anxiety into a manageable numbers game.
如果一名学生申请两所互为独立的院校——比如爱丁堡（126）和格拉斯哥（120）——并估计达到各自录取条件的概率分别为 0.6 和 0.75，那么至少达到一所首选院校要求的概率就可以用概率中的“至少一个”规则来计算。这种推理将考试焦虑转化为了可控的数字游戏。
11. Correlation vs. Causation: Do Higher Tariffs Mean Better Courses? | 相关与因果：更高要求就意味着更好课程吗？
Our scatter graph suggests a correlation between university ranking and entry tariff, but this does not imply causation. A high tariff often reflects course popularity and limited places rather than pure quality. Some newer universities offer excellent student satisfaction and employment outcomes with lower tariff requirements. When analysing data, always ask whether a third factor – such as subject specialisation or location – might explain the pattern.
我们的散点图表明大学排名和入学积分之间存在相关关系，但这并不意味因果关系。高积分往往反映的是课程的受欢迎程度和有限的名额，而非纯粹的教学质量。一些较新的大学虽然积分要求较低，但却能提供出色的学生满意度和就业成果。在分析数据时，始终要问是否存在第三个因素——比如专业特色或地理位置——能够解释这一模式。
In SQA Statistics, it is crucial to recognise the difference between correlation and causation. Jumping to conclusions without considering lurking variables can lead to poor decision-making.
在 SQA 统计中，认识到相关关系和因果关系之间的区别至关重要。不考虑潜伏变量就贸然下结论，可能导致决策失误。
12. Conclusion: Making Informed Choices with Statistics | 结论：利用统计做出明智选择
Year 9 students who master statistical tools can approach the university application process with confidence. By converting entry requirements into numerical tariff points, you can compare universities objectively using measures of centre and spread, visualise them with bar charts and box plots, and even estimate your chances with basic probability. Remember that statistics is not just about numbers – it is about using evidence to support your decisions. Start building your data set with your dream courses today, and let the numbers guide you towards a well-balanced UCAS application.
掌握了统计工具的 Year 9 学生可以充满信心地面对大学申请过程。通过将入学要求转换为数值积分，你可以利用集中趋势和离散程度的量数客观地比较大学，用条形图和箱线图进行可视化，甚至可以用基础概率估算自己的机会。请记住，统计不仅仅是关于数字——更是关于用证据来支持你的决策。今天就开始用你心仪的课程构建数据集吧，让数字引导你完成一份均衡的 UCAS 申请。
Published by TutorHao | Statistics Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图