B. Find the acceleration of Falcon9/Crew Dragon in the beginning of the third minute. Use your data for the time interval (100, 150) s and plot velocity versus time. Using the built-in linear regression function in the Spreadsheet file, determine the best line fit for the graph and the slope of that line. The slope of the best fit line is the acceleration of the Falcon 9/Crew Dragon in the interval (100, 150) second. Question: 1. What is the acceleration of the rocket in m/s^2? Here is an example of what the spreadsheet looks like. Notes. 1. The file below includes only part of my data and analysis. 2. Make sure your graph is XY scatter type 3. Do not connect the data points - add trendline (that's the linear fit line) 4. Include the equation of that trend line - that's the slope of the graph and should be equal to the acceleration of the rocket. File Edit View Insert Format Data Tools Add-ons Help Last edit was 5 min 100% - $ % .0 .00 123- Default (Art_ - i. Chart editor e in s Setup Customize 464 128.8888889 572 158.8988 687 Format data point Add 190.8333333 798 221.65 860 238.8888889 925 256.9444444 Error bars 1000 277.7777778 Data labels Trendline speed in (m/s) vs. time in seconds . speed in (mis) - 4.9x +-11.4 Line color time in seconds speed in (mis) 500 Linear 65.55555556 Line cpacity Line thickness 128.888888 158.88 20 40% 190.8333333 speed in (mis) 221.66 Label 238.888868 10 256.9444444 Use Equation 277.7777778 Show Re time in seconds Legend Results Submit your spreadsheet for lab credit. Your submission will be graded based on the following criteria: Total points 5 pt 1. Data for the first 3 minutes in 5 min increments (1 pt) 2. Plot for the first 3 minutes of flight, no trendline, or slope. (1 pt) 3. Plot of data for 100 s to 150 s of flight in XY scatter format (1 pt) 4. Draw the best line fit (trend line) and determine the slope (1 pt) 5. Give your answer for the acceleration of the rocket from 100 s to 150 s. (1 pt)Velocity and Acceleration (Tatiana Stantcheva) Purpose of this lab To analyze the motion of the NASA/SpaceX Falcon 9 rocket during its first 2 minutes. Here is a recording of the launch that occurred at 3:22 pm on May 30, 2020 https://www.youtube.com/watch?v=TxBj8R7XKe4 Activity 1. Collecting Data From the Video Open a spreadsheet and record the velocity of the Falcon 9/Crew Dragon for the first 3 minutes in increments of 5 seconds, beginning from TO to T+00:03:00 The velocity in km/h is given in the lower-left corner of the video. Use the launch counter for the time, e.g. T+00:00:15 is time marker of 15 seconds after launch. Here is an example of how your spreadsheet should look like. You should have about 25 entries - data for the first 2 minutes of the flight. time in seconds speed (km/h) 18 236 25 366 30 464 35 572 40 687 Activity 2. Data Analysis A. Plot of speed versus time The speed in the lower corner is given in km/h. In your spreadsheet, add a column where you convert the speed in the metric system. Here is an example of your spreadsheet: time in seconds speed (km/h) speed in (m/s) 18 236 65.55555556 25 366 101.6666667 30 464 128.8888889 35 572 158.8888889 40 687 190.8333333 Plot the speed in m/s versus time in second graph. Questions: 1. During what time intervals is the graph linear? 2. How does the graph look around the time Falcon separates from Crew Dragon