Basic Business Statistics, Student Value Edition
14th Edition
ISBN: 9780134685113
Author: Mark L. Berenson, David M. Levine, David F. Stephan, Kathryn Szabat
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14, Problem 11PS
A financial analyst engaged in business valuation obtained financial data on 60 drug companies (industry Group SIC 3 code: 283). The file BusinessValuation contains the following variables:
Company-Drug Company name
PB fye-Price-to-book-value ratio (fiscal year ending)
ROE-Return on equity
SGrowth-Growth (GS5)
a. Develop a regression model to predict price-to-book-value based on return on equity.
b. Develop a regression model to predict price-to-book-value based on growth.
c. Develop a regression model to predict price-to-book-value based on return on equity and
growth.
d. Compute and interpret the adjusted
e. Which of these three models do you think is the best predictor of price-to-book value ratio?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Use the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to perform a forward selection regression analysis. Assume a 5% level of significance. Which independent variables are in the final model? Select all that apply.
Company
Type
Total Revenues
Total Assets
Return on Equity
Earnings per Share
Average Yield
Dividends per Share
Average P/E Ratio
AFLAC
6
7251
29454
17.1
2.08
0.9
0.22
11.5
Albertson's
4
14690
5219
21.4
2.08
1.6
0.63
19
Allstate
6
20106
80918
20.1
3.56
1
0.36
10.6
Amerada Hess
7
8340
7935
0.2
0.08
1.1
0.6
698.3
American General
6
3362
80620
7.1
2.19
3
1.4
21.2
American Stores
4
19139
8536
12.2
1.01
1.4
0.34
23.5
Amoco
7
36287
32489
16.7
2.76
3.1
1.4
16.1
Arco Chemical
2
3995
4116
6.2
1.14
6.1
2.8
40.4
Ashland
7
14319
7777
9.5
3.8
2.3
1.1
12.4
Atlantic Richfield
7…
What is the regression line
Use the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to perform a forward selection regression analysis. Assume a 5% level of significance. Based on your final model, what is the p-value from the test of the overall model? Write your answer as a number and round to 3 decimal places.
Company
Type
Total Revenues
Total Assets
Return on Equity
Earnings per Share
Average Yield
Dividends per Share
Average P/E Ratio
AFLAC
6
7251
29454
17.1
2.08
0.9
0.22
11.5
Albertson's
4
14690
5219
21.4
2.08
1.6
0.63
19
Allstate
6
20106
80918
20.1
3.56
1
0.36
10.6
Amerada Hess
7
8340
7935
0.2
0.08
1.1
0.6
698.3
American General
6
3362
80620
7.1
2.19
3
1.4
21.2
American Stores
4
19139
8536
12.2
1.01
1.4
0.34
23.5
Amoco
7
36287
32489
16.7
2.76
3.1
1.4
16.1
Arco Chemical
2
3995
4116
6.2
1.14
6.1
2.8
40.4…
Chapter 14 Solutions
Basic Business Statistics, Student Value Edition
Ch. 14 - For this problem, use the following multiple...Ch. 14 - For this problem, use the following multiple...Ch. 14 - A nonprofit analyst seeks to determine which...Ch. 14 - Profitability remains a challenge for banks and...Ch. 14 - The production of wine is a multibillion-dollar...Ch. 14 - Human resource managers face the business problem...Ch. 14 - Prob. 7PSCh. 14 - Prob. 8PSCh. 14 - The following ANOVA summary table is for a...Ch. 14 - The following ANOVA summary table is for a...
Ch. 14 - A financial analyst engaged in business valuation...Ch. 14 - In Problem 14.3 on page 541, you predicted...Ch. 14 - In Problem 14.5 on page 542, you used the...Ch. 14 - In Problem 14.4 on page 541, you used efficiency...Ch. 14 - In Problem 14.7 on page 542, you used the weekly...Ch. 14 - Prob. 16PSCh. 14 - Prob. 17PSCh. 14 - Prob. 18PSCh. 14 - In Problem 14.5 on page 542, you used the...Ch. 14 - Prob. 20PSCh. 14 - Prob. 21PSCh. 14 - Prob. 22PSCh. 14 - Prob. 23PSCh. 14 - Prob. 24PSCh. 14 - In Problem 14.3 on page 541, you predicted...Ch. 14 - In Problem on page 541, you used efficiency ratio...Ch. 14 - Prob. 27PSCh. 14 - In Problem 14.6 on page 542, you used full-time...Ch. 14 - Prob. 29PSCh. 14 - Prob. 30PSCh. 14 - The following is the ANOVA summary table for a...Ch. 14 - The following is the ANOVA summary table for a...Ch. 14 - In Problem 14.5 on page 542, you used alcohol...Ch. 14 - In Problem 14.4 on page 541, you used efficiency...Ch. 14 - Prob. 35PSCh. 14 - In Problem 14.6 on page 542, you used full-time...Ch. 14 - Prob. 37PSCh. 14 - Suppose X1 is a numerical variable and X2 is a...Ch. 14 - The chair of the accounting department plans to...Ch. 14 - A real estate association in a suburban community...Ch. 14 - In Problem 14.5 on page 542, you developed a...Ch. 14 - In mining engineering, holes are often drilled...Ch. 14 - The owner of a moving company typically has his...Ch. 14 - Prob. 44PSCh. 14 - Zagat’s publishes restaurant rating for various...Ch. 14 - In Problem 14.6 on page 542, you used full-time...Ch. 14 - In Problem 14.5 on page 542, the percentage of...Ch. 14 - Prob. 48PSCh. 14 - The director of a training program for a large...Ch. 14 - Prob. 50PSCh. 14 - Prob. 51PSCh. 14 - Prob. 52PSCh. 14 - Prob. 53PSCh. 14 - Prob. 54PSCh. 14 - Prob. 55PSCh. 14 - Prob. 56PSCh. 14 - Prob. 57PSCh. 14 - An automotive insurance company wants to predict...Ch. 14 - A marketing manager wants to predict customer with...Ch. 14 - A local supermarket manager wants to use two...Ch. 14 - Prob. 61PSCh. 14 - Prob. 62PSCh. 14 - Prob. 63PSCh. 14 - Prob. 64PSCh. 14 - Prob. 65PSCh. 14 - Prob. 66PSCh. 14 - Prob. 67PSCh. 14 - Prob. 68PSCh. 14 - Prob. 69PSCh. 14 - Prob. 70PSCh. 14 - Prob. 71PSCh. 14 - The owner of a moving company typically has his...Ch. 14 - Professional basketball has truly become a sport...Ch. 14 - A sample of 61 house recently listed for sale in...Ch. 14 - Measuring the height of a California redwood tree...Ch. 14 - A sample of 61 houses recently listed for sale in...Ch. 14 - Prob. 77PSCh. 14 - Referring to Problem 14.77, Suppose that an...Ch. 14 - Prob. 79PSCh. 14 - Prob. 80PSCh. 14 - Prob. 81PSCh. 14 - Prob. 82PSCh. 14 - Prob. 83PS
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Use the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to perform a forward selection regression analysis. Assume a 5% level of significance. Identify observation 2 in the original dataset. Use the observed values from observation 2 to find the predicted value y-hat based on your final model selected. Write your answer as a number and round your final answer to a whole number. Company Type Total Revenues Total Assets Return on Equity Earnings per Share Average Yield Dividends per Share Average P/E Ratio AFLAC 6 7251 29454 17.1 2.08 0.9 0.22 11.5 Albertson's 4 14690 5219 21.4 2.08 1.6 0.63 19 Allstate 6 20106 80918 20.1 3.56 1 0.36 10.6 Amerada Hess 7 8340 7935 0.2 0.08 1.1 0.6 698.3 American General 6 3362 80620 7.1 2.19 3 1.4 21.2 American Stores 4 19139 8536 12.2 1.01 1.4 0.34 23.5…arrow_forwardDescribe the five-step process used to calculate the variance in the rate of return for an investmentarrow_forwardIdentify six problems that can arise in data collection for a regression analysis.arrow_forward
- Explain what a dummy variable is and how it is used in regression analysisarrow_forwardPlot the relationship between overhead costs and labor-hours. Draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line.arrow_forwardDefine a qualitative regression model for a survey question where four gender options have been mentioned - Male, Female, Neither Male/Female, Don't want to disclose. Define baseline of this model.arrow_forward
- Explain the process of Computing the Regression Line?arrow_forwardThe R-squared of a regression of an asset’s excess returns against a multi-factor asset pricing model indicates the proportion of the asset’s total volatility that is non-systematic. True Falsearrow_forwardCan we use "OLS Regression Model" as a method to examine the relationship of Education and Income Inequality? How?arrow_forward
- Calculate range and its co-efficient from the following statistical data: Profits ( $ in 000's) 125, 50, 30, 20, 80, 85, 90, 160, 180, 100, 170, 185, 155, 200, 140, 145.arrow_forwardWhat are some examples of ways in which linear regression to create a beneficial statistical outcome, in a business setting?arrow_forwardCreate a descriptive summary of the Revenue variable of the data.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY