STAT TECH IN BUSINESS & ECON AC
18th Edition
ISBN: 9781264731657
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 17E
(a)
To determine
To create: The
(b)
To determine
To calculate: The
(c)
To determine
The regression equation.
(d)
To determine
To find: The predicted value of sales.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Bloomberg Intelligence listed 50 companies to watch in 2018 (bloomberg.com/features/companies-to-watch-2018). Twelve of the companies are listed here with their total assets and 12-month sales. Let sales be the dependent variable and total assets the independent variable.
Draw a scatter plot
Compute the correlation coefficient
Determine the regression equation
For a company with $100 billion in assets, predict the 12- month sales.
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…
In this table, x represents the number of years that have passed since 1975. For example, an x-value of 10
represents the year 1985. The letter y represents the profit (or loss), in dollars, for a certain company in that
year.
Enter the data into a spreadsheet, create a scatterplot and add a trendline.
y
4
21.36
5.
23.25
22.74
23.63
8
25.52
9.
25.41
10
27.4
11
26.99
12
28.58
13
32.67
14
30.06
34.25
Use the equation of the trendline to estimate the profit in the year 1995. Round your answer to 1 place after the
decimal.
Question Help: Message instructor
Submit Question
MacBook
Chapter 13 Solutions
STAT TECH IN BUSINESS & ECON AC
Ch. 13 - Prob. 1SRCh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Bi-lo Appliance Super-Store has outlets in several...Ch. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - The owner of Maumee Ford-Volvo wants to study the...Ch. 13 - Prob. 2SRCh. 13 - Prob. 7ECh. 13 - Prob. 8E
Ch. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Prob. 3SRCh. 13 - Prob. 13ECh. 13 - Prob. 14ECh. 13 - Prob. 15ECh. 13 - Prob. 16ECh. 13 - Prob. 17ECh. 13 - Prob. 18ECh. 13 - Prob. 19ECh. 13 - Prob. 20ECh. 13 - Prob. 4SRCh. 13 - Prob. 21ECh. 13 - Prob. 22ECh. 13 - Prob. 23ECh. 13 - Prob. 24ECh. 13 - Prob. 5SRCh. 13 - Prob. 25ECh. 13 - Prob. 26ECh. 13 - Prob. 27ECh. 13 - Prob. 28ECh. 13 - Prob. 29ECh. 13 - Prob. 30ECh. 13 - Prob. 6SRCh. 13 - Prob. 31ECh. 13 - Prob. 32ECh. 13 - Prob. 33ECh. 13 - Refer to Exercise 16. a. Determine the .95...Ch. 13 - Prob. 35ECh. 13 - A regional commuter airline selected a random...Ch. 13 - Prob. 38CECh. 13 - Prob. 39CECh. 13 - Prob. 40CECh. 13 - Prob. 41CECh. 13 - Prob. 42CECh. 13 - Prob. 43CECh. 13 - Prob. 44CECh. 13 - The manufacturer of Cardio Glide exercise...Ch. 13 - Prob. 46CECh. 13 - Prob. 47CECh. 13 - Prob. 48CECh. 13 - Prob. 49CECh. 13 - Mr. William Profit is studying companies going...Ch. 13 - Prob. 51CECh. 13 - Prob. 54CECh. 13 - A regression analysis relating the current market...Ch. 13 - Prob. 56CECh. 13 - Prob. 57CECh. 13 - Prob. 58CECh. 13 - Prob. 59CECh. 13 - Prob. 60CECh. 13 - TravelAir.com samples domestic airline flights to...Ch. 13 - The North Valley Real Estate data reports...Ch. 13 - Prob. 64DA
Knowledge Booster
Recommended textbooks for you
- 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 HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- 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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning