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.     

SPREADSHEET PACKAGE (MICROSOFT EXCEL)

MICROSOFT EXCEL

It is a window based on application package that is used in solving calculation both arithmetic problems and engineering problems. It is on electronic speed sheet. It was produce by ms- Corporation as one of the electronic spreadsheet software.

VERSION OF MICROSOFT EXCEL

·        Lotus 123

·        Quartro pro

·        Valcark

·        Lotus AmiPro

·        Super cark  e.t.c

WAYS OF LOADING OR LAUNCHING MICROSOFT EXCEL INTO MEMORY(RAM)

·        After loading the operating window by booting the system

·        Move your mouse pointer to the start button on the taskbar

·        Click on the start button the taskbar

·        point to the all programs 

·        All the available programs will appear

·        Point microsoft office folder

      A dialogue box will appear

      Select Microsoft office excel

At the last you understand that microsoft logo will be display briefly which process the opening of microsoft excel environment.

BARS IN MICROSOFT EXCEL

·        TITTLE BAR: it is located at the top of the screen that display the name of the program e.g. microsoft Excel e.t.c as well as current filename, minimum, maximum and close button.

3

·      

          MENU BAR: it shows the main Manu of the program which include file, edit, view, insect, format, tools, table, window and help.

·    

           STANDARD TOOLS BAR: it consist of main Menu shortcuts or icon used for performing same task or command with out using the menu those shortcut are, view, open, save, point, preview, copy, cut, paste, e.t.c.

·  
      FORMATTING TOOLS BARS: it consist of icon that is use in editing character of such as bold, size, underline, fount colour, line colour center justify e.t.c.  

        FORMULA; it displays the label and formula of the current cell in use.

·   
         WORKSHEET; it  is an area located directly below the formula by which is made up of rows and columns that intercept to form a cell

·     
           SCROLL BAR; it is used in shifting  the spreadsheet up,down,depending on which side you want  to view

·
           SHEET; it displays a particular spreadsheet page that is still in the same file

·        DRAWING TOOL BAR; its a consist of already made gallery image like wordart,autoshapes,dash lines, fill colour draw e.t.c

·        STATUS BAR; it is D horizontal strip below the word sheet which displays the state at worksheet and work of the system.

·        Task bar.

·                                              COMPONENT OF MS-EXCEL

·        Row

·        Colum

·        Cell

·        Value

·        Label

       1 ROW; horizontal group of cell or line that is in a work sheet that runs from left to right, there are 65,536 rows in the worksheet.

2   COLUMNS; it is a vertical group of cell or line in a worksheet that runs from up to down, there 256 columns in ms-excel

3  CELL; it is the interception of row and colum.it is the small idock of rectangle from by interception.are,new,open,save,print,paint,preview,copy,cut,past e.t.c.

4  LABEL; it is a word or group of words that is used as a caption the identify info. Under it, either by row or column

5 VALUE; the data in a spreadsheet is called the value

AREAS OF APPLICATION

1 BUSINESS ORGANIZATION; it is very important in preparing ledger as an accountant, it is needed (ms-excel) in processing app.

Ledger; it is a book that o

Contains account of money for a business

2 EDUCATIONAL LEVEL; it is used in adding and subtracting minor calculation. It is used in working student result and assessment

3 statistical analysis; it help the statistic in solving the statistical problems like %, average e.t.c.

4 BUDGETING; it is use in planning ahead the expenditure of month or year, and it is also used to plan New Year document.

5 financial purpose; it is used to record a financial status of a company

FUNCTIONS OF MS-EXCEL

·        Statistical function

·        Logical function

·        Financial function

v SATISTICAL FUNCTION: it deals with some minor calculations, like average, minimum, maximum, standard deviations summation e.t.c.

FORMULA FOR CALCULATIONS

EXAMPLE FORMULAS;

v TO CALCULATE  MINIMUM:  type = min (B2:E2) press enter key

v TO CALCULATE MAXIMUM:  type = max (B2:F2)press enter key

v TO CALCULATE COUNT: type= count (B2:F2) press enter key

v STANDARD DEVIATION: type –stdev (B2:F2) press enter key

v MULTIPLICATION: type = B2*G2 press enter key

COMMENT

It is a statement made over a particular cell.

STEP

·        Click in cell your want to enter the comment

·        Go to insert on the menu bar

·        Select comment

·        Remove your cursor and observe that the comment is visible

HOW TO REMOVE COMMENT

·        Click in the cell that has the comment

·        Move to edit menu

·        Move to clear

·        Click on all or comment

CHART

Is a graphic or diagram representation of worksheet data.

TYPES OF CHART

·        COLUMN CHART: this shows variation over a period of time that illustrated comparison between two items.

·        LINE CHERT: this shows straight or change on data over a period of time.

·        PIE CHART: this shows relationship or proportion of part to a whole.

·        AREA CHART: it shows relatives information of value over a period of time

·        BAR CHART: this illustrate devotion between items

·        DOUGHNUT CHART: this is similar to pre chart  but more than data series

·        X-Y CHART: this shows relationship between numeric value in several chart maps.

On my next blog I will explain how to solve Statistical & Logical problem, thanks for coming.