*MICROSOFT EXCEL (STATISTICAL FUNCTION)*

On my previous blog, I said that I through some highlight on how to solve Statistical & Logical calculation.

        

   I will start with the Statistical functions like; Average, Summation, Division, Maximum, Minimum, Standard Deviation, Variance. E.t.c.

For instance; If you are working on a spreadsheet, your data will determine how you will insert your formula for a correct result.

In Microsoft Excel we have two types of data;

a)     UNGROUP DATA

b)    GROUP DATA

1.     UNGROUPED DATA: is data without label. If you are lost over the word label, you can check my previous blog on Microsoft Excel.

Example of ungrouped data;

	A	B	C	D	E	F
1	43	56	77	65	40	89
2	55	76	98	23	54	76
3	65	65	44	34	66	87
4	89	77	55	32	34	334
5	434	541	344	121	221	212

  

2.    

GROUPED DATA: is data with label.

Example of grouped data;

	A	B	C	D	E	F
1	NAMES	BIOLOGY	CHEMISTRY	I.C.T	PHYSICS	TOTAL
2	CHINEDU	76	98	23	54
3	LEGACY	65	44	90	66
4	ARINZE	77	55	89	34
5	KENNETH	541	344	121	221

If you were given the following using the table under 1.Ungrouped data;

Find Maximum, Minimum, Average, Summation, Standard Deviation, Variance e.t.c  

·        To find Maximum of all the data: Go to the next column and type; =max(A1:F5) and press Enter key on the keyboard.

·        To solve Minimum of all the data: Move to next column and type; =min(A1:F5) followed by your Enter key

·        To solve Mean/Average: type on the next column; =average(A1:F5) Enter key.

·        To find Median, type; =median(A1:F5) Enter key

·        To find Mode, type; =mode(A1:F5) followed by Enter key.

·        To find Summation, type; =sum(A1:F5) Enter key

·        To find Count, type; =count(A1:F5) Enter key

·        To calculate variance, type; =var(A1:F5) Enter key

·        To calculate Standard Deviation; In this particular one, it has two formula, the first one is; =stdev(A1:F5) Enter key.

The second method is; After you find variance type ; =sqrt(variance answer) Enter key . in the sense that standard deviation is square root of variance.

Now let’s move to the next data type, which is grouped data.

If you were given the same question above using the table under grouped data; this time you will need solve it on each and every row. Because it’s a grouped data.

·        To find Maximum score for CHINEDU, type; =max(B2:E2) press Enter key

·        To find Average score for LEGACY, type; =average(B3:E3) press Enter key

·        To find total score for ARINZE, type; =sum(B4:E4) press Enter key. e.t.c.

NB: before solving anything on a grouped data, enter the label @ the top cell. E.g; AVERAGE SCORE FOR LEGACY.

I WILL STOP HERE , SO AS TO TAKE A LITTLE BREAK, I WILL TREAT LOGICAL FUNCTION ON THE  NEXT BLOG.