Built-in functions

Data Analysis in Google Sheets

James Chapman

Curriculum Manager, DataCamp

Google Sheets for data analysis

 

Support key data analysis tasks:

  • Cleaning and manipulating data
  • Statistical analysis
  • Visualizations

A globe with spreadsheets markers spanning the different continents.

Data Analysis in Google Sheets

The data analysis process

  • Data analysis: process of extracting meaningful insights from data

 

The first stage of data analysis: formulate the problem.

  • Example: Are customers aged 21 to 30 more likely to churn than customers aged 41 to 50?
Data Analysis in Google Sheets

The data analysis process

  • Data analysis: process of extracting meaningful insights from data

 

The first two stages of data analysis: formulate the problem and collect the data.

Data Analysis in Google Sheets

The data analysis process

  • Data analysis: process of extracting meaningful insights from data

 

The first three stages of data analysis: formulate the problem, collect the data, and explore the data.

  • Chapter 1 → Exploring Data
Data Analysis in Google Sheets

The data analysis process

  • Data analysis: process of extracting meaningful insights from data

 

The first four stages of data analysis: formulate the problem, collect the data, explore the data, and clean and prepare the data.

  • Example: Converting dates of birth into ages
  • Chapter 2 → Cleaning and Preparing Data
Data Analysis in Google Sheets

The data analysis process

  • Data analysis: process of extracting meaningful insights from data

 

The first five stages of data analysis: formulate the problem, collect the data, explore the data, clean and prepare the data, and analyze the data.

  • Chapter 3 → Analyzing Data
Data Analysis in Google Sheets

The data analysis process

  • Data analysis: process of extracting meaningful insights from data

 

All stages of data analysis: formulate the problem, collect the data, explore the data, clean and prepare the data, analyze the data, and present the findings.

Data Analysis in Google Sheets

Built-in functions

  • Built-in functions: Pre-written calculations that are available in formulas

To create a meal, we need to combine ingredients using kitchen appliances, pots, and pans.

Data Analysis in Google Sheets

Built-in functions

  • Built-in functions: Pre-written calculations that are available in formulas

Instead of having to combine ingredients ourselves using appliances, pots, and pans, we can give the ingredients to our personal chef, who will create the meal for us.

Data Analysis in Google Sheets

Built-in functions

  • Built-in functions: Pre-written calculations that are available in formulas

Built-in functions are like having a personal chef, and the ingredients we pass them are like arguments.

Data Analysis in Google Sheets

Anatomy of a built-in function

 

ROUND() Syntax:

= ROUND(value, [places])
  • Required arguments: value
  • Optional argument: places → 0 by default
Data Analysis in Google Sheets

ROUND() examples

Exchange rates for different currencies.

Data Analysis in Google Sheets

ROUND() examples

Rounding the exchange rate for the Canadian dollar to two decimal places.

Data Analysis in Google Sheets

ROUND() examples

The exchange rate of the Canadian dollar rounded to two decimal places returned 0.77 Canadian dollars.

Data Analysis in Google Sheets

ROUND() examples

Rounding the exchange rate of the Swiss Franc to zero decimal places.

Data Analysis in Google Sheets

ROUND() examples

Rounding the exchange rate of the Swiss Franc to zero decimal places returned one Franc.

Data Analysis in Google Sheets

Let's practice!

Data Analysis in Google Sheets

Preparing Video For Download...