{"id":5166,"date":"2023-02-25T05:31:03","date_gmt":"2023-02-25T05:31:03","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/data-565-data-analytics-week-1\/"},"modified":"2023-02-25T05:31:03","modified_gmt":"2023-02-25T05:31:03","slug":"data-565-data-analytics-week-1","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/data-565-data-analytics-week-1\/","title":{"rendered":"Data 565 Data Analytics Week 1"},"content":{"rendered":"<div class=\"col-sm-12 messageContent\">\n <b>Learning Goal: <\/b>I&#8217;m working on a data analytics spreadsheet and need the explanation and answer to help me learn.<\/p>\n<p>1. Calculate &#8220;Annual Sales&#8221; for each restaurant. Annual Sales is the result of multiplying a restaurant&#8217;s &#8220;SqFt.&#8221; by &#8220;Sales\/SqFt&#8221;. the first value has been done ( in yellow)<\/p>\n<p>2. Calculate the mean, standard deviation, skew, 5-number summary, and interquartlie range (IQR) for each of the variables. The formulas and the first results have been provided for you( in Yellow)<\/p>\n<p>3. Create a box plot ( sometimes referred to as a box and whisker chart) for the &#8220;Annual Sales&#8221; variable.<\/p>\n<p>4. Create a histogram for the &#8220;Sales\/SqFt&#8221; variable<\/p>\n<p><strong>Respond to the following questions on the questions tab in the excel assignment<\/strong><\/p>\n<p>1. Does the annual sales boxplot look symmetric?<\/p>\n<p>2. Would you prefer the IQR instead of the standard deviation to describe the dispersion of the annual sales variable? If so , why?<\/p>\n<p>3. Does the histogram show that the sales per square foot distribution is symmetric?<\/p>\n<p>4. If the sales per square foot distribution is not symmetric, what is the skew?<\/p>\n<p>5. If there are any outliers, which one(s)? What is the &#8220;Sq\/Ft&#8221; area of the outlier(s)?<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Learning Goal: I&#8217;m working on a data analytics spreadsheet and need the explanation and answer to help me learn. 1. Calculate &#8220;Annual Sales&#8221; for each restaurant. Annual Sales is the result of multiplying a restaurant&#8217;s &#8220;SqFt.&#8221; by &#8220;Sales\/SqFt&#8221;. the first value has been done ( in yellow) 2. Calculate the mean, standard deviation, skew, 5-number [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[735],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/5166"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=5166"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/5166\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=5166"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=5166"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=5166"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=5166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}