Hello! hope all is well. Please I need your help with a project, specifically question 10 below.

I'm going to attach below a screenshot of the data needed to solve the questions

Context for project : As a team of consultants, you are tasked with analyzing 25 American depository institutions in order to better understand their characteristics. A depository institution is a bank, or institution that holds securities and assists in the trading of securities. A depository institution provides security and liquidity in the market, uses money deposited for safekeeping to lend to others, invests in other securities, and offers a funds transfer system. A depository must return the deposit in the same condition upon request.

Question 10:

a)Construct a multiple regression equation that describes the relationship (if any!) between the variable in columns C, I, M, O, and AB (make AB the dependent / Y variable). (please show equation in answer)

b) Are any of the variables significant at the 5% level? 1%? What is your proof? (please show proof)

c) Why do you think those variables are significant - clearly discuss your thesis!

d)Re-write the equation given your findings regarding significant and insignificant variables then use the average values of each independent variables and calculate a predicted value for dependent variable. (please show equation, all the numbers and calculations)

Here's the data, screenshot might be to small, so here's a link to this excel sheet :

https://docs.google.com/spreadsheets/d/163Mgd14jtmmw9rbXFBZX07sH5iH8lQAt/edit?usp=share_link&ouid=115422576723711698035&rtpof=true&sd=tru

