Summative Assessment on Covid 19 Impact on Socially-Distanced Contact with People Aged Under 18

SUMMATIVE
ASSESSMENT

Contents
1.Brief Description about Covid 19:......................................................................................3
2.Raw Data Presentation:.......................................................................................................3
3.Statistical Technique:..........................................................................................................4
4.Data Manipulation:..............................................................................................................6
5.Representation in Charts and Graphs:.................................................................................8
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12

MAIN BODY
1.Brief Description about Covid 19:
The data set which is considered to perform the task in Covid 19 which has affected the entire
globe with its huge impact on industry, business world, health of the people very severely for
almost during 2020. The data which has been considered to perform the test are socially contact
distanced with people having the age group of under 18 with other people so that analysis has
been carried out accordingly that how fast such pandemic has spread amongst the group of
individual. The period which has been considered in this report starts from July 2020 to February
2020 that is almost 1.50 years so that accuracy can be maintained with respect of inputs that have
been placed. In this report the raw data has been considered as base to evaluate the results
accordingly and then on that set of data the statistical techniques has been performed which
includes calculation of mean, median, mode etc. Thereafter the data manipulation techniques
have been performed such as sum, count, average, minimum, average etc. for the given set of
data relating to Covid 19.
2.Raw Data Presentation:
Time period
Socially-distanced contact with people aged under 18
Proportion
that had
contact
with 0
individuals
Proportion
that had
contact
with 1-5
individuals
Proportion
that had
contact
with 6-10
individuals
Proportion
that had
contact
with 11-20
individuals
Propo
rtion
that
had
contac
t with
21 or
more
individ
uals
19 July 2020 to 01 August 2020 0.38 0.37 0.12 0.06 0.07
02 August 2020 to 15 August 2020 0.38 0.36 0.13 0.07 0.07
16 August 2020 to 29 August 2020 0.38 0.35 0.13 0.07 0.07
30 August 2020 to 12 September 2020 0.22 0.16 0.08 0.09 0.45
13 September 2020 to 26 September 2020 0.17 0.08 0.06 0.08 0.60
27 September 2020 to 10 October 2020 0.18 0.07 0.06 0.07 0.62
11 October 2020 to 24 October 2020 0.19 0.07 0.05 0.07 0.61
25 October 2020 to 07 November 2020 0.24 0.11 0.06 0.07 0.51
08 November 2020 to 21 November 2020 0.20 0.06 0.04 0.07 0.63
22 November 2020 to 05 December 2020 0.20 0.05 0.04 0.07 0.64

06 December 2020 to 19 December 2020 0.18 0.05 0.04 0.07 0.66
20 December 2020 to 02 January 2021 0.51 0.21 0.04 0.04 0.21
03 January 2021 to 16 January 2021 0.67 0.17 0.05 0.04 0.07
17 January 2021 to 30 January 2021 0.68 0.17 0.06 0.05 0.05
31 January 2021 to 13 February 2021 0.66 0.19 0.05 0.05 0.05
14 February 2021 to 27 February 2021 0.62 0.24 0.05 0.05 0.04
28 February 2021 to 13 March 2021 0.43 0.17 0.06 0.07 0.27
14 March 2021 to 27 March 2021 0.17 0.05 0.04 0.08 0.66
28 March 2021 to 10 April 2021 0.24 0.15 0.07 0.07 0.47
11 April 2021 to 24 April 2021 0.24 0.16 0.07 0.08 0.46
25 April 2021 to 08 May 2021 0.13 0.05 0.05 0.07 0.70
09 May 2021 to 22 May 2021 0.12 0.05 0.04 0.07 0.72
23 May 2021 to 05 June 2021 0.15 0.08 0.06 0.07 0.63
06 June 2021 to 19 June 2021 0.16 0.08 0.05 0.07 0.64
20 June 2021 to 03 July 2021 0.14 0.06 0.05 0.06 0.69
04 July 2021 to 17 July 2021 0.16 0.06 0.05 0.06 0.67
18 July 2021 to 31 July 2021 0.27 0.16 0.08 0.06 0.43
01 August 2021 to 14 August 2021 0.36 0.26 0.13 0.08 0.17
15 August 2021 to 28 August 2021 0.36 0.26 0.13 0.08 0.17
29 August 2021 to 11 September 2021 0.23 0.17 0.09 0.07 0.45
12 September 2021 to 25 September 2021 0.10 0.04 0.03 0.05 0.78
26 September 2021 to 09 October 2021 0.10 0.03 0.03 0.05 0.79
10 October 2021 to 23 October 2021 0.10 0.03 0.03 0.04 0.80
24 October 2021 to 06 November 2021 0.17 0.09 0.06 0.06 0.62
07 November 2021 to 20 November 2021 0.09 0.03 0.02 0.05 0.82
21 November 2021 to 04 December 2021 0.09 0.03 0.03 0.04 0.81
05 December 2021 to 18 December 2021 0.08 0.03 0.03 0.04 0.82
19 December 2021 to 01 January 2022 0.29 0.17 0.06 0.05 0.43
02 January 2022 to 15 January 2022 0.19 0.10 0.05 0.05 0.61
16 January 2022 to 29 January 2022 0.09 0.03 0.02 0.04 0.81
30 January 2022 to 12 February 2022 0.08 0.02 0.03 0.04 0.83
13 February 2022 to 26 February 2022 0.11 0.06 0.04 0.05 0.73
3.Statistical Technique:
Time period
Socially-distanced contact with people aged under 18
Proportion
that had
contact
with 0
individuals
Proportion
that had
contact
with 1-5
individuals
Proportion
that had
contact
with 6-10
individuals
Proportion
that had
contact
with 11-20
individuals
Prop
ortio
n
that
had