Analysis of Death Caused by COVID and Other Reasons Using MS Excel

This study analyzes the difference between deaths caused by COVID and other reasons. It uses statistical techniques and Excel features to calculate percentages, averages, and create charts. The data shows that deaths caused by reasons other than COVID are proportionately higher than those caused by the pandemic.

MS Excel task

TABLE OF CONTENTS
MAIN BODY...................................................................................................................................3
Research topic.............................................................................................................................3
Raw data for analysis..................................................................................................................3
Calculating percentage................................................................................................................3
Use of statistical techniques........................................................................................................4
Use of excel AutoSum features...................................................................................................4
Use of charts................................................................................................................................5
Briefly explaining the finding.....................................................................................................6
REFERENCES................................................................................................................................7

MAIN BODY
Research topic
The current research topic is being related to the death which has taken place due to
COVID and not involving COVID. This research topic is being is selected for the reason that
pandemic has affected to the health of the people to a great extent. these negative impact over the
health of the person may result in death of the person. Hence, the current study will outline the
difference within the death which is being caused by COVID and which does not involve the
pandemic as the reason for death.
Raw data for analysis
For the analysis of the research problem it is necessary that proper data is being selected
and in case the raw data selected is not good and appropriate then the objective will not be
attained (Katoch, 2020). Hence, for this it is necessary for the researcher to collect relevant raw
data relating to the deaths due to pandemic and not involving it.
Raw data attached in excel
Calculating percentage
year
Deaths
not
involving
COVID
COVID-
19
All
deaths
- Five-
year
average
Percentage
of death
not
involving
COVID
Percentage
of death
involving
COVID
2020 10,062 1,525 10,171 660% 15%
2021 9,804 1,463 10,214 670% 14%
2022 10,803 1,012 12,571 1067% 8%
The calculation of the percentage outlines the ratio which is being expressed as the
fraction of 100. In the present case the data is provided relating to the death which involve
COVID as reason and not involve this as the reason for death. For this the percentage is being
calculated in order to analyse that what percentage of death not involving COVID from the total
average of five years. This is necessary to be analysed as it will outline the ratio of the death not

because of pandemic with the total five- year average and death involving COVID based on past
five- year data. With the help of the percentage it is clear that death not involving COVID is
more as compared to the death involving COVID. Also for the average of year 2020 it was 660
% of the total average for past five years. Along with this the death involving COVID was only
15 %. Similarly, the ratio for the next year that is 2021 was 670% for not involving pandemic
and 14 % for involving pandemic. Also for 2022 it was 1067 % for not including pandemic and 8
% because of pandemic.
Use of statistical techniques
Deaths not involving
COVID
COVID-
19
All deaths - Five-year
average
Mean 10,017 1,449 10,418
Median 9,792 698 10,188
Mode 8608 0 11548
There are different types of the statistical tools which are important to be used for the
reason to analyse the data. This is important for the reason that many a times there are different
types of the data being involved and it is necessary to analyse the average in order to analyse the
overall data with a single value (Kalwar and Khan, 2020). With the help of the above statistical
tools it is clear that the average number of death taken place because of factors other than
COVID is 10017 and due to pandemic is 10418. Also with the help of median it is clear that the
central value that is death which divides the series into equal part is 9792 in case of death due to
pandemic is 698. Further the most repeated number of death is 8608 in case of death with other
reason and in case of death caused by pandemic is 0.
Use of excel AutoSum features
Deaths not involving
COVID
COVID-
19
All deaths - Five-year
average
sum 1,161,925 168,058 1,208,489
average 10,017 1,449 10,418
count 116 116 116
max 14,058 8,758 14,183
min 6,925 0 7,954

The AutoSum is a type of feature within excel which assist the users in directly
calculating the different functions by selecting the column or row. This tool assists in using
different function and calculating the various functions like sum, count, max, min and others
(Sani, Wiliani and Husain, 2019). With the application of the AutoSum function it is clear that
the total number of death due to reason other than COVID is 1161925 and wit COVID is
168058. Also the average of total 5- year death is 1208489. Further the maximum number of
death taken place in single week in all the three years is 14058 without pandemic and due to
COVID is 8758 and average maximum is 14183. Further it was analysed that the total count of
data is 116 weeks which involves data with respect to 2020- 2022.
Use of charts
With the help of the graphical presentation it is clear that the average death other than
COVID is more as compared to the death caused by pandemic. The above graph clearly shows
that the average number of people dying is more in case of not involving pandemic and less
because of pandemic. Also, the average of death for past five years is almost similar to the death
without pandemic.

Briefly explaining the finding
With the help of the above whole finding it can be stated that though the pandemic has
affected to a great extent but it has not much increased the number of people dying. This is
particularly because of the reason that when the death is caused then this affects the economy of
the country as well. This is necessary to evaluate the fact that whether the major death is being
caused by pandemic or by reason other than pandemic (Demir and et.al., 2018). Hence, with the
help of different functions of excel it was analysed that high number of death is being caused by
reason not involving pandemic and some other reasons. Hence, with this it can be stated the
proportionately the death caused by reason other than pandemic is more as compared to death
being caused by pandemic.

REFERENCES
Books and Journals
Demir, S. and et.al., 2018. An MS excel add‐in for teaching hydraulics of pipe flow in
engineering curricula. Computer Applications in Engineering Education. 26(3). pp.449-
459.
Kalwar, M. A. and Khan, M. A., 2020. Optimization of Procurement & Purchase Order Process
in Foot Wear Industry by Using VBA in Ms Excel. International Journal of Business
Education and Management Studies. 5(2). pp.80-100.
Katoch, S. K., 2020. MS-Excel Spreadsheet Applications in Introductory Under-Graduate
Physics-A Review. Journal of Science and Technology. 5(03).
Sani, A., Wiliani, N. and Husain, T., 2019. Spreadsheet Usability Testing in Nielsen’s Model
among Users of ITSMEs to Improve Company Performance. European Journal of
Scientific Exploration. 2(6). pp.1-9.