tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{' x m>gS w4t3 5:(H_} gE2H`8LS0-iog9$:f:A꫾^fpPޓ\dzkR:җ6plT_ H߅f2@Ll9Od }& &0KoJh2P!7nF!`g\ +5Hd`;R0ƭYD,\; ?DK 1`={ss:*s@‚ۄV֕aovw$$A'syw.4M&L*\Iu)Q- ["$ k|B]RW8Q,cz4L4e JcTğ*uعwacG'2YQ\ +5Hd`;R0ƭYD,\; ?2{D1 -:ʒئDV\ +5Hd`;R0ƭYD,\; ? FŖwZ*RsF۰}ib|J/n\j&rJ%+j[Ʃ(nB sm??^`!?5vaȬ? /&H&ޫ唬tOJĨ}`݈sO>s_f/Xwl)mļ%rjru7DQy>oڥ>Sgc?yx?h1랰pE;b"'Xg ] 1HL`H$־H OkWXߩ~?p kˈ RFgt3/ߐUo%l8e(FbeRHOYNv?Ox E&3?OBBOdz&EV":QO*Z"0׼Ȱ}w[Tְp!IC g#0G= _1ИNM?kxܲ\PnqPPSnja&le,'wё2a,~%-P!AO{`PL /Xض$30k]eSA7Z}o[LZ@-1B83W\U##ٖAyYTe /cnoˆv>eE>AUbt9FX2Џ:`, WsE~T?1ϸ } >vMG$YytNYp N[}ЕrEVȜ*{ ؆/}Cn_f=ml'NBUSD<XPJl|I mR C*\U1.&:N㠔UEEjS~21AGpFy S_M'E!Kێȕ+MM:ܚ}Z5=ܹ0GMܣ fX9Wݎԧ鱌Ӛ .9c\r1_Y[5h9 keRs0"]|WYҋFoN_rR0 Et%a9ys0&/֝I)ɧlZ)ᄩ;:STE~0GJİ KQ>.*@# کwK7 Qo,1f&͊ijiF^,"uiYB-L>u[+[,';\uo&?52k@>P ̾lK0+e8D_Yt=e$YV6mW]EwW׮5_6^XNvԣΐ /:,!1Qe4o tLWʃwtnۚ9QqGFBkn%}VϺs|˘Jr~ͱU_~N)/Vf;Rf71$% ifCFy S_M';ClB( ʯ9MXNy1Sna Uܝ\e2@þ\rßSR?|cح',Ue/KgVM<^Iyu*IC_[WyQ[[ SG'vm#+5e.c3B[cyK\U{ow9Nا1 u1hD]d_Czh?:DpD $V?xNr[ޠ UOӬ  I|^@jc63Jt:fWE hj&Hbٟ֫1fFecXvvRNPw 򑜭&xqZ&(Ɏf|cHIhom)lsGX PxL{]l493A?$Lcڭo~AW[VˎWxt5>>30J5S0iH٦Sn '\Eh;熺['R7ē`]PDϽ;=u,{9RjV?~@ꕯ9MXNy1Sna Uܝ\gZm坷XFi 5YG4# +ϼ=8̲ -pⶖE%w7_Q$ߟe0-"0]$SIsƣȯsL!#T̰"#=& +!#oM{S)Ѓp,4w2TPdvA/NǴ33(7,TģY"TTRv%Rc &f.|ԟC]G"1DQK$h5/:,!1Qe4o tLWʃwtnۚ9QqGFBkn%}VϺs|˘Jr~iCRl`"N/dJF[$dO#k A!ש"\:޼=\ܯ)%8Ӳ#Snc%G8-plP4yrA3Sʧ;PNSP";[w)-JNG$YCWq1^ :}؝Ղg=jyfBkI_6k@V|qM>H?Y8hh#N!1y on-folder-open"> JAMA For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = U*S*V'
  •  JAMA Pythagorean Theorem: a = 3 b = 4 r = sqrt(square(a) + square(b)) r = 5 r = sqrt(a^2 + b^2) without under/overflow
  •  PHPExcel
    • Back to top  

    PHPExcel_Calculation_Database

    category PHPExcel
    package PHPExcel_Calculation
    copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

     Methods

    DAVERAGE

    DAVERAGE(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Averages the values in a column of a list or database that match conditions you specify.

    Excel Function: DAVERAGE(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DCOUNT

    DCOUNT(mixed[] $database, string | integer $field, mixed[] $criteria) : integer
    Static

    Counts the cells that contain numbers in a column of a list or database that match conditions that you specify.

    Excel Function: DCOUNT(database,[field],criteria)

    Excel Function: DAVERAGE(database,field,criteria)

    access public
    category Database Functions
    TODO The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria.

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    integer

    DCOUNTA

    DCOUNTA(mixed[] $database, string | integer $field, mixed[] $criteria) : integer
    Static

    Counts the nonblank cells in a column of a list or database that match conditions that you specify.

    Excel Function: DCOUNTA(database,[field],criteria)

    access public
    category Database Functions
    TODO The field argument is optional. If field is omitted, DCOUNTA counts all records in the database that match the criteria.

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    integer

    DGET

    DGET(mixed[] $database, string | integer $field, mixed[] $criteria) : mixed
    Static

    Extracts a single value from a column of a list or database that matches conditions that you specify.

    Excel Function: DGET(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    mixed

    DMAX

    DMAX(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Returns the largest number in a column of a list or database that matches conditions you that specify.

    Excel Function: DMAX(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DMIN

    DMIN(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Returns the smallest number in a column of a list or database that matches conditions you that specify.

    Excel Function: DMIN(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DPRODUCT

    DPRODUCT(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Multiplies the values in a column of a list or database that match conditions that you specify.

    Excel Function: DPRODUCT(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DSTDEV

    DSTDEV(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

    Excel Function: DSTDEV(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DSTDEVP

    DSTDEVP(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Calculates the standard deviation of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

    Excel Function: DSTDEVP(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DSUM

    DSUM(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Adds the numbers in a column of a list or database that match conditions that you specify.

    Excel Function: DSUM(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DVAR

    DVAR(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

    Excel Function: DVAR(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    DVARP

    DVARP(mixed[] $database, string | integer $field, mixed[] $criteria) : float
    Static

    Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

    Excel Function: DVARP(database,field,criteria)

    access public
    category Database Functions

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    stringinteger

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    float

    __fieldExtract

    __fieldExtract(mixed[] $database, mixed $field) : string | NULL
    Static

    Extracts the column ID to use for the data field.

    access private

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $field

    mixed

    Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

    Returns

    stringNULL

    __filter

    __filter(mixed[] $database, mixed[] $criteria) : array
    Static

    Parses the selection criteria, extracts the database rows that match those criteria, and returns that subset of rows.

    access private

    Parameters

    $database

    mixed[]

    The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.

    $criteria

    mixed[]

    The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

    Returns

    arrayof mixed