CREATING DECISION TREE IN EXCEL-BANK FAILURES

DAT 520 Milestone Two Guidelines and Rubric

In this milestone, you will create a first draft of your decision tree. This task assumes you have already established a viab le research question, identified a data
set, and performed the necessary data prep. To complete this milestone, you may have to exp eriment/iterate with different modeling styles. The main objective
of this milestone is to draft your model, explain what you did, and explain why it is the best model for your research questi on. For more details on completing
this milestone, refer to the Final Project Notes in the Assignment Guidelines and Rubrics folder.

Your submission should include the following:

 A clear description of the structure and purpose of the decision tree model that you choose.

 Documentation that refers to potential complications in the analysis process, in an outline or bulleted format. This should be clear, concise, and
thorough.

 An evaluation of the results of the model which includes discussion of whether or not the results are reasonable and the model is accurate, whether or
not there are elements that are not present or are needlessly present, and any errors that may be present.

Guidelines for Submission: Write 2 to 3 double-spaced pages explaining your model(s). Append the graphical representations of your model, and any other
supporting material that you feel is necessary to explain this draft model. Include any sources at the end and cite them in APA format.

Critical Elements Proficient (100%) Needs Improvement (70%) Not Evident (0%) Value

Structure Deci s i on tree and des cri pti on are
cl earl y s tructured

Deci s i on tree and des cri pti on are
s omewhat cl earl y s tructured

Deci s i on tree and des cri pti on are not
adequatel y s tructured

Process
Documentation

Documentati on i s cl ear, thorough, and
l ogi cal

Documentati on i s not ful l y cl ear, or
l eaves unexpl ai ned gaps

Documentati on i s not cl ear 30

Evaluation of Results Eval uati on cons i ders reas onablenes s ,

accuracy, mi s s ing/extraneous
el ements , and error i n the model

Eval uati on does not ful l y cons i der

reas onabl enes s , accuracy,
mi s s i ng/extraneous el ements , or error
i n the model

Eval uati on does not cons i der

reas onabl enes s , accuracy,
mi s s i ng/extraneous el ements , or error
i n the model
30

Articulation of
Response

Submi s s i on has no major errors
rel ated to grammar, s pel l i ng, s yntax,

or organi zati on

Submi s s i on has major errors rel ated to
grammar, s pel l i ng, s yntax, or

organi zati on that negati vel y i mpact
readabi l ity and arti culation of mai n
i deas

Submi s s i on has criti cal errors rel ated
to grammar, s pel l i ng, s yntax, or

organi zati on that prevent
unders tandi ng of i deas

Earned Total 100%

ecision

ree

1
0
0

0 0 0 D 2 1 2 0 0 0

1 0 0 E 2 3 4 0 0 0

2 0 0 T 0 0 0 0 0 0

5 TRUE

3 1 D 3 5

0 0

TRUE

4 1 T 0 0 0 0 0 0

9 TRUE

5 0 3 T 0 0 0 0 0 0 2

TRUE

6 0 3 E 2 8 9 0 0 0 9 13 TRUE
7 0 3 E 2 10

0 0 0

13 TRUE

8 6 T 0 0 0 0 0 0 7

TRUE

9 6 T 0 0 0 0 0 0

17 TRUE

10 7 T 0 0 0 0 0 0 17 17 TRUE
11 7 T 0 0 0 0 0 0

17 TRUE

																							Asset-Deposit/ Loss below	0	1
Grossly Unstable
Asset/ Deposit Ratio below	1.1
Asset -Deposit/Loss above 1.0
Relatively stable
Asset/ Deposite Ratio above 1.1
Stable
ID	Name	Value	Prob	Pred	Kind	NS	S1	S2	S				3	S			4	S	5	Row	Col	Mark
TreePlan	25	TRU			E
1						8					TRUE
32
										6		7			10	9
27
		13
			11	19
				17
12
22

Analysis

)

0 0 0 0 0 0

4 4 0

842

2 2 0

10 10 0

18 0

7 7 0

1 1 0

0 0 0 0 0 0

ERROR:#DIV/0!

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

56 56 0

61 0

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

1 1 0

0.6

1 1 0

44 44 0

2 2 0

6 6 0

1 1 0

3 3 0

1 1 0

0.6

8 8 0

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

8 8 0

0.5

16 16 0

11 11 0

0.5

2 2 0

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

5 5 0

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

2 2 0

911672

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

4 4 0

