Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)
8th Edition
ISBN: 9781337114172
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 14, Problem 58SE
The Dow Jones Industrial Average (DJIA) and the Standard & Poor’s 500 (S&P 500) indexes are used as measures of overall movement in the stock market. The DJIA is based on the price movements of 30 large companies; the S&P 500 is an index composed of 500 stocks. Some say the S&P 500 is a better measure of stock market performance because it is broader based. The closing price for the DJIA and the S&P 500 for 15 weeks, beginning with January 6, 2012, follow (Barron’s website, April 17, 2012).
Date | DJIA | S&P |
January 6 | 12,360 | 1278 |
January 13 | 12,422 | 1289 |
January 20 | 12,720 | 1315 |
January 27 | 12,660 | 1316 |
February 3 | 12,862 | 1345 |
February 10 | 12,801 | 1343 |
February 17 | 12,950 | 1362 |
February 24 | 12,983 | 1366 |
March 2 | 12,978 | 1370 |
March 9 | 12,922 | 1371 |
March 16 | 13,233 | 1404 |
March 23 | 13,081 | 1397 |
March 30 | 13,212 | 1408 |
April 5 | 13,060 | 1398 |
April 13 | 12,850 | 1370 |
- a. Develop a
scatter diagram with DJIA as the independent variable. - b. Develop the estimated regression equation.
- c. Test for a significant relationship. Use α = .05.
- d. Did the estimated regression equation provide a good fit? Explain.
- e. Suppose that the closing price for the DJIA is 13,500. Predict the closing price for the S&P 500.
- f. Should we be concerned that the DJIA value of 13,500 used to predict the S&P 500 value in part (e) is beyond the
range of the data used to develop the estimated regression equation?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Dave Fletcher, the general manager of North Carolina
Engineering Corporation (NCEC), thinks that his firm’s engineer-ing services contracted to highway construction firms are directly
related to the volume of highway construction business contractedwith companies in his geographic area. He wonders if this is reallyso, and if it is, can this information help him plan his operationsbetter by forecasting the quantity of his engineering servicesrequired by construction firms in each quarter of the year? Thefollowing table presents the sales of his services and total amountsof contracts for highway construction over the past eight quarters:
a) Using this data, develop a regression equation for predictingthe level of demand of NCEC’s services.
b) Determine the coefficient of correlation and the standard errorof the estimate.
2. The Dow Jones Industrial Average (DJIA) and the Standard & Poor’s 500 (S&P 500) indexes are used as measures of overall movement in the stock market. The DJIA is based on the price movements of 30 large companies; the S&P 500 is an index composed of 500 stocks. Some say the S&P 500 is a better measure of stock market performance because it is broader based. The closing price for the DJIA and the S&P 500 for 15 weeks, beginning with January 6, 2012, follow (Barron’s website, April 17, 2012).
must be solved on excel
Date
DJIA
S&P
January 6
12360
1278
January 13
12422
1289
January 20
12720
1315
January 27
12660
1316
February 3
12862
1345
February 10
12801
1343
February 17
12950
1362
February 24
12983
1366
March 2
12978
1370
March 9
12922
1371
March 16
13233
1404
March 23
13081
1397
March 30
13212
1408
April 5
13060
1398
April 13
12850…
2. The Dow Jones Industrial Average (DJIA) and the Standard & Poor’s 500 (S&P 500) indexes are used as measures of overall movement in the stock market. The DJIA is based on the price movements of 30 large companies; the S&P 500 is an index composed of 500 stocks. Some say the S&P 500 is a better measure of stock market performance because it is broader based. The closing price for the DJIA and the S&P 500 for 15 weeks, beginning with January 6, 2012, follow (Barron’s website, April 17, 2012).
must be solved on excel
Date
DJIA
S&P
January 6
12360
1278
January 13
12422
1289
January 20
12720
1315
January 27
12660
1316
February 3
12862
1345
February 10
12801
1343
February 17
12950
1362
February 24
12983
1366
March 2
12978
1370
March 9
12922
1371
March 16
13233
1404
March 23
13081
1397
March 30
13212
1408
April 5
13060
1398
April 13
12850…
Chapter 14 Solutions
Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)
Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations collected in a...Ch. 14.2 - Retail and Trade: Female Managers. The following...Ch. 14.2 - Production Line Speed and Quality Control. Brawdy...Ch. 14.2 - Prob. 6ECh. 14.2 - Sales Experience and Performance. A sales manager...Ch. 14.2 - Broker Satisfaction. The American Association of...Ch. 14.2 - Estimating Landscaping Expenditures. David’s...Ch. 14.2 - Prob. 10E
Ch. 14.2 - Laptop Ratings. To help consumers in purchasing a...Ch. 14.2 - Prob. 12ECh. 14.2 - Auditing Itemized Tax Deductions. To the Internal...Ch. 14.2 - Distance and Absenteeism. A large city hospital...Ch. 14.3 - 15. The data from exercise 1...Ch. 14.3 - Prob. 16ECh. 14.3 - The data from exercise 3 follow.
The estimated...Ch. 14.3 - Price and Quality of Headphones. The following...Ch. 14.3 - Prob. 19ECh. 14.3 - Price and Weight of Bicycles. Bicycling, the...Ch. 14.3 - Cost Estimation. An important application of...Ch. 14.3 - Prob. 22ECh. 14.5 - The data from exercise 1 follow.
Compute the mean...Ch. 14.5 - The data from exercise 2 follow.
Compute the mean...Ch. 14.5 - The data from exercise 3 follow.
What is the...Ch. 14.5 - Headphones Conclusion. In exercise 18, the data on...Ch. 14.5 - Prob. 27ECh. 14.5 - Broker Satisfaction Conclusion. In exercise 8,...Ch. 14.5 - Cost Estimation Conclusion. Refer to exercise 21,...Ch. 14.5 - Prob. 30ECh. 14.5 - Significance of Racing Bike Weight on Price. In...Ch. 14.6 - The data from exercise 1 follow. xi 1 2 3 4 5 yi 3...Ch. 14.6 - Prob. 33ECh. 14.6 - 34. The data from exercise 3...Ch. 14.6 - Prob. 35ECh. 14.6 - 36. In exercise 7, the data on y = annual sales ($...Ch. 14.6 - In exercise 13, data were given on the adjusted...Ch. 14.6 - Prob. 38ECh. 14.6 - Prob. 39ECh. 14.7 - Apartment Selling Price. The commercial division...Ch. 14.7 - Computer Maintenance. Following is a portion of...Ch. 14.7 - Annual Sales and Salesforce. A regression model...Ch. 14.7 - Prob. 43ECh. 14.7 - Auto Racing Helmet. Automobile racing,...Ch. 14.8 - Given are data for two variables, x and y. a....Ch. 14.8 - Prob. 46ECh. 14.8 - Restaurant Advertising and Revenue. Data on...Ch. 14.8 - Experience and Sales. Refer to exercise 7, where...Ch. 14.8 - Prob. 49ECh. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Predicting Charity Expenses. Charity Navigator is...Ch. 14.9 - Prob. 53ECh. 14.9 - Valuation of a Major League Baseball Team. The...Ch. 14 - 55. Does a high value of r2 imply that two...Ch. 14 - Prob. 56SECh. 14 - What is the purpose of testing whether 1 = 0? If...Ch. 14 - The Dow Jones Industrial Average (DJIA) and the...Ch. 14 - Prob. 59SECh. 14 - Prob. 60SECh. 14 - Machine Maintenance. Jensen Tire & Auto is in the...Ch. 14 - Production Rate and Quality Control. In a...Ch. 14 - Absenteeism and Location. A sociologist was hired...Ch. 14 - Bus Maintenance. The regional transit authority...Ch. 14 - Studying and Grades. A marketing professor at...Ch. 14 - Income and Percent Audited. The Transactional...Ch. 14 - Used Car Mileage and Price. The Toyota Camry is...Ch. 14 - One measure of the risk or volatility of an...Ch. 14 - As part of a study on transportation safety, the...Ch. 14 - Consumer Reports tested 166 different...Ch. 14 - When trying to decide what car to buy, real value...Ch. 14 - Buckeye Creek Amusement Park is open from the...
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
- Cholesterol Cholesterol in human blood is necessary, but too much can lead to health problems. There are three main types of cholesterol: HDL (high-density lipoproteins), LDL (low-density lipoproteins), and VLDL (very low-density lipoproteins). HDL is considered “good” cholesterol; LDL and VLDL are considered “bad” cholesterol. A standard fasting cholesterol blood test measures total cholesterol, HDL cholesterol, and triglycerides. These numbers are used to estimate LDL and VLDL, which are difficult to measure directly. Your doctor recommends that your combined LDL/VLDL cholesterol level be less than 130 milligrams per deciliter, your HDL cholesterol level be at least 60 milligrams per deciliter, and your total cholesterol level be no more than 200 milligrams per deciliter. (a) Write a system of linear inequalities for the recommended cholesterol levels. Let x represent the HDL cholesterol level, and let y represent the combined LDL VLDL cholesterol level. (b) Graph the system of inequalities from part (a). Label any vertices of the solution region. (c) Is the following set of cholesterol levels within the recommendations? Explain. LDL/VLDL: 120 milligrams per deciliter HDL: 90 milligrams per deciliter Total: 210 milligrams per deciliter (d) Give an example of cholesterol levels in which the LDL/VLDL cholesterol level is too high but the HDL cholesterol level is acceptable. (e) Another recommendation is that the ratio of total cholesterol to HDL cholesterol be less than 4 (that is, less than 4 to 1). Identify a point in the solution region from part (b) that meets this recommendation, and explain why it meets the recommendation.arrow_forwardConsider a business owner, how would you use methodology and the data results to increase sales or improve overall profitability? What are some of your recommendations?arrow_forwardHow will marketers change their social media use in the near future? A survey by Social Media Examiner reported that 77% of B2B marketers (marketers that focus primarily on attracting businesses) plan to increase their use of LinkedIn, as compared to 54% of B2C marketers (marketers that primarily target consumers). The survey was based on 1,184 B2B marketers and 1,703 B2C marketers. The following table summarizes the results: Give an example of a simple Give an example of a joint What is the complement of a marketer who plans to increase use of LinkedIn? Why is a marketer who plans to increase use of LinkedIn and is a B2C marketer a joint event?arrow_forward
- Does the proportion of Democrats who support Medicare for all appear to be substantially different than the 70% rate foir the general population? If so, why do you think that is?arrow_forwardWhat is the stock market? How do you explain its significance to an economy?. The focus of your researched response should be within the Barbados context.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Introduction to Statistical Quality Control (SQC); Author: FORSEdu;https://www.youtube.com/watch?v=c18FKHUDZv8;License: Standard YouTube License, CC-BY
[DAXX] Introduction to Statistical Quality Control; Author: The Academician;https://www.youtube.com/watch?v=ypZGDxjSM60;License: Standard Youtube License