The Football Bowl Subdivision (FBS) level of the National Collegiate Athletic Association (NCAA) consists of over 100 schools.

Compute the cluster sizes, as well as the minimum and maximum of the latitude and longitude of Ward's method. If required, round your answers to one decimal place. If your answer is negative, use minus sign.Apply hierarchical clustering with 10 clusters using latitude and longitude as variables. Choose the correct scatter plot diagrams below with longitude as the x-variable and latitude as the y-variable of Ward's method. (Hint: This can be done using a PivotTable in Excel to display the count of schools in each cluster as well as the minimum and maximum of the latitude and longitude within each cluster.)

(b)Compute the cluster sizes, as well as the minimum and maximum of the latitude and longitude of complete linkage method. If required, round your answers to one decimal place. If your answer is negative, use minus sign. (Hint: This can be done using a PivotTable in Excel to display the count of schools in each cluster as well as the minimum and maximum of the latitude and longitude within each cluster.)

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4
• Attachment 5