Find Hyper geometric Distribution Using formula on Ms Excel

Hyper Geometric Distribution:

Here is the formula by using that you can find binomial distribution in excel

The formula to find binomial distribution in excel is: 

= hypgeomdist (x,n,k,N)

Where
X=numbers
n = No. of Samples

k =  pop. sample

N = Population

To explain this look at the example below 

Example: N=12 ,n=4 , k=4 Then Hyper geometric Dist: on excel

Find Poisoon distribution Using Formula on Excel

Poisoon distribution:
Here is the formula by using that you can find binomial distribution in excel


The formula to find binomial distribution in excel is :

= Poisson (X , mean, Cumulative)

Where:

X = No. of observations
Mean  = average of X
Cumulative = False

Question
	μ	1

                X                            0,1,2,3,4,5

Then

Poisson Distribution on Excel

Find Binomial Distribution Using Formula on MS Excel

Binomial Distribution 

Here is the formula by using that you can find binomial distribution in excel
The formula to find binomial distribution in excel is 
=binomdist(X ,trials, Prob: of success, cumulative)
Where
X=numbers
Cumulative=false
To explain this look at the example below 

Example:  If value of P and n  is:
P	0.8
n	4

then

Binomial Distribution on Excel

How To Find Inverse on Excel

Find Inverse on Excel:

Formula by using that we can find addition matrix on Excel:
Formula is that:

 = minverse(...)

   

 This Matrix is explain by an example:

Example:  

Find The Inverse of this matrix: Find Inverse on Excel

How to find Determinant on Excel

 Find Determinant on Excel: |...|

Formula by using that we can find addition matrix on Excel:
Formula is that:

=mdeterm(.....)

   

 This Matrix is explain by an example:

Example:
  

Find The determinants of this matrix:

Find Determinant on Excel:

Find Formulas of Matrix Operation on Excel

 Matrix Operation For Addition:

Formula by using that we can find addition matrix on Excel:
Formula is that:

=Name of Matrix 1 + Name of matrix 2

For Answer press:

Shift+Ctrl+Enter 
   

 This Matrix is explain by an example:

Example:
  

Find the addition of Matrix A and B  Matrix Operation For Addition:

 Matrix Operation For Multiplication:

Formula by using that we can find Multiplication matrix on Excel:
Formula is that:

= mmult(name of matrix)

For ans press:

Shift+Ctrl+Enter 

This Matrix is explain by an example:

Example:
 

Find the Multiplication of Matrix A and B

Matrix Operation For Multiplication

Formulas of quartile,Percentile Squre root, power etc on Excel

Quartile:

=quartile(.....,quar)

Percentile:

=percentile(.....,k)

Addition:

=sum(.....)

Maximum:

=max(.....)

Minimum:

=min(.......)

Squre Root:

=sqrt(....)

Power:

=(..)^n

Skewness:

=skew(..)

• if => 0 then positive skewness
• if =< 0 then negitive skewness
• if = 0 then symetric skewness

Kurtosis:

=kurt(.....)

• if k > 3 laptokaurtic
• if k < 3 Meso kurtic
• if k = 3 Platy Kurtic

farmulas of Measure of Central Tendency on Excel

Mean:

 =average(...)

Geomatri Mean(G.M):

=geomean(...)

Harmonic Mean:

=Harmean(.......)

Median:

=Median(.....)

Mode:

=Mode(.......)

Variance:

=var(........)

=varp(......)

Stenderd deviation(S.D):

=stdev(...)

=stdevp(...)

Action and Reults

Click cell:
     It makes cell action.

Enter:
     It Moves the active cell Down.

(Shift+Enter):

     It moves the active cell on cell up moves the active cell.

Tab:
     Moves the active cell one cell up moves the active cell.

Arrow Keys:
     Moves active cell left, right , up and down one row or coloumn.

Ctr+Shift+Arrow key(any):
    Select the whole cell in the direction.

Ribbon

Ribbon:
  The ribbon is the panel at the top portion of Docouments. It has Seven Tabs.

1. Insert
2. Page
3. Layout
4. Formulas
5. Data
6. Review
7. View

                           Each Tab is devided into Groups. The group is legalCollection of feature designed to performed functions that you will utilized in developing or editing your excel work sheet.

                          Comonly utlized features are displayed on the ribbon to view conditional features with in each groups click to the arrow at the button right corner of each group.

Home:

• Clip Board
• fonts
• Allignments
• Numbers
• Styles
• Cells 
• Editing.

Insert:

• Tables 
• Illustrations
• Chart
• Links 
• text.

Page layout:

• Theme
• Page Setup
• Scale to fit
• Sheet Options
• arrange

Formulas:

• Function Library
• Predefined names
• farmula editing
• Calculation

Data:

• Get external data Conections
• sort and filter,
• Data Tooles
• Out Line

Recived: 

•  Profing
•  comments 
•  changing

Difference b/w Spreed Sheet & Word Process:

Difference b/w Spreed Sheet & Word Process:

Spreed Sheet:

• It provides the facilty to creat and edit docouments.
• The data in it inserted in docouments.
• It does not provided data analysis.
• It provides a small number of predefined functions to manipulate data.
• It does not provide the facilty of recalculating data.
• Conditional formating is not available in it.
• It is used to creat latter applications memos and reports.

Word Process:

• It provides the facility of calculation.
• The Data in it inserted in work sheet.
• It provide Data analysis facility such as filter,subtotal,pivote Table and editing.
• It provides many pre defined functions to manipulate data.
• It provide the facility of recalculating the data.
• The Result changing aoutomatically if any change in data.
• It provides the facility of conditional formating.
• Format data is changed when it meets certain critaria.
• It is used to creat salarysheet, Home budgets and balance sheets.

Disadvantages of Spread Sheet:

Disadvantages of Spread Sheet:

1. Spread sheet cannot process a large volume of Data quickly.
2. It doesnot provide much programing facilities.

Advantages of Spread Sheet:

Advantages of Spread Sheet:

  Computrized spread sheet can calculate data easily,acuratly and efficiently.The large numbers can be added, subtrected,multiplied and devided. When new information is inserted in spread sheet revised calculation are performed automaticaly.

1. It increase the case and speed of calculating.
2. It makes it easy to modify information and recalculated automattically.
3. It displays numaric data as a chart or Graph.
4. In corpurate numaric daa into another software application.

Application of Spread Sheets

Application of Spread Sheets: 

1. It  can be used by corporation to track profit and loss.
2. Economics and generate growth graphs of country's economy.
3. Statisticians can calculate probability of crashing markets.
4. Women can manage their hous hold budgets.

Spread Sheets

Spread Sheets:

                  A spread Sheet is an electronic docouments that stors verious types of data .There are vertical coloumn and row intersected.

A Cell can contain data and can be used in calculation of data with in spread sheet 

An Excel Spread sheet can contain  work books and work sheets. Work book is the holder for related work sheets.