Intro to BA assignment 7

xlsx

School

University of Scranton *

*We aren’t endorsed by this school

Course

571

Subject

Computer Science

Date

Feb 20, 2024

Type

xlsx

Pages

25

Uploaded by AdmiralQuetzal3056

Report
Player Comp Att Pct Yds Avg Yds/G TD Int 1 107 166 45.3 1172 7.1 167.5 12 4 2 238 353 47.3 2829 8 188.7 20 4 3 207 347 41.9 2324 6.7 145.3 20 9 4 252 392 44.9 2975 7.6 198.4 22 11 5 66 119 38.9 760 6.4 152 4 4 6 220 366 42.1 2580 7 161.3 16 10 7 134 221 42.6 1285 5.8 116.8 7 9 8 67 120 39.1 761 6.3 126.9 4 4 9 38 78 34.4 380 4.9 95.2 0 2 10 86 156 38.4 1001 6.4 143 3 4 11 203 344 41.4 2311 6.7 144.5 17 12 12 114 186 43 1384 7.4 197.8 7 5 13 185 308 42.1 2307 7.5 177.5 26 5 14 227 336 47.3 2482 7.4 165.6 17 5 15 215 343 44 2326 6.8 145.5 17 10 16 226 360 43.9 2447 6.8 163.2 17 10 17 88 142 43.3 1189 8.4 169.9 15 6 18 178 333 37.5 2025 6.1 135 8 17 19 270 375 50.4 3033 8.1 189.6 18 6 20 55 111 34.8 625 5.6 125.2 4 4 21 246 399 43.1 2427 6.1 161.8 15 10 22 193 328 41.2 2168 6.6 135.5 10 5 23 197 309 44.7 2452 7.9 188.7 15 8 24 207 333 43.5 2662 8 177.5 22 5 25 186 300 43.4 1866 6.2 133.3 15 11 26 84 124 47.2 1092 8.8 182 5 4 27 246 384 44.9 2198 5.7 137.4 14 10 28 186 277 47.1 2048 7.4 157.6 14 7 29 242 378 45 2865 7.6 179.1 21 10 30 196 317 43.4 2262 7.1 150.9 10 12 31 54 88 43 602 6.8 150.6 3 4 32 239 370 45.3 2866 7.7 179.1 16 9 33 259 395 46 3112 7.9 194.5 23 8 34 65 98 46.5 583 5.9 145.7 3 4 35 137 231 41.6 1535 6.6 128 5 5 36 39 70 39.5 375 5.4 53.7 4 1 37 252 402 43.8 3160 7.9 197.5 22 8 38 237 387 42.9 2788 7.2 174.2 27 8 39 67 114 41.2 772 6.8 128.7 5 2 40 269 406 46.4 3203 7.9 200.3 25 6 41 87 156 39.3 988 6.3 123.6 4 4 42 144 244 41.3 1599 6.6 145.4 9 11 43 184 294 43.8 1959 6.7 130.6 11 3
Record 3 3 3 Record ID Cluster Sub-Cluster Record 6 3 3 Record 1 1 1 Record 7 3 6 Record 2 2 2 Record 11 3 3 Record 3 3 3 Record 15 3 3 Record 4 2 4 Record 16 3 3 Record 5 1 5 Record 18 3 9 Record 6 3 3 Record 21 3 3 Record 7 3 6 Record 22 3 6 Record 8 1 5 Record 25 3 3 Record 9 1 7 Record 27 3 3 Record 10 1 5 Record 30 3 3 Record 11 3 3 Record 35 3 6 Record 12 1 1 Record 42 3 3 Record 13 2 8 Record 43 3 6 Record 14 2 2 Record 15 3 3 Record 16 3 3 Record 17 1 1 Record 18 3 9 Record 19 2 2 Record 20 1 7 Record 21 3 3 Record 22 3 6 Record 23 2 2 Record 24 2 8 Record 25 3 3 Record 26 1 1 Record 27 3 3 Record 28 2 2 Record 29 2 4 Record 30 3 3 Record 31 1 10 Record 32 2 2 Record 33 2 4 Record 34 1 10 Record 35 3 6 Record 36 1 7 Record 37 2 4 Record 38 2 4 Record 39 1 10 Record 40 2 4 Record 41 1 5 Record 42 3 3 Record 43 3 6
dg ds 3 20 3 16 3 7 3 17 3 17 3 17 3 8 3 15 3 10 3 15 3 14 3 10 3 5 3 9 3 11 12.68293
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cluster TD 2 20 2 20 2 22 2 16 2 7 2 17 2 26 2 17 2 17 2 17 2 8 2 18 2 15 2 10 2 15 2 22 2 15 2 14 2 14 2 21 2 10 2 16 2 23 2 5 2 22 2 27 2 25 2 9 2 40
Data Mining: Hierarchical Clustering Output Navigator Inputs Data Workbook Gayathri assignment 7.xlsx Worksheet Sheet1 Range $A$1:$I$44 # Records in the input data 43 Variables # Selected Variables 8 Selected Variables Comp Att Pct Yds Avg Hierarchical Clustering: Fitting Parameters Similarity Measure EUCLIDEAN Clustering Method WARD Hierarchical Clustering: Model Parameters Cluster Assignment 1 # Clusters 3 Hierarchical Clustering: Reporting Parameters Normalized? 1 Draw Dendrogram? 1 Maximum Number of Leaves in Dendr 10 Data Type Raw Data Clustering Stages Stage Cluster 1 Cluster 2 Distance Stage1 8 41 0.50951119 Stage2 5 10 0.62247682 Stage3 15 16 0.63645535 Stage4 33 37 0.70037872 Stage5 4 29 0.74765503 Stage6 6 15 0.81220681 Stage7 33 40 0.97034726 Cluster Labels Dendrogram Inputs Clustering Stages
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Stage8 3 11 0.98299577 Stage9 13 24 1.05112786 Stage10 23 32 1.06494787 Stage11 22 43 1.09163695 Stage12 21 27 1.12378945 Stage13 5 8 1.13805894 Stage14 31 39 1.1659255 Stage15 14 28 1.18815748 Stage16 3 6 1.24879098 Stage17 2 19 1.26418126 Stage18 25 42 1.4454355 Stage19 1 12 1.4964169 Stage20 25 30 1.53332357 Stage21 9 20 1.57909765 Stage22 7 35 1.62012303 Stage23 4 38 1.6696464 Stage24 17 26 1.98939899 Stage25 31 34 2.02405853 Stage26 4 33 2.07247849 Stage27 14 23 2.14456839 Stage28 1 17 2.44554802 Stage29 3 21 2.46905848 Stage30 7 22 2.62131832 Stage31 2 14 2.851553 Stage32 9 36 2.92545063 Stage33 3 25 3.14160987 Stage34 5 31 3.27835363 Stage35 2 13 3.31358352 Stage36 3 18 4.22550601 Stage37 2 4 4.65231933 Stage38 5 9 6.77070076 Stage39 3 7 7.41946087 Stage40 1 5 11.8124411 Stage41 2 3 19.9648111 Stage42 1 2 41.2256949 33
Date: 19-Oct-2023 19:53:12 Elapsed Times in Milliseconds Data Reading Time lgorithm Tim Report Time Total 0 2 2 4 Yds/G TD Int
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Data Record ID Sum of Cluster Sum of Sub-Cluster Record 1 1 1 Record 10 1 5 Record 11 3 3 Record 12 1 1 Record 13 2 8 Record 14 2 2 Record 15 3 3 Record 16 3 3 Record 17 1 1 Record 18 3 9 Record 19 2 2 Record 2 2 2 Record 20 1 7 Record 21 3 3 Record 22 3 6 Record 23 2 2 Record 24 2 8 Record 25 3 3 Record 26 1 1 Record 27 3 3 Record 28 2 2 Record 29 2 4 Record 3 3 3 Record 30 3 3 Record 31 1 10 Record 32 2 2 Record 33 2 4 Record 34 1 10 Record 35 3 6 Record 36 1 7 Record 37 2 4 Record 38 2 4 Record 39 1 10 Record 4 2 4 Record 40 2 4 Record 41 1 5 Record 42 3 3 Record 43 3 Record 5 1 5 Record 6 3 3 Record 7 3 6 Record 8 1 5 Record 9 1 7 Recor d I D Record R 0 2 4 6 8 10 12
Total Result 87 184
ord 11 Record 14 Record 17 Record 2 Recor d 22 Recor d 25 Record 28 Record 30 Record 33 Recor d 36 Recor d 39 Recor d 41 Record 5 Record 8 Data Column C
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cluster Count of Record ID 1 14 2 14 3 15 Total Result 43 1 2 3 Total Re 0 5 10 15 20 25 30 35 40 45 50 Total
esult Count of Record ID
Data Mining: Hierarchical Clustering - Predicted Clusters Output Navigator Cluster Labels Record ID Cluster Sub-Cluster Record 1 1 1 Record 2 2 2 Record 3 3 3 Record 4 2 4 Record 5 1 5 Record 6 3 3 Record 7 3 6 Record 8 1 5 Record 9 1 7 Record 10 1 5 Record 11 3 3 Record 12 1 1 Record 13 2 8 Record 14 2 2 Record 15 3 3 Record 16 3 3 Record 17 1 1 Record 18 3 9 Record 19 2 2 Record 20 1 7 Record 21 3 3 Record 22 3 6 Record 23 2 2 Record 24 2 8 Record 25 3 3 Record 26 1 1 Record 27 3 3 Record 28 2 2 Record 29 2 4 Record 30 3 3 Record 31 1 10 Record 32 2 2 Record 33 2 4 Record 34 1 10 Cluster Labels Dendrogram Inputs Clustering Stages
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Record 35 3 6 Record 36 1 7 Record 37 2 4 Record 38 2 4 Record 39 1 10 Record 40 2 4 Record 41 1 5 Record 42 3 3 Record 43 3 Record ID 3 15
Date: 19-Oct-2023 19:53:12 Elapsed Times in Milliseconds Data Reading Time lgorithm Tim Report Time Total 0 2 2 4
Data Mining: Hierarchical Clustering - Dendrogram Output Navigator Cluster Legend (Numbers show the record sequence relative to the original data) 1 2 3 4 5 7 9 13 18 12 14 6 29 8 22 20 24 17 19 11 33 10 35 36 26 23 15 37 41 43 28 16 38 32 21 40 25 27 30 42 Cluster Labels Dendrogram Inputs Clustering Stages Sub- Cluster 1 Sub- Cluster 2 Sub- Cluster 3 Sub- Cluster 4 Sub- Cluster 5 Sub- Cluster 6 Sub- Cluster 7 Sub- Cluster 8 Sub- Cluster 9
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Date: 19-Oct-2023 19:53:12 Elapsed Times in Milliseconds Data Reading Time lgorithm Tim Report Time Total 0 2 2 4 31 34 39 Sub- Cluster 10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Record ID Cluster Sub-Cluster Record ID Cluster Sub-Cluster Record 1 1 1 Record 3 3 3 Record 2 2 2 Record 6 3 3 Record 3 3 3 Record 7 3 6 Record 4 2 4 Record 11 3 3 Record 5 1 5 Record 15 3 3 Record 6 3 3 Record 16 3 3 Record 7 3 6 Record 18 3 9 Record 8 1 5 Record 21 3 3 Record 9 1 7 Record 22 3 6 Record 10 1 5 Record 25 3 3 Record 11 3 3 Record 27 3 3 Record 12 1 1 Record 30 3 3 Record 13 2 8 Record 35 3 6 Record 14 2 2 Record 42 3 3 Record 15 3 3 Record 43 3 6 Record 16 3 3 15 Record 17 1 1 Record 18 3 9 Record 19 2 2 Record 20 1 7 Record 21 3 3 Record 22 3 6 Record 23 2 2 Record 24 2 8 Record 25 3 3 Record 26 1 1 Record 27 3 3 Record 28 2 2 Record 29 2 4 Record 30 3 3 Record 31 1 10 Record 32 2 2 Record 33 2 4 Record 34 1 10 Record 35 3 6 Record 36 1 7 Record 37 2 4 Record 38 2 4 Record 39 1 10 Record 40 2 4 Record 41 1 5 Record 42 3 3 Record 43 3 6
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cluster 1 1 0 1 2 0 1 3 1 1 2 0 1 1 0 1 3 1 1 3 1 1 1 0 1 1 0 1 1 0 1 3 1 1 1 0 1 2 0 1 2 0 1 3 1 1 3 1 1 0 3 1 2 0 1 0 3 1 3 1 2 0 2 0 3 1 1 0 3 1 2 0 2 0 3 1 1 0 2 0 2 0 1 0 3 1 1 0 2 0 2 0 1 0 2 0 1 0 3 1 3 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help