{"id":51281,"date":"2026-01-28T21:26:35","date_gmt":"2026-01-28T21:26:35","guid":{"rendered":"https:\/\/www.oracletutoring.ca\/blog\/?p=51281"},"modified":"2026-01-28T21:26:36","modified_gmt":"2026-01-28T21:26:36","slug":"statistics-spreadsheet-vs-calculator-part-1-google-sheets-compared-with-ti-83-plus-normal-cdf","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/statistics-spreadsheet-vs-calculator-part-1-google-sheets-compared-with-ti-83-plus-normal-cdf\/","title":{"rendered":"Statistics: spreadsheet vs calculator, part 1: Google Sheets compared with TI-83 Plus, normal cdf"},"content":{"rendered":"\n<h2>Tutoring statistics, one encounters various electronic facilities. The tutor compares Google Sheets with the TI-83 Plus using the normal cdf.<\/h2>\n<p>The following is according to my understanding.<\/p>\n\n<p>\nMy earlier coverage of a Google Sheets way to use the normal cdf one will find <a href=\"https:\/\/www.oracletutoring.ca\/blog\/statistics-spreadsheets-using-the-normal-cdf-on-google-sheets\/\">in my post from January 24.<\/a> Then, in <a href=\"https:\/\/www.oracletutoring.ca\/blog\/statistics-the-normal-cdf-on-the-ti-83-plus\/\">my post on January 27<\/a>, I show how to use the normal cdf on the TI-83 Plus. One who uses both will notice their different approaches.<\/p>\n<p>\nThe TI-83 Plus assumes the user understands the use of the normal distribution for finding the proportion of the population between two values of a normal distribution. For someone not expecting that, the lower bound requirement might come as a surprise. Yet, for someone who is used to the normal distribution, it&#8217;s very convenient. Moreover, the TI-83 Plus is not the only calculator I&#8217;ve encountered that&#8217;s set up this way.<\/p>\n<p>\nTo find, on Google Sheets, the proportion of a population between two values of a normal distribution, one can simply do two calculations, and afterward subtract. Here&#8217;s an example:\n<\/p>\n<p>\nSuppose the mean mile time of track-and-field students is 345 seconds with standard deviation 34 seconds. What percent of them run the mile between 295 and 305 seconds?<\/p>\n<p>\nSolution: To find the proportion whose run times are between 295s and 305s, the user can apply NORMDIST twice, then subtract, as follows:<\/p>\n<p>\nLet&#8217;s imagine in Cell E5 one enters =normdist(295,345,34,1): the answer, it seems, will be 0.07070 rounded. Then, in Cell F5, one enters =normdist(305,345,34,1): the answer, it seems, will be 0.11970 rounded. Next, in Cell G5, one can enter = F5 &#8211; E5: the answer, it seems, will be 0.04900 rounded.<\/p>\n<p>\nThe meaning of the answer in Cell G5 is that the proportion of the students who run the mile between 295s and 305s is 0.049, or 4.9 percent.<\/p>\n<p>\nTo get the same answer on the TI-83 Plus, one would key in 2nd VARS 2 295,305,345,34) Enter.<\/p>\n<p>\nSource:<\/p>\n<p><a href=\"https:\/\/support.google.com\/docs\/answer\/3094021?hl=en\">support.google.com NORMDIST<\/a><\/p>\n<p>Texas Instruments (1999). <em>TI-83 Plus Graphing Calculator Guidebook<\/em>. Texas Instruments Incorporated.<\/p>\nJack of <a href=\"https:\/\/www.oracletutoring.ca\">Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.\n","protected":false},"excerpt":{"rendered":"<p>Tutoring statistics, one encounters various electronic facilities. The tutor compares Google Sheets with the TI-83 Plus using the normal cdf. The following is according to my understanding. My earlier coverage of a Google Sheets way to use the normal cdf &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/statistics-spreadsheet-vs-calculator-part-1-google-sheets-compared-with-ti-83-plus-normal-cdf\/\"> <span class=\"screen-reader-text\">Statistics: spreadsheet vs calculator, part 1: Google Sheets compared with TI-83 Plus, normal cdf<\/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":[3934,3996,3995,3978,3991,3985,292,3993,3990,3994,451],"class_list":["post-51281","post","type-post","status-publish","format-standard","hentry","category-statistics","tag-google-sheets","tag-google-sheets-normal-distribution-between-two-values","tag-google-sheets-normdist","tag-normal-cdf","tag-normal-cdf-between-two-values","tag-normal-cumulative-distribution-function","tag-normal-distribution","tag-normal-distribution-between-two-values","tag-normal-distribution-function","tag-normal-distribution-function-between-two-values","tag-ti-83-plus"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/51281","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=51281"}],"version-history":[{"count":8,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/51281\/revisions"}],"predecessor-version":[{"id":51289,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/51281\/revisions\/51289"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=51281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=51281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=51281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}