Accomplish the following tasks by whatever means necessary based on the material we've covered in class. Save the notebook in this format: `<lastname>_DoNow_2-2.ipynb` where `<lastname>` is your last (family) name and turn it in via Slack.



In [ ]:

    
# the magic command to plot inline with the notebook 
# https://ipython.org/ipython-doc/dev/interactive/tutorial.html#magic-functions
%matplotlib inline

1. Import the pandas package and use the common alias



In [ ]:

2. Read the file "heights_weights.xlsx" in the `data` folder into a pandas dataframe



In [ ]:

3. Plot a histogram for both height and weight. Describe the data distribution in comments.



In [ ]:

4. Calculate the mean height and mean weight for the dataframe.



In [ ]:

5. Calculate the other significant descriptive statistics on the two data points

Standard deviation
Range
Interquartile range



In [ ]:

6. Calculate the coefficient of correlation for these variables. Do they appear correlated? (put your answer in comments)



In [ ]:

Extra Credit: Create a scatter plot of height and weight



In [ ]:

Accomplish the following tasks by whatever means necessary based on the material we've covered in class. Save the notebook in this format: <lastname>_DoNow_2-2.ipynb where <lastname> is your last (family) name and turn it in via Slack.

1. Import the pandas package and use the common alias

2. Read the file "heights_weights.xlsx" in the data folder into a pandas dataframe

3. Plot a histogram for both height and weight. Describe the data distribution in comments.

4. Calculate the mean height and mean weight for the dataframe.

5. Calculate the other significant descriptive statistics on the two data points

6. Calculate the coefficient of correlation for these variables. Do they appear correlated? (put your answer in comments)

Extra Credit: Create a scatter plot of height and weight

Accomplish the following tasks by whatever means necessary based on the material we've covered in class. Save the notebook in this format: `<lastname>_DoNow_2-2.ipynb` where `<lastname>` is your last (family) name and turn it in via Slack.

2. Read the file "heights_weights.xlsx" in the `data` folder into a pandas dataframe