Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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:
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 windowStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started