SCHOOL BOOKS


SCHOOL BOOKS




EXAM TIME TABLE 2018 -- +2 +1 10TH










Tamilnadu School Books Change for Academic Years


Standards


Academic year




2, 7, 10 & 12


2019-20


3, 4, 5 & 8


2020-21





STD - 1
STD - 2
STD - 3
STD - 4
STD - 5
STD - 6
STD - 7
STD - 8
STD - 9
STD - 10
STD - 11
STD - 12









.

STDEV Function Dictionary

Function Dictionary Function Examples Function Categories
STDEV            
 
 
Values Values Values
10 10 10
10 10 11
9 11 9
10 10 12
0.5 0.5 1.2909944
 =STDEV(C4:C7)  =STDEV(E4:E7)  =STDEV(G4:G7)
What Does It Do ?              
This function calculates the sample population standard deviation of a list of values.
A sample population is used when the list of values represents a sample of a population.
Syntax                
=STDEV(Range1,Range2,Range3 through to Range30)
Formatting              
No special formatting is needed.
Example                
The table below was used by a company interested in buying a new machine
to pack washing powder.
Three machines were short listed and allow to run for a day.
At the end of the day four boxes of soap powder were picked at random from the production
of each machine.
The boxes were weighed and the =STDEV() function used as these boxes only represented
a sample of the complete days production.
The machine with the smallest deviation was the most consistent.
Soap Powder Box Filling Machine Test Results
Test 1 Test 2 Test 3 Test 4 Variance
Machine 1 1.4 1.5 1.6 1.5 0.0816  =STDEV(D34:G34)
Machine 2 1.5 1.5 1.4 1.5 0.0500  =STDEV(D35:G35)
Machine 3 1.5 1.6 1.7 1.8 0.1291  =STDEV(D36:G36)
    The smallest deviation is :  0.0500  =MIN(H34:H36)
      The machine with the smallest deviation is :  Machine 2
 =INDEX(C34:C36,MATCH(MIN(H34:H36),H34:H36,0))
Explanation of formula:            
This finds the lowest value.  =MIN(H34:H36)
This finds the position of the lowest value.  =MATCH(MIN(H34:H36),H34:H36,0)
This looks down the Machine column to  =INDEX(C34:C36,MATCH(MIN(H34:H36),H34:H36,0))
find the machine name.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu plus1 all books free download, Tamilnadu 11th all books free download