BigDan
11-11-2012, 05:12 PM
I'm doing an assignment. I've tried googling but I think my answer is wrong based on what I read.
I'm attaching a workbook here. In col E-I there's a Two-Variable Data Table. I'm guessing this is just supposed to be one variable multiplied by the other. Eg F18=F17*E18. Is this correct?
If so, how do I do this? I chose B9 as the row reference and B4 as the col reference, because those seemed to be the relevant data points.
Here's the actual question:
Create a two-variable data table in the range E17:I28, using the Ticket Price per Person as the Row input cell and the No. of Attendees as the Column input cell.
Help!
for the one-variable data table I'd be grateful if you could see if I did that correctly. In that I didnt get why we use B4 as a reference. It seems completely unrelated except for that being the first mention of the number of attendees. But in the table itself it doesnt seem to have a place.
I'm attaching a workbook here. In col E-I there's a Two-Variable Data Table. I'm guessing this is just supposed to be one variable multiplied by the other. Eg F18=F17*E18. Is this correct?
If so, how do I do this? I chose B9 as the row reference and B4 as the col reference, because those seemed to be the relevant data points.
Here's the actual question:
Create a two-variable data table in the range E17:I28, using the Ticket Price per Person as the Row input cell and the No. of Attendees as the Column input cell.
Help!
for the one-variable data table I'd be grateful if you could see if I did that correctly. In that I didnt get why we use B4 as a reference. It seems completely unrelated except for that being the first mention of the number of attendees. But in the table itself it doesnt seem to have a place.