LAB 2: Working With Excel
Manual
PHYSICS
Introductory Physics 1300/1400/1310/1410, Lab 2. September, 2020
, LAB 2 OBJECTIVES
Obtain, install, and learn to utilize MS Excel
Generate data by using equations in an Excel spreadsheet
Plot data in Excel
Fit mathematical functions other than lines to pre-generated data in Excel
Rescale data by applying a mathematical model to it
Analyze unknown data to determine the functional form
Demonstrate your ability to prepare a PDF lab report
Demonstrate your ability to submit a lab report as a Blackboard assignment
Introductory Physics 1300/1400/1310/1410, Lab 2. September, 2020
, NOTE ON USING THE LAB MANUALS
These lab manuals have been constructed with embedded YouTube videos to
better show you how the data was acquired and how certain aspects of data
collection or analysis are performed.
You should definitely watch these before attempting the analysis or asking your
GA/TA for assistance.
Embedded YouTube videos are generally
shown as images with a magenta/pink box
around them and a magenta/pink
“YouTube” tag next to that. Clicking on this
link in our lab manual should take you to
the appropriate video if your device is
connected to the internet.
Introductory Physics 1300/1400/1310/1410, Lab 2. September, 2020
Manual
PHYSICS
Introductory Physics 1300/1400/1310/1410, Lab 2. September, 2020
, LAB 2 OBJECTIVES
Obtain, install, and learn to utilize MS Excel
Generate data by using equations in an Excel spreadsheet
Plot data in Excel
Fit mathematical functions other than lines to pre-generated data in Excel
Rescale data by applying a mathematical model to it
Analyze unknown data to determine the functional form
Demonstrate your ability to prepare a PDF lab report
Demonstrate your ability to submit a lab report as a Blackboard assignment
Introductory Physics 1300/1400/1310/1410, Lab 2. September, 2020
, NOTE ON USING THE LAB MANUALS
These lab manuals have been constructed with embedded YouTube videos to
better show you how the data was acquired and how certain aspects of data
collection or analysis are performed.
You should definitely watch these before attempting the analysis or asking your
GA/TA for assistance.
Embedded YouTube videos are generally
shown as images with a magenta/pink box
around them and a magenta/pink
“YouTube” tag next to that. Clicking on this
link in our lab manual should take you to
the appropriate video if your device is
connected to the internet.
Introductory Physics 1300/1400/1310/1410, Lab 2. September, 2020
