Question

2. Create an excel sheet of the reported COVID 19 cases in Pakistan in any of
the five days (by observing /reading the news on COVID 19). Show the statistics of
COVID province wise on day-to-day basis for minimum five days (Hint(s): create a
table, use the appropriate formulas e.g., SUM, AVERAGE and then plot a line/bar
chart).
a)
b)
c)
Cases: Punjab, Sindh, KPK, ICT, Balochistan
Recovered: Punjab, Sindh, KPK, ICT, Balochistan
Deaths: Punjab, Sindh, KPK, ICT, Balochistan
Using IF statement formula, show which province has maximum number of total
reported cases, recovered cases and deaths.
Create a line/bar chart of the statistics province wise.
Take its print and submit it.
(8 mark​

Answer 1

Answer:

but I should know no of patients

Answer 2

Answer:

sorryyyyy i am very sorry i didn't understand please sorry but please mark me as the brainlist please i am sorry