Embedded Files
Department of Biology, San Diego Mesa College
Welcome!
Welcome!
This website was created to provide biology students with a collection of resources to learn about data analysis and graphing.
Please explore the pages on this site:
On this page, you will learn about different types of data and how to calculate descriptive statistics (mean and standard deviation) for your dataset using Google Sheets.
On this page, you will learn how to create graphs for numerical and categorical data using Google Sheets.
Coming soon! On this page, you will learn how to run test statistics including T-tests, regressions and ANOVAS using Microsoft Excel.
Accessing Google Sheets
Accessing Google Sheets
Google Sheets is a web-based spreadsheet program that is freely available to users. These tutorials will teach you how to do descriptive statistics and create graphs in Google Sheets.
Google Sheets can be accessed in many ways:
In your web browser: Go to sheets.google.com
In your Google Drive: Click New > Google Sheets
On your phone: Install the Google Sheets app (available on iOS or Android)
When prompted, you will want to choose a "Blank" Spreadsheet.
Note: You will need a Google Account to access Google Sheets. You do not need to have a Gmail Account. Creating either type of account is free.
Page updated
Google Sites
Report abuse