Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finite Mathematics and Its Applications

Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair

12th edition

978-0134768588, 9780134437767, 134768582, 134437764, 978-0134768632

More Books

Students also viewed these Mathematics questions

Question

What do you think are the major problems affecting society today?

Answered: 1 week ago