# Physics Excel Error Analysis Worksheet Report

Anonymous
account_balance_wallet \$15

Question 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!

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

Kevins_Jr
School: Boston College

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
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...

flag Report DMCA
Review

Anonymous
awesome work thanks

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors