Provide a thorough analysis that explains the result set from the Excel run. The detailed analysis should document each process (step) through the analysis and include responses to the following:

kenny8888
BUSA421BusinessCase3DataWorkbook.xlsx

Model

Disposal Tank Locations
Parameters 1 means share a border, 0 not Note that the diagonal elements are 1.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Ashtabula 1 1 1 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0
Lake 2 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
Cuyahoga 3 0 1 1 1 0 0 0 0 1 1 0 1 1 0 0 0 0 0 0 0
Lorain 4 0 0 1 1 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0
Huron 5 0 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
Richland 6 0 0 0 0 1 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0
Ashland 7 0 0 0 1 1 1 1 1 1 0 0 0 0 0 0 0 1 1 0 0
Wayne 8 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 1 0 0
Medina 9 0 0 1 1 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0
Summit 10 0 0 1 0 0 0 0 1 1 1 1 1 1 0 0 0 0 0 0 0
Stark 11 0 0 0 0 0 0 0 1 0 1 1 0 1 1 1 0 0 1 1 1
Marian 12 1 1 1 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 0
Portage 13 0 0 1 0 0 0 0 0 0 1 1 1 1 0 1 1 0 0 0 0
Columbiana 14 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0 1
Mahoning 15 0 0 0 0 0 0 0 0 0 0 1 0 1 1 1 1 0 0 0 0
Trumbull 16 1 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 0 0 0 0
Knox 17 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 1 0 0
Holmes 18 0 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0 1 1 1 0
Tuscarawas 19 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 1 1
Carroll 20 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 1 1
Model
Number of Disposal Tank Locations
Ashtabula Lake Cuyahoga Lorain Huron Richland Ashland Wayne Medina Summit Stark Marian Portage Columbiana Mahoning Trumbull Knox Holmes Tuscarawas Carroll
Disposal Tank Location?
Covered?
Ashtabula
Lake
Cuyahoga
Lorain
Huron
Richland
Ashland
Wayne
Medina
Summit
Stark
Marian
Portage
Columbiana
Mahoning
Trumbull
Knox
Holmes
Tuscarawas
Carroll