VBA subroutine to determine the angle at which the max area occurs?
-
For the isosceles triangle shown below, as the angle (θ) changes, so does the area of the triangle. Using the equations shown below, write a VBA subroutine to determine the angle at which the maximum area occurs. Requirements for this solution are as follows: Read the length of the sides (x) from the spreadsheet (1 point). Vary the angle of the triangle from 0° to 180°, in increments of 1°, and calculate the area of the triangle for each angle. Use the equations shown below (6 points). Remember to convert the angle in degrees to radians for the calculations (2 points). Write each angle and area to the spreadsheet (2 points). Identify the angle at which the maximum area is achieved (2 points). Use the data from step 4 to generate a graph that shows the angle (y-axis) vs. the area (x-axis). Make sure the graph axes are labeled and a title is included on the graph (6 points). Include a complete flowchart for the VBA program (6 points). The base is "b" and the 2 sides "x" the angle is at the vertex of sides "x"
-
Answer:
are you asking us to do your homework?
Alex at Yahoo! Answers Visit the source
Related Q & A:
- Which area around San Diego should I stay if I want to be near the beach, nightlife, and shopping?Best solution by Yahoo! Answers
- Are there any jobs in dallas-ft worth area offering $10.00 an hour and up? If so, which companys?Best solution by Yahoo! Answers
- Which area in IT is easy to find a job?
- Which is the best WW1 and 2 museums to see inthe Dunkirk area?Best solution by Yahoo! Answers
- Which of these subwoofers are the best the lanzar 15 vibe or the lanzar 15 max pro?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.