Wholesale Unrealized Gains Loan Loss Tangible Equity/ Liquid Assets/ Loans/ Deposits Leverage Ratio Total Debt/ Total Liquid Assets/ Held to Maturity Total Securities Unrealized Gains Funding Ratio / Losses (% of Total Assets Total Equity Net Interest Efficiency Ratio Securities ($000] HTM FV ($000) / Losses ($000) State RDAA (9%) NPAs/ Assets (9%) Reserves/ Gross Tangible Assets (9%) (99) Equity (x) Liabilities (9%) Deposits (9%] Company Name (95) Equity) ($000) ($000) Margin (9%) Loans (9%) (9%) 0.00 25.4 25.5 0.0 14,443.0 14,416.0 27.0 0.3 0.2 15.0 0.1 D.S 68.3 6.4 8.1 SC 140,907.0 9,008.0 2.8 4.9 584,744.0 470,001.0 -114,743.0 -45.1 Bank 01 21.1 3.3 13 46.0 0.2 1.2 72.0 6.6 8.8 0.69 20.0 Bank 02 CA 3,840,762.0 254,450.0 0.00 29.9 30.1 0.0 9,950.0 9,950.0 0.0 0.0 60.6 0.3 1.4 75.9 9.3 10.3 Bank 03 VA 713,718.0 66,393.0 3.7 1.1 21.3 20.9 0.00 4.0 4.1 0.0 1,093,348.0 1,011,049.0 82,299.0 -27.2 303,047.0 1.9 0.8 33.3 0.2 1.0 9.4 Bank 04 NY 1,421,424.0 146,409.0 135,847.0 -10,562.0 -6.7 1.2 51.9 0.7 1.4 52.9 7.1 10.7 0.11 44.1 44.8 0.9 Bank 05 WA 2,087,762.0 158,390.0 2.9 17.6 17.7 0.0 6,221.0 5,869.0 -352.0 -1.8 3.7 0.8 69.3 0.0 1.0 87.1 10.1 11.3 0.00 Bank 06 NC 191,806.0 19,415.0 9.0 7.2 81,512.0 69,500.0 -12,012.0 -8.7 3.9 10 65.6 0.1 1.0 97. 11.5 12.5 0.51 8.3 Bank 07 NC 1,118,256.0 137,917.0 14.0 4,789,522.0 4,263,461.0 -526,061.0 -40.1 73. 10.9 10.9 1.13 2.5 2.9 Bank 08 CA 12,054,744.0 1,313,082.0 2.7 0.9 57.6 0.3 1.1 23,772.0 848.0 -1.0 5.3 2.1 30.2 0.2 2.5 116.7 28.0 28.0 0.00 6.1 6.1 0.0 24,620.0 Bank 09 OH 299,515.0 83,752.0 6.3 65,788.0 60,918.0 4,870.0 -2.7 1.4 54.7 1.6 1.6 108.9 14.0 14.3 0.39 5.1 5.5 Bank 10 1,292,127.0 180,391.0 4.0 0.21 21.9 23.4 4.7 6,041.0 5,803.0 238.0 -0.1 102.4 17.9 17.5 Bank 11 CA 1,175,415.0 210,620.0 5.0 2.8 23.0 0.1 1.1 3.9 4.3 8.7 28,348,000.0 23,587,503.0 4,760,497.0 -27.3 8.5 0.96 Bank 12 CA 212,639,000.0 17 446,000.0 2.7 0.9 59.9 0.1 0.5 94.6 8.1 9.1 5.8 108,253.0 -11,838.0 8.8 0.01 5.7 0.1 120,091.0 -21.9 79.6 Bank 13 MD 595,469.0 54,047.0 3.4 0.8 69.4 1.2 1.1 3,091.0 409.0 -0.1 0.0 0.7 147.0 9.2 9.5 3.31 9.5 14.5 33.8 3,500.0 24.8 -17.2 Bank 14 MA 4,193,799.0 385,966.0 2.8 1.0 44,051.0 -3,863.0 8.1 0.95 19.3 20.4 4.9 47,914.0 wv 461,234.0 22,511.0 3.1 0.8 64.8 0.4 1.1 74.2 4.9 -65.8 Bank 15 -23,293.0 10.2 0.07 29.1 29.5 0.5 141,511.0 118,218.0 NC 484,339.0 35,390.0 3.2 1.0 65.2 0.8 1.1 12.0 7.2 10.1 0.02 21.7 267,754.0 -11.0 Bank 16 -17,280.0 9.4 21.7 0.2 250,474.0 Bank 17 TX 1,680,875.0 157,266.0 2.6 0.5 69.4 0.0 1.9 68.2 -12.0 0.1 1.0 76.2 9.7 9.9 0.04 18.7 19.1 0.4 95,538.0 86,696.0 -8,842.0 CA 755,653.0 73,687.0 1.1 Bank 18 4.0 67.1 22,459.0 20,518.0 1,941.0 -0.3 0.5 1.4 91.1 9.8 10.3 0.27 20.6 21.5 3.0 Bank 19 CA 6,425,358.0 630,426.0 4.1 2.1 26.3 11.4 0.13 11.3 11.5 1.7 9,810.0 8,000.0 1,810.0 -2.4 1.2 101.9 NH 653,939.0 3.8 39.8 11.7 Bank 20 76,313.0 1.6 0.3 0.3 2,840.0 2,834.0 -6.0 0.0 197,676.0 4.2 1.8 38.8 0.2 1.7 79.9 9.9 10.4 0.02 25.7 26.0 Bank 21 CA 1,744,487.0 57. 0.0 6,510.0 6,376.0 -134.0 -0.6 13.4 0.00 57.5 NY 212,703.0 21,255.0 3.3 0.9 68.8 1.3 1.4 48.6 10.0 2.9 548,392.0 518,992.0 -29,400.0 -1.6 Bank 22 9.9 0.21 21.5 22.5 VA 15,845,267.0 1,888,757.0 3.1 1.2 62.2 0.1 1.0 81.2 9.0 -7.4 Bank 23 0.29 37.2 38.5 2.8 14,999.0 12,172.0 -2,827.0 NC 445,109.0 38,439.0 2.8 -0.1 90.4 0.0 1.3 69.5 8.6 12.4 Bank 24 1.0 77.7 4.3 7.7 2.30 19.8 23.5 13.6 11,126,000.0 11,238,585.0 112,585.0 2.3 0.4 89,545,000.0 4,893,000.0 3.1 58.6 Bank 25 UT