Creating new variables by calculation in Excel

Learning intentions:

We will be learning how to create new variables in Excel, specifically to,
• understand what it means to create a new variable by performing
calculations using existing data
• how to create simple new variables by performing a calculation in Excel
• understand the concept of conditional statements for creating new
variables

Creating new variables by calculation in Python

Download Python Part 1 Download Python Part 2

Creating new calculated variables, where the calculation that is used is the same for each row in the dataset. NPA (5,6) PDA (7,8)

Learning intentions:

We will be learning how to create new variables in Python, specifically,

understand why it can be useful to create a new variable by performing calculations using existing data
understand what it means to create a new variable by performing calculations using existing data
how to create simple new variables by performing a calculation in Python