Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Initial Kinematics Spreadsheet HW Assignment The Initial HW Spreadsheet file found in the Course Documents section of BlackBoard contains four separate position (x1, x2, x3,x4)
Initial Kinematics Spreadsheet HW Assignment The "Initial HW Spreadsheet file" found in the Course Documents section of BlackBoard contains four separate position (x1, x2, x3,x4) vs time data sets. For each data set (x1, x2, x3, x4) use the centered difference calculation presented in class of Ax/At to calculate: (1) the resulting velocity v, and (2) Av/At to calculate the resulting acceleration a. Next, produce a set of position vs time, velocity vs time, and acceleration vs time graphs for each of the 4 data sets. Make sure each of your graphs contains a title indicating what is plotted in that graph, along with axis titles indicating the quantity and measurement unit plotted along that axis. Submit a pdf of the resulting filled-in spread sheet with calculated values and graphs by email. DUE DATE: 9:00 AM, Wednesday, 06 September, 2023A A P G ... 3 Initial Spreadsheet HW ~ Q AutoSave OFF Home Insert Draw Page Layout Formulas Data Review ? Tell me Comments Share Calibri (Body) 16 AA = ap Wrap Text v Number Ex AY- O. Conditional Format Cell Insert Delete Format Sort & Find & Analyze Paste BIU BY OvAv E Merge & Center v $ ~ % " Formatting as Table Styles Filter Select Data D36 C D E F G H I J K M N 0 a R S T U A B 2 time [s] x1 [m] v1 [m/s] a1 [m/s^2] x2 [m] v2 [m/s] a2 [m/s^2] x3 [m] v3 [m/s] a3 [m/s^2] x4 [m] v4 [m/s] a4 [m/s^2] 0.00 0 0.00 0.00 0.01 0.67 0.02 0.01 2.37 1.33 0.09 0.02 4.63 2.00 0.20 0.03 6.77 2.67 0.36 0.06 8.77 3.33 0.56 0.10 10.64 4.00 0.80 0.16 12.36 J 10 4.67 1.09 0.28 13.92 11 8 5.33 1.42 0.47 15.32 12 6.00 1.80 0.78 16.54 10 6.67 2.22 1.30 17.59 13 14 11 7.33 2.69 2.12 18.45 8.00 19.13 15 12 3.20 3.36 16 13 8.67 3.76 5.12 19.61 9.33 4.36 19.90 17 14 7.39 15 10.00 5.00 10.00 20.00 18 19 16 10.67 5.69 12.61 19.90 17 11.33 6.42 14.8 19.61 20 19.13 21 18 12.00 7.20 16.64 22 19 12.67 8.02 17.88 18.45 23 20 13.33 8.89 18.70 17.59 24 21 14.00 9.80 19.22 16.54 25 22 14.67 10.76 19.53 15.32 26 23 15.33 11.76 19.72 13.92 24 16.00 19.84 12.36 27 12.80 25 16.67 13.8 19.90 10.64 28 8.77 29 26 17.33 15.02 19.94 30 27 18.00 16.20 19.97 6.77 31 28 18.67 17.42 19.98 4.63 32 19.33 18.69 19.99 2.37 Sheet1 + 100% Ready 12 Accessibility: Good to go3 Initial Spreadsheet HW ~ Q AutoSave OFF A B P G ... Insert Draw Page Layout Formulas Data Review View ? Tell me Comments Share Home Calibri (Body) 16 AA ap Wrap Text v Number EX AY- O. Cell Insert Delete Format Sort & Find & Analyze Paste OvAv E Merge & Center v $ ~ % " Conditional Format Formatting as Table Styles Filter Select Data D36 fx 3 C D E G H I K L M N P R S T U.JO 10.04 4.00 0.80 0.16 12.36 10 4.67 1.09 0.28 13.92 5.33 1.42 0.47 15.32 11 12 6.0 1.80 0.78 16.54 13 10 6.67 2.22 1.30 17.59 18.45 14 11 7.33 2.69 2.12 15 12 8.00 3.20 3.36 19.13 16 13 8.67 3.76 5.12 19.61 14 9.33 4.36 7.39 19.90 17 18 15 10.00 5.00 10.00 20.00 16 10.67 5.69 19.90 19 12.61 20 17 11.33 6.42 14.88 19.61 21 18 12.00 7.20 16.64 19.13 18.45 22 19 12.67 8.02 17.8 23 20 13.33 8.89 18.70 17.59 24 21 14.00 9.80 19.22 16.54 25 22 14.67 10.76 19.53 15.32 26 23 15.33 11.76 19.72 13.92 27 24 16.00 12.80 19.84 12.36 25 16.67 13.89 19.90 10.64 28 29 26 17.33 15.02 19.94 8.77 27 18.00 16.20 19.97 6.77 30 31 28 18.67 17.42 19.98 4.63 32 29 19.33 18.69 19.99 2.37 33 30 20.00 20.00 19.99 0.00 34 35 36 37 38 39 D Sheet1 + + 100% Ready 12 Accessibility: Good to go
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started