Answer to Question #52981 in Microeconomics for Halima
I am having problems plotting a supply and demand graph on excel just using an equation and also just creating graphs to show a shift in the demand or supply curve without any numbers. Also how to calculate relative price concerning two commodities.
To plot a supply and demand graph on excel just using an equation you need to create a table with column "Q" and column "P" (in which you use equation provided to calculate P using Q). And then you should create a graph using points XY. If you need just creating graphs to show a shift in the demand or supply curve without any numbers, you need also to create a table, but with additional column for P1 (for the curve after the shift). To calculate relative price concerning two commodities you just need to express one commodity using the other.
Everything works, thank you (Operator and Expert) so much! I will bookmark this page for future reference. Excellent job on the comments to by the way, now I can study and understand what is happening for the future!