A government economist obtained the following data from a simple random sample of ten private companies in the natural gas exploration business. In the table below, x is the capital investment the company puts into exploration and development (in millions of dollars) and y is the volume of natural gas discovered (adjusted to sea level pressure and in billions of cubic feet).
a) Draw the scatter diagram for this data.
b) Find the slope, b, and the intercept, a, for the leastsquares line. Write the equation of the leastsquares line.
c) Graph the leastsquares line on your scatter diagram.
d) If a company had invested 6.5 million dollars, what would the leastsquares line predict for the volume of natural gas discovered?
Solution:
a) Using Excel we obtain the following scatter diagram:
b) Again, we use Excel to find the least squares line. We get the following output:
SUMMARY OUTPUT 

Regression Statistics 

Multiple R 
0.854114 
R Square 
0.729511 
Adjusted R Square 
0.6957 
Standard Error 
3.328525 
Observations 
10 
This means that the least squares line is given by
_{}
c)
d) To get the predicted value we just have to evaluate_{}in the regression equation. The predicted value is hence
_{}