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

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?

Step by Step Solution

★★★★★

3.56 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

importance of workalike balance for women as a leader in healthcare. 1. The purpose of the research; 2. Research question/s; 3. Findings and relevant data; 4. Any recommendations and; 5. The...

Burger King identity crisis: who is it now? When Burger King was established in the early 1950s, it wanted to attract the families of baby boomers and serve them with affordable and quick broiled...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

SO MUCH CANDY DATA, SERIOUSLY Candy 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...

Summary This assignment asks you to use the techniques that you have learned in this course to evaluate a potential investment opportunity. Specifically, it asks you to use the data provided with...

Assignment: Excel (75 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a...

Summary This assignment asks you to use the techniques that you have learned in this course to evaluate a potential investment opportunity. Specifically, it asks you to use the data provided with...

AA 11-3 Global Analysis LO P3 Refer to Samsung's statement of cash flows in Appendix A for the year ended December 31, 2017. Required 1. What amount (in millions of Korean won) did Samsung spend to...

A family friend has asked your help in analyzing the operations of three anonymous companies operating in the same service sector industry. Supply the missing data in the table below: (Loss amounts...

Grocery Inc. (Grocery or the Company), an SEC registrant, is a wholesale grocery distributor and retailer in the United States. One of the Companys core businesses is distributing grocery products to...

Two identical springs hang from the ceiling, while a 4.0 kg block is attached to the end of the springs, as shown in the diagram. The spring constant is equal to: 0 20 40 60 80 2468 cm 4 kg

Garden Haven has excess cash of $15,000 at the end of the harvesting season. Garden Haven will need this cash in four months for normal operations. Requirements 1. What are some reasons why Garden...

Dubois sold Hocking a condominium that included an option to participate in a rental pool arrangement. Hocking elected to participate in the arrangement. Under it, the rental pool's agent rented...

A mail-order company has two warehouses, one on the West Coast and the second on the East Coast. The companys policy is to mail all orders placed with it within 72 hours. The companys quality control...

Mary Dale worked in the law office of Emory Stone, an attorney practicing securities law. While proofreading Marys keying of a document relating to the merger of two computer software companies,...

The management of a supermarket chain wanted to investigate if the percentages of men and women who prefer to buy national brand products over the store brand products are different. A sample of 600...

A firm has total assets of $ 1 0 0 and total debt of $ 2 5 . Equity is $ 7 5 . Debt - equity ratio is 3 . Debt ratios is 2 5 % . Equity ratio is 7 5 % .

Apply cluster analysis to the Excel file Sales Data, using the input variables Percent Gross Profit, Industry Code, and Competitive Rating. Create four clusters and draw conclusions about the...

The Excel file Investment Returns provides sample data for the annual return of the S& P 500, and monthly returns of a stock portfolio and bond portfolio. Construct histograms for each data set and...

Using the data in the Excel file Cell Phone Survey, apply ANOVA to determine if the mean response for Value for the Dollar is the same for different types of cell phones.

In an article titled Childhood Pastimes Are Increasingly Moving Indoors, Dennis Cauchon asserts that there have been huge declines in spontaneous outdoor activities such as bike riding, swimming, and...

A marketing research firm is interested in determining whether there is a difference between the proportion of households in Chicago and the proportion of households in Milwaukee who purchase...

Suppose, as part of a national study of economic competitiveness, a marketing research firm randomly sampled 200 adults between the ages of 27 and 35 living in metropolitan Seattle and 180 adults...