Question: 8. Adjust the spreadsheet parameters to match the data and calculate the drag factor. You want to adjust the parameters of the spreadsheet so that

 8. Adjust the spreadsheet parameters to match the data and calculate

8. Adjust the spreadsheet parameters to match the data and calculate the drag factor. You want to adjust the parameters of the spreadsheet so that they match the data from the filter drop. The initial time in your data set is probably not 0. Enter the measured initial time in cell A7. The other times should adjust automatically. Enter the initial position in G7. The initial velocity should be 0. The time range for your data is probably smaller than the range of times you used in the previous problem. You can fix this by using a smaller time step. Decrease the value of the time step in cell 134 until the time range covered by the model is just a little larger than the time range of the data. Look at the initial slope of your model graph. If it doesn't match the slope of the data, adjust the value of the initial velocity in the model to get a good match. Finally, input the mass of the coffee filter into cell B1. When you make this change, your data and graph will change drastically. This is just because the value of K is too big right 110W. The K value is the only parameter left to adjust. Change the \"K" value until the model graph matches the actual data as closely as possible. Get the best value for Kto 2 significant figures. Record your K value for the coffee filter below {include appropriate units): K: Show the instructor your plots and K value. Ask your instructor if you should print the graph showing the model and actual data and attach it to your write-up. Save your spreadsheet (including the position vs. time graph) in your group folder

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Physics Questions!