Chapter 12, Problem 12.49AC

What is regression analysis? Describe the process of performing regression analysis on a graphing utility.

Cable TV The following table shows the number C. in millions, of basic subscribers to cable TV in the indicated year These data are from the Statistical Abstract of the United States. Year 1975 1980 1985 1990 1995 2000 C 9.8 17.5 35.4 50.5 60.6 60.6 a. Use regression to find a logistic model for these data. b. By what annual percentage would you expect the number of cable subscribers to grow in the absence of limiting factors? c. The estimated number of subscribers in 2005 was 65.3million. What light does this shed on the model you found in part a?

The U.S. Postal Service is attempting to reduce the number of complaints made by the public against its workers. To facilitate this task, a staff analyst for the service regresses the number of complaints lodged against an employee last year on the hourly wage of the employee for the year.  The analyst ran a simple linear regression in SPSS.  The results are shown below.   The current minimum wage is $5.15. If an employee earns the minimum wage, how many complaints can that employee expect to receive? Is the regression coefficient statistically significant? How can you tell?

Stock Beta. In June 2021 Yahoo Finance reported the beta value for Coca-Cola was .61 (Yahoo Finance website). Betas for individual stocks are determined by simple linear regression. The dependent variable is the total return for the stock, and the independent variable is the total return for the stock market, such as the return of the S&P 500. The slope of this regression equation is referred to as the stock's beta. Many financial analysts prefer to measure the risk of a stock by computing the stock's beta value. The data show the monthly percentage returns for the S&P 500 and the Coca-Cola Company for July 2020 to June 2021. Answer the following questions. 1. Develop a scatter diagram with the S&P % Return as the independent variable. Label this graph as "Scatterplot Coke vs S&P" 2. What does the scatter diagram developed in part (1) indicate about the relationship between the returns of the S&P 500 and those of the Coca-Cola Company? State your answer here 3. Develop the least…

A financial website reported the beta value for a certain company was 0.86. Betas for individual stocks are determined by simple linear regression. The dependent variable is the total return for the stock, and the independent variable is the total return for the stock market, such as the return of a market index. The slope of this regression equation is referred to as the stock's beta. Many financial analysts prefer to measure the risk of a stock by computing the stock's beta value.   Suppose the following data show the monthly percentage returns for the market index and the company for a recent year. Month Market Index% Return Company% Return August -3 4 September 8 7 October 0 1 November -2 1 December -5 0 January 0 0 February 7 7 March 0 -2 April 2 0 May -5 -1 a. Develop the least squares estimated regression equation. (Let x = Market Index % Return (as a %), and let y = Company % Return (as a %). Round your numerical values to four decimal places.)

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 develop the multiple linear regression model.  Assume a 5% level of significance.   Which independent variable is the strongest predictor of the average P/E ratio of a company?     A. Total Revenues B. Average Yield C. Earnings Per Share D.Return on Equity E. Total Assets F.Dividends Per Share   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…

A marketing consultant created a linear regression model to predict the number of units sold by a client based on the amount of money spent on marketing by the client. Which of the following is the best graphic to use to evaluate the appropriateness of the model?

According to human capital theory, a person’s earning is linked to her level of education – there is a relationship between workers income and years of education. Using data from the Labour Force Survey, a researcher found the following regression results for earnings on intercept, years of education, experience, and experience squared:                         Earnings =    5.24  +  0.035 educ + 0.165 exper – 0.003 exper2                                            (2.45)      (0.012)                 (0.031)               (0.001)      Construct a 95% confidence interval for the effect of years of education on earnings  ?                                                                                                                                                                           2. Consider an individual with 8 years of experience. What would you expect to be the return to two (2) additional years of experience (the effect on earnings)?    3. According to economic theory,…

The following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers):   A.What would be the typical linear regression equation for the number of sales?    B.Make the sales forecast for period 15 of next year.    C. Make the sales forecast for period 17 of next year.      D. What is the standard error for the data?