Question: 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

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 strong is the model? Note the residuals.

Compute a Durbin-Watson statistic from the data and discuss the presence of auto correlation in thismodel.

SUMMARY OUTPUT Regression Statistics Multiple F R Square Adjusted R Square Standard Error Observations 0.529 8179.84 ANOVA Significance df 0.0351 1 364069877.4 364069877.4 5.44 14 936737379.6 15 1300807257 Residual 66909812.8 Coefficients 75532.43621 0.01574 Standard Error 4980.08791 0.00675 t Stat Pvalue 15.17 0.0000 2.33 0.0351 Intercept Year RESIDUAL OUTPUT Predicted Bus. Bankruptcies Observation Residuals -1338.6 -8588.3 -7050.6 1115.0 12772.3 14712.8 -3029.4 -2599.1 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 9747.3 9288.8 10 10875.4 -9808.0 -4277.7 -256.8 13 16

Step by Step Solution

★★★★★

3.40 Rating (159 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)

243-M-S-L-R (509).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

AP4: Queuing OPS 3880 You need coffee and FAST! You happen to be at the coffee shop in Target at the Sawgrass mall. You are buying your groceries, but can see the smiling people with their coffee and...

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...

The USA Today type graph on the following page is based on data from the Department of Agriculture. It represents the percentage of income a middle-income family will spend on their children. (a) 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...

Shown below is the Excel output for a regression analysis to predict the number of business bankruptcy fi lings over a 16-year period by the number of consumer bankruptcy fi lings. How strong is the...

SpendRat Age 11.83 16.83 11.38 31.33 1.9 84.13 2.15 38 136.28 61.46 2.73 5.86 113 8.4 31.67 19 70.85 20.17 0.59 19.48 86.2 25.46 76.82 0.77 335.94 18.78 205.07 216.57 77.21 0.26 92.53 46.55 6.86...

The Darden Global Supply Chain please read and answer the following questions. 1. Describe how Darden Restaurants achieves competitive advantage with their supply chains. 2. What are the primary...

Hello This is regarding BUS5440. I need help with the following discussion questions and I need the answer in next 2 hrs as I have a deadline today, *********************************** Share your...

ACC353 ? Fall 2015 Excel Homework ? Linear Regression (30 points) Use the spreadsheet data provided for US Airways. The Excel file is posted on Moodle in the Regression Assignment folder. Select one...

Hello This is related to Course BUS5440. I need help with the following project:- OCS Project 1) These are the instructions given in my class to do this project:- The OCS project requires you to...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

Select a public (i.e. one that publishes its financial information) manufacturing company and become familiar with its products. Describe the company, its products, and the specific manufacturing...

Consider the following statements made about EBCT Model 1. (a) e represents the 'true' risk premium for a given risk. (b) The variance of X; doesn't depend on 6. (c) None of the random variables or...

In order to be valid and enforceable, a Negotiable Instrument ( UCC Article Three ) SELECT the correct answer: 1 ) Be signed by the payee 2 ) Contain a promise to pay, which may be conditional 3 )...

Draw the shear and moment diagrams of the given load diagram. Find the maximum shear force and maximum bending moment of the beam. Please easy to read. 50 KN 5 KN/m 2.00 2.00 2.00 A D

Joanna is looking at her business numbers and making a plan for next year. She feels like her sales margins are too small, but drastic price increases may severely impact her sales volume. Sales...

Part 1 Translate the following sentences into symbolic form using capital letters to represent affirmative statements. All examples are from Hurley, pp 319-322. [If you do not have the dot, use...

Part 1 Using information from this weeks lesson and last weeks Rules for Translating Ordinary Language, translate the following sentences into symbolic form using capital letters to represent...

2) Starting from rest, a block of mass m slides down a = 23 ramp. The coefficient of kinetic friction between the block and the ramp is u= 0.1. How fast is the block moving when it reaches the...

4. Explain niche marketing.

Downtime in virtually any business can be costly. In a manufacturing setting, it means less product produced in a given time period while still having to pay the bills. This might mean late...

The American Water Works Association reports that, on average, men use between 40 L and 60 L of water daily to shave when they leave the water running. Suppose the following data are the numbers of...

A local company installs natural-gas barbecues. As part of the installation, a ditch is dug to lay a small natural-gas line from the barbecue to the main line. On average, the depth of these lines...

The following information should be used for Question 36 until 39: Net Income $50,000 Provision for bad debts 2,000 Increase in inventory 1,000 Increase in account payable 2,000 Purchase new...

67 Which of the following tangible non-current assets are not usually depreciated? (1 Point) Machinery purchased through a finance lease Land Buildings with a life in excess of 30 years Vehicles

Moerdyk Company's stock has a beta of 1 . 5 , the risk - free rate ( rRFR ) is 4 % , and the market risk premium ( rM - rRFR ) is 9 % . What is the firm's required rate of return?