Question: Please I will thumbs up. 0 A = 10 in B B 01-30 C Instructions: In this exercise, you will explore the triangle above using
Please I will thumbs up.


0 A = 10 in B B 01-30 C Instructions: In this exercise, you will explore the triangle above using Excel. 1. Create an excel spreadsheet with the following column headers: C (in inches), e in degrees), (in degrees), B (in inches), and Area (in 59, in.) (5 points) 2. Use "Fill" to populate C with integer values from 1 to 15. (5 points) 3. Create formulas to calculate 9, B, B and Area. (40 points) 4. Extend the first column to include C values up to 30. What happens to your calculations? Why does this happen? What is the maximum value C can have? (10 points) 5. Look at the Area column. Is the Area always increasing? Between which two values of C does the area decrease? (20 points) 6. Insert rows with values of that fall between the two values named in #5 (in other words, use decimals, not integers). Try different values of C to maximize the Area of the triangle. At which value of C does Amus occur? At which value of does Amus occur? (20 points) Derive your result for the maximum area mathematically - use. Calculus. Calculate the value of at which the maximum area occurs and the value of Amus. Show ALL work neatly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
