Eide Problem 5.19: It is expected that power functions represent the surface area and volume of...
Eide Problem 5.19: It is expected that power functions represent the surface area and volume of a certain geometric shape. The values of the surface area and volume are given for different radius values in the table below. Radius, R (ft) 1 2 3 5 6 Surface Area, SA (ft) | Volume, V (ft) 12.6 4.19 50.3 33.5 113 113 200 268 314 524 450 905 616 1437 800 2145 1018 3054 1257 4189 7 T 8 10 In Excel, do the following: • Plot the Surface Area and Volume versus Radius with the appropriate axis to display the power data as linear (it will be easier if you do this on two separate graphs) Determine the equations of the power curves that fit the Surface Area and volume data using trendlines Determine the sum of the residuals squared for both the Surface Area and the Volume Refer to the following website and, based on the formulas you found to represent that data, determine the type of geometric shape that generated this data https://www.thoughtco.com/surface-area-and-volume-2312247