business intelligence

decisiontree construction

State Nam ST Question Create a decision tree for the following data set. The objective is to predict the class category floan approved or not). 3. Analyze the data as you have leamed showing step by step analysis. Draw the final decision tree and let it appear on excel (you can doww using any drawing sottware and transfer the drawing into excel) c. Find the result of the following Age House Credit Loan Approved You Fale No Good 1 4. According to the previous figure, what are the not affecting attributes in the boats approved decision based on the data provided Willips Job Age Young Young Young Young Young Mid Middle Job Fabe False True True Loan Approved No No House No No No Yes No No No Yes Yes Yes Yes Yes Ne Ya No No No F Folie True Fabe Fabe Fabe False True True Credit Fair Good Good Fair Fair Fair Good Good Excellent Excellent Excelle Good Good Excellent Middle Midi Mi Old Old Old ad Od Ya Yo Ya Yes 713 Yes No F 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 tempe 1. Find the formula 2. Find the result for the prediction 3. How Accurate is the formula predictive! 4. Find the formula for predicting the sales based on Temperature only having just two variables Sales Temperature) 5. How accurate is your formula Write you answers on She Sales Rain Temperature $28.00 1 54 $ 270.00 0 95 $ 48.00 1 74 $ 68.00 1 84 $ 88.00 1 94 $ 150.00 0 75 S 36.00 0 56 $ 210.00 0 85 S 90.00 $10.00 1 55 State Nam ST Question Create a decision tree for the following data set. The objective is to predict the class category floan approved or not). 3. Analyze the data as you have leamed showing step by step analysis. Draw the final decision tree and let it appear on excel (you can doww using any drawing sottware and transfer the drawing into excel) c. Find the result of the following Age House Credit Loan Approved You Fale No Good 1 4. According to the previous figure, what are the not affecting attributes in the boats approved decision based on the data provided Willips Job Age Young Young Young Young Young Mid Middle Job Fabe False True True Loan Approved No No House No No No Yes No No No Yes Yes Yes Yes Yes Ne Ya No No No F Folie True Fabe Fabe Fabe False True True Credit Fair Good Good Fair Fair Fair Good Good Excellent Excellent Excelle Good Good Excellent Middle Midi Mi Old Old Old ad Od Ya Yo Ya Yes 713 Yes No F 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 tempe 1. Find the formula 2. Find the result for the prediction 3. How Accurate is the formula predictive! 4. Find the formula for predicting the sales based on Temperature only having just two variables Sales Temperature) 5. How accurate is your formula Write you answers on She Sales Rain Temperature $28.00 1 54 $ 270.00 0 95 $ 48.00 1 74 $ 68.00 1 84 $ 88.00 1 94 $ 150.00 0 75 S 36.00 0 56 $ 210.00 0 85 S 90.00 $10.00 1 55