{"id":363,"date":"2014-05-30T18:54:22","date_gmt":"2014-05-30T15:54:22","guid":{"rendered":"http:\/\/www.sjut.org\/math\/?p=363"},"modified":"2014-05-31T17:01:34","modified_gmt":"2014-05-31T14:01:34","slug":"mat212-14-05-30-spreadsheets","status":"publish","type":"post","link":"http:\/\/www.sjut.org\/math\/index.php\/mat212-14-05-30-spreadsheets\/","title":{"rendered":"Statistics using spreadsheets"},"content":{"rendered":"

A student asked how to work a problem with the sample distribution of Pearson’s r using a calculator alone. It involves using a z-table<\/a>, but so many tools are available to make the work easier – even some accessible from a smart phone with a web browser. More on that another time.<\/p>\n

For those with access to a spreadsheet: Microsoft Excel, OpenOffice or LibreOffice Calc, Kingsoft Office, Gnumeric and Google Sheets offer a wealth of statistical tools.<\/p>\n

Click here to download a spreadsheet<\/a> that solves the problem on page 319 of the Lane textbook<\/a> and Exercise 2 on page 324 of Lane.<\/p>\n

If you do not have spreadsheet software, try looking with Excel Online<\/a> or Google Sheets<\/a>. (Note: you will need either a free Microsoft (Excel) or Gmail (Google) account to make a copy and edit the file, otherwise you can only view.)<\/p>\n

The main functions are:<\/p>\n

FISHER<\/strong><\/em>(r value)<\/strong>, which transforms the correlation coefficient into a normal variable<\/p>\n

NORMSDIST(Z-value)<\/strong><\/em>, which returns the cumulative distribution for the standard normal distribution with mean = 0 and standard deviation = 1<\/p>\n

NORMDIST(X-value, Mean, Std.Dev,1)<\/strong><\/em>, which returns the cumulative distribution for the normal distribution with mean = Mean<\/em> and standard deviation = Std.Dev.<\/em><\/p>\n

Computers make the mechanics of statistics easy, so we can focus on understanding, analysis and interpretation!<\/p>\n","protected":false},"excerpt":{"rendered":"

A student asked how to work a problem with the sample distribution of Pearson’s r using a calculator alone. It involves using a z-table, but so many tools are available […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/posts\/363"}],"collection":[{"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/comments?post=363"}],"version-history":[{"count":7,"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/posts\/363\/revisions"}],"predecessor-version":[{"id":370,"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/posts\/363\/revisions\/370"}],"wp:attachment":[{"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/media?parent=363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/categories?post=363"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sjut.org\/math\/index.php\/wp-json\/wp\/v2\/tags?post=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}