{"id":1203,"date":"2024-09-05T23:09:45","date_gmt":"2024-09-05T21:09:45","guid":{"rendered":"https:\/\/site.ellistat.com\/?p=1203"},"modified":"2024-10-23T15:16:15","modified_gmt":"2024-10-23T13:16:15","slug":"how-to-analyze-a-data-table","status":"publish","type":"post","link":"https:\/\/ellistat.com\/en\/comment-analyser-un-tableau-de-donnees\/","title":{"rendered":"How do you analyze a data table?"},"content":{"rendered":"

Often, when we want to understand how a process works, we find ourselves faced with a table of data like the one below. In this example, we'd like to see which parameters influence the pH of a swimming pool.<\/p>\n\n\n\n

Pastille supplier<\/th>Water temperature<\/th>Time between 2 tablets<\/th>pH<\/th><\/tr><\/thead>
A<\/td>21.8<\/td>8.0<\/td>7.5<\/td><\/tr>
A<\/td>21.9<\/td>5.0<\/td>7.4<\/td><\/tr>
A<\/td>23.4<\/td>9.0<\/td>7.4<\/td><\/tr>
A<\/td>21.7<\/td>10.0<\/td>7.2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

In other words, a table containing multiple rows, each of which contains information about the measurement you wish to improve (in this case, pH) and the process conditions at the time of manufacture\/measurement (in this case, the type of tablet supplier, the water temperature and the time since the last tablet). The difficulty with this type of exercise is how to analyze the data and find out from it how the process works.<\/p>\n\n\n\n

????Tip<\/strong>Do not merge cells in Excel when constructing this type of table, as this generally complicates analysis after the fact.<\/p>\n\n\n\n

Step 1 to analyze your data: Look the table straight in the eye<\/h3>\n\n\n\n

Our first reaction to this type of picture is often to look it straight in the eye and try to understand from the figures how the process behaves. I'll let you do that, but it's not easy, because our brains aren't made for it. In fact, 70% of our nerve cells are designed to analyze visual information. But a table of figures doesn't contain much visual information, especially numbers that we'll find hard to interpret. So, if we want to form an intuition, we need to quickly move on to step 2.<\/p>\n\n\n\n

Step 2 for data analysis: Building graphs<\/h3>\n\n\n\n

Our brains are visual, so we're going to satisfy them by giving them graphics to look at.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

The graph above shows the pH measurements according to the two suppliers A and B. It's immediately clearer, as we can see that the tablet supplier seems to have an influence on the pH of our pool... However, making graphs shouldn't be the ultimate step in our analysis. While it may give our brains an intuition, it doesn't provide proof that the tablet supplier does indeed have an influence on the pool's pH. For this, we need to statistical proof<\/strong>.<\/p>\n\n\n\n

Step 3 to analyze your data : Proof with statistical tests<\/h3>\n\n\n\n

Once you know which graphics are interesting, just ask Ellistat<\/a> to provide us with statistical proof of our claims by clicking on the \"statistical proof\" button. The following window appears:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

If you read what Ellistat tells us, you can see that the difference in averages (ANAVAR and TEST T tests)<\/a> is statistically \"very significantly different\". This is proof of the supplier's influence. It's no longer intuition, but proof.<\/p>\n\n\n\n

Step 4 to analyze your data: Model the process<\/h3>\n\n\n\n

Perfect, we've shown the influence of the tablet supplier. But can we go further? Well, yes, by trying to model the process. Instead of analyzing columns one by one, we'll try to analyze multiple columns at once, using multiple regression. The result is as follows:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Using multiple regression, we see not only that the influence of the lozenge supplier is statistically significant (Read the Signif column), but we also see that the time since the last lozenge is also influential. And all this in a single study - it's almost magical.<\/p>\n\n\n\n

To take it a step further, simply go to the forecasting tab and you'll be able to predict the pH of your pool according to the type of supplier, the time between two tablets and the water temperature:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Thus, using supplier A and a time between two tablets of 7.5 days, we predict an average pH of 7.4.<\/p>\n\n\n\n

Conclusion<\/h3>\n\n\n\n

Analyzing a data table isn't all that complicated. All you need to do is master the last 3 steps in this article to understand how your processes work. To help you in this process, Ellistat guides you through the study so that you don't have to worry about statistical calculations, but concentrate on understanding the physical phenomena involved.<\/p>","protected":false},"excerpt":{"rendered":"

Souvent, lorsque l\u2019on souhaite comprendre le fonctionnement d\u2019un proc\u00e9d\u00e9, on se retrouve face \u00e0 un tableau de donn\u00e9es du type ci-dessous. Dans cet exemple, on souhaite voir quels sont les param\u00e8tres qui influent sur le pH d\u2019une piscine. Fournisseur Pastille Temp\u00e9rature eau Temps entre 2 pastilles pH A 21.8 8.0 7.5 A 21.9 5.0 7.4 […]<\/p>\n","protected":false},"author":2,"featured_media":1208,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analysis"],"acf":[],"yoast_head":"\nComment analyser un tableau de donn\u00e9es ? - Ellistat<\/title>\n<meta name=\"description\" content=\"Ellistat vous guide dans les \u00e9tapes pour analyser un tableau de donn\u00e9es pour que vous n'ayez pas \u00e0 vous souciez des calculs statistiques.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ellistat.com\/en\/how-to-analyze-a-data-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment analyser un tableau de donn\u00e9es ? - Ellistat\" \/>\n<meta property=\"og:description\" content=\"Ellistat vous guide dans les \u00e9tapes pour analyser un tableau de donn\u00e9es pour que vous n'ayez pas \u00e0 vous souciez des calculs statistiques.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ellistat.com\/en\/how-to-analyze-a-data-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Ellistat\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-05T21:09:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-23T13:16:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ellistat.com\/wp-content\/uploads\/2024\/09\/spreadsheet-2816806_1280.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"960\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Davy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Davy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/\"},\"author\":{\"name\":\"Davy\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/#\\\/schema\\\/person\\\/e2a04a9eb45bae5d885b534cbf70df8d\"},\"headline\":\"Comment analyser un tableau de donn\u00e9es ?\",\"datePublished\":\"2024-09-05T21:09:45+00:00\",\"dateModified\":\"2024-10-23T13:16:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/\"},\"wordCount\":798,\"image\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ellistat.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/spreadsheet-2816806_1280.jpg\",\"articleSection\":[\"Data Analysis\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/\",\"url\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/\",\"name\":\"Comment analyser un tableau de donn\u00e9es ? - Ellistat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ellistat.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/spreadsheet-2816806_1280.jpg\",\"datePublished\":\"2024-09-05T21:09:45+00:00\",\"dateModified\":\"2024-10-23T13:16:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/#\\\/schema\\\/person\\\/e2a04a9eb45bae5d885b534cbf70df8d\"},\"description\":\"Ellistat vous guide dans les \u00e9tapes pour analyser un tableau de donn\u00e9es pour que vous n'ayez pas \u00e0 vous souciez des calculs statistiques.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ellistat.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/spreadsheet-2816806_1280.jpg\",\"contentUrl\":\"https:\\\/\\\/ellistat.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/spreadsheet-2816806_1280.jpg\",\"width\":1280,\"height\":960,\"caption\":\"illustration d'un tableau de donn\u00e9e \u00e0 analyser\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/comment-analyser-un-tableau-de-donnees\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/ellistat.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Analysis\",\"item\":\"https:\\\/\\\/ellistat.com\\\/category\\\/data-analysis\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Comment analyser un tableau de donn\u00e9es ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/#website\",\"url\":\"https:\\\/\\\/ellistat.com\\\/\",\"name\":\"Ellistat\",\"description\":\"La suite qualit\u00e9 de l'industrie m\u00e9canique\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ellistat.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/#\\\/schema\\\/person\\\/e2a04a9eb45bae5d885b534cbf70df8d\",\"name\":\"Davy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ellistat.com\\\/wp-content\\\/litespeed\\\/avatar\\\/e2d1fff799059e0c9b9f4f3451274ada.jpg?ver=1776273376\",\"url\":\"https:\\\/\\\/ellistat.com\\\/wp-content\\\/litespeed\\\/avatar\\\/e2d1fff799059e0c9b9f4f3451274ada.jpg?ver=1776273376\",\"contentUrl\":\"https:\\\/\\\/ellistat.com\\\/wp-content\\\/litespeed\\\/avatar\\\/e2d1fff799059e0c9b9f4f3451274ada.jpg?ver=1776273376\",\"caption\":\"Davy\"},\"sameAs\":[\"https:\\\/\\\/ellistat.com\"],\"url\":\"https:\\\/\\\/ellistat.com\\\/en\\\/author\\\/elliadmin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to analyse a data table? - Ellistat","description":"Ellistat guides you through the steps involved in analyzing a data table, so you don't have to worry about statistical calculations.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ellistat.com\/en\/how-to-analyze-a-data-table\/","og_locale":"en_US","og_type":"article","og_title":"Comment analyser un tableau de donn\u00e9es ? - Ellistat","og_description":"Ellistat vous guide dans les \u00e9tapes pour analyser un tableau de donn\u00e9es pour que vous n'ayez pas \u00e0 vous souciez des calculs statistiques.","og_url":"https:\/\/ellistat.com\/en\/how-to-analyze-a-data-table\/","og_site_name":"Ellistat","article_published_time":"2024-09-05T21:09:45+00:00","article_modified_time":"2024-10-23T13:16:15+00:00","og_image":[{"width":1280,"height":960,"url":"https:\/\/ellistat.com\/wp-content\/uploads\/2024\/09\/spreadsheet-2816806_1280.jpg","type":"image\/jpeg"}],"author":"Davy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Davy","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/#article","isPartOf":{"@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/"},"author":{"name":"Davy","@id":"https:\/\/ellistat.com\/#\/schema\/person\/e2a04a9eb45bae5d885b534cbf70df8d"},"headline":"Comment analyser un tableau de donn\u00e9es ?","datePublished":"2024-09-05T21:09:45+00:00","dateModified":"2024-10-23T13:16:15+00:00","mainEntityOfPage":{"@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/"},"wordCount":798,"image":{"@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/#primaryimage"},"thumbnailUrl":"https:\/\/ellistat.com\/wp-content\/uploads\/2024\/09\/spreadsheet-2816806_1280.jpg","articleSection":["Data Analysis"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/","url":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/","name":"How to analyse a data table? - Ellistat","isPartOf":{"@id":"https:\/\/ellistat.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/#primaryimage"},"image":{"@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/#primaryimage"},"thumbnailUrl":"https:\/\/ellistat.com\/wp-content\/uploads\/2024\/09\/spreadsheet-2816806_1280.jpg","datePublished":"2024-09-05T21:09:45+00:00","dateModified":"2024-10-23T13:16:15+00:00","author":{"@id":"https:\/\/ellistat.com\/#\/schema\/person\/e2a04a9eb45bae5d885b534cbf70df8d"},"description":"Ellistat guides you through the steps involved in analyzing a data table, so you don't have to worry about statistical calculations.","breadcrumb":{"@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/#primaryimage","url":"https:\/\/ellistat.com\/wp-content\/uploads\/2024\/09\/spreadsheet-2816806_1280.jpg","contentUrl":"https:\/\/ellistat.com\/wp-content\/uploads\/2024\/09\/spreadsheet-2816806_1280.jpg","width":1280,"height":960,"caption":"illustration d'un tableau de donn\u00e9e \u00e0 analyser"},{"@type":"BreadcrumbList","@id":"https:\/\/ellistat.com\/comment-analyser-un-tableau-de-donnees\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/ellistat.com\/"},{"@type":"ListItem","position":2,"name":"Data Analysis","item":"https:\/\/ellistat.com\/category\/data-analysis\/"},{"@type":"ListItem","position":3,"name":"Comment analyser un tableau de donn\u00e9es ?"}]},{"@type":"WebSite","@id":"https:\/\/ellistat.com\/#website","url":"https:\/\/ellistat.com\/","name":"Ellistat","description":"The quality suite for the mechanical engineering industry","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ellistat.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ellistat.com\/#\/schema\/person\/e2a04a9eb45bae5d885b534cbf70df8d","name":"Davy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ellistat.com\/wp-content\/litespeed\/avatar\/e2d1fff799059e0c9b9f4f3451274ada.jpg?ver=1776273376","url":"https:\/\/ellistat.com\/wp-content\/litespeed\/avatar\/e2d1fff799059e0c9b9f4f3451274ada.jpg?ver=1776273376","contentUrl":"https:\/\/ellistat.com\/wp-content\/litespeed\/avatar\/e2d1fff799059e0c9b9f4f3451274ada.jpg?ver=1776273376","caption":"Davy"},"sameAs":["https:\/\/ellistat.com"],"url":"https:\/\/ellistat.com\/en\/author\/elliadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/posts\/1203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/comments?post=1203"}],"version-history":[{"count":2,"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/posts\/1203\/revisions"}],"predecessor-version":[{"id":1805,"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/posts\/1203\/revisions\/1805"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/media\/1208"}],"wp:attachment":[{"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/media?parent=1203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/categories?post=1203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ellistat.com\/en\/wp-json\/wp\/v2\/tags?post=1203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}