{"id":7860,"date":"2023-03-04T14:13:37","date_gmt":"2023-03-04T14:13:37","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/data-analytics-1\/"},"modified":"2023-03-04T14:13:37","modified_gmt":"2023-03-04T14:13:37","slug":"data-analytics-1","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/data-analytics-1\/","title":{"rendered":"Data Analytics 1"},"content":{"rendered":"<div class=\"col-sm-12 messageContent\">\n <b>Learning Goal: <\/b>I&#8217;m working on a excel case study and need the explanation and answer to help me learn.<\/p>\n<p>Download the following Excel file.<\/p>\n<p>Then<\/p>\n<p>Summarize each county\u00e2\u20ac\u2122s cumulative sales during the four-month period:<\/p>\n<p><strong>a.<\/strong> Using PivotTable, calculate the cumulative sales for each county during the four-month period.<\/p>\n<p><strong>b.<\/strong> Using PivotChart, create a bar chart that shows each county\u00e2\u20ac\u2122s cumulative sales during the four-month period.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Learning Goal: I&#8217;m working on a excel case study and need the explanation and answer to help me learn. Download the following Excel file. Then Summarize each county\u00e2\u20ac\u2122s cumulative sales during the four-month period: a. Using PivotTable, calculate the cumulative sales for each county during the four-month period. b. Using PivotChart, create a bar chart [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[759],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7860"}],"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=7860"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7860\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=7860"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=7860"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=7860"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=7860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}