Question

In: Statistics and Probability

The following data gives the credibility score of certain firms based on current ratio, Debt/ Asset...

The following data gives the credibility score of certain firms based on current ratio, Debt/ Asset ratio, and
whether the firms go bankrupt or not

Firm No. Current Ratio Debt/Asset Ratio % Credibility Score Did Firm go Bankrupt earlier
1 3.4 60 0.78 N
2 3 76 0.791 Y
3 2.6 56 0.620 Y
4 2.5 68 0.757 Y
5 2.4 60 0.509 N
6 2.2 28 0.129 N
7 2.0 42 0.220 N
8 1.7 20 0.948 N
9 1.2 46 0.871 Y
10 1 28 0.391 Y

Fit a suitable regression equation predicting the credibility score.

Solve using Excel Data Analysis : Regression

Solutions

Expert Solution

sol:

code N as 0 anD Y as 1

from data analysis toolpak

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.392337
R Square 0.153928
Adjusted R Square -0.26911
Standard Error 0.315668
Observations 10
ANOVA
df SS MS F Significance F
Regression 3 0.108774 0.036258 0.363865 0.781908
Residual 6 0.597879 0.099646
Total 9 0.706652
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 0.335089 0.366704 0.913785 0.396064 -0.5622 1.232382
Current Ratio 0.036945 0.269687 0.136993 0.895518 -0.62296 0.696845
Debt/Asset Ratio % 0.002278 0.011391 0.199947 0.848127 -0.0256 0.03015
Did Firm go Bankrupt earlier 0.149991 0.292426 0.512921 0.626337 -0.56555 0.865531

regression eq is

credibilty score=   0.335088831+0.036945181*Current Ratio+0.002277606*Debt/Asset Ratio %+0.149991296*Did Firm go Bankrupt earlier


Related Solutions

Based on the following data, estimate the four firms’ concentration ratio based on the Herfindahl–Hirschman Index....
Based on the following data, estimate the four firms’ concentration ratio based on the Herfindahl–Hirschman Index. Interpret your results. 1)65, 15, 10, 10 2) 30, 30, 20, 20
Describe in 200 words Benedictine Monastery of Admont Current Ratio and Debt to Asset Ratio, please...
Describe in 200 words Benedictine Monastery of Admont Current Ratio and Debt to Asset Ratio, please type
Describe in 200 words Benedictine Monastery of Admont Current Ratio and Debt to Asset Ratio, please...
Describe in 200 words Benedictine Monastery of Admont Current Ratio and Debt to Asset Ratio, please type
Calculate the following for each of the years listed A. Debt/ Equity ratio B. Debt/asset ratio...
Calculate the following for each of the years listed A. Debt/ Equity ratio B. Debt/asset ratio C.Profit Margin (as a %) D. Gross Margin (as a %) E. Calculate the change in profit margin over each year Exhibit 1: Iggy’s Financial Statements, 1994-1999 1994 1995 1996 1997 1998 1999 Income Statement Data Net revenue 1,000,000 2,500,000 3,000,000 4,000,000 4,500,000 6,000,000 Cost of goods sold Labor Other 570,000 220,000 350,000 1,700,000 900,000 800,000 1,920,000 1,080,000 840,000 2,520,000 1,480,000 1,040,000 3,195,000 1,890,000...
Based on the following data, compute: a) Current Ratio (Industry Average is 2.4) b) Quick Ratio...
Based on the following data, compute: a) Current Ratio (Industry Average is 2.4) b) Quick Ratio (Industry Average is 1.5) c) Inventory Turnover (Industry Average is 100 days) d) Accounts Receivable Turnover (Industry Average is 59 days) e) Earnings Per Share (Industry Average is $2) f) Price-Earnings Ratio (Industry Average is 5) Data: Cash = $91,000 A/R = $45,000 A/P = $99,000 Supplies = $1000 Equipment = $400,000 Wages Payable = $6000 Inventory = $110,000 Net Credit Sales = $600,000\...
1. Determine the missing values based on the provided information: Current Ratio = 4.8571429 Debt Ratio...
1. Determine the missing values based on the provided information: Current Ratio = 4.8571429 Debt Ratio = 0.3306836248 Asset Turnover = 1.3879173291 Gross Profit Margin = 64% Net Profit Margin = 20% Inventory Turnover = 6.5475  A/R Turnover = 10.9125 Total Assets = $629,000 Long-term Debt = $180,000 Common Shares = $41,000 Cash =      A/R =      Inventory =     PP&E =      A/P =      R/E =      Sales =      COGS =      SG&A =      Net Income =     Assume that there are no other...
Which of the following best describes the current ratio? debt ratio operating performance ratio liquidity ratio...
Which of the following best describes the current ratio? debt ratio operating performance ratio liquidity ratio efficiency ratio
Calculate your net worth and your debt ratio, current ratio, liquidity ratio, debt payment ratio, and...
Calculate your net worth and your debt ratio, current ratio, liquidity ratio, debt payment ratio, and inflows and outflows, do you have a shortage or surplus. Current Value of your home $330,000 Monthly gas $300.00 Balance of car loan $27,000 Monthly utilities $500.00 Balance of student loans $29,000 Monthly groceries $1100.00 Value of car $40,000 Monthly meals out $400.00 Balance of Mortgage $200,000 Monthly cable/internet $150.00 Household contents $19,000 Monthly cell phone $275.00 Stock portfolio 194,000 Monthly Miscellaneous $75.00 Balance...
Chitown has $20 million in assets. it is considering a 50 -percent debt/asset ratio vs.its current...
Chitown has $20 million in assets. it is considering a 50 -percent debt/asset ratio vs.its current 20% debt/asset ratio. Debt carries interest charges of 12 percent and shares sell for $20 per share. A. What is the number of shares under each plan? B. assuming a 40 - percent tax rate, find the level of EBIT at which both plans will have the same EPS?
A company has a debt-to-equity ratio of 0.62, an asset turnover ratio of 1.39, and a...
A company has a debt-to-equity ratio of 0.62, an asset turnover ratio of 1.39, and a profit margin of 7.8%. The total equity is $ 672,100. What is the amount of net profit?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT