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.

Please I will thumbs up. 0 A = 10 in B B

01-30 C Instructions: In this exercise, you will explore the triangle above

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

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!