Overview
Page 1 Part III a) Steps
Type the order pairs from your T-table from Part I in Excel.
Highlight your T-table and insert a chart. Look at the right for picture.
Select a scatter chart.
Picture 1: Place the cursor on your order pairs and click on them until it highlights the order pairs and the T-table. Let go the cursor. Picture 2: Now, right click and select Add Trendline. Picture 3: Play around with your order pairs to select the right equation. You can see the following pictures below.5. Play around with the trending options: linear, logarithmic, polynomial (you may change the degree to see which one fits the most order pairs degree 2,3, 4, 5, or 6, etc.
6. Select Set Intercept and Display Equation on Chart.
7. Print a copy of your chart with your equation.
Page 2 Part III b) Steps
Using the formula that you just created using excel.
Set-up the Integral for the volume.
Use Excel to Calculate the Volume of the Avocado (this volume includes the seed inside the avocado). You may use a graphing calculator but must submit all work done.
Print a copy of the excel work with the volume included. Don’t forget the units.