Some Excel Explanation at Hospital 🏥

Excel

(1)     =SUM (number1, [number2], ....)

Used to calculate total number. e.g.(No. of cases which enter any department in hospital)

(2)      =AVERAGE (number1, [number2], ....)

Used to calculate the average value in a set of numbers is the middle value, calculated by dividing the total of all the values by the number of values. e.g. (Calculate average food intake and food supply to get a predictable look)

(3)    =MAX (number1, [number2], ....)

returns the highest value in a set of data that you specify. e.g.  (The maximum consumption of meals for visitors and patients per week this survey helps in predicting the profits and losses)

(4)     =MIN (number1, [number2], ....)

returns the lowest value in a set of data that you specify. e.g. (The minimum consumption of meals for visitors and patients per week this survey helps in predicting the profits and losses)

(5)     =LARGE (array, k)

The function will return the k largest value, e.g. (all vendors of flour can be listed sequentially either by the largest Quality per pound, by various package sizes, or by price per unit.)

(6)      =SMALL (array, k)

it calculates and returns the k smallest value in a dataset. e.g. (all vendors of flour can be listed sequentially either by the lowest price per pound, by various package sizes, or by price per unit.)  

(7)     =COUNT (number1, [number2], ....)

Use the COUNT function to get the number of entries in a number field which only exist that is in a range or array of numbers. e.g. (Calculating No. of Availability of vacant rooms for accommodation)

(8)    =COUNTA (number1, [number2], ....)

Use COUNTA to count cells that aren't blank. e.g. (the no. of patient with certain medical condition depend on name of disease)

(9)    =COUNTBLANK (number1, [number2], ....)

Use COUNT BLANK to count cells that are blank. e.g. (exception of the empty beds no. of each department.)

(10)    =AND (logical1, [logical2], ....)

The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE. e.g. (the percentage of satisfying meal each day)

(11)    =OR (logical1, [logical2], ....)

The OR function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE. e.g. (the percentage of accepted meals every day)