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









.

STDEVP Function Dictionary

Function Dictionary Function Examples Function Categories

STDEVP          
 
 
Values Values Values
10 10 10
10 10 11
9 11 9
10 10 12
0.433013 0.433013 1.118034
 =STDEVP(C4:C7)  =STDEVP(E4:E7)  =STDEVP(G4:G7)
What Does It Do ?              
This function calculates the standard deviation of a list of values.
The result is calculated on the basis that the values represent the entire population.
Syntax                
=STDEVP(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.
A trial run of just four boxes per machine were produced.
The boxes were weighed and the =STDEVP() function used as these boxes
represented the entire test run.
The machine with the smallest variance 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.0707  =STDEVP(D32:G32)
Machine 2 1.5 1.5 1.4 1.5 0.0433  =STDEVP(D33:G33)
Machine 3 1.5 1.6 1.7 1.8 0.1118  =STDEVP(D34:G34)
    The smallest variance is :  0.0433  =MIN(H32:H34)
The machine with the smallest variance is :  Machine 2
 =INDEX(C32:C34,MATCH(MIN(H32:H34),H32:H34,0))
Explanation of formula:            
This finds the lowest value.  =(MIN(H32:H34)
This finds the position of the lowest value.  =MATCH(MIN(H32:H34),H32:H34,0)
This looks down the Machine column to  =INDEX(C32:C34,MATCH(MIN(H32:H34),H32:H34,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