Day 8
Excel
- you can drag down down the black cross in the corner to repeat a formula, or double click to fill an entire column
- use "$" to lock a cell
- click "insert" to insert graphs
- use "=" to start a formula
- click on cells to select them for use in a formula
=AVERAGE()
- Calculates the average of the selected data
- Note: Excel formulas are case INSENSITIVE, but Python commands are case SENSITIVE
Sample of work done in class can be found here.
Data Analysis Challenge
The data analysis challenge can be found in the class GitHub repository, or on Google Classroom. For help, please consult the work done yesterday.
Data Analysis Project (Homework)
For homework, please make sure that you are ready to present the data that you have analysed today in the form of a poster.