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.