Explore BrainMass
Share

# Excel Formula

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The data in the following table show the number of shares selling (millions and the expected price (average of projected low price and projected high price) for 10 selected initial public stock offering.

See attached data:
A. Develop an estimated regression equation with the number of shares selling as the independent variable and the expected price as the dependent variable.
B. As the 0.05 level of significance, is there a significant relationship between the two variables?
C. Did the estimated regression equation provide a good fit? Explain.
D. Use the estimated regression equation to estimate the expected price for a firm considering an initial public offering of 6 millions shares.

#### Solution Preview

In excel 2003 select Tools then Data analysis, in that select Regression and click on ok. Next in Input Y- Range select variable Price with label and in Input X-range select variable Shares with label, then click on Labels. Finally Click Ok. A brief regression output should appear. In 2007 select Data then Data analysis then follow the same procedure as in 2003.

The data in the following table show the number of shares selling (millions and the expected price (average of projected low price and projected high price) for 10 selected initial public stock offering.
A) develop an estimated regression equation with the number of ...

#### Solution Summary

The expert examines an excel formula to develop an estimated regression equation with the number of shares selling as the independent variable.

\$2.19