Hello,
For my Optimization class, I have to make a chart from a 2 variable function F(x,y)
This is the function : F(x,y) = 500*(x^1/2)*(y^1/4)
x ranges between 0 and 20
y ranges between 0 and 60
I think my excel table is right, but I can't seem to make the right graphic.
Any help? I'll put the document in the post.
[TABLE="width: 237"]
<tbody>[TR]
[TD]x[/TD]
[TD]y[/TD]
[TD]f(x,y)[/TD]
[/TR]
[TR]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]1.00[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]500.00[/TD]
[/TR]
[TR]
[TD="align: right"]2.00[/TD]
[TD="align: right"]2.00[/TD]
[TD="align: right"]840.90[/TD]
[/TR]
[TR]
[TD="align: right"]3.00[/TD]
[TD="align: right"]3.00[/TD]
[TD="align: right"]1139.75[/TD]
[/TR]
[TR]
[TD="align: right"]4.00[/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]1414.21[/TD]
[/TR]
[TR]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]1671.85[/TD]
[/TR]
[TR]
[TD="align: right"]6.00[/TD]
[TD="align: right"]6.00[/TD]
[TD="align: right"]1916.83[/TD]
[/TR]
[TR]
[TD="align: right"]7.00[/TD]
[TD="align: right"]7.00[/TD]
[TD="align: right"]2151.76[/TD]
[/TR]
[TR]
[TD="align: right"]8.00[/TD]
[TD="align: right"]8.00[/TD]
[TD="align: right"]2378.41[/TD]
[/TR]
[TR]
[TD="align: right"]9.00[/TD]
[TD="align: right"]9.00[/TD]
[TD="align: right"]2598.08[/TD]
[/TR]
[TR]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]2811.71[/TD]
[/TR]
[TR]
[TD="align: right"]11.00[/TD]
[TD="align: right"]11.00[/TD]
[TD="align: right"]3020.05[/TD]
[/TR]
[TR]
[TD="align: right"]12.00[/TD]
[TD="align: right"]12.00[/TD]
[TD="align: right"]3223.71[/TD]
[/TR]
[TR]
[TD="align: right"]13.00[/TD]
[TD="align: right"]13.00[/TD]
[TD="align: right"]3423.16[/TD]
[/TR]
[TR]
[TD="align: right"]14.00[/TD]
[TD="align: right"]14.00[/TD]
[TD="align: right"]3618.81[/TD]
[/TR]
[TR]
[TD="align: right"]15.00[/TD]
[TD="align: right"]15.00[/TD]
[TD="align: right"]3811.00[/TD]
[/TR]
[TR]
[TD="align: right"]16.00[/TD]
[TD="align: right"]16.00[/TD]
[TD="align: right"]4000.00[/TD]
[/TR]
[TR]
[TD="align: right"]17.00[/TD]
[TD="align: right"]17.00[/TD]
[TD="align: right"]4186.07[/TD]
[/TR]
[TR]
[TD="align: right"]18.00[/TD]
[TD="align: right"]18.00[/TD]
[TD="align: right"]4369.43[/TD]
[/TR]
[TR]
[TD="align: right"]19.00[/TD]
[TD="align: right"]19.00[/TD]
[TD="align: right"]4550.25[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]20.00[/TD]
[TD="align: right"]4728.71[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]21.00[/TD]
[TD="align: right"]4786.74[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]22.00[/TD]
[TD="align: right"]4842.73[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]23.00[/TD]
[TD="align: right"]4896.85[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]24.00[/TD]
[TD="align: right"]4949.23[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]25.00[/TD]
[TD="align: right"]5000.00[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]26.00[/TD]
[TD="align: right"]5049.27[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]27.00[/TD]
[TD="align: right"]5097.13[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]28.00[/TD]
[TD="align: right"]5143.69[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]29.00[/TD]
[TD="align: right"]5189.01[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]30.00[/TD]
[TD="align: right"]5233.18[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]31.00[/TD]
[TD="align: right"]5276.25[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]32.00[/TD]
[TD="align: right"]5318.30[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]33.00[/TD]
[TD="align: right"]5359.37[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]34.00[/TD]
[TD="align: right"]5399.51[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]35.00[/TD]
[TD="align: right"]5438.79[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]36.00[/TD]
[TD="align: right"]5477.23[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]37.00[/TD]
[TD="align: right"]5514.87[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]38.00[/TD]
[TD="align: right"]5551.76[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]39.00[/TD]
[TD="align: right"]5587.93[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]5623.41[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]41.00[/TD]
[TD="align: right"]5658.23[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]42.00[/TD]
[TD="align: right"]5692.43[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]43.00[/TD]
[TD="align: right"]5726.01[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]44.00[/TD]
[TD="align: right"]5759.01[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]45.00[/TD]
[TD="align: right"]5791.46[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]46.00[/TD]
[TD="align: right"]5823.37[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]47.00[/TD]
[TD="align: right"]5854.76[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]48.00[/TD]
[TD="align: right"]5885.66[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]49.00[/TD]
[TD="align: right"]5916.08[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]50.00[/TD]
[TD="align: right"]5946.04[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]51.00[/TD]
[TD="align: right"]5975.55[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]52.00[/TD]
[TD="align: right"]6004.62[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]53.00[/TD]
[TD="align: right"]6033.29[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]54.00[/TD]
[TD="align: right"]6061.55[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]55.00[/TD]
[TD="align: right"]6089.42[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]56.00[/TD]
[TD="align: right"]6116.91[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]57.00[/TD]
[TD="align: right"]6144.04[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]58.00[/TD]
[TD="align: right"]6170.81[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]59.00[/TD]
[TD="align: right"]6197.24[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]60.00[/TD]
[TD="align: right"]6223.33[/TD]
[/TR]
</tbody>[/TABLE]
For my Optimization class, I have to make a chart from a 2 variable function F(x,y)
This is the function : F(x,y) = 500*(x^1/2)*(y^1/4)
x ranges between 0 and 20
y ranges between 0 and 60
I think my excel table is right, but I can't seem to make the right graphic.
Any help? I'll put the document in the post.
[TABLE="width: 237"]
<tbody>[TR]
[TD]x[/TD]
[TD]y[/TD]
[TD]f(x,y)[/TD]
[/TR]
[TR]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]1.00[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]500.00[/TD]
[/TR]
[TR]
[TD="align: right"]2.00[/TD]
[TD="align: right"]2.00[/TD]
[TD="align: right"]840.90[/TD]
[/TR]
[TR]
[TD="align: right"]3.00[/TD]
[TD="align: right"]3.00[/TD]
[TD="align: right"]1139.75[/TD]
[/TR]
[TR]
[TD="align: right"]4.00[/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]1414.21[/TD]
[/TR]
[TR]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]1671.85[/TD]
[/TR]
[TR]
[TD="align: right"]6.00[/TD]
[TD="align: right"]6.00[/TD]
[TD="align: right"]1916.83[/TD]
[/TR]
[TR]
[TD="align: right"]7.00[/TD]
[TD="align: right"]7.00[/TD]
[TD="align: right"]2151.76[/TD]
[/TR]
[TR]
[TD="align: right"]8.00[/TD]
[TD="align: right"]8.00[/TD]
[TD="align: right"]2378.41[/TD]
[/TR]
[TR]
[TD="align: right"]9.00[/TD]
[TD="align: right"]9.00[/TD]
[TD="align: right"]2598.08[/TD]
[/TR]
[TR]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]2811.71[/TD]
[/TR]
[TR]
[TD="align: right"]11.00[/TD]
[TD="align: right"]11.00[/TD]
[TD="align: right"]3020.05[/TD]
[/TR]
[TR]
[TD="align: right"]12.00[/TD]
[TD="align: right"]12.00[/TD]
[TD="align: right"]3223.71[/TD]
[/TR]
[TR]
[TD="align: right"]13.00[/TD]
[TD="align: right"]13.00[/TD]
[TD="align: right"]3423.16[/TD]
[/TR]
[TR]
[TD="align: right"]14.00[/TD]
[TD="align: right"]14.00[/TD]
[TD="align: right"]3618.81[/TD]
[/TR]
[TR]
[TD="align: right"]15.00[/TD]
[TD="align: right"]15.00[/TD]
[TD="align: right"]3811.00[/TD]
[/TR]
[TR]
[TD="align: right"]16.00[/TD]
[TD="align: right"]16.00[/TD]
[TD="align: right"]4000.00[/TD]
[/TR]
[TR]
[TD="align: right"]17.00[/TD]
[TD="align: right"]17.00[/TD]
[TD="align: right"]4186.07[/TD]
[/TR]
[TR]
[TD="align: right"]18.00[/TD]
[TD="align: right"]18.00[/TD]
[TD="align: right"]4369.43[/TD]
[/TR]
[TR]
[TD="align: right"]19.00[/TD]
[TD="align: right"]19.00[/TD]
[TD="align: right"]4550.25[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]20.00[/TD]
[TD="align: right"]4728.71[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]21.00[/TD]
[TD="align: right"]4786.74[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]22.00[/TD]
[TD="align: right"]4842.73[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]23.00[/TD]
[TD="align: right"]4896.85[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]24.00[/TD]
[TD="align: right"]4949.23[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]25.00[/TD]
[TD="align: right"]5000.00[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]26.00[/TD]
[TD="align: right"]5049.27[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]27.00[/TD]
[TD="align: right"]5097.13[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]28.00[/TD]
[TD="align: right"]5143.69[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]29.00[/TD]
[TD="align: right"]5189.01[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]30.00[/TD]
[TD="align: right"]5233.18[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]31.00[/TD]
[TD="align: right"]5276.25[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]32.00[/TD]
[TD="align: right"]5318.30[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]33.00[/TD]
[TD="align: right"]5359.37[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]34.00[/TD]
[TD="align: right"]5399.51[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]35.00[/TD]
[TD="align: right"]5438.79[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]36.00[/TD]
[TD="align: right"]5477.23[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]37.00[/TD]
[TD="align: right"]5514.87[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]38.00[/TD]
[TD="align: right"]5551.76[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]39.00[/TD]
[TD="align: right"]5587.93[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]5623.41[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]41.00[/TD]
[TD="align: right"]5658.23[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]42.00[/TD]
[TD="align: right"]5692.43[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]43.00[/TD]
[TD="align: right"]5726.01[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]44.00[/TD]
[TD="align: right"]5759.01[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]45.00[/TD]
[TD="align: right"]5791.46[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]46.00[/TD]
[TD="align: right"]5823.37[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]47.00[/TD]
[TD="align: right"]5854.76[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]48.00[/TD]
[TD="align: right"]5885.66[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]49.00[/TD]
[TD="align: right"]5916.08[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]50.00[/TD]
[TD="align: right"]5946.04[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]51.00[/TD]
[TD="align: right"]5975.55[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]52.00[/TD]
[TD="align: right"]6004.62[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]53.00[/TD]
[TD="align: right"]6033.29[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]54.00[/TD]
[TD="align: right"]6061.55[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]55.00[/TD]
[TD="align: right"]6089.42[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]56.00[/TD]
[TD="align: right"]6116.91[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]57.00[/TD]
[TD="align: right"]6144.04[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]58.00[/TD]
[TD="align: right"]6170.81[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]59.00[/TD]
[TD="align: right"]6197.24[/TD]
[/TR]
[TR]
[TD="align: right"]20.00[/TD]
[TD="align: right"]60.00[/TD]
[TD="align: right"]6223.33[/TD]
[/TR]
</tbody>[/TABLE]