{"id":24092,"date":"2017-09-22T16:27:17","date_gmt":"2017-09-22T16:27:17","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=24092"},"modified":"2017-09-22T16:27:17","modified_gmt":"2017-09-22T16:27:17","slug":"spreadsheets-p-value-with-excel","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-p-value-with-excel\/","title":{"rendered":"Spreadsheets: p-value with Excel"},"content":{"rendered":"<h1>Tutoring stats, you deal with p-values. The tutor shows an Excel connection.<\/h1>\n<p>In my posts <a href=\"?p=17786\">here<\/a> and <a href=\"?p=17820\">here<\/a> I mention p-values.<\/p>\n<p><strong>Example: Using Excel, get a two-tailed p-value for z=2.4<\/strong><\/p>\n<p>Solution: Using symmetry, it&#8217;s best to get the cumulative z-probability for -2.4, then double it:<\/p>\n<p>=2*normsdist(-2.4)<\/p>\n<p>Jack of <a href=\"https:\/\/www.oracletutoring.ca\">Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutoring stats, you deal with p-values. The tutor shows an Excel connection. In my posts here and here I mention p-values. Example: Using Excel, get a two-tailed p-value for z=2.4 Solution: Using symmetry, it&#8217;s best to get the cumulative z-probability &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-p-value-with-excel\/\"> <span class=\"screen-reader-text\">Spreadsheets: p-value with Excel<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[2501],"class_list":["post-24092","post","type-post","status-publish","format-standard","hentry","category-statistics","tag-p-value-using-excel"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/24092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=24092"}],"version-history":[{"count":16,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/24092\/revisions"}],"predecessor-version":[{"id":24108,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/24092\/revisions\/24108"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=24092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=24092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=24092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}