Question
Sorry for asking again, but I am trying to create the graphs by the instructions given to me from a previous Q&A. I was asking
Sorry for asking again, but I am trying to create the graphs by the instructions given to me from a previous Q&A. I was asking how I can make the following code given to me into excel graphs:
a)
Price (P) ^ | 60,000 + demand (P(x) = 60,000 - 30x) |\ | \ | \ | \ 45,000 + \____________ | / \ | / \ | / cost (TK = 29.5x^2 + 500x + 50,000) 30,000 + / | / |/ 0 -----|-----------------|--------> Quantity (x) 0 500
b) Price (P) ^ | 45,000 + A C |\ / / | \ / / | \ / / | \ / / D 29,500 + \/ / | /\ / | / \/ | / B | / 0 -----|---------------> Quantity (x) 0 500
I was given the following instructions to make a table in excel:
a) In Column A (Quantity), input values from 0 to 500, in increments of your choice (e.g., 1, 5, or 10).
b) In Column B (Price), input the formula for demand (P(x) = 60,000 - 30x) in the first cell (B2), with x being the corresponding value in Column A. Drag this formula down to calculate the values for the entire range of x.
c) In Column C (Cost), input the formula for cost (TK = 29.5x^2 + 500x + 50,000) in the first cell (C2), with x being the corresponding value in Column A. Drag this formula down to calculate the values for the entire range of x.
how do I write point b) and c) into the cell?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started