Mathematics AI SL's Sample Internal Assessment

Mathematics AI SL's Sample Internal Assessment

To what extent is there a Co-relation between the number of individuals who are going out to their workplaces after Lockdown and the number of individuals who are getting infected by COVID-19?

6/7
6/7
10 mins read
10 mins read
Candidate Name: N/A
Candidate Number: N/A
Session: N/A
Word count: 1,937

Table of content

Rationale

The world has turned upside down after the spread of corona virus. We all are fighting with the virus in our own ways. To practice social distancing, the world had gone to a lockdown.

 

It has been months. No school, no outings, no vacations, no playing in parks; we are confined to our houses. The world could not be locked down for months, so with all safety measures it is trying to get back to its workings.

 

With every passing day, there is so much deaths and active corona cases. It is really disheartening. Though there is no more lockdown, we prefer staying at home. We do not go out until any need.

 

With everything getting back to normal, a news of reopening schools was surfacing for quite some time for which parents' consent was required.

 

The decision of going to school required a lot of research because that could not only cost me and my friends and family getting infected but also could cost our lives.

 

I went on to research more about the spread of the virus. I read many articles, surfed the internet and got to know many factors, precautions and many more. I could not get the answer I was looking for. However, reading several newspapers and statistical data that has been reported collecting data from a number of companies in the cities has helped to get a clear idea about the number of individuals who were bound to go out of their houses to their work places after remission of lockdown period.

 

I wanted to know to what extent there is a relation between the number of individuals going out to their workplaces after lockdown and the number of individuals getting infected by COVID – 19.

 

This IA is about the same. This research would allow my family to decide if I should attend school or should I continue with my online classes.

Aim

The main motive of this IA is to show a correlation between the number of employees and working professionals those who are getting infected by COVID-19 with respect to the number of working professionals going out right after calling off the Lockdown.  The study will show the effect of Lockdown during the COVID-19 pandemic on the rate of spreading after remission of it. It will also redirect to the fact how much it is safe for individuals to go out for work after Lockdown.

Research question

What is the relationship between the number of individuals who are going out to their workplaces after Lockdown and the number of individuals who are getting infected by COVID-19?

Introduction

COVID – 19 was one of the most infectious diseases the world has ever seen. It has spread throughout the globe within a span of 3 to 5 months. Originating from the city of Yuhan in China, it has spread to different countries including the far west – The USA. One of the most affect countries is India. From the month of March to July, complete Lockdown was called by the government to cope up with the pandemic and restrict the spread. However, lockdown was called off by the government since August and emergency services, such as, banking sector, media, etc. were allowed to start their usual operation. In this process, the infection of COVID – 19 is again taking its pace in an increasing order.

 

In this IA, data of the number of attendees of 20 companies situated in Mumbai, Delhi, and Kolkata, the three most affected cities of India, has been collected and the number of employees who got infected were noted. This collection is done for three different age groups from 25 years old to 55 years old with an interval of 10 years. This will help to analyze the spread of infection among individuals of different age groups after lockdown.

Data collection

The data collection for this correlative analysis has been done from a number of internationalized media houses and newspaper which are considered as authentic sources of information.

Sl. No.Total number of individualsNumber of individuals infected
115021
216018
315030
412012
520021
614018
716020
815040
917015
1015021
111206
121608
1315030
1416031
1512013
1615010
171407
1818017
191606
2012020

Figure 1 - Table On Number Of Individuals Getting Infected By COVID-19 Out Of The Individuals Those Were Going Out For Work Of The Age Group 25 Years To 35 Years

Sl. No.Total number of individualsNumber of individuals infected
11504
21606
31509
41203
52008
614010
71600
81500
917012
101503
1112030
121601
131505
141603
151201
161509
171404
181807
191606
201203

Figure 2 - Table On Number Of Individuals Getting Infected By COVID-19 Out Of The Individuals Those Were Going Out For Work Of The Age Group 35 Years To 45 Years

Sl. No.Total number of individualsNumber of individuals infected
115034
216036
315032
412024
520021
61403
716025
815028
917032
1015034
1112021
1216014
1315025
1416023
1512020
1615021
1714022
1818027
1916034
2012021

