Question: Shown below is the Excel output for a regression analysis to predict the number of business bankruptcy filings over a 16-year period by the number

Shown below is the Excel output for a regression analysis to predict the number of business bankruptcy filings over a 16-year period by the number of consumer bankruptcy filings. How strong is the model? Note the residuals. Compute a Durbin-Watson statistic from the data and discuss the presence of autocorrelation in thismodel.

SUMMARY OUTPUT Regression Statistics Multiple F R Square Adjusted R Square Standard Error Observations 0.529 0.280 0.228 8179.84 ANOVA Significance MS 364069877.4 66909812.8 df 1 364069877.4 14 936737379.6 1300807257 0.0351 Regression Residual Total 5.44 15 Coefficients 75532.43621 -0.01574 Standard Error 4980.08791 0.00675 t Stat P-value 15.17 0.0000 2.33 0.0351 Intercept Year RESIDUAL OUTPUT Predicted Bus Bankruptcies Observation Residuals 70638.58 71024.28 71054.61 70161.99 68462.72 67733.25 66882.45 65834.05 64230.61 61801.70 61354.16 62738.76 63249.36 61767.01 57826.69 54283.80 -1338.6 8588.3 7050.6 1115.0 12772.3 14712.8 -3029.4 2599.1 622.4 9747.3 9288.8 -434.8 4 6 8 12 13 14 15 -10875.4 9808.0 -4277.7 256.8

Step by Step Solution

★★★★★

3.41 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The model is Bankruptcies 75532436 0016 Year Since R 2 28 and the adjusted R 2 23 this is a weak mod... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

409-M-S-L-R (1313).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Shown on the following page is the Excel output for a regression analysis to predict the number of business bankruptcy filings over a 16-year period by the number of consumer bankruptcy filings. How...

In Exercise 9.19, we give computer output for a regression line to predict the number of Facebook friends a student will have, based on a normalized score of the grey matter density in the areas of...

The Bhaskara Corporation used regression analysis to predict the annual cost of indirect materials. The results were as follows: Intercept coefficient Standard error of Y estimate 2 Number of...

#6 Business Statistics with Computer Applications II Problems from book: Chapter 12 (page 523) 12.62, 12.63, 12.65-12.69 Problems not in book: Casting aluminum. In casting metal parts, molten metal...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

Ex 11-2... question is attached... Exercise 11-22 Break-even sales and sales mix for a service company Yellow Dove Airways provides air transportation services between Portland and Minneapolis. A...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Sendelbach Corporation is a U.S.-based organization with operations throughout the world. One of its subsidiaries is headquartered in Toronto. Although this wholly owned company operates primarily in...

(0.512, 0.596) Use the confidence interval to find the margin of error and the sample proportion.

List and explain the factors we typically hold constant when drawing a demand curve. What additional factors do you think could be added to the list?

Examples of scheduling methods include: a. activity list, bar chart, network diagram b. WBS, activities, resources, dependencies c. critical path method, critical chain method d. define activities,...

Refer to Procedure 8.1. a. Explain in detail the assumptions required for using the z-interval procedure. b. How important is the normality assumption? Explain your answer.

What is a confidence-interval estimate of a parameter? Why is such an estimate superior to a point estimate?

In each part, assume that the population standard deviation is known. Decide whether use of the z-interval procedure to obtain a confidence interval for the population mean is reasonable. Explain...

Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Guests (in thousands) Guests (in thousands) Quarter Winter Year 1 Spring Year 1 Summer Year 1 Fall Year 1 Winter...

Which of the following are legal and acceptable reasons for the high level of merger activity in the U.S. during the 1980s? a. A profitable firm acquires a firm with large accumulated tax losses that...

Beginning accounts receivable were $275,500, and ending accounts receivable were $302,300. Cash amounting to $2,965,000 was collected from customers' credit sales. Calculate the amount of sales on...