Greetings, the following questions 2 and 10 are a part of a project. I only want the answers to 2 and 10. I will link the entire project only for reference, along with the data. kindly elaborate on the answers as much as possible.

2. Using the data in columns B, C, and D calculated the weighted-average total equity and assets per state.

a. Do you observe anything of significance that would be worth further investigation?

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

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

a. Are any of the variables significant at the 5% level? 1%? What is your proof?

b. Why do you think those variables are significant - clearly discuss your thesis!

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

the project:

https://drive.google.com/file/d/1g0mOYgoI9o4HomTSMSFSbWUyQoxu1KjO/view?usp=share_link

the data:

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