{"id":22,"date":"2011-08-17T20:55:22","date_gmt":"2011-08-17T20:55:22","guid":{"rendered":"http:\/\/mcdsbiology.org\/?page_id=22"},"modified":"2016-02-25T21:56:18","modified_gmt":"2016-02-25T21:56:18","slug":"01-statistical-analysis","status":"publish","type":"page","link":"http:\/\/mcdsbiology.org\/?page_id=22","title":{"rendered":"00- Statistical Analysis"},"content":{"rendered":"<p><strong>Standard Deviation<\/strong><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<p>What is standard deviation?<\/p>\n<p><iframe loading=\"lazy\" title=\"What is the standard deviation?\" width=\"604\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/t8kDuV1Alt4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>How do I calculate standard deviation &amp; what do those numbers mean?<\/p>\n<p><a href=\"http:\/\/www.mathsisfun.com\/data\/standard-deviation.html\">http:\/\/www.mathsisfun.com\/data\/standard-deviation.html<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Video Working Through Several Examples:<\/p>\n<p><a href=\"http:\/\/study.com\/academy\/lesson\/data-analysis-standard-deviation.html\">http:\/\/study.com\/academy\/lesson\/data-analysis-standard-deviation.html<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Course help sheet- Plant Example:<\/p>\n<p>&nbsp;<\/p>\n<p>How to calculate mean, median, standard deviation etc. in Google sheets:<\/p>\n<p>https:\/\/www.youtube.com\/watch?v=QLlrPNOmyCQ<\/p>\n<p>&nbsp;<\/p>\n<p>How to insert error bars in Google Sheets:<\/p>\n<p><iframe loading=\"lazy\" title=\"Making a simple bar graph in Google Spreadsheet with Error Bars\" width=\"604\" height=\"453\" src=\"https:\/\/www.youtube.com\/embed\/BhhwHU9Wjqk?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>***WAIT! \u00a0This may not work on the new Google update- Try clearing the checkboxes in chart editor and selecting only &#8220;switch rows \/ columns&#8221; to create different series. \u00a0This way you can add unique error bars for each series.<\/p>\n<p>Those Pesky Error Bars!: (Courtesy of Crystal)<\/p>\n<ul>\n<li>In Excel: Double click on a single data point to select that point, change that point to its own series \/ color<\/li>\n<li>Click format data series<\/li>\n<li>Custom<\/li>\n<li>Specify Value<\/li>\n<li>list all of the standard deviations<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Regression Analysis<\/strong><\/p>\n<hr \/>\n<ul>\n<li><a href=\"http:\/\/college.cengage.com\/mathematics\/brase\/understandable_statistics\/7e\/students\/datasets\/slr\/frames\/frame.html\">Sample Data Sets\u00a0<\/a><\/li>\n<li>Instructional PowerPoint:\u00a0<a href=\"http:\/\/mcdsbiology.org\/wp-content\/uploads\/2011\/08\/Regression-analysis.pptx\" rel=\"\">Regression analysis<\/a><\/li>\n<li>Statistical Test for Correlation:\n<ul>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=WcI_-a5hzuc\">You Tube<\/a><\/li>\n<li><a href=\"http:\/\/www.life.illinois.edu\/ib\/203\/Fall%2009\/PEARSONS%20CORRELATION%20COEFFICIENT%20TABLE.pdf\">Pearson&#8217;s Correlation Table <\/a>(2-Tailed)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Bi- and Multivariate Inferential Statistical Tests Differences of Groups<\/strong><\/p>\n<hr \/>\n<ul>\n<li>Chi Squared &amp; T-test are two multivariate statistical tests we consider.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Chi Squared Test for Independence<\/strong><\/p>\n<hr \/>\n<ul>\n<li>Compares observed frequencies to expected frequencies<\/li>\n<li>ex: Is the distribution of sex and voting behavior due to chance or is there a difference between the sexes on voting behavior?<\/li>\n<li>How to:\u00a0<a href=\"http:\/\/stattrek.com\/chi-square-test\/independence.aspx?Tutorial=AP\">Chi Squared Test<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>T-Test<\/strong><\/p>\n<hr \/>\n<ul>\n<li>looks at differences between two groups on some variable of interest<\/li>\n<li>the IV must have only two groups (male\/female, undergrad\/grad) &#8211; though multiple t-tests can be performed<\/li>\n<li>ex: Do males and females differ in the amount of hours they spend shopping in a given month?<\/li>\n<li>T-Test Instructional Example:\u00a0<a href=\"http:\/\/mcdsbiology.org\/wp-content\/uploads\/2011\/08\/Bean-Germination-Lab-with-T-Test-Good.pdf\" rel=\"\">Bean Germination Lab with T-Test &#8211; Good<\/a><\/li>\n<li>T-Test PowerPoint :<a href=\"http:\/\/mcdsbiology.org\/wp-content\/uploads\/2011\/08\/T-test1.ppt\" rel=\"\">T-test[1]<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Standard Deviation &nbsp; What is standard deviation? How do I calculate standard deviation &amp; what do those numbers mean? http:\/\/www.mathsisfun.com\/data\/standard-deviation.html &nbsp; Video Working Through Several Examples: http:\/\/study.com\/academy\/lesson\/data-analysis-standard-deviation.html &nbsp; Course help sheet- Plant Example: &nbsp; How to calculate mean, median, standard deviation etc. in Google sheets: https:\/\/www.youtube.com\/watch?v=QLlrPNOmyCQ &nbsp; How to insert error bars in Google Sheets: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":6,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-22","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=\/wp\/v2\/pages\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22"}],"version-history":[{"count":10,"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=\/wp\/v2\/pages\/22\/revisions"}],"predecessor-version":[{"id":386,"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=\/wp\/v2\/pages\/22\/revisions\/386"}],"up":[{"embeddable":true,"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=\/wp\/v2\/pages\/6"}],"wp:attachment":[{"href":"http:\/\/mcdsbiology.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}