Keep the data in raw and universal (csv) form: Update data anytime with external programs like Excel, Python, MATLAB, R, PowerShell
Render scientific notation correctly and uniform: Render 4.41941738e-02 as $4.42 \cdot 1 0^{- 2}$ $3a, 3b, 3c$
Format numbers: Set max. decimal places $3a, 3b, 3c$ ; When to show exponent $3c$ ; Use German commas $3b$
Visually guide horizontal reading: Shade every other row $3a$ ; Add dashed line every third row $3b$
Process input data: sort with column $3c$
More ideas: filter, sort, custom column titles, multi column names, Align at decimal or scientific separator
See source examples: Layout the table

table measurements 1.svg

calculate sum, mean, standard deviation under table

Statistics

Calculate sum, mean, or standard deviation for each column

table stats.svg

\documentclass{standalone}
\usepackage{tabularray}
\usepackage{tabularray,tikz}
\UseTblrLibrary{functional}
\usetikzlibrary{fpu}
\renewcommand{\thetable}{3.2}
\ExplSyntaxOn
\clistNew\vchilds 
\fpNew\naccum \fpNew\nmean \intNew\nlast \fpNew\ncell
\prgNewFunction\vclist{ n }{
    \__tblr_get_childs:nx{ #1 }{ \therowcount }
    \prgReturn{\l_tblr_childs_clist}%
}
\prgNewFunction\vMapInline{ mm }{
    \fpZero\naccum
    \clistVarMapInline{ \vclist{#1} }{
        \fpSet\ncell{ \cellGetText{##1}{\thecolnum} }
        \fpSet\naccum{ #2 }
    }
    \prgReturn{ \fpEval{ round(\naccum,2) }}
}
\prgNewFunction\vsum{ m }{
    \prgReturn{ \vMapInline{#1}{\naccum + \ncell}  }}
\prgNewFunction\vcount{ m }{
    \prgReturn{ \clistVarCount{\vclist{#1}} }
}
\prgNewFunction\vmean{ m }{
    \prgReturn{ \fpEval{ round( \vsum{#1} / \vcount{#1} ,2) }}}
\prgNewFunction\vstandarddeviation{ m }{
    \fpSet\nmean{ \vmean{#1} }
    \prgReturn{ \vMapInline{#1}{\naccum + (\ncell - \nmean)^2 }  }}
\ExplSyntaxOff
\begin{document}
\begin{tblr}[tall,caption]{
    colspec={rrr}, hline{1,Z}={.08em},hline{2,W},
    column{2-Z}={r,mode=math,cmd=\pgfmathprintnumber}, 
    column{1}={mode=math},
    cell{2-4}{1}={cmd=\intEval{\therownum-1}},
    row{1}={c,mode=text,cmd={}}, 
    cell{X}{2-Z}={cmd=\vsum{2-W}},
    cell{Y}{2-Z}={cmd=\vmean{2-W}},
    cell{Z}{2-Z}={cmd=\vstandarddeviation{2-W}},
}
\#     & a & b    & c              \\
       & 1 & 2.3  & 1.43587294e-01 \\
       & 4 & 5.2  & 4.41941738e-02 \\
       & 7 & 8.44 & 8.20091159e-03 \\
\Sigma                             \\
\mu                                \\
\sigma                             \\
\end{tblr}
\end{document}

Table calculation

Sum up integers

table stats integer sum.svg

\documentclass{standalone}
\usepackage{tabularray}
\UseTblrLibrary{functional}
\renewcommand{\thetable}{3.1}
\IgnoreSpacesOn
\prgNewFunction \funcSum {} {
 \intStepOneInline {2} {\arabic{colcount}} {
 \intZero \lTmpaInt
 \intStepOneInline {2} {\arabic{rowcount}-1} {
 \intAdd \lTmpaInt {\cellGetText {####1} {##1}}
 }
 \cellSetText {\expWhole{\arabic{rowcount}}} {##1} {\intUse\lTmpaInt}
 }
}
\IgnoreSpacesOff
\begin{document}
\begin{tblr}[tall,caption]{
    colspec={rrr},process=\funcSum,
    column{1-Z}={r, mode=math}, column{1}={rightsep=0pt},
    row{1}={c,mode=text}, hline{1,Z}={.08em},hline{2,Y},
}
       & a & b & c \\
       & 1 & 2 & 3 \\
       & 4 & 5 & 6 \\
       & 7 & 8 & 9 \\
\Sigma &   &   &   \\
\end{tblr}
\end{document}

Sum up floats

table stats float sum.svg

\documentclass{standalone}
\usepackage{tabularray}
\usepackage{tabularray,tikz}
\UseTblrLibrary{functional}
\usetikzlibrary{fpu}
\renewcommand{\thetable}{3.2}
\IgnoreSpacesOn
\prgNewFunction \funcSum {} {
    \intStepOneInline {2} {\arabic{colcount}} { % for columns 2-Z
        \fpZero \sum % sum = 0.0
        \intStepOneInline {2} {\arabic{rowcount}-1} { % for rows 2-Y
            \fpAdd \sum {\cellGetText {####1} {##1}} % sum += cell
        }
        \cellSetText {\expWhole{\arabic{rowcount}}} {##1} {\fpUse\sum} % cell = sum
    }
}
\IgnoreSpacesOff
\begin{document}
\begin{tblr}[tall,caption]{
    colspec={rrr}, process=\funcSum, hline{1,Z}={.08em},hline{2,Y},
    column{1-Z}={r,mode=math,cmd=\pgfmathprintnumber}, 
    column{1}={rightsep=0pt,cmd=\intEval{\therownum-1}},
    row{1}={c,mode=text,cmd={}}, 
    row{Z}={cmd={}}
}
\#     & a & b & c \\
       & 1 & 2.3 & 1.43587294e-01 \\
       & 4 & 5.2 & 4.41941738e-02 \\
       & 7 & 8.44 & 8.20091159e-03 \\
\Sigma &   &   &   \\
\end{tblr}
\end{document}

\documentclass{standalone}
\usepackage{tabularray}
\usepackage{tabularray,tikz}
\UseTblrLibrary{functional}
\usetikzlibrary{fpu}
\renewcommand{\thetable}{3.2}
\IgnoreSpacesOn
\prgNewFunction \sumRowRange {mm} {
    \fpZero \sum % sum = 0.0
    \intStepOneInline {#1} {#2} { % for rows 2-Y
        \fpAdd \sum {\cellGetText {##1} {\thecolnum}} % sum += cell
    }
    \prgReturn {\fpEval {round(\sum,2)}}
}
\prgNewFunction \meanRowRange {mm} {
    \prgReturn {\fpEval{\sumRowRange{#1}{#2}/(#2-#1)}}
}
\prgNewFunction \standardDeviationRowRange {mm} {
    \fpSet \mean {\meanRowRange{#1}{#2}}
    \fpZero \sum % sum = 0.0
    \intStepOneInline {#1} {#2} { % for rows 2-Y
        \fpAdd \sum {(\cellGetText {##1} {\thecolnum} - \mean)^2}
    }
    \prgReturn {\fpEval {round(\sum,2)}}
}
\IgnoreSpacesOff
\begin{document}
\begin{tblr}[tall,caption]{
    colspec={rrr}, hline{1,Z}={.08em},hline{2,W},
    column{2-Z}={r,mode=math,cmd=\pgfmathprintnumber}, 
    column{1}={mode=math},
    cell{2-4}{1}={cmd=\intEval{\therownum-1}},
    row{1}={c,mode=text,cmd={}}, 
    cell{X}{2-Z}={cmd=\sumRowRange{2}{4}},
    cell{Y}{2-Z}={cmd=\meanRowRange{2}{4}},
    cell{Z}{2-Z}={cmd=\standardDeviationRowRange{2}{4}},
}
\#     & a & b    & c              \\
       & 1 & 2.3  & 1.43587294e-01 \\
       & 4 & 5.2  & 4.41941738e-02 \\
       & 7 & 8.44 & 8.20091159e-03 \\
\Sigma                             \\
\mu                                \\
\sigma                             \\
\end{tblr}
\end{document}

\documentclass{standalone}
\usepackage{tabularray}
\UseTblrLibrary{functional}
\begin{document}
\IgnoreSpacesOn
\prgNewFunction \charToNum{mm} {
    \strCaseTF {#1} {
         {U} {\tlSet\lTmpkTl{5}}  {V} {\tlSet\lTmpkTl{4}}
         {W} {\tlSet\lTmpkTl{3}}  {X} {\tlSet\lTmpkTl{2}}
         {Y} {\tlSet\lTmpkTl{1}}  {Z} {\tlSet\lTmpkTl{0}}
    }{  \prgReturn{\intEval{#2-\lTmpkTl}}  }
    {  \prgReturn{#1}  }}
\IgnoreSpacesOff
\charToNum{X}{5} \charToNum{Y}{5} \charToNum{Z}{5} \charToNum{3}{5}
\end{document}

\documentclass{standalone}
\usepackage{tabularray}
\UseTblrLibrary{functional}
\ExplSyntaxOn
\prgNewFunction\getVChilds{ m }{
    \__tblr_get_childs:nx{ #1 }{ \therowcount }
    \prgReturn \l_tblr_childs_clist
}
\prgNewFunction\getHChilds{ m }{
    \__tblr_get_childs:nx{ #1 }{ \thecolcount }
    \prgReturn \l_tblr_childs_clist
}
\ExplSyntaxOff
\begin{document}
\begin{tblr}[tall, caption]{}
a & b & c & d \\
1 & 2 & 3 & 4 \\
5 & \getVChilds{1-Z} & 7 & 8 \\
9 & 9 & 9 & 9 \\
\end{tblr}
\end{document}

Figure collection for note preview

table functional.svg

\documentclass{standalone}
\usepackage{graphics}
\begin{document}
\includegraphics{table counters 2}
\hspace{1em}
\includegraphics{table stats}
\end{document}

Anton's Digital Garden

Table of Contents

Calculate statistics for table numbers

Statistics

Calculate sum, mean, or standard deviation for each column

Sum up integers

Sum up floats

Figure collection for note preview

Backlinks