Background: SO MUCH CANDY DATA, SERIOUSLYCandy hierarchy data for 2017 Boing Boing Halloween candy hierarchy. This is
Question:
Background: SO MUCH CANDY DATA, SERIOUSLYCandy hierarchy data for 2017 Boing Boing Halloween candy hierarchy. This is survey data over the span of 4-years. The data is split into 4 separate files. Students should download all 4-years and integrate them into one file in order to look at Candy sentiment over time (longitudinal effects).Issues: If you want to look for longitudinal effects, you also have access to previous datasets. Unfortunate quirks in the data include the fact that the 2014 data is not the raw set (can’t seem to find it), and in 2015, the candy preference was queried without the MEH option.Data: https://www.scq.ubc.ca/so-much-candy-data-seriously/Instructions:1.Download 2014-2017 data files2.Integrate all data into one spreadsheet3.Perform data analysis and answer the following questions:-What is the average satisfaction percentage of Twix of the 2014-2017 years?-How many columns does your integrated file have? What are they?-What item has the highest satisfaction level over a 4 years period?
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans