A) Using Excel, or some other graphing software, plot the values of y as a function of x. (You will not submit this spreadsheet.
However, the results will be needed later in this problem).
x y
1 2.5
2 3.3
3 4.5
4 4.9
5 7.0
B) Use the trendline option to draw the best fit line for the above data and use it to determine the slope and y-intercept.
x y
1 2.5
2 3.3
3 4.5
4 4.9
5 7.0
B) Use the trendline option to draw the best fit line for the above data and use it to determine the slope and y-intercept.
1 answer:
Answer:
y = 1.06 x + 0.14
r² = 0.95
Explanation:
a) To make this graph, a spreadsheet-type calculation program is used, see attached.
On the y axis are the measured values
On the x-axis, the values checked in the experiment are placed.
From the graph we see that a linear graph and that one of the values has a strong deviation with respect to the others
b) The red line is the best straight line that can be drawn,
for this the quality ajust is r²
the closer to 1 the better the fit
the equation of the line is
y = 1.06 x + 0.14
r² = 0.95
You might be interested in
1. Velocity at which the packet reaches the ground: 121.2 m/s
The motion of the packet is a uniformly accelerated motion, with constant acceleration directed downward, initial vertical position
, and initial vertical velocity
. We can use the following SUVAT equation to find the final velocity of the packet after travelling for d=750 m:
substituting, we find
2. height at which the packet has half this velocity: 562.6 m
We need to find the heigth at which the packet has a velocity of
In order to do that, we use again the same SUVAT equation substituting with this value, so that we find the new distance d that the packet travelled from the helicopter to reach this velocity:
Which means that the heigth of the packet was