Statistical Techniques in Business and Economics
16th Edition
ISBN: 9780077639723
Author: Lind
Publisher: Mcgraw-Hill Course Content Delivery
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 14, Problem 31CE
a.
To determine
Perform a global test of hypothesis to verify if any of the regression coefficients are different from zero.
b.
To determine
Perform individual test for each of the variables.
Explain whether any of the variables can be deleted.
c.
To determine
Revise the regression equation.
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 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…
Jensen, 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.
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
Statistical Techniques in Business and Economics
Ch. 14 - There are many restaurants in northeastern South...Ch. 14 - The director of marketing at Reeves Wholesale...Ch. 14 - Thompson Photo Works purchased several new, highly...Ch. 14 - A consulting group was hired by the Human...Ch. 14 - Cellulon, a manufacturer of home insulation, wants...Ch. 14 - Refer to Self-Review 141 on the subject of...Ch. 14 - Prob. 5ECh. 14 - Prob. 6ECh. 14 - Prob. 3SRCh. 14 - Given the following regression output, answer the...
Ch. 14 - The following regression output was obtained from...Ch. 14 - A study by the American Realtors Association...Ch. 14 - The manager of High Point Sofa and Chair, a large...Ch. 14 - Prob. 10ECh. 14 - Prob. 11ECh. 14 - A real estate developer wishes to study the...Ch. 14 - Prob. 13CECh. 14 - Prob. 14CECh. 14 - Prob. 15CECh. 14 - Prob. 16CECh. 14 - The district manager of Jasons, a large discount...Ch. 14 - Suppose that the sales manager of a large...Ch. 14 - The administrator of a new paralegal program at...Ch. 14 - Prob. 20CECh. 14 - Prob. 21CECh. 14 - A regional planner is studying the demographics of...Ch. 14 - Great Plains Distributors, Inc. sells roofing and...Ch. 14 - Prob. 24CECh. 14 - Prob. 25CECh. 14 - Prob. 26CECh. 14 - An investment advisor is studying the relationship...Ch. 14 - Prob. 28CECh. 14 - Prob. 29CECh. 14 - The director of special events for Sun City...Ch. 14 - Prob. 31CECh. 14 - Prob. 32CECh. 14 - Refer to the Real Estate data, which report...Ch. 14 - Prob. 34DECh. 14 - Refer to the Buena School District bus data....Ch. 14 - Prob. 1PCh. 14 - Quick-print firms in a large downtown business...Ch. 14 - The following ANOVA output is given. a. Compute...Ch. 14 - Prob. 1CCh. 14 - Prob. 2CCh. 14 - Prob. 3CCh. 14 - In a scatter diagram, the dependent variable is...Ch. 14 - What level of measurement is required to compute...Ch. 14 - If there is no correlation between two variables,...Ch. 14 - Which of the following values indicates the...Ch. 14 - Under what conditions will the coefficient of...Ch. 14 - Given the following regression equation, = 7 ...Ch. 14 - Given the following regression equation, = 7 ...Ch. 14 - Given the following regression equation, = 7 ...Ch. 14 - Prob. 1.9PTCh. 14 - In a multiple regression equation, what is the...Ch. 14 - Prob. 1.11PTCh. 14 - Prob. 1.12PTCh. 14 - For a dummy variable, such as gender, how many...Ch. 14 - What is the term given to a table that shows all...Ch. 14 - If there is a linear relationship between the...Ch. 14 - Given the following regression analysis output: a....Ch. 14 - Given the following regression analysis output. a....
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardThe Transactional Records Access Clearinghouse at Syracuse University reported data showing the odds of an Internal Revenue Service audit. The following table shows the average adjusted gross income reported and the percent of the returns that were audited for 20 selected IRS districts. Develop the estimated regression equation that could be used to predict the percent audited given the average adjusted gross income reported. At the .05 level of significance, determine whether the adjusted gross income and the percent audited are related. Did the estimated regression equation provide a good fit? District Adjusted Gross Income ($) Percent Audited Los Angeles 36,664 1.3 Sacramento 38,845 1.1 Atlanta 34,886 1.1 Boise 32,512 1.1 Dallas 34,531 1.0 Providence 35,995 1.0 San Jose 37,799 0.9 Cheyenne 33,876 0.9 Fargo 30,513 0.9 New Orleans 30,174 0.9 Oklahoma City 30,060 0.8 Houston 37,153…arrow_forwardWhich of the following will help to mitigate confounding? A. Multiple regression modelB. RandomizationC. StratificationD. All of the abovearrow_forward
- Management at Jagoda Wholesalers, in Calgary, Canada, has used time-series regression based on point-of-sale data to forecast sales for the next 4 quarters. Sales estimates are $100,000, $120,000, $140,000, and $160,000 for the respective quarters. Seasonal indices for the four quarters have been found to be1.30, .90, .70, and 1.10, respectively.arrow_forwardYou perform a bivariate regression and note that the independent variable explains 25% of the variation in the dependent variable. The remaining 75% of variation that is left unexplained is likely due to: a. other unmeasured variables. b. measurement error. c. random chance. d. any/all of the above.arrow_forwardSuppose that you have several hypotheses to test, as follow:H1: Costumer focus has a significant positive relationship with organization performance.H2: Continuous improvement has a significant negative relationship with organization performance.H3: Employee involvement has a significant negative relationship with organization performance.H4: Top management support has a significant positive relationship with organization performance.H5: Supplier management has a significant positive relationship with organization performance.After you analyze the data using linear regression analysis, the result showed as follow: MODEL SUMMARY Model R R Square Adjusted R Square Std. Error of the Estimate 1 .674a 0.579 0.467 0.833 ANNOVA Model Sum of Squares df Mean Square F Sig. Regression 85.400 6 13.673 23.547 .000b Residual 140.500 195 .695 Total 218.500 198 a. Dependent Variable: Organization Performance b. Predictors: (Constant), Customer focus,…arrow_forward
- Connie Harris, who is in charge of office supplies at First Capital Mortgage Corp., would like to predict the quantity of paper used in the office photocopying machines per month. She believes that the number of loans originated in a month influence the volume of photocopying performed. She has compiled the following recent monthly data: Develop an estimated regression equation for this data set. Place output in cell G1 At .05 level of significance, is the equation significant? Why? Does the equation seem to have a good “fit”? Why? Forecast the amount of paper used in a month when 42 loan originations are expected. Loans Originated in Month Paper Used (000's) 45 22 25 13 50 24 60 25 40 21 25 16 35 18 40 25arrow_forwardBill wants to explore factors affecting work stress. He would like to examine the relationship between age, number of years at the workplace, perceived social support, and work stress. He collects data on the variables from 100 employees (males and females) working in banks. Conduct a multiple regression analysis to answer the following questions: What is the relationship of age, number of years, and social support with work stress? Is the regression significant? If yes, what does it indicate? What is the regression equation for all the predictors? Write a results section based on your analysis that answers the research question. * last person got this wrong*arrow_forwardA. Write the equation of the regression line. B. Interpret the slope in this context, and calculate the predicted birth weight of first borns and others C. Is there a statistically significant relationship between the average birth weight and parity? Provide an explanation with numeric support.arrow_forward
- Use the International Stock Market database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict the DJIA by the Nasdaq, the S&P 500, the Nikkei, the Hang Seng, the FTSE 100, and the IPC. What is the increase in the r-squared value from the best initial model (step 1) to the final model you’ve chosen? Write your answer as a number, round the final answer to 3 decimal places. (i.e. if r2 = 0.24135 in step 1 and r2 = 0.5255 in step 2, the increase would be 0.284) DATE DJIA NASDAQ S&P 500 NIKKEI 225 HANG SENG FTSE 100 IPC 9-Feb 8270.87 1591.56 869.89 87.63 1658.5 5774.95 1351.73 9-Jan 8000.86 1476.42 825.88 97.73 1856.39 6375.22 1616.08 8-Dec 8776.39 1577.03 903.25 89.49 1820.22 6033.18 1436.55 8-Nov 8829.04 1535.57 896.24 86.68 1850.86 7041.92 1612.58 8-Oct 9336.93 1720.95 968.75 107.68 2319.76 8780.95 2284.53 8-Sep 10850.66 2091.88 1164.74 118.69 2678.44 10077.78…arrow_forwardA marketing professor at Givens College is interested in the relationship between hoursspent studying and total points earned in a course. Data collected on 156 students whotook the course last semester are provided in the file MktHrsPts.a. Develop a scatter chart for these data. What does the scatter chart indicate about therelationship between total points earned and hours spent studying?b. Develop an estimated regression equation showing how total points earned is relatedto hours spent studying. What is the estimated regression model?c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.01level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of total point earned does the modelyou estimated in part b explain?e. Mark Sweeney spent 95 hours studying. Use the regression model you estimated inpart b to predict the total points…arrow_forwardRestaurant Digest, a famous restaurant magazine writes that the amount of tips servers get in Florida is affected by several factors including the amount of bill, number of adult diners as well as kids and the income of the diners. Use the data below to answer the following questions: Find the multiple regression model. At a level of significance of 0.03, is there a significance relationship between the amount of tip and at least one of the independent variables? What is the likely amount of tip if a group of diners spend $40.33 and had an annual income of $81,000. The diners included 4 adults and 3 kids? What percent of the variation in amount of tip is accounted for by amount of bill, annual income, number of adults and kids? Customer Amount of Tip Amount of Bill Number of adult Diners Number of kids Annual Income 1 $ 7.00 $ 48.97 5 3 100000 2 $ 4.50 $ 28.23 4 3 80000 3…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
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
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
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Mod-01 Lec-01 Discrete probability distributions (Part 1); Author: nptelhrd;https://www.youtube.com/watch?v=6x1pL9Yov1k;License: Standard YouTube License, CC-BY
Discrete Probability Distributions; Author: Learn Something;https://www.youtube.com/watch?v=m9U4UelWLFs;License: Standard YouTube License, CC-BY
Probability Distribution Functions (PMF, PDF, CDF); Author: zedstatistics;https://www.youtube.com/watch?v=YXLVjCKVP7U;License: Standard YouTube License, CC-BY
Discrete Distributions: Binomial, Poisson and Hypergeometric | Statistics for Data Science; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=lHhyy4JMigg;License: Standard Youtube License