Concept explainers
Financial analysts engage in business valuation to determine a company’s value. A standard approach uses the multiple of earnings method. You multiply a company’s profits by a certain value (average of median) to arrive at a final value. More recently,
COMPANY-Drug company name
TS-Ticker symbol
SIC3-Standard industrial Classification 3 codes (industry group identifier)
SIC4-Standard industrial Classification 4 codes (industry identifier)
PB fye-Price-to-book value ratio (fiscal year ending)
PB fye-price-to-earning ratio (fiscal year ending)
NL Assets-Natural log pf assets (as a measure of size)
ROE-Return on equity
SGROWTH-Growth (GS5)
DEBT/EBITDA-Ratio of debt to earnings before interest, taxes depreciation, and amortization
D2834-Dummy variable indicator of SIC 4 code 2534 (1 if 2834, 0 if not)
D2835-Dummy variable indicator of SIC 4 code 2835 (1 if 2835,0 if not)
Develop the most appropriate multiple regression model to predict the price-to-book value ratio. Perform a through residual analysis and provide a detailed explanation of your results.
Want to see the full answer?
Check out a sample textbook solutionChapter 15 Solutions
Basic Business Statistics, Student Value Edition
- What is regression analysis? Describe the process of performing regression analysis on a graphing utility.arrow_forwardWhat does it mean for a regression line to be the "best-fit" line.arrow_forwardShow that the regression line that runs through the standardized data values has the formarrow_forward
- A business statistics professor would like to develop a regression model to predict the final exam scores for students based on their current GPAs, the number of hours they studied for the exam, the number of times they were absent during the semester, and their genders. The data for these variables are given in the accompanying table at the bottom of this page. a) Using Excel, construct a regression model using all of the independent variables. Create the dummy variable Gen, which equals 1 for a male and 0 for a female student ( this assignment is arbitrary) complete the regression equation for the model below, where y= Score, x1= GPA, x2= Hours, x3= Absenses, and x4= Gen. y= (__) + (__)x1 + (__)x2 + (__)x3 + (__)x4 b) Test the significance of the overall regression model using a= 0.10. c) interpret the meaning of the regression coefficient for the dummy variable. d) using the p-values, identify which independent variables are significant with a= 0.10. e) construct a regression…arrow_forwardAs large U.S. companies flattened their management hierarchies during the 1990s, many of the middle managers who were laid off gave up on “corporate life” and started their own companies or bought franchise operations. This talent migration, along with the fact that most new jobs in the United States were being created by small businesses, cast entrepreneurism into the national spotlight. The business listed in the table were among the fastest growing in the franchise industry. instuction: Propose a regression model that will enable you to compare the mean number of new franchises for the four types of franchises (food, cleaning, accounting/consulting, hospitality) Provide a clear definition for the variables (dependent and independents) being used in the model.arrow_forwardA rural state wants to encourage high school graduates to continue their education and attend college. The state collected information on a random sample of high school seniors from across the state 7 years ago and is now observing how many years of education they completed. They believe students decide to achieve more education when they are more capable, have easier access to college education, and the opportunity cost of attending are lower. To explore the factors that affect the years of education completed they have used multiple regression to estimate the years of completed education as a function of: Unemployment rate - the unemployment rate in the county (3.9 – 16.8) County Hr Wage - average starting hourly manufacturing wage in the county Test - student score on college admission test (0 to 100 scale) Dist to college - Distance to near college (measured in 100’s of miles) Tuition - Tuition charged at nearest state university (measured in $1000s)…arrow_forward
- A rural state wants to encourage high school graduates to continue their education and attend college. The state collected information on a random sample of high school seniors from across the state 7 years ago and is now observing how many years of education they completed. They believe students decide to achieve more education when they are more capable, have easier access to college education, and the opportunity cost of attending are lower. To explore the factors that affect the years of education completed they have used multiple regression to estimate the years of completed education as a function of: Unemployment rate - the unemployment rate in the county (3.9 – 16.8) County Hr Wage - average starting hourly manufacturing wage in the county Test - student score on college admission test (0 to 100 scale) Dist to college - Distance to near college (measured in 100’s of miles) Tuition - Tuition charged at nearest state university (measured in $1000s)…arrow_forwardA rural state wants to encourage high school graduates to continue their education and attend college. The state collected information on a random sample of high school seniors from across the state 7 years ago and is now observing how many years of education they completed. They believe students decide to achieve more education when they are more capable, have easier access to college education, and the opportunity cost of attending are lower. To explore the factors that affect the years of education completed they have used multiple regression to estimate the years of completed education as a function of: Unemployment rate - the unemployment rate in the county (3.9 – 16.8) County Hr Wage - average starting hourly manufacturing wage in the county Test - student score on college admission test (0 to 100 scale) Dist to college - Distance to near college (measured in 100’s of miles) Tuition - Tuition charged at nearest state university (measured in $1000s)…arrow_forwardJensen, Solberg, and Zorn investigated the relationship of insider ownership, debt, and dividend policies in companies. One of their findings was that firms with high insider ownership choose lower levels of both debt and dividends. Shown here is a sample of data of these three variables for 11 different industries. Use the data to develop the equation of the regression model to predict insider ownership by debt ratio and dividend payout. Comment on the regression coefficients.arrow_forward
- A study in the univeristy of massachusetts amherst published in the may 2007 journal of marriage and family found that married women do about one fewer hour of housework a week for every $7500 they earn as a full time workers outside of the home, regardless of their husband's income A) what would be the numerical value of the slope coefficient in the regression model that predicts womens housework hours from their income? what does the sign of the slope (positive or negative) tell us about the relationship between these variables B) Suppose Lynette's salary is $30,000 greater than Gabriells. what would you predict the difference in hours of housework they each do.arrow_forwardWhat is A REGRESSION LINE?arrow_forwardWhen should a regression model not be used to make a prediction?arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt