Question 1 Google Trends allows users to see how often a term is searched for in a geographic region and time frame. You will read in a csv file named https://sueuland.greenriverdev.com/SDEV ... pfizer.csv that was generated from Google Trends. This file contains a scaled number of times people searched the word "pfizer" on google in the US from January 1, 2021 through May 1, 2021. This scaled number ranges from 0 to 100. Where 100 is the peak popularity of the search term and 0 reflects low volume for the search term. You will load this Times Series DataSet into a Pandas DataFrame called pfizer_df. Rename the column pfizer: (United States) to simply Pfizer
Answer:
#add your code here
Question 2 Display the descriptive statistics for how many times Pfizer was used as a google search term over the course of four months and display the associated boxplot. Do you see any outliers in the Google Trends Pfizer Data?
Answer:
Create a Time Series Plot of the Pfizer Data by Day. During which month did the Pfizer search term peak in popularity?
Answer
Question 4
Create an optimal histogram for the Pfizer data. Does the data in your histogram appeared skewed? If so, is it left or right-skewed? Does the data in the histogram appear to be unimodal, bimodal, or multimodal?
Answers
#add your code here
Question 5
Load the data from https://sueuland.greenriverdev.com/SDEV ... lities.csv into a pandas dataframe named utilities_df. The seattle_utilities.csv contains energy usage data collected in Seattle from January 2013 to December 2015. Note the first two columns are named Electricity kWh)and Natural Gas(Therms) usage.1
Question 6
Create a regression plot of the Electricity (kWh) versus the Natural Gas(Therms). Using the regression plot, describe the relationship you see between the two values.
Answer
[ ]
#add your code here
Question 7 Find the equation for the regression line.
(1) What is the r-value? What is it telling you about this relationship?
Answer
(2) What is the slope of the regression line?
Answer
(3) What is the intercept of the regression line?
Answer
(4) What is the predicted Natural Gas usage for an Electricity usage of 1456666 kWh?
Answer
#add your code here
Question 1 Google Trends allows users to see how often a term is searched for in a geographic region and time frame. You
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am