Figure 3 - Table On Number Of Individuals Getting Infected By COVID-19 Out Of The Individuals Those Were Going Out For Work Of The Age Group 45 Years To 55 Years

Processed data

Sl. No.Cumulative total number of individualsCumulative number of infected individuals
115021
231039
346069
458081
5780102
6920120
71080140
81230180
91400195
101550216
111670222
121830230
131980260
142140291
152260304
162410314
172550321
182730338
192890344
203010364

Figure 4 - Table On Cumulative Frequency Table For The Age Group Of 25 Years To 35 Years

Sl. No.Cumulative total number of individualsCumulative number of infected individuals
11504
231010
346019
458022
578030
692040
7108040
8123040
9140052
10155055
11167085
12183086
13198091
14214094
15226095
162410104
172550108
182730115
192890121
203010124

Figure 5 - Table On Cumulative Frequency Table For The Age Group Of 35 Years To 45 Years

Sl. No.Cumulative total number of individualsCumulative number of infected individuals
115034
231070
3460102
4580126
5780147
6920150
71080175
81230203
91400235
101550269
111670290
121830304
131980329
142140352
152260372
162410393
172550415
182730442
192890476
203010497

Figure 6 - Table On Cumulative Frequency Table For The Age Group Of 45 Years To 55 Years

Graphical analysis

Figure 7 - Cumulative Number Of Individuals Getting Infected By COVID-19 With Respect To Cumulative Individuals Those Were Going Out For Work Of The Age Group 25 Years To 35 Years

Figure 8 - Number Of Individuals Getting Infected By COVID-19 With Respect To The Individuals Those Were Going Out For Work Of The Age Group 25 Years To 35 Years

Figure 9 - Cumulative Number Of Individuals Getting Infected By COVID-19 With Respect To Cumulative Individuals Those Were Going Out For Work Of The Age Group 35 Years To 45 Years

Figure 10 - Number Of Individuals Getting Infected By COVID-19 With Respect To The Individuals Those Were Going Out For Work Of The Age Group 35 Years To 45 Years

Figure 11 - Cumulative Number Of Individuals Getting Infected By COVID-19 With Respect To Cumulative Individuals Those Were Going Out For Work Of The Age Group 45 Years To 55 Years

Figure 12 - Number Of Individuals Getting Infected By COVID-19 With Respect To The Individuals Those Were Going Out For Work Of The Age Group 45 Years To 55 Years

Calculation of R2

x

y

x2

y2

xy

15021225004413150
3103996100152112090
46069211600476131740
58081336400656146980
7801026084001040479560
92012084640014400110400
1080140116640019600151200
1230180151290032400221400
1400195196000038025273000
1550216240250046656334800
1670222278890049284370740
1830230334890052900420900
1980260392040067600514800
2140291457960084681622740
2260304510760092416687040
2410314580810098596756740
25503216502500103041818550
27303387452900114244922740
28903448352100118336994160
301036490601001324961095640
∑x = 31930∑y = 4151

∑x2 = 66084300

∑y2 = 1088363

∑xy = 8468370

Figure 13 - Table On Processed Data For Calculation Of Correlation Coefficient R2 For Group 1 (25 Years To 35 Years)

\(r = \frac{n\bigg(∑xy\bigg)-(∑x)(∑y)}{\sqrt{[n∑x^2-\bigg(∑x\bigg)^2][n∑y^2-\bigg(∑y\bigg)^2]}}\)

 

\(r = \frac{20×8468370-(31930)(4151)}{[20×66084300-(31930)^2][20×1088363-(4151)^2]}\)

 

=> r2 = 0.9894

x

y

x2

y2

xy

15042250016600
31010961001003100
460192116003618740
5802233640048412760
7803060840090023400
92040846400160036800
1080401166400160043200
1230401512900160049200
1400521960000270472800
1550552402500302585250
16708527889007225141950
18308633489007396157380
19809139204008281180180
21409445796008836201160
22609551076009025214700
2410104580810010816250640
2550108650250011664275400
2730115745290013225313950
2890121835210014641349690
3010124906010015376373240
∑x = 31930∑y = 1335

