For part of my micro economics final project I have to graph certain functions from a companies financial statements over a few years. I chose Honda 03-09.
I cant get the graphs to turn out the way they should; with price on the y-axis, and quantity on the x-axis.
I have everything calculated out in excel. any ideas? I can email the spreadsheet to someone if they want to mess with it.
(everything is in thousands, btw)
it should look something like this:
though you already did the hard part…
good try newman. lol
here is what I got by breaking up the data. I still cant figure out how to get the quantity on the x axis and have the corresponding lines plot correctly.
so theyre just linear plots? i dont understand whats keeping them from plotting correctly if the x and ys are all in the right place,
also i hate the new excel
well technically its not an (x,y) plot. for example:
at 15,120 units (x-axis) with a price of $4,386.18 (y-axis) yields 66,319,000 in total revenue (point to be plotted).
So it’s 3 dimensional?
it better not be, this is micro economics 101. Ill try to get more clairification in class tomorrow.
This is a lot more than he is expecting, most of the kids in this class are freshman and he said its ok to draw it by hand. Regardless, I still want to know how to do it.
Dude, i’m telling you a 2d graph can only be a function of 1 variable.
If you have 2 variables, time and price, you need a 3d graph.
You said wanted quantity on the X and dollars on the Y, but in economics, Q is TIME not quantity.
However, you can have Y(x) = X, q
where Q is also a function of x, or a SCALAR
this
Although from the look of the attachment, it just looks like he is trying to have them all plotted against individual Y axises. Easy with two variables (think dyno plot of HP/tq) but I’m not sure how to do it with more than that in Excel.
Yeah, but everything he seems to want to plot is time vs dollars… it’s going to get ugly if you’re trying to associate 3 different Y axes of dollars to 3 different curves… For that I would scale the input data and note it in the legend MC^-3 or something…
What I think he’s missing about adding the QUANTITY is that his FUNCTION for each plotted curve is dependent on quantity, so that’s where it picks it up.
Yea, you can fudge the numbers by scaling them and then hiding the Y-axis labels in order to get the “look” that you seem to be going for.
if you get real desperate, in my mae334 class, i got lazy and didnt do my last lab, i used paint an made all the figures
93/100 =)
is this what you’re trying to do?
a dual axis graph.
one axis on the left one on the right
thats the same graph as I did above, but you selected the line segment instead of a curve
ok, now we are getting some where…
No, it’s actually totally different…
That is units vs. dollars
Yours is time vs. dollars.
On a dual axis graph you are still only able to plot ONE variable…
It’s like making:
a quantity vs dollars graph
a time vs. dollars graph
and laying them over the top of one another… is that what you want to do?
no, its the same graph, he just incorrectly re-labeled the x axis.
his:
mine:
nice try, it probably would have gone un noticed in a paper. lol
The graph I posted originally is right. my economics professor (brewer, taught at UB for a while, anyone know him?) said that all of the functions in the bigger graph have a common denominator of output (quantity), so they are already in respect to quantity.