{"id":1223,"date":"2021-02-26T16:10:46","date_gmt":"2021-02-26T08:10:46","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1223"},"modified":"2021-02-26T21:33:43","modified_gmt":"2021-02-26T13:33:43","slug":"financial-and-statistical-functions-in-easy-excel-analysis-and-sql-data-analysis","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2021\/02\/26\/financial-and-statistical-functions-in-easy-excel-analysis-and-sql-data-analysis\/","title":{"rendered":"Financial and statistical functions in Easy Excel Analysis and SQL Data Analysis"},"content":{"rendered":"<p>In <a href=\"https:\/\/www.yohz.com\/ya_eea_overview.htm\">Easy Excel Analysis<\/a> and <a href=\"https:\/\/www.yohz.com\/sda_details.htm\">SQL Data Analysis<\/a> 2, we added <a href=\"https:\/\/www.yohz.com\/help\/easyexcelanalysis\/advanced_summaries.htm\">statistical and financial functions<\/a> to the analysis tables.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1233\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/02\/stats01.png\" alt=\"\" width=\"715\" height=\"517\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/02\/stats01.png 715w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/02\/stats01-300x217.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/02\/stats01-624x451.png 624w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/p>\n<p>To use these functions, right click on the column header you want to compute to bring up the context menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1234\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/02\/stats02.png\" alt=\"\" width=\"542\" height=\"250\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/02\/stats02.png 542w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/02\/stats02-300x138.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/p>\n<p>Select the <strong>advanced<\/strong> item.\u00a0 This then brings up the <strong>Advanced Summary Item<\/strong> window where you can define the data source for the various parameters required for the function you select.<\/p>\n<p>See also:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.yohz.com\/blogs\/?p=1237&amp;preview=true\">why do you need to define a period for the IRR, MIRR and NPV financial functions<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2021\/02\/26\/financial-and-statistical-functions-in-easy-excel-analysis-and-sql-data-analysis\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2021\/02\/26\/financial-and-statistical-functions-in-easy-excel-analysis-and-sql-data-analysis\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>In Easy Excel Analysis and SQL Data Analysis 2, we added statistical and financial functions to the analysis tables. To use these functions, right click on the column header you want to compute to bring up the context menu. Select the advanced item.\u00a0 This then brings up the Advanced Summary Item window where you can [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82,86],"tags":[83,87],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1223"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=1223"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1223\/revisions"}],"predecessor-version":[{"id":1251,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1223\/revisions\/1251"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}