Is anyone familiar with creating graphs with Excel?
I have a formula that I want to input into Excel Here is the formula
Total Costs=Variable Costs + Fixed Costs
C(x)=mx+y
where x represents the number of items produced, m represents the cost to produce each item, and y represents the fixed costs
My x values will be changing, because I must show how the graph will change with low numbers and high numbers substituted for x.
I want to have Excel figure out the y values, but I don't know what to type in the fx box for it to work this formula.
Thanks!
2007-07-06 08:18:05 · 2 answers · asked by Anonymous in Education & Reference ➔ Homework Help
nora, I know but I don't have the values for y yet, and that's what I want Excel to figure out, my y values. What do I put in to have it figure out the y? Thanks!
2007-07-06 08:34:56 · update #1
Not sure if this will answer your question, but the RAND formula will allow you to do a sort of Monte Carlo analysis. You just need to put the upper and lower parameters and Excel will pick random numbers between the parameters for "X" or "Y" , whatever you choose. Hope this helps
2007-07-06 08:27:38 · answer #1 · answered by Anonymous · 0⤊ 0⤋
It's very simple, so if you do too much, you'll screw it up.
Make a table, and put your 'x' values horizontally and your 'y' values vertically. Then press the 'graph' icon at the top of the screen, and Excel will make your graph for you.
You can pick options like making titles, etc. after that.
2007-07-06 15:27:00 · answer #2 · answered by nora22000 7 · 0⤊ 0⤋