Instructions\tPlease read the following scenario and answer the questions below. Use the data set below to complete this assignment. You may create your assignment using either Microsoft Word or Excel.\tScenario\t10 bags of a certain candy were opened. The candy comes in 3 different colors: red, blue, and green. The number of each color of candy per bag was counted and recorded.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tBag\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tRed\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tBlue\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGreen\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t5\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t7\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t4\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t4\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t7\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t5\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t5\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t6\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t7\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t4\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t8\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t9\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t4\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t10\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t5\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t4\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\u807d\tAnalyze the data by calculating the following:\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWhat was the total number of candies in each bag?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWhat was the average number of each color?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWhat the average total?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWhat was the variance and standard deviation of each color?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWhat was the variance and standard deviation for the total number of candies?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSuppose a new bag was opened with the following numbers:\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tRed\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tBlue\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGreen\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t3\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCompute the z-scores for this bag for each color and for the total number of candies.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tHint: Parts 1-5 can be done using Microsoft Excel. Use the following functions: sum(), average(), var.s(), stdev.s()<\/p>\n","protected":false},"excerpt":{"rendered":"
Instructions Please read the following scenario and answer the questions below. Use the data set below to complete this assignment. You may create your assignment using either Microsoft Word or Excel. Scenario 10 bags of a certain candy were opened. Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-229519","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/229519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=229519"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/229519\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=229519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=229519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=229519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}