Comparing UK University Entry Requirements with Year 10 Edexcel Statistics | 运用Year 10 Edexcel统计知识对比英国大学入学要求

📚 Comparing UK University Entry Requirements with Year 10 Edexcel Statistics | 运用Year 10 Edexcel统计知识对比英国大学入学要求

As Year 10 students following the Edexcel Statistics course, you will learn how to collect, represent and analyse data. In this article, we apply these skills to a real-world context: comparing UK university entry requirements. By investigating the A-level grades or UCAS tariff points needed for different courses and institutions, you can practise key statistical techniques and gain valuable insights for your future applications.

作为学习Edexcel统计学课程的10年级学生，你将学习如何收集、呈现和分析数据。在本文中，我们将这些技能应用于现实情境：比较英国大学的入学要求。通过调查不同课程和院校所需的A-level成绩或UCAS分数，你可以练习关键的统计方法，并为未来的大学申请获取宝贵信息。

1. Understanding University Entry Criteria | 理解大学入学标准

University entry requirements in the UK are typically expressed as specific A-level grades, such as A*AA or AAA, or as a total UCAS tariff score. The UCAS tariff system converts grades and qualifications into points, enabling fair comparisons across different types of offers. For example, an A* at A-level earns 56 points, an A earns 48, and a B earns 40. Some courses may also require particular subjects or include additional assessments like admissions tests.

英国大学的入学要求通常以特定的A-level成绩（如A*AA或AAA）或UCAS总分来表示。UCAS分数系统将等级和资历转换为点数，从而能够公平比较不同类型的录取条件。例如，A-level的A*得56分，A得48分，B得40分。某些课程可能还要求特定科目，或包含入学考试等额外评估。

Understanding these criteria is the first step in any statistical comparison. We need to define the variables clearly: the university name, the course, the typical offer expressed in both letter grades and tariff points. This data will form the basis of our statistical enquiry, following the PPDAC cycle (Problem, Plan, Data, Analysis, Conclusion) that you encounter throughout the Edexcel Statistics curriculum.

理解这些标准是任何统计比较的第一步。我们需要明确定义变量：大学名称、课程、以字母等级和分值表示的典型录取条件。这些数据将构成我们统计调查的基础，遵循你在Edexcel统计学课程中接触到的PPDAC循环（问题、计划、数据、分析、结论）。

2. Planning a Statistical Investigation | 规划一项统计调查

Before collecting data, you must define a clear research question. For our purpose, consider: 'How do entry requirements vary across different UK universities for Economics degrees?' We need to identify the population (all UK universities offering Economics degrees) and take a sample, perhaps selecting 20 institutions that include both Russell Group and non-Russell Group members to allow comparisons. This is a type of stratified sampling by university category.

在收集数据之前，你必须定义一个清晰的研究问题。针对我们的目的，可以考虑：“不同英国大学的经济学学位入学要求有何差异？”我们需要确定总体（所有提供经济学学位的英国大学），并选取一个样本，例如选择20所院校，包含罗素集团和非罗素集团成员，以便进行比较。这是一种按大学类别分层的抽样方式。

In Edexcel Statistics, you learn about primary and secondary data. For this project, we will use secondary data sourced from university websites or UCAS prospectuses. It is important to record the date of collection and ensure the data is reliable and accurate. We also decide to measure the entry requirement using the UCAS tariff points as a continuous numerical variable, enabling calculations of averages and measures of spread.

在Edexcel统计学中，你会学到一手数据和二手数据。对于这个项目，我们将使用来自大学网站或UCAS招生简章的二手数据。记录收集日期并确保数据的可靠性和准确性非常重要。我们还决定使用UCAS分数作为连续数值变量来衡量入学要求，从而能够计算平均值和离散程度指标。

3. Data Collection and Organisation | 数据收集与整理

Below is a table of 14 UK universities offering Economics degrees, showing the typical A-level offer and the corresponding UCAS tariff points. The tariff points are calculated by summing the point values of the three A-level grades. This organised data set allows us to begin our statistical analysis.

下表列出了14所开设经济学学位的英国大学，显示了典型的A-level录取条件和相应的UCAS分数。分值是通过将三个A-level等级的点数相加计算得出的。这个整理好的数据集使我们能够开始统计分析。

University	Course	Typical Offer	UCAS Tariff Points
University of Cambridge	Economics	A*A*A	160
University of Oxford	Economics & Management	A*AA	152
London School of Economics	Economics	A*AA	152
Imperial College London	Economics, Finance & Data Science	A*AA	152
University College London	Economics	A*AA	152
University of Warwick	Economics	A*AA	152
University of Edinburgh	Economics	A*AA	152
University of Bristol	Economics	AAA	144
University of Manchester	Economics	AAA	144
Durham University	Economics	A*AA	152
University of Bath	Economics	A*AA	152
University of Liverpool	Economics	ABB	128
University of Leicester	Economics	BBB	120
Coventry University	Economics	BBC	112

As an Edexcel Statistics student, you learn to recognise that the tariff points variable here is quantitative and continuous (though recorded as whole numbers). You would then enter these values into a spreadsheet or statistical software, or simply use pen and paper, to construct frequency tables and graphs.

作为Edexcel统计学的学生，你要学会识别这里的分数变量是定量且连续的（尽管记录为整数）。然后你会将这些数值输入电子表格或统计软件，或者仅用纸笔，来构建频数表和图形。

---

广告 / Sponsored

4. Frequency Tables and Bar Charts | 频数表和条形图

To summarise the data, we can create a grouped frequency table. Let us group the tariff points into intervals of width 8, starting from 110: 110–117, 118–125, 126–133, 134–141, 142–149, 150–157, 158–165. By counting how many universities fall into each interval, we obtain the following distribution.

为了汇总数据，我们可以创建一个分组频数表。让我们将分数以8为组距进行分组，从110开始：110–117、118–125、126–133、134–141、142–149、150–157、158–165。通过计算每个区间内的大学数量，我们得到如下分布。

Tariff Points Interval	Frequency
110 – 117	2
118 – 125	1
126 – 133	1
134 – 141	0
142 – 149	2
150 – 157	8
158 – 165	1

From this table, we can draw a bar chart where the horizontal axis represents the tariff point intervals and the vertical axis shows the frequency. A bar chart is suitable because the intervals are treated as discrete categories even though the data is continuous. The chart immediately reveals the shape of the distribution: it is clustered around the 150–157 interval, indicating that a typical offer for Economics at these universities is in the range of 150–157 points, which corresponds to A*AA grades.

根据这个表格，我们可以绘制条形图，横轴表示分数区间，纵轴表示频数。条形图是合适的，因为尽管数据是连续的，但区间被当作离散类别处理。该图立即揭示了分布的形状：数据集中在150–157区间，表明这些大学经济学专业的典型录取分数在150–157分范围内，这相当于A*AA的成绩。

---

5. Measures of Central Tendency | 集中趋势的度量

We can calculate the mean, median and mode of the UCAS tariff points to find a typical value. Using the raw data from our table of 14 universities, we first calculate the mean.

我们可以计算UCAS分数的平均值、中位数和众数，以找出典型值。使用我们14所大学表格中的原始数据，我们首先计算平均值。

Mean = (Sum of all tariff points) ÷ (Number of universities)

erage suggests the typical entry tariff is around the AAA level (144 points). However, the mean might be pulled down by lower values.

总和 = 160 + 152 + 152 + 152 + 152 + 152 + 152 + 144 + 144 + 152 + 152 + 128 + 120 + 112 = 1996。大学数量 = 14。因此，平均值 = 1996 ÷ 14 ≈ 142.6。这个平均值表明典型入学分数大约在AAA等级（144分）附近。然而，平均值可能会被较低的值拉低。

median is the average of the 7th and 8th values. Both are 152, so Median = 152. This indicates that half of the universities require 152 points or fewer, and half require 152 points or more. The mode is 152, as it occurs eight times, far more than any other value.

为了找到中位数，我们将数据从小到大排序：112, 120, 128, 144, 144, 152, 152, 152, 152, 152, 152, 152, 152, 160。有14个值，中位数就是第7和第8个值的平均值。两者都是152，因此中位数 = 152。这表明一半的大学要求152分或更低，一半要求152分或更高。众数是152，因为它出现了八次，远多于任何其他值。

Comparing the mean (142.6) and median (152) shows the mean is lower, indicating a negatively skewed distribution. This is because a few universities with lower requirements (e.g. 112, 120) reduce the mean, while the median remains at the common higher tariff. This is an important concept in Edexcel Statistics: recognising how outliers affect measures of central tendency.

比较平均值（142.6）和中位数（152）可以看出平均值较低，这表明分布呈负偏态。这是因为少数要求较低的大学（例如112、120）拉低了平均值，而中位数保持在常见的高分值上。这是Edexcel统计学中的一个重要概念：识别异常值如何影响集中趋势的度量。

---

6. Measures of Spread | 离散程度的度量

ge. From the ordered list, the highest tariff is 160 and the lowest is 112, so Range = 160 – This tells us the difference between the most and least competitive offers in our sample.

离散程度的度量描述数据的差异性有多大。最简单的度量是极差。根据排序列表，最高分是160，最低分是112，因此极差 = 160 – 112 = 48。这告诉我们样本中最具竞争力和最不具竞争力的录取条件之间的差异。

bust measure is the interquartile range (IQR), which describes the spread of the middle 50% alues: 112, 120, 128, 144, 144, 152, 152), so Q1 = 144. Q3 is the median of the upper half (last 7 values: 152, 152, 152, 152, 152, 152, 160), so Q3 = 152. Thus, IQR = Q3 – Q1 = 152 – onfirms that the central half of the universities have offers tightly clustered around 144–152 points.

一个更稳健的度量是四分位距（IQR），它描述了中间50%数据的离散程度。要找到IQR，我们首先确定下四分位数（Q1）和上四分位数（Q3）。对于14个值，Q1是低半部分（前7个值：112, 120, 128, 144, 144, 152, 152）的中位数，因此Q1 = 144。Q3是高半部分（后7个值：152, 152, 152, 152, 152, 152, 160）的中位数，因此Q3 = 152。因此，IQR = Q3 – Q1 = 152 – 144 = 8。这个非常小的IQR证实，中间一半大学的录取条件紧密聚集在144–152分之间。

Box plots are an excellent way to display these measures visualy. A box plot for our data would show a median at 152, a box from 144 to 152, and whiskers extending to the minimum 112 and maximum 160. The long left whisker highlights the negative skew we observed earlier. In Edexcel Statistics, you will learn to construct and interpret such diagrams to compare distributions.

箱线图是可视化显示这些度量的绝佳方式。我们数据的箱线图会显示中位数为152，箱体从144到152，触须延伸至最小值112和最大值160。长左须突显了我们之前观察到的负偏态。在Edexcel统计学中，你将学习构建和解读此类图表以比较分布。

---

7. Comparing Groups: Russell Group vs Non-Russell Group | 对比组别：罗素集团与非罗素集团

Our sample contains both Russell Group (research-intensive) universities and non-Russell Group institutions. We can split the data into two groups: Russell Group includes Cambridge, Oxford, LSE, Imperial, UCL, Warwick, Edinburgh, Bristol, Manchester, Durham (10 universities); non-Russell Group includes Liverpool, Leicester, Coventry (3 universities) plus perhaps others if added, but for simplicity let us use the three named. Their tariff points are 128, 120, 112. We can compare the median and IQR.

我们的样本既包含罗素集团（研究密集型）大学，也包含非罗素集团院校。我们可以将数据分成两组：罗素集团包括剑桥、牛津、伦敦政经、帝国理工、伦敦大学学院、华威、爱丁堡、布里斯托、曼彻斯特、杜伦（10所大学）；非罗素集团包括利物浦、莱斯特、考文垂（3所大学），如果添加其他院校也可以，但为简单起见，我们使用这三所命名的。它们的分数分别为128、120、112。我们可以比较中位数和IQR。

52 (upper half median) actually Q3 calculation: upper half 152,152,152,152,160 → median 152, so IQR = 0 for this subset, showing extremely low variation among the top group apart from the two with AAA (144) and one with A*A*A (160). The non-Russell Group values are 112, 120, 128, giving median = 120, IQR = Q3 – Q1 = 128 – 112 = 16.

对于罗素集团，排序后的分数为：144,

Published by TutorHao | Year 10 统计 Revision Series | aleveler.com

更多咨询请联系16621398022（同微信）