TextBox 1 : r A a c 1 Time is] Free fall distance in] Free (all Dislarlne [ml 2 0-001\" \"10453 When an object is dropped from a height it starts moving downwards due to Earth gravitvu The force acting on the object, if the air 3 0.00371 \"\"0537 resistance is neglected. is following the Newton's law of gravity: 4 0.00517 0.09505 5 0.00054 01125 M * m . 5 3332: 31133? |:| F = "' 'E rrz \"l" a 0.0151 0.102155 ' Where: 9 0.01353 0.12555 6 = 6.674x10'\" mJ-kg"-s'1 is the gravitational constant '0 0-02105 \"11544 M, is the mass of the Earth \" \"2357 \"237 R - Is the radius ofthe Earth 2 Egg: \"'13:: mo,"- - Is the mass of an object on the surface of the Earth. 14 0mm (\"gm If we rearrange this equation above we will get: 15 0.113358 0.15412 6 \" Ml ' m 15 0.005211 0.15975 R2 on} 17 0.09331 015594 We can make substitution: 13 0.04159 0.17155 0 .Mg m 19 0.04393 0.17775 11 = R2 57 2 0-04658 0118337 Now if we allow an object fall freely from a height Ho it follows the welLknown equation of motion with a constant acceleration. 21 0.04913 01755 at2 22 0.05179 0.19744 M18) = _+ pnt + 110 23 0.05443 0.20531 2 24 0.05708 0.21094 15 935573 \"0531 If no other forces are present in this test, the object moves under the force of Earth gravitvu Then: 25 0.06239 022555 a = g m/sAZ 17 0-055\" \"3455 If we use Excel add trend function and from the quadratic polynomial fit, we take the coefficient in front of the x"2 we can calculate 25 0'06\" (\"5937 the magnitude of the Earth magnetic eld. 29 0.07054 0.25256 30 0.07325 0.24537 31 0.075 0.17 Follow the numbered steps below to complete this 32 0.071177 0.27955 3 3:2: 2'22: Note: to receive full credit, the calculations in the steps below must be performed using Excel. Full credit will not be given for having 35 0mm 022512 the correct values in a cell without the proper rorm ula. 15 0.09005 0.32119 37 0.09239 0.33: To maintain the integrity of the project, make sure you have your name in the final graph Title 35 099577 \"34451 |n column A and B we have data collected during a free fall of an object measured by Ultrasound range sensor. The column A have :9) \":3: 3:23: the time in seconds and the column a has the distance in ft. In order for the Earth g to be calculated in Si units, all variables in the 41 0.10455 '0'396 graph of the position vs time should be in Si units. This means that the relative height should he in meters instead of feet 42 0.107511 0.39375 A3 0-1105! 41-40781 1) Converting free fall distance from feet to meters. Using Excel in column (C), add a formula with a cell reference to j: 8'32: 22;: column (B) to convert the relative height from feet to meters. Enter the formula into cell C3 and hit enter to convert the 45 0:119\" 0:45112 temperature in BS to meter. Click on C3, and then click CI'RL+C, then point your mouse to the cell C46 and then press 5HlFT+ Left 47 click. This should select the range of cells from c3 to 015. Then press mm. The whole range should be populated. as 49 IConversion formula: Ah (m) = Ah(ft) 4 0.3048 2) Building a chart. Click the column A on the column label A to select the whole column then hoid Ctrl key and left click the top of the column C. You should see columns A and C selected. Form the top menu select Insert and then from the ribbon group Charts select Insert Scatter. From Scatter insert the chart with points only. Piace the chart. The graph represents the free fall reiative height {m} vs time [s] 3} Adding Trendline. Now we will add Trendline to the plotted data. Right click on the data points on the graph and select from the popup menu Add Trendline. From the Format trendline window on the left select Polynomial Order 2. Select Display Equation on the chart check box from the same window on the 1eft of your Excel spreadsheet. You should see the trendiine equation on the graph. 4) Calculating 3. Calculate the g from the coefcient in front of x2 in the trendline formula. Place the value in E2 cell. 5) Type your full name into the titie of the graph. To do that double click on the graph Title and add your name. Questions: 1) Why are we converting the distance in ft to meters? 2) If the experiment is performed on the top of the mount Everest what will be the result for g. Explain. 3) What you expect to be the result if the same experiment is performed by the Mars Rover on surface of Mars? Explain. Post a Screenshot of your results in Excel when completed