**Having trouble knowing how my excel sheet should be set up, if you could include how you set up yours in the answer that would be very helpful. Thank you**

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

Finance 2: A lending organization has acquired data on a sample of recent customers and is interested in building a model to predict whether or not a given customer will default on a loan. The available data are contained in the worksheet "Default" and the variables are defined as follows. Default: Coded as "Yes" if the customer defaulted on the loan and "No" otherwise. Student: Whether or not the customer is currently a student (coded Yes/No) Balance: The average balance carried by the customer in hundreds of USD. Income: The income of the customer in ten thousands of USD. Fit the proper regression model to predict whether or not a customer will default on a loan. Fit the model so that the event being modeled is "Yes". Furthermore, code the variable Student 50 that "No" serves as the reference group. Finally, it is hypothesized that income has a curvilinear relationship with the likelihood of being in default. Therefore, t a second-order polynomial model in terms of the variable Income to test this theory. (a) Complete the following statement (Enter your rst answer as a whole number and the percent rounded to two decimal places). Out of a total of n = ' customers in the sample, % were in default. (b) State the model equation. 1 1+e-Qo+1(Student)+2(BaIance)+B3(Income)+l34(1ncomez)) (V P(Y= Default) = O )7 = [30+1(Student)+2(BaIance)+3(Income)+4(Income2) 1 1 +6(o+1(Student)+2(BaIance)+3(Incame)) 2'? P(Y= Default) = 0 l7 = o+1(Student)+z(BaIance)+3(Income)+/34LN(Income) by )7 = [30+1(Student)+2(BaIance)+3(Income) 1 A P0, = Default) = 1+e(o+1(Student)+2(BaIance)+B3(Income)+4LN(Incon-ie)) State the hypotheses to be tested. O Ho: B1 = B2 = B3 = B4 = 35 = 0 Ha: All of the coefficients are equal to zero. O Ho: B1 = B2 = B3 = B4 = 35 = 0 Ha: At least one of the coefficients is not equal to 0. O Ho: B1 = B2 = B3 = 0 Ha: At least one of the coefficients is not equal to 0. O Ho: B1 = B2 = B3 = 4 = 0 Ha: At least one of the coefficients is not equal to 0. O Ho: B1 = $2 = P3 = B4 = 0 Ha: All of the coefficients is not equal to 0. State the decision rule. Reject Ho if p 0.01. Do not reject Ho if p 5 0.01. Reject Ho if p > 0.005. Do not reject Ho if p