Question: PLEASE PROVIDE THE CODE FOR EACH STEP AND ANSWER THE QUESTIONS! For this assignment, you will be using the Ice Cream Dataset:https://www.kaggle.com/datasets/tysonpo/ice-cream-dataset The dataset has

PLEASE PROVIDE THE CODE FOR EACH STEP AND ANSWER THE QUESTIONS!

For this assignment, you will be using the Ice Cream Dataset:https://www.kaggle.com/datasets/tysonpo/ice-cream-dataset

The dataset has two files: products.csv, which contains information about individual ice cream flavors, and reviews.csv, which contains reviews from individuals.

products dataset: https://drive.google.com/file/d/1NRg2ZDOYynhIJHsBkG5Khr2G6TojY55Z/view?usp=sharing

reviews dataset: https://drive.google.com/file/d/1OmViL8jbwU386sjNsJtPOhC9G3qQSIJV/view?usp=sharing

------------------------------------------------------------------------------------------------------------------------------------------------------------

Part 1: Descriptive analysis

1.3 Product ratings histogram

Using the products dataset, make a histogram of the product ratings ranging from 1 to 5 (inclusive) with a bin width of 0.1. Use the brand of the ice cream as the color and stack the values across the brands for each bar (i.e. don't overlap them).

What do you notice about the overall distribution of ratings and the ratings for the brands?

1.4 Product ratings boxplot

Again using the products dataset, make a boxplot of the product ratings, separated by brand. Is there any brand that has notably better/worse ratings than the others? Is there any brand that has a notably larger range of values?

1.5 Star ratings barplot

Now, using the reviews dataset, make a barplot showing the brand of ice cream along the x-axis, the percent of reviews along the y-axis, and the number of stars given as a color. With this plot, each rectangle should indicate the percentage of reviews with a particular number of stars given to a brand. Organize your plot such that the total percentage across each of the four bars (one for each brand) is 100% and the number of stars in the reviews are ordered 1-5.

Is there any brand with proportionally fewer 5-star reviews? What about proportionally more 1-star reviews?

(Hint: your final plot should resemble the plot in the picture below, but instead of 'specie' along the x-axis, it should be brands and your colors should be the star ratings)

PLEASE PROVIDE THE CODE FOR EACH STEP AND ANSWER

1.00 - 0.75 - I!! condition value 0.50 - Nitrogen normal stress 0.25 - 0.00 - banana poacee sorgho triticum specieHistogram of Product Ratings by Brand brand 25 bj III hd talenti breyers 20 15 Count 10 5 0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 RatingBoxplot of Product Ratings by Brand 5.0 4.5 4.0 I 3.5 Rating 3.0 2.5 2.0 1.5 bi hd talenti breyers BrandPercentage of Reviews by Star Rating and Brand Star Rating 70 2 W 60 5 50 40 Percentage of Reviews 30 20 10 0 bj breyers hd talenti Brand

Step by Step Solution

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 Mathematics Questions!

BSBHRM613 Contribute to the development of learning and development strategies STUDENT NAME* STUDENT ID* Date* /Day/MonthYear Date Student Email* example@example.com Location* Brisbane campusSydney...

use the code r Script below to Answer the questions from number 3 to 7 Questions : 3. Model #1 - First Logistic Regression Model Reporting Results Report the results of the regression model. Address...

please provide the code in racket programming language. I only need answer for question1. Programming Rules Submit one Racket file named as hw 3-net-id).rkt. lang racket (provide (all-defined-out))...

write a Java code with GUI(Graphical User Interface) Assignment # 2 Binary I/O Objective: Reading/Writing information in Binary format to file sequentially i.e., using DataInput/DataOutput Streams...

1. Casel Ivana's Ice Cream just finished its first six months of manufacturing and selling ice cream. The company has two main product lines, Ice cream cups and ice cream bars, both of which are...

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

How do you perceive the role of econometrics in decision making in business and economics?

Hydroborationoxidation of (E)-2-( p-anisyl)-2-butene yielded an alcohol A, mp 60C, in 72% yield. When the same reaction was performed on the Z alkene, an isomeric liquid alcohol B was obtained in 77%...

Solve for the unknown discount rate in each of the following: ( Enter your answers as a percentage rounded to 2 decimal places ( i . e . 0 . 1 2 3 4 should be entered as 1 2 . 3 4 ) . )

April 7, 5,000 April 1 and 7. 7. On the first day of the fiscal year, a company issues a $500,000, 8%, 10-year bond that pays semi-annual interest of $20,000 ($500,000 x 8% x ), receiving cash of...