1. The worksheet Base Data in the Excel File Credit Risk Data provides information about 425 bank customers who have applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, Age housing status and number of years at current residence, job type and credit risk classification by bank. a. Frequency Distribution for Categorical Data Use the COUNTIF Function to determine (1) how many customers applied for a new-car, business, education, small-appliance, and furniture loans. You may these at the bottom of the spreadsheet. b. Frequency Distribution for Categorical Data Use the COUNTIF Function to determine the number of customers with checking account less than $ 500.00. You may these at the bottom of the spreadsheet. c. Modify the spreadsheet using the IF Functions to include new columns, classifying the checking and savings balances as low if the balance is less than $ 250, medium if between $250 and less than 2000 and high otherwise. Add Conditional formatting. If the Checking account balance is low, change the cell color to red. If the Savings account balance is High change to Green.

d, conspicuous consumption is when you try to increase your wealth or social status (and in the case he's trying to create the perception of wealth considering he can't really afford it)

cognitive overload: having a lot on your mind impairs decision-making and tends to result in the simplest, but not necessarily best, option being selected.

empathy gaps: overlooking how you might feel in a different situation can result in unnecessary purchases, such as overbuying when shopping for food on an empty stomach.

optimism and overconfidence: wearing rose-tinted glasses and having unrealistic expectations about the future can affect money management and leave you unprepared for a change in circumstance.

instant gratification: seeking instant gratification drives impulsive spending and can undermine long-term planning and savings.

harmful habits: automatic or mindless behaviour can amplify a poor financial decision as it becomes a recurring event.

social norms: we are heavily influenced by the actions of others; while this can be in certain circumstances, it also contributes to the pressure to keep up with the joneses through conspicuous consumption.

answer; the nav calculated at the market close at 4: 00 pm new york time;

answerreactive approach;