Physics Excel Error Analysis Worksheet Report

User Generated

ONABENY

Science

Description

Hi

I need help with my physics report and the assignment is about 4 part please read the documents carefully before you start working on it.


Thank you!


Unformatted Attachment Preview

Part 1: Types of Errors Pick whether the below scenario is random or systematic 1. Measuring the length of an object using a caliper to the nearest hundredth of a millimeter. Random ☐ Systematic ☐ 2. Mis-calibrated current sourcemeter. Random ☐ Systematic ☐ 3. An effect that was not thought of during the collection data, but it biased the results. Random ☐ Systematic ☐ 4. You make a bunch of measurements of the gravitational acceleration constant (close to Earth’s surface). The results are measured in meters/second/second (m/s2). Below are your results: 11.3, 12.0, 11.1, 10.9, 11.0, 11.5, 11.1, 11.3, 10.9, 11.0, 11.7, 11.2, 11.1, 11.8, 11.5, 10.9, 11.1, and 11.7 Referring to the data collected, using just a measured distance and photodetector to measure the time interval of the falling object. What type of error would you think is present? Random ☐ Systematic ☐ Part 2: Accuracy and Precision 1. Select the best description for the scenarios below: ACCURACY: ☐ ☐ ☐ ☐ PRECISION: ☐ ☐ ☐ ☐ 2. Using the information and data from question 4 in Part 1, discuss the accuracy and precision of the data set. Download the Error and analysis worksheet (Part 3 and 4) and complete it before leaving the lab!!! Save this Worksheet as a PDF Submit both Worksheets to canvas Part 4: Plot and Lines Part 3: Standard Deviation Find the Standard deviation and Standard deviation of the mean for the data below. Compare your result with the built in function in Excel (STDEV). 11,3 12 11,1 10,9 11 11,5 11,1 11,3 10,9 11 11,7 11,2 11,1 11,8 11,5 10,9 11,1 11,7 Sum (S) Mean N S Sm (𝑔𝑖 − 𝑔)ҧ 𝑔𝑖 − 𝑔ҧ 2 Diameter (cm) 1,9 3,3 4,23 6,04 6,6 Slope Uncertainity 1 0,9 0,8 0,7 Axis Title Acceleration (m/s^2) Perform a Linest analysys for the data below Diameter. Remember to include t 0,6 0,5 0,4 0,3 0,2 0,1 0 0 0,2 Part 4: Plot and Linest Group Names: nest analysys for the data below. Plot Circumference vs iameter. Remember to include the trendline. Circumference (cm) 5,93 10,45 13,3 18,45 21,2 Chart Title Series1 1, 0 0,4 0,6 Axis Title 0,8 1 1,2
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Part 1: Types of Errors
Pick whether the below scenario is random or systematic
1. Measuring the length of an object using a caliper to the
nearest hundredth of a millimeter.
Random
2. Mis-calibrated current sourcemeter.
Systematic
3. An effect that was not thought of during the collection data,

but it biased the results.
Random
4. You make a bunch of measurements of the gravitational
acceleration constant (close to Earth’s surface). The results
are measured in meters/second/second (m/s2). Below are
your results:
11.3, 12.0, 11.1, 10.9, 11.0, 11.5, 11.1, 11.3, 10.9, 11.0,
11.7, 11.2, 11.1, 11.8, 11.5, 10.9, 11.1, and 11.7

Referring to the data collected, using just a measured
distance and photodetector to measure the time interval of
the falling object. What type of error would you think is
present?
Systematic
Part 2: Accuracy and Precision
1. Select the best description for the scenarios below:

Precision

None

Accuracy and

Accuracy

Precision

2. Using the information and data from question 4 in Part...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags