Determine the Intersection

[xuetengwang]

Hi I have 2 sets of data. One straight line and one curve.

The curve consists of numbers that given, no formula...

Can anyone please tell me how to get the intersection of these 2 graphs?

I been struggling with it for hours, and just could not find a way. Any hints will be greatly appreciated. I tried but could not post attachments or images from my PC.

I can send through by email: xuetengwang@gmail.com

Thank you!!

 

[shg]

See the workbook at https://app.box.com/s/hkivovq1895ngjeo6r1g for a UDF solution.

 

[FDibbins]

cross-posted here...
Determine the Intersection

 

[mirabeau]

Hi I have 2 sets of data. One straight line and one curve.

The curve consists of numbers that given, no formula...

Can anyone please tell me how to get the intersection of these 2 graphs?

I been struggling with it for hours, and just could not find a way. Any hints will be greatly appreciated. I tried but could not post attachments or images from my PC.

I can send through by email: xuetengwang@gmail.com

Thank you!!

So you want to find the quantity at which marginal cost cuts marginal revenue from below to determine profit-maximizing output.

Whoever set your assignment, since it seems that's what it is, seems to have conveniently given you a (very, very close to) cubic total cost curve, hence a quadratic marginal cost curve, making your problem very easy.

Set up the equation MR-MC= a + b*Q + c*Q^2. Then do a regression of the LHS on the RHS using Excel's LINEST, or the data analysis add-in regression, or other. With your obviously jacked-up data the fit would be very good.

Solve the resulting equation for quantities Q at MR-MC=0 (there's two solutions) using Excel GoalSeek or Solver, and choose the larger value for profit maximum.

If you're keen, you could then do the formal statistical calculation of confidence interval for the result, etc.