Question 1 Create a decision tree for the following data set. The objective is to predict the class category (loan approved or not). a. Analyze the data as vou have learned showing step by step analysis. b. Draw the final decision tree and let it appear on excel (vou can draw using any drawing software and transfer the drawing into excel) C. Find the result of the following. Age Job House Credit Loan Approved Young False No Good ? d. According to the previous figure, what are the not affecting attributes in the loan approved decision based on the data provided? Write your solution and steps on Sheet 1 House Credit Job False Loan Approved No No Fair False No Good No No Good Yes Yes Fair Age Young Young Young Young Young Middle Middle Middle Middle Middle True True False False Yes No No Fair No Fair No False No Good No True Yes Good Yes Yes Yes False False Excellent Excellent Excellent Yes Yes Yes Yes Yes Old False Old Good Yes False True Old No Good Yes Old True No Excellent Yes No Old False No Fair Question 2 The following Table shows the previous Sales during rain status and temperature, what are the expected Sales if you know that tomorrow it will rain, and the expected temperature is 87? 1. Find the formula. 2. Find the result for the prediction. 3. How Accurate is the formula prediction? 4. Find the formula for predicting the Sales based on Temperature onlv (havine iust two variables (Sales. Temperature) 5. How accurate is vour formula? Sales Write you answers on Sheet 2 Rain Temperature $ 28.00 1 64 $ 270.00 0 95 $ 48.00 1 74 $ 68.00 1 84 $ 88.00 1 94 $ 150.00 0 75 $36.00 0 56 $ 210.00 0 85 $ 90.00 0 65 $ 10.00 1 55 TTT