Question
Hello, hope all is well. Please I need your help with a project, specifically questions 2 and 10 below. I'm going to attach below a
Hello, hope all is well. Please I need your help with a project, specifically questions 2 and 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 2:
a)Using the data in columns B, C, and D calculated the weighted-average total equity and assets per state. (please show numbers)
b) Do you observe anything of significance that would be worth further investigation?
c) Construct a Box-and-Whisker plot to determine if there are extreme outliers in the data for columns
C and D. Use 3IQR in your whisker calculations. (Please show box-and-whiskey plot and calculations)
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