3 3 0

6 6 0

3 3 0

0.21

3 3 0

6 6 0

0.41

3 3 0

7 7 0

4 4 0

1.27

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

10 10 0

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

6 6 0

4 4 0

1.1

5 5 0

0.08

4 4 0

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

16 16 0

0.76

9 9 0

0 0 0 0 0 0 ERROR:#DIV/0! ERROR:#DIV/0!

363 0

FDIC: HSOB Bank & Thrift Failures
Table BF03
Federal Deposit Insurance Corporation
US and Other Areas
(Dollar amounts in thousands)
Effective Date(s): 2010 – 2017
Insurance Fund: ALL
Charter Type: ALL
Transaction Type: All Failures
State	Number of Institutions	Number of Failures	Number of Assistance Transactions	Assets	Deposits	Estimated Loss (12/31/20				16	Ratio (Assets/Deposits)	Assets-Deposits/Loss
Alaska
Alabama	3,923,592	3,524,148	527,116	1.1133		44		0.76
Arkansas	258,100	237,227	31,980	1.087987455			0.6
Arizona	1,724,911	1,521,634	367,101	1.133591258			0.5
California		18	10,369,863	8,527,943	1,180,136	1.215986434	1.		56
Colorado	5,907,934	5,033,322	997,068	1.173764365	0.88
Connecticut	26,368	25,715	9,211	1.025393739	0.07
District of Columbia													ERROR:#DIV/0!
Delaware
Florida	17,814,855	15,603,039	2,734,235	1.141755462	0.81
Georgia		61	17,615,642	16,457,170	5,499,612	1.070393148		0.21
Guam
Hawaii
Iowa	91,580	81,967	16,053	1.117278905
Idaho	153,361	145,813	3,487	1.051764932	2.16
Illinois	18,464,884	16,970,638	2,757,912	1.0880489	0.54
Indiana	2,176,991	1,864,957	128,806	1.167314313	2.42
Kansas	2,732,313	2,504,392	442,837	1.091008516	0.51
Kentucky	92,982	87,196	7,767	1.066356255	0.74
Louisiana	3,952,217	3,587,749	77,872	1.101586817	4.68
Massachusetts	245,534	233,222	20,560	1.052790903
Maryland	1,538,639	1,433,845	305,523	1.073086003	0.34
Maine
Michigan	3,769,306	3,358,462	816,063	1.122330996
Minnesota	2,081,648	2,010,361	405,386	1.035459801	0.18
Missouri	2,330,765	2,023,419	614,026	1.151894393
Mississippi	288,777	268,518	56,284	1.075447456	0.36
Montana
North Carolina	1,030,991	957,681	148,152	1.076549498	0.49
North Dakota
Nebraska	2,930,812	2,291,278	17,655		1.27	36.22
New Hampshire
New Jersey	446,500	437,714	79,422	1.020072467	0.11
New Mexico	3,470,419	2,788,769	400,484	1.244426842	1.7
Nevada	1,263,154	1,215,863	344,056	1.038895007	0.14
New York	927,324	892,626	163,505	1.038871823
Ohio	154,325	137,841	40,112	1.11958706		0.41
Oklahoma	1,104,610	1,005,099	244,219	1.099006168
Oregon	1,920,174	1,828,737	147,585	1.050000082	0.62
Pennsylvania	896,785	818,579	170,463	1.095538732	0.46
Puerto Rico	24,830,175	18,908,535	4,654,070	1.313172861
Rhode Island
South Carolina	3,041,833	2,792,700	595,639	1.089208651	0.42
South Dakota
Tennessee	2,278,148	2,224,875	637,427	1.023944267		0.08
Texas	3,538,873	2,739,025	725,795	1.29201924
Utah	2,714,230	2,655,833	766,758	1.021988205
Virginia	1,208,342	1,106,594	288,370	1.091947001	0.35
Virgin Islands
Vermont
Washington	9,437,876	8,373,008	1,401,612	1.127178667
Wisconsin	2,893,010	2,600,210	354,328	1.112606289	0.83
West Virginia
Wyoming
Totals:		363	159647843	139275704	28178689.59	1.146272023	0.72

Turn in your highest-quality paper
Get a qualified writer to help you with

“ CREATING DECISION TREE IN EXCEL-BANK FAILURES ”

Get high-quality paper

Guarantee! All work is written by expert writers!

Still stressed from student homework?

Get quality assistance from academic writers!

Order now