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

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