{"id":182330,"date":"2024-03-28T01:22:00","date_gmt":"2024-03-28T00:22:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=182330"},"modified":"2024-03-09T20:08:42","modified_gmt":"2024-03-09T19:08:42","slug":"calculating-means-with-excel-4-essential-tips","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips","title":{"rendered":"Calculating means with Excel: 4 essential tips"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"182330\" class=\"elementor elementor-182330\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d488fc0 e-flex e-con-boxed e-con\" data-id=\"d488fc0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3ca6673 elementor-widget elementor-widget-heading\" data-id=\"3ca6673\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Despite the emergence of a wide range of data processing software, Excel is still one of the most widely used business solutions, for example to calculate means with Excel.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efefd31 elementor-widget elementor-widget-text-editor\" data-id=\"efefd31\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Through its functions and formulas, this Microsoft tool simplifies data preparation, analysis and visualization. One of the most important functions is, of course, Excel averaging. DataScientest explains how it&#8217;s done.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Standard deviations in Excel: What's it for? How do I calculate it?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/standard-deviations-in-excel-whats-it-for-how-do-i-calculate-it\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/standard-deviations-in-excel-whats-it-for-how-do-i-calculate-it\" target=\"_blank\" rel=\"noopener\">Standard deviations in Excel: What&#8217;s it for? How do I calculate it?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel VBA: How to automate tasks with this language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\" target=\"_blank\" rel=\"noopener\">Excel VBA: How to automate tasks with this language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Pie Chart Excel: Mastering Data Visualization &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\" target=\"_blank\" rel=\"noopener\">Pie Chart Excel: Mastering Data Visualization <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Creating Stunning Excel Charts: A Step-by-Step Guide&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\" target=\"_blank\" rel=\"noopener\">Creating Stunning Excel Charts: A Step-by-Step Guide<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4563a6d e-flex e-con-boxed e-con\" data-id=\"4563a6d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5240ef3 elementor-widget elementor-widget-heading\" data-id=\"5240ef3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I calculate means with Excel?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a767fb elementor-widget elementor-widget-text-editor\" data-id=\"3a767fb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The average is the sum of all numerical values in a list, divided by the number of terms. To calculate it with a<strong> Microsoft 365 Excel spreadsheet,<\/strong> you don&#8217;t need to add all the values manually. Instead, you can use a specific function. Here&#8217;s how to do it:<\/p><ul><li>Select an empty cell in which you want the average to appear;<\/li><li>Type =MOYENNE( ;<\/li><li>Select the cell range for which you want to calculate the average;<\/li><li>Close the parenthesis;<\/li><li>Type Enter.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12e88cf elementor-widget elementor-widget-text-editor\" data-id=\"12e88cf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For example, the average calculation formula in Excel might look like this: =MOYENNE(A2;A23). The average then <strong>appears in the cell where you wrote down the formula.<\/strong><\/p><p><strong>Good to know:<\/strong> rather than typing formulas manually, you can also use the formula designer to avoid typing errors.<\/p><p><strong>Here&#8217;s how:<\/strong> go to Formulas &gt; Insert &gt; choose your function. The formula designer appears for you to enter your data. But beware, depending on the version of Excel (Excel 2016, Excel 2019, Excel 2021, Excel for Mac, &#8230;), there may be slight variations in the approach.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-300dc7d e-flex e-con-boxed e-con\" data-id=\"300dc7d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d3bba49 elementor-widget elementor-widget-heading\" data-id=\"d3bba49\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do you calculate the average of non-adjacent cells\/ means with Excel?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b7bc443 elementor-widget elementor-widget-text-editor\" data-id=\"b7bc443\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>While the previous method is very efficient for calcuating <strong>means with Excel<\/strong> it necessarily implies that cells are adjacent to each other within the same data range.<\/p><p>But what if you only want to include certain non-adjacent cells?<\/p><p>Simply follow these steps:<\/p><ul><li>Select the cell in which you want the average to appear;<\/li><li>Type =MOYENNE( ;<\/li><li>Select the cells you wish to include in the average and separate them with semicolons;<\/li><li>Close the parenthesis;<\/li><li>Type Enter.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dfbe8f7 elementor-widget elementor-widget-text-editor\" data-id=\"dfbe8f7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<span style=\"font-weight: 400;\">For example, the formula might look like this: <\/span>\n<p style=\"padding-left: 40px;\"><b>=MOYENNE(A2;A7;A15;A18;A23)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6fcc7a0 elementor-widget elementor-widget-image\" data-id=\"6fcc7a0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel1.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b1b7ec0 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"b1b7ec0\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Microsoft Excel training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-60ecf0c e-flex e-con-boxed e-con\" data-id=\"60ecf0c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fd0a016 elementor-widget elementor-widget-heading\" data-id=\"fd0a016\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do you calculate a weighted average in your Excel file?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c52bc4f elementor-widget elementor-widget-text-editor\" data-id=\"c52bc4f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>weighted average corresponds to the average of several numerical values,<\/strong> each of which is assigned a coefficient.<\/p><p>For example: if you want to know the weighted average of orders placed for different products, you&#8217;ll need to <strong>divide the total cost of orders by the total number of units ordered.<\/strong><\/p><p>To explain this approach, let&#8217;s assume that the price per unit corresponds to column B, and the <strong>number of units sold corresponds to column C.<\/strong><\/p><p>In this case, you&#8217;ll need to use the <strong>SUMPROD<\/strong> function. Here&#8217;s how it works:<\/p><ul><li>Select the cell in which you want the average to appear;<\/li><li>Type =SOMMEPROD( ;<\/li><li>Select the range corresponding to prices per unit, then add a semicolon ;<\/li><li>Select the range corresponding to the number of units and close the parenthesis ;<\/li><li>Add the divide symbol (\/)<\/li><li>Type =SOMM( ;<\/li><li>Select the range corresponding to the number of units and close the parenthesis;<\/li><li>Type Enter.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4ff953 elementor-widget elementor-widget-text-editor\" data-id=\"c4ff953\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<span style=\"font-weight: 400;\">Here is an example of the result:<\/span>.\n<p style=\"padding-left: 40px;\"><b>=SOMMEPROD(B2:B17;C2:C17)\/SOMME(C2:C17)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3c21cec e-flex e-con-boxed e-con\" data-id=\"3c21cec\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-72fc465 elementor-widget elementor-widget-heading\" data-id=\"72fc465\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do you calculate an average while ignoring specific values?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c2d9172 elementor-widget elementor-widget-text-editor\" data-id=\"c2d9172\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">If you wish to exclude certain specific values (such as values equal to 0), you will need<\/span><b> to use the AVERAGE.IF function. <\/b><span style=\"font-weight: 400;\">Here&#8217;s how it works:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select the cell in which you want the average to appear; <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Type =MOYENNE.SI(; <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select the cell range for which you wish to calculate the average, then add a semicolon; <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Type &#8221; &lt;&gt;0&#8243;; <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Close the parenthesis; <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Type Enter<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ced5e5 elementor-widget elementor-widget-text-editor\" data-id=\"9ced5e5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<span style=\"font-weight: 400;\">Here is an example of a formula for calculating an average in Excel while ignoring certain values:<\/span>\n<p style=\"padding-left: 40px;\"><b>=MOYENNE.SI(B2:B17; &#8221; <>0 &#8220;)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bfc2483 e-flex e-con-boxed e-con\" data-id=\"bfc2483\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-596c608 elementor-widget elementor-widget-heading\" data-id=\"596c608\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Go deeper in Excel with DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-500efa7 elementor-widget elementor-widget-text-editor\" data-id=\"500efa7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>While the average is one of the most important calculations to know, it&#8217;s far from the only one. Indeed, to carry out relevant analyses or create <a href=\"https:\/\/datascientest.com\/en\/manifold-learning-what-is-this-machine-learning-method\">Machine Learning models,<\/a> Data Analysts and Data Scientists need to master a multitude of mathematical and statistical concepts, such as variance, standard deviation, mode, median&#8230;<\/p><p>All these methods are reviewed within our training courses at DataScientest.<\/p><p>But it&#8217;s not just a matter of reviewing theoretical calculation methods. Instead, we give them practical application to help you improve your <a href=\"https:\/\/datascientest.com\/en\/project-environment-preparation-essential-steps-for-smooth-workflow\">data preparation<\/a>, analysis and modeling skills.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efd161c elementor-widget elementor-widget-image\" data-id=\"efd161c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/moyenne-excel2.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a09b7e elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4a09b7e\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-excel\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Start your Excel training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-008c062 e-flex e-con-boxed e-con\" data-id=\"008c062\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-78b2cc3 elementor-widget elementor-widget-html\" data-id=\"78b2cc3\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"How do I calculate an average in Excel?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The average is the sum of all the numerical values in a list divided by the number of terms. To calculate it with a Microsoft 365 Excel spreadsheet, you don't need to add all the values manually. Instead, a specific function can be used.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I calculate the average of non-adjacent cells?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"If the previous method is very efficient for calculating the average on Excel, it necessarily implies that the cells are adjacent on the same data range. But what if you only want to include certain non-adjacent cells?\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do you calculate a weighted average on your Excel file?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The weighted average corresponds to the average of several numerical values, which are assigned a coefficient. For example: if you want to know the weighted average of orders placed for different products, you'll need to divide the total cost of the orders by the total number of units ordered.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Despite the emergence of a wide range of data processing software, Excel is still one of the most widely used business solutions, for example to calculate means with Excel. Through its functions and formulas, this Microsoft tool simplifies data preparation, analysis and visualization. One of the most important functions is, of course, Excel averaging. DataScientest [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":182331,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculating means with Excel: 4 essential tips<\/title>\n<meta name=\"description\" content=\"When you want to calculate means with Excel, you have to follow the following steps in order to obtain a quality...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculating means with Excel: 4 essential tips\" \/>\n<meta property=\"og:description\" content=\"Despite the emergence of a wide range of data processing software, Excel is still one of the most widely used business solutions, for example to calculate\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-28T00:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-09T19:08:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/03\/moyenne-excel-1024x512-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Calculating means with Excel: 4 essential tips\",\"datePublished\":\"2024-03-28T00:22:00+00:00\",\"dateModified\":\"2024-03-09T19:08:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips\"},\"wordCount\":749,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips\",\"url\":\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips\",\"name\":\"Calculating means with Excel: 4 essential tips\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-28T00:22:00+00:00\",\"dateModified\":\"2024-03-09T19:08:42+00:00\",\"description\":\"When you want to calculate means with Excel, you have to follow the following steps in order to obtain a quality...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Calculating means with Excel: 4 essential tips","description":"When you want to calculate means with Excel, you have to follow the following steps in order to obtain a quality...","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:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips","og_locale":"en_GB","og_type":"article","og_title":"Calculating means with Excel: 4 essential tips","og_description":"Despite the emergence of a wide range of data processing software, Excel is still one of the most widely used business solutions, for example to calculate","og_url":"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-28T00:22:00+00:00","article_modified_time":"2024-03-09T19:08:42+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/03\/moyenne-excel-1024x512-1.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Calculating means with Excel: 4 essential tips","datePublished":"2024-03-28T00:22:00+00:00","dateModified":"2024-03-09T19:08:42+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips"},"wordCount":749,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips","url":"https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips","name":"Calculating means with Excel: 4 essential tips","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-28T00:22:00+00:00","dateModified":"2024-03-09T19:08:42+00:00","description":"When you want to calculate means with Excel, you have to follow the following steps in order to obtain a quality...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/calculating-means-with-excel-4-essential-tips"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182330"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=182330"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182330\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/182331"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=182330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=182330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=182330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}