Next, analyze Table 2 as follows: 1 . You will use Excel to plot a graph of range vs. initial speed squared then fit a best-fit equation to the data. Start by inputting each initial speed in a column then input each square value in the next column in Excel. Do not include units. Then input each range value in the next column. Again, do not include the units. 2. Next, highlight the speed squared and range data, then click the "Insert" tab near the top of the screen, then click "Scatter" and select the first item in the drop-down menu. Your plot should appear. If not, get help from the instructor. 3. Confirm that your x-axis is scaled for speed-squared data and your y-axis is scaled for range data. If the data is plotted incorrectly, get help from the instructor. 4. To fit a best-fit equation, right-click on any data point and click "Add Trendline..." from the pop-up menu. An options menu appears and you should make sure "Linear" is selected, then check the box at the bottom that reads, "Display Equation on Chart," and check the box that reads, "Set intercept". Make sure "0.0" is listed, then click "Close." Your trendline and corresponding equation (of the form, y = slope.x) should appear on the plot. If not, get help from the instructor. 5 . Finally, write your equation below. y = 0. 07 8 1 x Use the equation to predict what the range will be for an initial speed of 19 m/s. Slide the target there and set the initial speed to 19 m/s, then fire the cannon. Does the cannonball strike the middle of the target? y = 0 . 0781 x = 0 0781 ( 19)2 = 0. 0981 ( 341) - 28. 19 m To determine why you included the square of speed in your data, derive an expression below for range by combining Equations 1 and 2 to eliminate time. Note that the vertical displacement is zero, and there is no horizontal acceleration. Equation 1 : Ay = Joy At + 2 ag (At ) 2 . Ax = Vox At+ 2 ax ( At ) ? ay = 0 Compare your expression to your Excel equation by Equation Matching. Use your expression to calculate the slope below. Show your calculations with units