Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

image text in transcribed

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

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 3 Lnai 9286

Authors: Albert Bifet ,Michael May ,Bianca Zadrozny ,Ricard Gavalda ,Dino Pedreschi ,Francesco Bonchi ,Jaime Cardoso ,Myra Spiliopoulou

1st Edition

3319234609, 978-3319234601

More Books

Students also viewed these Databases questions

Question

Technology. Refer to Case

Answered: 1 week ago