SOLUTION: Coronavirus Vaccinated Data | My Assignment Tutor

Coronavirus VaccinatedDataUK Comparison with USA and Israel(number of total vaccinated people) The outcomes of this case study will beas follow.Define and ApplyMean(Average),Median,Mode,Sum,Count, Max and Min.With help of Graphs, Charts and Tables and we will comparevaccinated people data among the following countries.UKUSAISRAELAnd we will find the comparison in percentage aswell.Average(Mean), Median, Mode, Sum,Count, Max and Min. Mean:The mean (average) of a data set is found by adding all numbers in the data set and then dividing by the number ofvalues in the set. Median:The median is the middle value when a data set is ordered from least to greatest. Mode:The mode is the number that occurs most often in a data set. Sum:The sum total of all numbers in the rows that match this criteria Count: Counts the number of cells in a range than contain numbers Max:The highest number in all of the rows that match this criteria Min :The lowest number in all of the rows that match this criteriaAverage, Median,Mode,Sum,Count,Max and Min(UK,USA,ISRAEL) Row LabelsSum of USASum of IsraelSum of UK01/01/2021 – 07/01/202124,851,700.009,998,624.0008/01/2021 – 14/01/202134,693,448.0014,216,430.0017,026,168.0015/01/2021 – 21/01/202160,375,109.0019,643,713.0033,941,954.0022/01/2021 – 28/01/2021158,616,157.0028,382,032.0051,484,001.0029/01/2021 – 04/02/2021222,671,088.0035,591,299.0071,251,758.0005/02/2021 – 11/02/2021293,852,160.0040,663,888.0092,625,193.0012/02/2021 – 18/02/2021321,176,756.0046,605,412.00113,615,135.0019/02/2021 – 25/02/2021447,913,798.0052,784,654.00131,174,853.0026/02/2021 – 01/03/2021218,496,247.0024,143,025.0062,427,808.00Grand Total1,782,646,463.00272,029,077.00573,546,870.00Average198,071,829.2230,225,453.0071,693,358.75MEDIAN218,496,247.0028,382,032.0066,839,783.00MODE#N/A#N/A#N/ASum1,782,646,463.00272,029,077.00573,546,870.00Count998Max447,913,798.0052,784,654.00131,174,853.00Min24,851,700.009,998,624.0017,026,168.00 UK Comparisonwith USA andIsrael(number of total vaccinatedpeople)• UK• USA• ISRAEL–50,000,000.00100,000,000.00150,000,000.00200,000,000.00250,000,000.00300,000,000.00350,000,000.00400,000,000.00450,000,000.00500,000,000.00Sum of USASum of Israel Sum of UK-Total vaccinated • Total• Vaccinated• UK• USA• ISRAEL–50,000,000.00100,000,000.00150,000,000.00200,000,000.00250,000,000.00300,000,000.00350,000,000.00400,000,000.00450,000,000.00500,000,000.00Sum of USASum of IsraelSum of UK-Totalvaccinated Applying percentage on vaccinated people among UK, USA and ISRAEL Row LabelsSum of USAPercentage of populationgot VaccinatedSum of IsraelPercentage of populationgot VaccinatedSum of UK-TotalvaccinatedPercentage of populationgot VaccinatedTotalPopulation01/01/2021 –07/01/202124,851,700.000.1%9,998,624.001%0%USA331,000,000.0008/01/2021 –14/01/202134,693,448.000.1%14,216,430.002%17,026,168.000%UK67,886,011.0015/01/2021 –21/01/202160,375,109.000.2%19,643,713.002%33,941,954.000%Israel9,291,000.0022/01/2021 –28/01/2021158,616,157.000.5%28,382,032.003%51,484,001.001%29/01/2021 –04/02/2021222,671,088.000.7%35,591,299.004%71,251,758.001%05/02/2021 –11/02/2021293,852,160.000.9%40,663,888.004%92,625,193.001%12/02/2021 –18/02/2021321,176,756.001.0%46,605,412.005%113,615,135.002%19/02/2021 –25/02/2021447,913,798.001.4%52,784,654.006%131,174,853.002%26/02/2021 –01/03/2021218,496,247.000.7%24,143,025.003%62,427,808.001%Grand Total1,782,646,463.005.39%272,029,077.0029%573,546,870.008% UK Vaccinated People Data Comparison taken fromwww.gov.uk and www.ourworldindata.gov www.gov.ukwww.Ourworldindata.org03/01/2021 –09/01/20212200211/01/2021 –17/01/20216090210/01/2021 –16/01/2021301051318/01/2021 –24/01/20211817717/01/2021 –23/01/2021323890125/01/2021 –31/01/20212373124/01/2021 –30/01/2021334330401/02/2021 –07/02/20211837231/01/2021 –06/02/2021351969308/02/2021 –14/02/20212704907/02/2021 –13/02/2021367565115/02/2021 –21/02/20218469514/02/2021 –20/02/2021402772022/02/2021 –28/02/202119149121/02/2021 –27/02/2021493791501/03/2021 –07/03/202132682728/02/2021 –01/03/2021815816Grand Total751244Grand Total26591515 www.gov.ukwww.Ourworldindata.org03/01/2021 –09/01/20212200211/01/2021 –17/01/20216090210/01/2021 –16/01/2021301051318/01/2021 –24/01/20211817717/01/2021 –23/01/2021323890125/01/2021 –31/01/20212373124/01/2021 –30/01/2021334330401/02/2021 –07/02/20211837231/01/2021 –06/02/2021351969308/02/2021 –14/02/20212704907/02/2021 –13/02/2021367565115/02/2021 –21/02/20218469514/02/2021 –20/02/2021402772022/02/2021 –28/02/202119149121/02/2021 –27/02/2021493791501/03/2021 –07/03/202132682728/02/2021 –01/03/2021815816Grand Total751244Grand Total26591515 01 23 4 5 6 7 8 901 2 34 5 6 7 8 9100000020000002000400000040000006000000 30000005000000Gov Our World in Date6000000Gov.Uk Data Our World in Date.orgThank You