can you show me how to

Perform the Analysis What kind of analysis will help show a relationship between our transformed Loan Paid (loan_status) and the various independent variables? Consider the following types of analyses: - Pivottables: A pivottable of Loan Paid ("loan_status" as dependent variable) and each independent variable you proposed ((Excel: Insert PivotTable). After running the pivot analysis, do you still believe there is a relationship between the dependent and each independent variable you proposed? - Correlations: Using the data analysis toolpak (Exeel: Data>Analysis>Data Analysis>Correlation), run a correlation between Loan Paid (dependent variable) and a few independett (now transformed) variables one by one. After running the correlation analysis. do you still believe there is a relationship between the dependent and each independent variable you proposed? - Regression analysis: Using the data analysis toolpak (Excel: Data>Analysis>Data Analysis>Regression), fun a regression of Loan Paid (dependent variable) on your proposed independent (now transformed) variables. (For additional description of regression analysis, see the statistics review in Chapter 5 .)