• Home
  • Blog
  • UCF Measuring the Acceleration of Gravity Close to The Earth Surface Excel

UCF Measuring the Acceleration of Gravity Close to The Earth Surface Excel

0 comments

You will need to do an experiment in order to complete this assignment, and there will be an excel should be completed, too. Watch and read the instructions and attached videos to do it. 

Measuring the acceleration of gravity close to the Earth’s surface “the hard way”

(Try to get three significant digits using your digital phone as a timer and your measuring device to determine your drop height)

In this lab activity, you will become familiar with the simple free-fall approximation. By the end of this activity, you will be able to:

Identify the need for minimize random error in measuring a well-known constant.

Develop skills in analyzing data of multiple trial runs.

  • Determine the reliability of a result from your result of the data analysis.
  • Make sure you read the activity instruction carefully and follow the steps to complete this activity. Use the first Excel-practice-analysis (OPTIONAL) sheet to practice the analysis from steps 5-17 or so. Then, use the other sheet to place YOUR DATA (your collected drop times). Note: A distance, which is kept fixed throughout the lab, should be as much as possible without getting hurt!! You will drop the ball from the same height as instructed and measure the drop times. NOTE: This is not a task where you are expected to get everything perfect. The idea here is to recognize and minimize error to get the (best) result you can.
  • Download and the read (THE LAB INSTRUCTIONS BEGIN ON PAGE 4):

Analysis of free-fall experiment-STUDENT DATA COLLECTION.pdf 

Excel-practice-analysis.xlsx

Excel 2-student template.xlsx

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}