# Excel Formula

Not what you're looking for?

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.

##### Purchase this Solution

##### Solution Summary

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

##### 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 ...

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

##### Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

##### Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

##### Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

##### Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.