Answer Question 2:

The answer for question 1 is 2934 psia

I just need the plot done for question 2 with excel please.

Q1: Six months ago, you completed the first well in a newly-discovered reservoir whose initial pressure was 3150 psig. The well produces 40.3API oil and 0.756 specific gravity gas. The well's producing gas-oil ratio (Rp) is 1000SCF/STB, which has remained constant. Estimate the reservoir-oil's bubble-point pressure given that the reservoir temperature is 205F. Q2: Estimate and plot the solution gas-oil ratio of the reservoir oil of Q1. Start at a pressure of 3I50 psig and decrease the pressure in 500psi steps to a final pressure of 150psig