\# Homework Assignment 2: Super Bow1 caselet (Part 2) You are hired as a Business Analyst to he7p the manager to find out if spending millions of dollars on super Bowl ads creates social media buzz. As a second step, carry out descriptive analysis on superbowl. csv data. There are some questions for each sections that you need to answer. \#\# Section 1: univariate statistics Task 1 , compute the "mean", "variance", and "standard deviation" of "kadspend"* for each **new_brand*" before the super Bow and after the super Bow1. Hint: you may use dplyr functions groupby() and summarise(). Note that the superbow] column is 0 for the weeks before super bow 1 and 1 for the weeks of or after super bow7. {r *"Task 1 , Section 1**} Task 2, compute the "mean* and "standard deviation" of "volume." (the number of tota1 mentions form social media), "pos* (the number of positive mentions) and *kneg*: (the number of negative mentions) for each **new_brand* before the Super Bow1 and after the Super Bow1. {r s*task 2 , section 1*ik} Task 2, compute the "mean" and "standard deviation" of "volume" (the number of total mentions form social media), "*pos** (the number of positive mentions) and *neg** (the number of negative mentions) for each **new brand" before the Super Bowl and after the super Bowl. \{r **Task 2, section 1} Then, answer the following questions. Please write your answers after *"Response**: **Questions**: 1. What brand has the *"highest mean ad spend"* after the super Bowl? Has the mean ad spending increased after the super Bow] for that brand? By how much? 2. What brand has the "highest mean*s volume of mentions after the super Bow1? What brand has the ** Towest mean** volume of **positive** mentions after the Super Bow1