Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Infrared Technology Fundamentals

Authors: Monroe Schlessinger

2nd Edition

1351438344, 9781351438346

More Books

Students also viewed these Physics questions