∑x= 66084300

∑y2 = 118875

∑xy = 2794140

Figure 14 - Table On Processed Data For Calculation Of Correlation Coefficient R2 For Group 2 (35 Years To 45 Years)

\(r = \frac{n\bigg(∑xy\bigg)-(∑x)(∑y)}{\sqrt{[n∑x^2-\bigg(∑x\bigg)^2][n∑y^2-\bigg(∑y\bigg)^2]}}\)

 

\(=> r = \frac{20×2794140-(31930)(1335)}{\sqrt{[20×66084300-(31930)^2][20×118875-(1335)^2]}}\)

 

=> r2 = 0.977

x

y

x2

y2

xy

150342250011565100
3107096100490021700
4601022116001040446920
5801263364001587673080
78014760840021609114660
92015084640022500138000
1080175116640030625189000
1230203151290041209249690
1400235196000055225329000
1550269240250072361416950
1670290278890084100484300
1830304334890092416556320
19803293920400108241651420
21403524579600123904753280
22603725107600138384840720
24103935808100154449947130
255041565025001722251058250
273044274529001953641206660
289047683521002265761375640
301049790601002470091495970
∑x = 31930∑y = 5381

∑x= 66084300

∑y2 = 1818533

∑xy = 10953790

Figure 15 - Table On Processed Data For Calculation Of Correlation Coefficient R2 For Group 2 (45 Years To 55 Years)

\(r = \frac{n\bigg(∑xy\bigg)-(∑x)(∑y)}{\sqrt{[n∑x^2-\bigg(∑x\bigg)^2][n∑y^2-\bigg(∑y\bigg)^2]}}\)

 

\(=> r = \frac{20×10953790-(31930)(5381)}{\sqrt{[20×66084300-(31930)^2][20×1818533-(5381)^2]}}\)

 

=> r2 = 0.9968

Calculation of pearson’s correlation coefficient

x

y

\( x-\bar x\)

\(y-\bar y\)

\((x-\bar x)(y-\bar y)\)

\((x-\bar x)^2\)

\((y-\bar y)^2\)

150211596.5207.55-1446.5-186.55269844.575
310391596.5207.55-1286.5-168.55216839.575
460691596.5207.55-1136.5-138.55157462.075
580811596.5207.55-1016.5-126.55128638.075
7801021596.5207.55-816.5-105.5586181.575
9201201596.5207.55-676.5-87.5559227.575
10801401596.5207.55-516.5-67.5534889.575
12301801596.5207.55-366.5-27.5510097.075
14001951596.5207.55-196.5-12.552466.075
15502161596.5207.55-46.58.45-392.925
16702221596.5207.5573.514.451062.075
18302301596.5207.55233.522.455242.075
19802601596.5207.55383.552.4520114.575
21402911596.5207.55543.583.4545355.075
22603041596.5207.55663.596.4563994.575
24103141596.5207.55813.5106.4586597.075
25503211596.5207.55953.5113.45108174.575
27303381596.5207.551133.5130.45147865.075
28903441596.5207.551293.5136.45176498.075
30103641596.5207.551413.5156.45221142.075

Figure 16 - Table On Processed Data Table For Calculation Of Pearson’s Correlation Coefficient In Group 1

Calculation:

 

\(\bar x=\frac{∑x}{N}=\frac{31930}{20}=1596.5\)

 

\(\bar y=\frac{∑y}{N}=\frac{4151}{20}=207.55\)

 

\(∑(x-\bar x)(y-\bar y)=1841298.5\)

 

\(∑(x-\bar x)^2=15108055\)

 

\(∑(y-\bar y)^2=226822.95\)

 

Let, the Pearson’s Correlation Coefficient be .

 

\(R = \frac{∑(x-\bar x)(y-\bar y)}{∑(x-\bar x)^2\times∑(y-\bar y)^2}\)

 

\(=> R =​​​​​​​ \frac{1841298.5}{15108055226822.95}\)

 

R = 0.998

x

y

\( x-\bar x\)

\(y-\bar y\)

\((x-\bar x)(y-\bar y)\)

