Question: I need help writing VBA codes in Excel for the following tasks: Problem Statement: Write a single well-commented program to determine the drag coefficient c

I need help writing VBA codes in Excel for the following tasks:

I need help writing VBA codes in Excel for the following tasks:

Problem Statement: Write a single well-commented program to determine the drag coefficient

Problem Statement: Write a single well-commented program to determine the drag coefficient c requi achutist with a mass of 68.1 kg reaches a velocity of 40 m/s (+/- 0.01 m/s) after 10 second of ach to do so. You should graph the error over a range of drag coefficients frecfall. Use the incremental appro (say, I to 20) to determine an appropriate search neighborhood before beginning your coding. Derived from Newton's second law, the parachutist's velocity is described by 7 1 -e-(c/m)t Where v is the velocity in m/s, m is mass in kg, t is time in seconds, and c is the drag. Acceleration due to gravity, g, is 9.80665 m/s Additional Requirements/Details: In this situation, the error we want to minimize is in the velocity estimation, not in the drag coefficient. You may find it simpler to use a Do Loop for this, with multiple stopping criteria: one if you get withir your target error for velocity, and one if you have scanned the entire range of c values without finding a suitable solution- in which case, you might add a pop-up warning "Solution not found." Report the results to a popup window. Problem Statement: Write a single well-commented program to determine the drag coefficient c requi achutist with a mass of 68.1 kg reaches a velocity of 40 m/s (+/- 0.01 m/s) after 10 second of ach to do so. You should graph the error over a range of drag coefficients frecfall. Use the incremental appro (say, I to 20) to determine an appropriate search neighborhood before beginning your coding. Derived from Newton's second law, the parachutist's velocity is described by 7 1 -e-(c/m)t Where v is the velocity in m/s, m is mass in kg, t is time in seconds, and c is the drag. Acceleration due to gravity, g, is 9.80665 m/s Additional Requirements/Details: In this situation, the error we want to minimize is in the velocity estimation, not in the drag coefficient. You may find it simpler to use a Do Loop for this, with multiple stopping criteria: one if you get withir your target error for velocity, and one if you have scanned the entire range of c values without finding a suitable solution- in which case, you might add a pop-up warning "Solution not found." Report the results to a popup window

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 Databases Questions!