Find the Regression Line Using Excel for Mr. William Profit
Not what you're looking for?
Mr. William Profit is studying companies going public for the first time. He is particularly interested in the relationship between the size of the offering and the price per share. A sample of 15 companies that recently went public revealed the following information.
Company Size ($ millions), X Price per Share, Y Company Size ($ millions), X Price per Share Y
1 9.0 10.8 9 160.7 11.3
2 94.4 11.3 10 96.5 10.6
3 27.3 11.2 11 83.0 10.5
4 179.2 11.1 12 23.5 10.3
5 71.9 11.1 13 58.7 10.7
6 97.9 11.2 14 93.8 11.0
7 93.5 11.0 15 34.4 10.8
8 70.0 10.7
Determine the regression equation.
Determine the coefficient of determination. Do you think Mr. Profit should be satisfied with using the size of the offering as the independent variable?
Purchase this Solution
Solution Summary
Mr. William Profit is studying companies going public for the first time. He is particularly interested in the relationship between the size of the offering and the price per share. A sample of 15 companies that recently went public revealed the following information.
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.