Answered step by step
Verified Expert Solution
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 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 kmeans clustering with using football stadium capacity, latitude, longitude, endowment, and undergraduate enrollment as variables. Be sure to Normalize input data, and specify iterations and random starts in Step of the XLMiner kMeans 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 conferences directly with the clusters?
c Repeat part a but this tirke do not Normalize input data in Step of the XLMiner kmeans clustering procedure. Analyze the resultant clusters. Why do they differ from part a Identify the dominating factors 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 indicates whether Web site was visited by user
Using a minimum support of transactions and a minimum confidence of percent, use XLMinder to generate a list of association rules. Review the top rules. What information does this analysis provide Cookie Monster regarding the online behavior of individuals?
tableABcDFGSchool,StadiumCapacity,Latitude,Longitude,AthleticRevenue $Endowment $EnrollmentAir Force Falcons,Akron Zips,Alabama Crimson Tide,Arizona State Sun Devils,Arizona Wildcats,Arkansas Razorbacks,Arkansas State Red Wolves,Army Black Knights,Auburn Tigers,Ball State Cardinals,Baylor Bears,Boise State Broncos,Boston College Eagles,Bowling Green Falcons,Buffalo Bulls,BYU Cougars,California Golden Bears,Central Michigan Chippewas,Charlotte ers,Cincinnati Bearcats,Clemson Tigers,Colorado Buffaloes,Colorado State Rams,Connecticut Huskies,Duke Blue Devils,East Carolina Pirates,Eastern Michigan Eagles,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started