Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)
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
bartleby

Videos

Textbook Question
Book Icon
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
  1. a. Develop a scatter diagram with DJIA as the independent variable.
  2. b. Develop the estimated regression equation.
  3. c. Test for a significant relationship. Use α = .05.
  4. d. Did the estimated regression equation provide a good fit? Explain.
  5. e. Suppose that the closing price for the DJIA is 13,500. Predict the closing price for the S&P 500.
  6. 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?
Blurred answer
Students 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 - 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
Background pattern image
Statistics
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
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra
Algebra
ISBN:9781337282291
Author:Ron Larson
Publisher:Cengage Learning
Text book image
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