With this data that can be found on the shareable link that I created:

https://docs.google.com/spreadsheets/d/1QorJa5qWY1dyH7TzTvXhbHpolBNq4w_TwMJin91nCeA/edit?usp=sharing

1. The data inthe link provide above is collected for building a regression model to predict credit card balance of retail banking customers in a Canadian bank. Use this data to perform a simple regression analysis between Account balance and Income (in thousands).

1. Develop a scatter diagram using Account Balance as the dependent variable y and Income as the independent variable x.Explain
2. Develop the estimated regression equation.Explain
3. Use the estimated regression equation to predict the Account Balance of a customer with Income of $58 thousands.Explain
4. Use the critical-value approach to perform an F test for the significance of the linear relationship between account balance and Income at the 0.05 level of significance.Explain
5. What percentage of the variability of Account Balance can be explained by its linear relationship with Income?Explain
6. Use the p-value approach to perform a t test for the significance of the linear relationship between Account Balance and Income at the 0.05 level of significance.Explain