\((x-\bar x)^2\)

\((y-\bar y)^2\)

15041596.566.75-1446.5-62.7590767.875
310101596.566.75-1286.5-56.7573008.875
460191596.566.75-1136.5-47.7554267.875
580221596.566.75-1016.5-44.7545488.375
780301596.566.75-816.5-36.7530006.375
920401596.566.75-676.5-26.7518096.375
1080401596.566.75-516.5-26.7518096.375
1230401596.566.75-366.5-26.759803.875
1400521596.566.75-196.5-14.752898.375
1550551596.566.75-46.5-11.75546.375
1670851596.566.7573.518.251341.375
1830861596.566.75233.519.254494.875
1980911596.566.75383.524.259299.875
2140941596.566.75543.527.2514810.375
2260951596.566.75663.528.2518743.875
24101041596.566.75813.537.2530302.875
25501081596.566.75953.541.2539331.875
27301151596.566.751133.548.2554691.375
28901211596.566.751293.554.2570172.375
30101241596.566.751413.557.2580922.875

Figure 17 - Table On Processed Data Table For Calculation Of Pearson’s Correlation Coefficient In Group 2

Calculation

 

\(\bar x=\frac{\sum x}{N}=\frac{31930}{20} = 1596.5\)

 

\(\bar y=\frac{\sum y}{N}=\frac{1335}{20} = 66.75\)

 

\(\sum(x-\bar x)(y-\bar y)=662812.5\)

 

\(\sum(x-\bar x)^2=15108055\)

 

\(\sum(y-\bar y)^2=29763.75\)

 

Let, the Pearson’s Correlation Coefficient be .

 

\(R=\frac{\sum(x-\bar x)(y-\bar y)}{\sqrt{\sum(x-\bar x)^2\times\sum(y-\bar y)}}\)

 

\(=>R=\frac{662812.5}{\sqrt{15108055\times29763.75}}\)

 

R = 0.988

x

y

\(x-\bar x\)

\(y-\bar y\)

\((x-\bar x)(y-\bar y)\)

\((x-\bar x)^2\)

\((y-\bar y)^2\)

150341596.5269.05-1446.5-235.05339999.825
310701596.5269.05-1286.5-199.05256077.825
4601021596.5269.05-1136.5-167.05189852.325
5801261596.5269.05-1016.5-143.05145410.325
7801471596.5269.05-816.5-122.0599653.825
9201501596.5269.05-676.5-119.0580537.325
10801751596.5269.05-516.5-94.0548576.825
12302031596.5269.05-366.5-66.0524207.325
14002351596.5269.05-196.5-34.056690.825
15502691596.5269.05-46.5-0.052.325
16702901596.5269.0573.520.951539.825
18303041596.5269.05233.534.958160.825
19803291596.5269.05383.559.9522990.825
21403521596.5269.05543.582.9545083.325
22603721596.5269.05663.5102.9568307.325
24103931596.5269.05813.5123.95100833.325
25504151596.5269.05953.5145.95139163.325
27304421596.5269.051133.5172.95196038.825
28904761596.5269.051293.5206.95267689.825
30104971596.5269.051413.5227.95322207.325

Figure 18 - Table On Processed Data Table for calculation of Pearson’s Correlation Coefficient in Group 3

Calculation

 

\(\bar x=\frac{\sum x}{N}=\frac{31930}{20} = 1596.5\)

 

\(\bar y=\frac{\sum y}{N}=\frac{5381}{20}= 269.05\)

 

\(\sum(x-\bar x)(y-\bar y)=2363023.5\)

 

\(\sum(x-\bar x)^2=15108055\)

 

\(\sum(y-\bar y)^2=370774.95\)

 

Let, the Pearson’s Correlation Coefficient be .

 

\(R=\frac{\sum (x-\bar x)(y-\bar y)}{\sqrt{\sum(x-\bar x)^2\times\sum(y-\bar y)^2}}\)

 

\(=> R=\frac{2363023.5}{\sqrt{15108055370774.95}}\)

 

R = 0.998

Conclusion

