Graphics, Figures & Tables ⇒ Converting an Excel table to LaTeX

[dalovering]

Hey guys, i am a noobie, and i'm in the process of converting my research paper to latex, but i got stuck on this table. if anybody could help me out with would be wonderful (the borders aren't mandatory...the table should make sense though)

I attached an image of the table

Thank you so much in advance!

[localghost]

There exist some conversion tools but I suggest to build that table from scratch. A first approach could look like the following.

Code: Select all

\documentclass[11pt,a4paper,english]{article}
\usepackage[T1]{fontenc}
\usepackage[latin1]{inputenc}
\usepackage{babel}
\usepackage[includeheadfoot,margin=2cm]{geometry}
\usepackage[font=small,labelfont=bf,tableposition=top]{caption}
\usepackage{booktabs,multirow}
\usepackage{lmodern}


\begin{document}
  \begin{table}[!ht]
    \centering
    \caption{Statistical Analysis of the Performance of MySQL vs.~PostgreSQL}\label{tab:MySQL-vs-PostgreSQL}
    \begin{tabular}{ccccccc}\toprule
      & & \multicolumn{5}{c}{Number of Rows} \\ \cmidrule{3-7}
      & & 1000 & 25000 & 50000 & 100000 & 250000 \\ \midrule[0.8pt]
      \multirow{3}{*}{MySQL} & Mean (time, s) & 6.89E-004 & 1.04E-002 & 1.63E-002 & 3.24E-002 &  8.82E-002 \\
      & Standard Dev. &  9.52E-005 & 1.71E-002 & 4.56E-004 & 1.26E-003 &  3.82E-003 \\
      & Variance & 9.06E-009 & 2.92E-004 & 2.08E-007 & 1.58E-006 &  1.46E-005 \\ \midrule
      \multirow{3}{*}{PostgreSQL} & Mean (time, s) & 4.60E-005 & 5.01E-005 & 5.01E-005 & 4.85E-005 &  4.81E-005 \\
      & Standard Dev. &  6.71E-006 & 6.23E-006 & 5.25E-006 & 5.45E-006 &  1.87E-005 \\
      & Variance & 4.50E-011 & 3.88E-011 & 2.76E-011 & 2.97E-011 &  3.48E-010 \\ \midrule
      \multicolumn{2}{c}{Mean (PostgreSQL/MySQL)} & 15 & 191 & 328 & 672 & 1935 \\ \midrule
      \multicolumn{2}{c}{T Value} & 67 & 6 & 357 & 257 & 231 \\ \bottomrule
    \end{tabular}
  \end{table}
\end{document}

Since it is recommended to omit vertical lines for improving readability, you won't see none of them in the sample. The digits could be formatted with the siunitx package. Take a look into the manuals of the used packages to get familiar with them.


Best regards and welcome to the board
Thorsten¹