Loose Leaf for Statistical Techniques in Business and Economics
17th Edition
ISBN: 9781260152647
Author: Douglas A. Lind
Publisher: McGraw-Hill Education
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…
Use the International Stock Market database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict the Nikkei by the DJIA, the Nasdaq, the S&P 500, the Hang Seng, the FTSE 100, and the IPC. Assume a 1% level of significance.
What percent of residuals are within 1 standard error? Write your answer as a number rounded to 1 decimal place. Do not include the % sign in your answer
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
2554.66
8-Aug
11543.55
2367.52
1282.83
121.78
2929.61
10569.58
2700.02
8-Jul
11378.02
2325.55
1267.38
127.03…
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.
Chapter 14 Solutions
Loose Leaf for 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 - Prob. 33DACh. 14 - Prob. 34DACh. 14 - Prob. 35DACh. 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_forwardUse 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…arrow_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_forward
- a. PLease Determine the explanatory and response variables from the table. b. What is the equation of the regression line and what is the meaning of the slope regression line in this context? c. What is the predicted income for someone who has 3 years of work experience?arrow_forwardUse 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…arrow_forwardSuppose you wanted to test whether or not the payoff to an additional year of education was the same for men and women in the STEM majors. How would you set up your regression analysis in this casearrow_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_forwardWhich statement below is correct? Select one: A. The value of a correlation between X and Y is reported by a researcher to be r = -0.5, it indicates that the X variable explains 25% of the variability in the Y variable in a univariate regression. B. QQ plot can be used to judge whether there is an outlier effect in the regression. C. Capital asset pricing theory asserts that individual stock returns are best explained by multiple factors. D. You are running a regression of Y on X, if you scale Y and X by dividing them by 100, it will have no effect on intercept and coefficient of X.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