Embedded Files
OUTCOME: Students will be able to summarise data on google sheets using a variety of techniques and use this to draw conclusions from the data
Make a copy of the data and follow the activity to create a Pivot Table to summarise the data.
Continue on from Creating Summary Tables
More summaries and visualisations.movSummarising Data
3) Watch this video to show how to do the following:
Binning using (COUNTIF and COUNTIFS)
Bivariate analysis (scatter plot, trend line and r squared)
Averages by type using (AVERAGEIF)
Mastery
1) Download the dataset here as a csv file
2) Import it into a Pandas dataframe using Jupyter notebook
3) Try and perform some of tasks above using python
Page updated
Report abuse