In this IA, a correlation has been developed between the total number of individuals who are going to their respective work places after calling off of Lockdown in India and thereby getting infected by COVID-19. For the first group, i.e., between the age of 25 years and 35 years, working individuals are getting infected by COVID-19 in an increasing fashion. The trendline shows an increasing direct relationship between the number of individuals going out for their work and the ones those who are getting infected. The equation of the trendline is shown below:

 

y = 0.1219x + 12.976

 

The value of R2 correlation coefficient for the graph is 0.9894 which validates the fact that the relation is linear and increasing. Furthermore, the value of Pearson’s Correlation Coefficient for this graph is 0.998. As the value is very close to 1, it justifies the claim that the relationship is linear and being a positive value, it satisfies the claim that the relationship is increasing or direct. The reason behind such a correlation is assumed to be the work load that is there on the individuals of this age group. On the other hand, being on the lower side of the age group, their immunity is comparatively less strong than that of the other age groups. Thus, the spread of infection is taking a significant number in this age group.

 

For the second group, i.e., between the age of 35 years and 45 years, working individuals are getting infected by COVID-19 is showing a direct increasing relation. The equation of the trendline is shown below:

 

y = 0.0439x - 3.2908

 

The value of R2 correlation coefficient for the graph is 0.977 which validates the fact that the relation is linear and increasing. Furthermore, the value of Pearson’s Correlation Coefficient for this graph is 0.988. As the value is very close to 1, it justifies the claim that the relationship is linear and being a positive value, it satisfies the claim that the relationship is increasing or direct. The spread is comparatively less in this group as the immunity of the individuals of this age group is considerably more and with an increase in age, people often tend to be more cautious and aware and take significant preventive measures to protect them from the disease.

 

Finally, in the third group, i.e., between the age of 45 years and 55 years, working individuals are getting infected by COVID-19 is showing a direct increasing relation. The equation of the trendline is shown below:

 

y = 0.1564x + 19.344

 

The value of R2 correlation coefficient for the graph is 0.9968 which validates the fact that the relation is linear and increasing. Furthermore, the value of Pearson’s Correlation Coefficient for this graph is 0.998. As the value is very close to 1, it justifies the claim that the relationship is linear and being a positive value, it satisfies the claim that the relationship is increasing or direct. This group has shown maximum infection than that of the other groups. It is due to the fact that, this age group is quite close to the limit of senior citizens. According to the doctors, people aged more than 50 are more vulnerable to the disease which is significantly proved in its correlative study.

Bibliography

  • Novel, Coronavirus Pneumonia Emergency Response Epidemiology. "The epidemiological characteristics of an outbreak of 2019 novel coronavirus diseases (COVID-19) in China." Zhonghua liu xing bing xue za zhi= Zhonghua liuxingbingxue zazhi 41.2 (2020): 145.
  • India Coronavirus: 8,041,051 Cases and 120,583 Deaths - Worldometer.https://www.worldometers.info/coronavirus/country/india/. Accessed 29 Oct. 2020.
  • “How Does Coronavirus Spread?” WebMD,https://www.webmd.com/lung/coronavirus-transmission-overview. Accessed 29 Oct. 2020.
  • Desk, The Hindu Net. “Coronavirus India Lockdown Day 169 Updates | September 10, 2020.” The Hindu, 10 Sept. 2020. www.thehindu.com,https://www.thehindu.com/news/national/coronavirus-india-lockdown-september-10-2020-live-updates/article32567344.ece.
  • “Covid 19 Lockdown: How India Compares to Other Coronavirus Hotbeds.” The Economic Times. The Economic Times,https://economictimes.indiatimes.com/news/politics-and-nation/lockdown-stats-how-india-compares-to-other-coronavirus-hotbeds/articleshow/74805295.cms. Accessed 6 Nov. 2020.
  • “India - Online Deliveries after COVID-19 Lockdown 2020.” Statista,https://www.statista.com/statistics/1115652/india-coronavirus-post-lockdown-purchase-e-commerce/. Accessed 6 Nov. 2020.
  • Benesty, Jacob, et al. "Pearson correlation coefficient." Noise reduction in speech processing. Springer, Berlin, Heidelberg, 2009. 1-4