Using a Two-Way Data Table to Calculate the Volume of a Cone

[knenok]

Possible height values: 6, 9, 12, 15, 18

Possible Radii: 2, 4, 6, 8, 10

Formula: Volume=Pi*(Radius^2*Height)/3

Not sure how to set up a two-way data table to calculate the possible volumes.

What I have:

			Height Values
		6	9	12	15	18
	2
	4
Radius Values	6
	8
	10

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

 

[Eric W]

Homework?

You've about got it set up properly. Go to the cell at the intersection of 2 and 6, and enter the formula pointing to those cells. Now read up on the $ symbol, and absolute and relative references, and see how to set up the formula so you can copy/paste it to the other cells.