Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will use the files FBS and CookieMonster to complete. The FBS level of the NCAA consists of over 1 0 0 schools. Most of

You will use the files FBS and CookieMonster to complete.
The FBS level of the NCAA consists of over 100 schools. Most of those schools belong to one of seval conferences that compete with each other on a regular basis. Suppose the NCAA has commissioned a study that will propose the formation of conferences based on the similarities of the constituent schools. Each row in the FBS file contains information on the school. The variables include football stadium capacity, latitude, longitude, athletic dept revenue, endowment, and undergraduate enrollment.
a. Apply k-means clustering with k=10 using football stadium capacity, latitude, longitude, endowment, and undergraduate enrollment as variables. Be sure to Normalize input data, and specify 50 iterations and 10 random starts in Step 2 of the XLMiner k-Means Clustering procedure. Analyze the resultant clusters. What is the smallest cluster? What is the least dense cluster (as measured by average distance in the cluster)? What makes the least dense cluster so diverse?
b. What problems do you see with the plan with defining the school membership of the 10 conferences directly with the 10 clusters?
c. Repeat part a, but this tirke do not Normalize input data in Step 2 of the XLMiner k-means clustering procedure. Analyze the resultant clusters. Why do they differ from part a? Identify the dominating factor(s) in the formation of these new clusters.
Please use the file "CookieMonster" to help you complete the following. Cookie Monster Inc. is a company that specializes in the development of software that tracks Web browsing history of individuals. Using the binary matrix format, the entry in row i and column j indicates whether Web site j was visited by user i.
Using a minimum support of 800 transactions and a minimum confidence of 50 percent, use XLMinder to generate a list of association rules. Review the top 14 rules. What information does this analysis provide Cookie Monster regarding the online behavior of individuals?
\table[[,A,B,c,D,E,F,G],[1,School,StadiumCapacity,Latitude,Longitude,AthleticRevenue ($),Endowment ($000),Enrollment],[2,Air Force Falcons,52,480,38.86,-104.76,39,823,782,56,600,4,413],[3,Akron Zips,30,000,41.08,-81.52,25,583,730,171,513,27,470],[4,Alabama Crimson Tide,101,821,33.24,-87.54,124,498,616,995,147,31,647],[5,Arizona State Sun Devils,73,379,33.39,-111.93,55,294,113,514,724,72,254],[6,Arizona Wildcats,57,803,32.20,-110.89,59,663,128,552,351,39,236],[7,Arkansas Razorbacks,76,000,36.07,-94.16,91,768,112,788,668,23,199],[8,Arkansas State Red Wolves,30,964,35.82,-90.69,13,374,507,39,479,13,900],[9,Army Black Knights,40,000,41.36,-74.03,34,342,038,73,190,4,624],[10,Auburn Tigers,87,451,32.59,-85.48,103,982,441,471,851,25,469],[11,Ball State Cardinals,22,500,40.12,-87.84,20,483,476,140,275,22,147],[12,Baylor Bears,50,000,31.57,-97.18,,1,003,929,15,029],[13,Boise State Broncos,37,000,43.61,-116.23,37,524,722,72,507,19,664],[14,Boston College Eagles,44,500,42.34,-71.02,,1,726,100,13,906],[15,Bowling Green Falcons,23,724,41.37,-83.65,20,157,361,141,788,17,577],[16,Buffalo Bulls,29,013,42.89,-78.86,26,228,030,494,791,28,860],[17,BYU Cougars,63,725,40.25,-111.64,,920,149,34,101],[18,California Golden Bears,62,717,37.87,-122.30,65,243,053,3,257,667,25,885],[19,Central Michigan Chippewas,30,199,43.60,-84.78,23,500,552,85,267,28,194],[20,Charlotte 49ers,15,300,35.20,-80.83,,140,913,25,277],[21,Cincinnati Bearcats,35,000,39.14,-84.51,42,724,841,1,004,368,32,264],[22,Clemson Tigers,81,500,34.68,-82.81,61,174,977,473,748,19,914],[23,Colorado Buffaloes,53,750,40.03,-105.25,60,923,253,784,580,32,252],[24,Colorado State Rams,34,400,40.56,-105.07,29,372,783,221,231,30,450],[25,Connecticut Huskies,40,000,41.81,-72.26,63,089,340,312,329,25,868],[26,Duke Blue Devils,33,941,35.98,-78.91,,5,747,377,15,427],[27,East Carolina Pirates,50,000,35.60,-77.37,34,048,869,128,551,27,386],[28,Eastern Michigan Eagles,30,200,42.24,-83.62,27,717,6
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What is Aufbau's rule explain with example?

Answered: 1 week ago