Physics Excel Error Analysis Worksheet Report Hi I need help with my physics report and the assignment is about 4 part please read the documents carefully
Physics Excel Error Analysis Worksheet Report 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
Purchase answer to see full
attachment
