Political donations 2020
Download the Excel workbook at bit.ly/parties2020.

It shows donations made to UK political parties in 2020 and is taken from the Electoral Commission website.

Tidy up the dataset:

- duplicate the sheet with the data (as a backup)
- delete columns you think you don't need
- freeze the top row (under the 'View' tab)
- adjust the 'Value' column to a simple number with no pence (Format / Cells / Number)
- rename any column names you want to improve

Answer the questions below.
登入 Google 即可儲存進度。瞭解詳情
1. How many donations are listed?
清除選取的項目
2. How many donations were made by individuals?
清除選取的項目
3. How many donations were made to the Animal Welfare Party?
清除選取的項目
4. Using a filter (for party) and the automatic calculations in the bottom right, choose the correct order for these Northern Ireland parties (from biggest to smallest amount received).
清除選取的項目
5. What, roughly, was the average value of a donation to a political party in 2020?
清除選取的項目
6. Filtering by quarter ('Q2 2020') and donor ('HMRC' or variations of) and party, find the amount collected by the Conservative Party through the furlough scheme, in the second quarter of 2020.
清除選取的項目
7. Repeat for the Labour party and the Liberal Democrats. (You can check your answers against the third paragraph in this article: https://www.bbc.co.uk/news/uk-politics-54010431)
清除選取的項目
8. Now we want to see how all the parties compare in terms of amounts received in 2020. Remove all filters, then add a pivot table ('Data/Summarise with Pivot Table') in a new sheet. Build the table with the parties as rows and the donations as the values. Which party is tenth in order of donations received, with almost £273,000? (Stuck? Get help here: bit.ly/helpanswers)
清除選取的項目
提交
清除表單
Google 並未認可或建立這項內容。 檢舉濫用情形 - 服務條款 - 隱私權政策
Google 表單