PLEASE HELP WITH STEP-BY-STEP EXPLANATION.

Part B. Statistical Analysis -- Practice Integrating Data from two data sources: Google Trends data AND information about when Black Friday occurs.

1. Cards Against Humanity is a social party game. The owners have a tradition of doing a Black Friday stunt. See here: https://cardsagainsthumanity.com/blackfriday/

2. Watch the video and then review the following questions below.

Does the company make money on selling boxes of bull feces?

Investigate the following hypothesis: Hypothesis: Cards Against Humanity uses its Black Friday campaign each year to increase searches for its game. What did the company do 2014 to present?

3. Let's use Google Trends and Excel to investigate the above questions.

Use Google Trends to see data charts about searches of Cards Against Humanity on Google. Use the pulldown menu to change from "Past 12 months" to "Past 5 Years" Download the data pressing the button. Open it in Excel Explain the meaning of the Google Trends index: https://support.google.com/trends/answer/4365533?hl=en

You should now have an Excel file with "week" in one column and "Google trend index" in another Add external data: make a new column with 1 indicating Black Friday week each year and 0 otherwise. "1" for the Black Friday week in the past year and "0" for all the other weeks.

Open the file in RStudio Run a linear regression on this simple data. Example: model <- lm(trendcah ~ ynBlackFridayStunt, CAH_data)[note that you should replace trendcah with whatever you named the Google trends data column from step 6, replace ynBlackFridayStunt with whatever you named the column from step 7, and replace CAH_data with whatever you named the spreadsheet that you imported into RStudio], summary(model) Note that ynBlackFriday is likely to be significantly related to an increase in trending for Cards Against Humanity. 11. This is a simple example of integrating two data sources: Google Trends data AND information about when Black Friday occurs. However, could there be other explanations about why ynBlackFridayStunt might be significant? It is the holiday season after all. So, it might be significant whether there was a Black Friday stunt or not, simply related to people buying things more in general during this season. Consider getting more Google Trends data on other board games like Apples to Apples, or Exploding Kittens, games whose owners do NOT do Black Friday stunts like CAH. Add these as control variables to your model. model <- lm(trendcah ~ ynBlackFridayStunt + trendExplodingKittens, CAH_data) summary(model) Does significance hold for the ynBlackFridayStunt? Obviously, this still doesn't prove our hypothesis, because we are only showing correlations of Google searches on CAH with the timing of Black Friday. But it is interesting to investigate!