{"id":1125,"date":"2016-06-27T10:12:33","date_gmt":"2016-06-27T14:12:33","guid":{"rendered":"https:\/\/sites.berry.edu\/vbissonnette\/?page_id=1125"},"modified":"2023-12-29T09:07:24","modified_gmt":"2023-12-29T14:07:24","slug":"statistical-spreadsheets","status":"publish","type":"page","link":"https:\/\/sites.berry.edu\/vbissonnette\/index\/statistical-spreadsheets\/","title":{"rendered":"Statistical Spreadsheets"},"content":{"rendered":"<h3>Just the Basics<\/h3>\n<p>I created these spreadsheets for students who have difficulty installing Java and running the <em>Stats Homework<\/em> package (e.g., students with older computers or Chromebooks). \u00a0This ensures that all students have free, user-friendly software support for double-checking their hand-written calculations.\u00a0 Each present cells where the student enters a very small data set, and a table that displays the results of the statistical analysis. \u00a0For example, here is the spreadsheet that computes descriptive statistics:<\/p>\n<p><a href=\"https:\/\/sites.berry.edu\/vbissonnette\/wp-content\/uploads\/sites\/21\/2021\/07\/SpreadSheets.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2013\" src=\"https:\/\/sites.berry.edu\/vbissonnette\/wp-content\/uploads\/sites\/21\/2021\/07\/SpreadSheets.png\" alt=\"\" width=\"873\" height=\"572\" srcset=\"https:\/\/sites.berry.edu\/vbissonnette\/wp-content\/uploads\/sites\/21\/2021\/07\/SpreadSheets.png 873w, https:\/\/sites.berry.edu\/vbissonnette\/wp-content\/uploads\/sites\/21\/2021\/07\/SpreadSheets-300x197.png 300w, https:\/\/sites.berry.edu\/vbissonnette\/wp-content\/uploads\/sites\/21\/2021\/07\/SpreadSheets-768x503.png 768w, https:\/\/sites.berry.edu\/vbissonnette\/wp-content\/uploads\/sites\/21\/2021\/07\/SpreadSheets-260x170.png 260w\" sizes=\"auto, (max-width: 873px) 100vw, 873px\" \/><\/a><\/p>\n<p>Last update: 7\/22\/2021.<\/p>\n<h4>Available as Google Sheets \u00ae.<\/h4>\n<p>I have posted these spreadsheets <a href=\"https:\/\/drive.google.com\/drive\/folders\/1RYs734ls38qiEUgYH6uGkIvrMvzWcHDr?usp=sharing\" target=\"_blank\" rel=\"noopener\">on my Google Drive<\/a>.\u00a0 These were specifically developed for and tested on Chromebooks using the Chrome Browser.\u00a0 Because the Chrome OS will not allow the user to install the JAVA runtime environment, students with Chromebooks have not been able to use my\u00a0<em>Stats Homework<\/em> package.\u00a0 These online sheets offer Chromebook users a free and simple method of double-checking their basic statistical computations.<\/p>\n<p>If you have your own Google account, you should be able to copy these sheets to your own Google Drive and then enter data and obtain basic statistics.\u00a0 These can also be downloaded to your local computer and run with a spreadsheet program.\u00a0 However, if this is your goal, you might find the next approach easier.<\/p>\n<h4>Available as Excel \u00ae Spreadsheets<\/h4>\n<p>I have posted <a href=\"https:\/\/sites.berry.edu\/vbissonnette\/wp-content\/uploads\/sites\/21\/2023\/12\/Spreadsheets-12.29.2023.zip\">a .zip archive file with all the spreadsheets<\/a>.\u00a0\u00a0These files are in MS Excel \u00ae format, and you should be able to open them with a variety of different spreadsheet programs.<\/p>\n<p>With either source, you will find spreadsheets for descriptive statistics, T tests, one-factor ANOVAs, correlation and regression, goodness-of-fit tests, and contingency table tests.\u00a0 Students should be able to use these spreadsheets to compute almost all of the basic statistics that are covered in an introductory class.\u00a0 An added benefit of these spreadsheets is that students can explore the formulae embedded in them and learn about statistical computing in spreadsheets.<\/p>\n<p>If you have any difficulties with these, or if you have suggestions for improvements, please let me know &#8211; vbissonnette@berry.edu.<\/p>\n<hr \/>\n<p><a href=\"https:\/\/sites.berry.edu\/vbissonnette\/\">Return to the Main Page<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just the Basics I created these spreadsheets for students who have difficulty installing Java and running the Stats Homework package (e.g., students with older computers or Chromebooks). \u00a0This ensures that [&hellip;]<\/p>\n","protected":false},"author":34,"featured_media":0,"parent":275,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"class_list":["post-1125","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/pages\/1125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/comments?post=1125"}],"version-history":[{"count":23,"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/pages\/1125\/revisions"}],"predecessor-version":[{"id":2235,"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/pages\/1125\/revisions\/2235"}],"up":[{"embeddable":true,"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/pages\/275"}],"wp:attachment":[{"href":"https:\/\/sites.berry.edu\/vbissonnette\/wp-json\/wp\/v2\/media?parent=1125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}