{"id":678,"date":"2020-01-27T09:54:10","date_gmt":"2020-01-27T09:54:10","guid":{"rendered":"https:\/\/statanalytica.com\/blog\/?p=678"},"modified":"2021-08-14T12:39:32","modified_gmt":"2021-08-14T11:39:32","slug":"excel-top-10-formula","status":"publish","type":"post","link":"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/","title":{"rendered":"Excel Top 10 Formula For The MS Excel Beginners"},"content":{"rendered":"\n<p>Excel is the top software for calculating the massive amount of numeric data. In this Information age, excel makes sense for calculating large amounts of data simple. Excel is a part of Microsoft office. Over the years there is much software designed to manipulate, analyze, and visualize data. But Microsoft Excel still remains the most efficient tool if the person has to make sense out of data. In this blog, we have accumulated all the vital information about excel top 10 formula. <\/p>\n\n\n\n<p>Also, we add some additional information, such as importance and tips for the beginner. Many beginners waste time by typing formula manually. Just learn this 10 formula and you will be able to work with your excel sheet efficiently.<\/p>\n\n\n\n<p>A lot to know a lot to discuss, let\u2019s get started.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Excel Top 10 Formula For The Beginners\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/wDSTO9IQSTQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"most-used-excel-top-10-formula\"><\/span><strong>Most Used Excel top 10 formula<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69f1f9442b2f1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ff5104;color:#ff5104\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ff5104;color:#ff5104\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69f1f9442b2f1\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#most-used-excel-top-10-formula\" >Most Used Excel top 10 formula<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#1-count-sum-average\" >1. Count, Sum, Average:-<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#2-if-statement\" >2. IF statement<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#3-sumif-countif-averageif\" >3. SUMIF, COUNTIF, AVERAGEIF.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#4-vlookup-hlookup\" >4. VLOOKUP &amp; HLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#5-concatenate\" >5. Concatenate<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#6-max-and-min\" >6. MAX and MIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#7-and\" >7. AND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#8-proper\" >8. PROPER<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#9conditional-formatting\" >9.Conditional formatting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#10-upper-lower-trim\" >10. UPPER, LOWER, TRIM.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/statanalytica.com\/blog\/excel-top-10-formula\/#conclusion\" >Conclusion.<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n\n\n\n<p>Excel offers 500+ functions but for a regular person or for a corporate person all the functions are not useful. Definitely every function has used for a specific case. But we are left with 10 functions that truly matters to everyone regardless of which profession you are.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-count-sum-average\"><\/span>1. <strong>Count, Sum, Average:-<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>These are some of the most useful commands in excel. Everyone who sees a spreadsheet knows while working this visual information person need these command very often and these are some of the basic mathematics formulas.<\/p>\n\n\n\n<p>These basic formulas are so important that they made at the top of this excel top 10 formula list.<\/p>\n\n\n\n<p><strong>COUNTING OF CELL(Count, Counta).<\/strong><\/p>\n\n\n\n<p><strong>Count: <\/strong>&nbsp;<\/p>\n\n\n\n<p>This command is useful when the user wants to count the number of cells that contain numeric values.<\/p>\n\n\n\n<p><strong>Command keyword:&nbsp;<\/strong><\/p>\n\n\n\n<p><strong>Count(2,3)<\/strong> <strong>=<\/strong>&nbsp;<\/p>\n\n\n\n<p>This command will give the number of values in the brackets. For example, in Count(2,3) there are only two values. This command only works with numbers. This command will only work for numeric values.<\/p>\n\n\n\n<p><strong>Count(B1, B2, B3&#8230;)<\/strong> <strong>=<\/strong>&nbsp;<\/p>\n\n\n\n<p>This command will give the number of the cells having a numeric value from selected cells specified in the bracket. It will not count the empty cells. This command only works with numbers.<\/p>\n\n\n\n<p><strong>Count(B1: B8)<\/strong> <strong>=<\/strong>&nbsp;<\/p>\n\n\n\n<p>This command will provide the number of values in the range of cells starting from B1, B2, B3\u2026till B8. For example in \u201cCount(B1: B8)\u201d the computer will count the number of cells that contain any value it will not count empty cells.<\/p>\n\n\n\n<p><strong>COUNTA(B1: B10) =<\/strong><\/p>\n\n\n\n<p>This command is useful when a user wants to count the number of non-empty cells in a range. This command works with numeric as well as alphabetical or any character. Besides, this command can also be used in these formats for examples such as Counta(B1, B2,&#8230;) or Counta(B1: B10) and Counta(2,4,6).<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Submission of the cells(SUM).<\/strong><\/li><\/ol>\n\n\n\n<p>This command performs an addition between selected cells or a range of cells. this command is only for numerical values. this command can be used in any format for example SUM(2,3) or SUM(B1, A5) and SUM(B2: B9).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/llWQABR5L_5_wvvV6qPZeKbbqSnLCcdoqzsG-soUWHwDw3n9gsfNBw2mOX9qHqwfn0wdHLKJfZUSbz8o9ngwvDt3qNJppe19ueSdzRsnLTABtr_-h9NDnxw7zDNPW_t5N2OMGHnC\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>SUM(2,3): <\/strong>Sum of numbers specified in the bracket.<\/p>\n\n\n\n<p><strong>SUM(A1, B2, C5&#8230;): <\/strong>Addition between selected cells only.<\/p>\n\n\n\n<p><strong>SUM(C1: C9): <\/strong>Addition in the range of cells.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Average:- <\/strong>As its name suggests it provides us with the average of the input numbers. It only calculates an average of the numerical value.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-if-statement\"><\/span><strong>2. IF statement<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This command is used for conditional output. Using this user can take any output from the computer according to the requirement.&nbsp;<\/p>\n\n\n\n<p><strong>Command keyword= <\/strong>IF(logical, output if logic is true, output if logic is false).<\/p>\n\n\n\n<p>Let\u2019s suppose an example that a company took a target to increase its turnover in a year then the management can follow strict rules in order to meet the target. They can monitor themselves through an excel sheet using a command like IF(turnover&gt;100cr. Turnover achieved, Turnover not achieved).<\/p>\n\n\n\n<p>Then by the end of the year\/session, the excel sheet will remind output about the turnover achieved or turnover not achieved.<\/p>\n\n\n\n<p>If command very important role and many functions can be performed through it. The importance is so huge that it made on the 2<sup>nd<\/sup> position of our excel top 10 formula.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-sumif-countif-averageif\"><\/span><strong>3. SUMIF, COUNTIF, AVERAGEIF.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>These commands are useful for the user when you want to put a condition on some of the basic commands like adding the data if the condition is fulfilled. Count the data if the condition gets fulfilled, Take an average of the data if the condition is true.<\/p>\n\n\n\n<p><strong>Command Keyword: <\/strong>SUMIF(Range, Criteria, {Sum_range}),&nbsp;<\/p>\n\n\n\n<p>COUNTIF(Range, Criteria),&nbsp;<\/p>\n\n\n\n<p>AVERAGEIF(Range, criteria)<\/p>\n\n\n\n<p>Furthermore, these conditional commands are very useful so 3<sup>rd<\/sup> Position in our excel top 10 formulas.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-vlookup-hlookup\"><\/span><strong>4. VLOOKUP &amp; HLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>As the name of this command it allows users to lookup for a value in an array. In VLOOKUP \u2018V\u2019 stands for vertical lookup. Similarly, in HLOOKUP H stands for horizontal. Basically in these commands we lookup for the values in an array.<\/p>\n\n\n\n<p><strong>Command Keyword:- <\/strong>VLOOKUP(lookup value, table array, column index number, range lookup).<\/p>\n\n\n\n<p>And HLOOKUP((lookup value, table array, row index number, range lookup ).<\/p>\n\n\n\n<p>So these are formulas that will provide you flexibility in the excel sheet. This command made it on the 4th position on our list of excel top 10 formula.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-concatenate\"><\/span><strong>5. Concatenate<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This command is used to combine the characters of two different cells. This is applicable when we have to combine first name, last name and combining addresses from a huge datasheet.<\/p>\n\n\n\n<p><strong>Command Keyword:<\/strong> CONCATENATE(text1, text2, text3\u2026).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-max-and-min\"><\/span><strong>6. MAX and MIN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>As the name suggests, the main function of both the commands is to search for the maximum value in a huge table, and the minimum value in a huge table.<\/p>\n\n\n\n<p><strong>Command Keyword: \u2018<\/strong>MAX(select range)\u2019 and \u2018MIN(select range)\u2019.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-and\"><\/span><strong>7. AND<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This is one very useful function. The user can use this function to check if any condition is true or false. There could more than one condition.<\/p>\n\n\n\n<p><strong>Command Keyword: <\/strong>AND(logic 1, logic 2,&#8230;).<\/p>\n\n\n\n<p>For example,&nbsp;<\/p>\n\n\n\n<p>AND(A1=&#8221;GOOD&#8221;,C3&gt;5) output would be TRUE if A1 is GOOD and the value of C3 is greater than 5.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8-proper\"><\/span><strong>8. PROPER<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This command is useful when you have huge data which is oddly formatted. if a cell has &#8220;tiMe iS moNeY&#8221; clearly the sentence needs formatting. so the user can use the proper command, for example, =PROPER(cell_number) and it would output a well-formatted sentence in the cell.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/A-ZDxGmF_U8l0d8q-IuuVksS8i8XH15aLDqQAl_ANodNSxi1MgJI9XnEe1c5Zxw-yUd7QovL5DV3c3XUefmHzR1hTRBKaap7o6mgNM3hAan9qqJKLz_eS7CJMMe6-CYEorogEkSk\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Command keyword: <\/strong>PROPER(cell no1., cell no2&#8230;), or PROPER(cel no1: cell no10).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9conditional-formatting\"><\/span><strong>9.Conditional formatting<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This command is useful if the user wants to format things with the condition. for example- let\u2019s suppose we have a table or huge data. And in our example figure we students marks and we want to see how many students got less than 50%.<\/p>\n\n\n\n<p><strong>Step 1<\/strong><\/p>\n\n\n\n<p>Select the cell range.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/oD0P7pixjQAktIwVFy3xJhCPr93QZgyE9FqQD0yjCI0DUaAEx7lw3Pj7zzrllmh8utkf5XlYMFVcPy-m7U_QpjZUfgxUtANjK1Oegj8q6l3v8XP45v8gsXhPTC1H6lwuYleZQ88n\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Step 2<\/strong><\/p>\n\n\n\n<p>Select the conditional formating<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/HUHsM-GuYIGNWlWPwmbscHQQHGJGaDvX7xCyxC29V5cLgi4U2ol7wa5t9xHgMVtQWLFePvmeD8ph6K4QC5jXvjKYAq7vjO84Mz-Eg8OOmyimS9kVpnUve3luAZK1IFyh8HcnqKqv\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Step 3<\/strong><\/p>\n\n\n\n<p>Select the condition greater than or less than in our example we need less than.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/rQhXKPdRW-h-Az3SdWc4JoU6YXNxcGUHM74YxY1512JVFIrIx8E6Is9IV-Nt0NN251e4nXof9rkeu5Xvs5Te3n4Bs_1u5_9X4ItkSSPDxKV9wlh_SKachZbFoHUTS9Wad1tWOK2l\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/TLYT1sY8HGecZmQIRNxe9WjN7U6TuJRdz5DF2f2T_DnQyd5Pwnxe1Pv57FOtHQClQw2IlNmRPpuq7ErUAVMGkTPyykwXYFQxDJIeJ1UvwVgymaQacL724USbA7ABPQRKn1pJArQN\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Step 4: <\/strong>Put the values in the pop-up then click ok.<\/p>\n\n\n\n<p>Now the table is highlighting the marks below 50%.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"10-upper-lower-trim\"><\/span><strong>10. UPPER, LOWER, TRIM.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>These commands are useful when the user has huge data that is not well structured and well-formatted. All of these commands define its function. The lower feature has used to convert all the characters in small letters within a cell. The upper feature will convert all the characters in Capital letters within a cell. Trim will remove all the space within a cell.<\/p>\n\n\n\n<p><strong>Command keywords:&nbsp;<\/strong><\/p>\n\n\n\n<p>LOWER(cell_number).<\/p>\n\n\n\n<p>UPPER(cell number).<\/p>\n\n\n\n<p>TRIM(cell number).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span><strong>Conclusion.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>These are all the excel top 10 formula that everyone should know in order to boost excel skills. Each of these commands is very basic. If you want to start improving your excel skills, then you must concentrate on these basic excel top 10 formula. Each of these commands gets complex as you want to perform more complicated tasks on the excel. The importance will be more clear once you perform these formula by yourself then you will understand why we added them in the list for excel top 10 formula.<\/p>\n\n\n\n<p>Get the best MS <strong>excel homework help<\/strong> from the <strong><a href=\"https:\/\/statanalytica.com\/excel-homework-help\">excel homework helper<\/a><\/strong>. We are offering the world class <strong><a href=\"https:\/\/statanalytica.com\/excel-homework-help\">excel homework assignment<\/a><\/strong> to the students at nominal charges.<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel is the top software for calculating the massive amount of numeric data. In this Information age, excel makes sense for calculating large amounts of data simple. Excel is a part of Microsoft office. Over the years there is much software designed to manipulate, analyze, and visualize data. But Microsoft Excel still remains the most [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":680,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[73],"tags":[],"class_list":["post-678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-statistics-software"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/posts\/678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/comments?post=678"}],"version-history":[{"count":0,"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/posts\/678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/media\/680"}],"wp:attachment":[{"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/media?parent=678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/categories?post=678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statanalytica.com\/blog\/wp-json\/wp\/v2\/tags?post=678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}