A few days ago
Anonymous

Can anyone tell me what to input into Excel?

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!

Top 2 Answers
A few days ago
Anonymous

Favorite Answer

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
0

A few days ago
nora22000
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.

0