{"id":49815,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/reserved-for-goodmorning"},"modified":"2017-08-16T12:24:51","modified_gmt":"2017-08-16T12:24:51","slug":"reserved-for-goodmorning","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/reserved-for-goodmorning\/","title":{"rendered":"reserved for goodmorning"},"content":{"rendered":"

Included with this assignment is an Excel spreadsheet that contains data with two dimension values.<\/p>\n

The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis.<\/p>\n

Review the “k-MEANS CLUSTERING ALGORITHM” section in Chapter 4 of the Sharda et. al. textbook for additional background.<\/p>\n

Use Excel to perform the following data analysis.<\/p>\n

    \n
  1. Plot the data on a scatter plot.<\/li>\n
  2. Determine the ideal number of clusters.<\/li>\n
  3. Choose random center points (centroids) for each cluster. (Note:  Each student will select a different random set of centroids.)<\/li>\n
  4. Using a standard distance formula measure the distance from each data point to each center point.<\/li>\n
  5. Assign each data point to an initial cluster region based on closeness.<\/li>\n
  6. For each cluster calculate new center points.<\/li>\n
  7. Repeat steps 4 through 6.<\/li>\n<\/ol>\n

    You will use Excel to help with calculations, but only standard functions should be used (i.e. don’t use a plug-in to perform the analysis for you.)  You need to show your work doing this analysis the long way.  If you were to repeat steps 4 through 6, what will likely happen with the cluster centroids?  The rubric for this assignment can be viewed when clicking on the assignment link.<\/p>\n

    Here is a link to an example spreadsheet using a smaller data set.  It contains two tabs.  The first tab is the raw data.  The second tab contains the analysis that was performed.  Make sure that you use a different starting center points from the example.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Included with this assignment is an Excel spreadsheet that contains data with two dimension values. The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the “k-MEANS CLUSTERING ALGORITHM” section in Chapter 4 of Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-49815","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/49815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=49815"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/49815\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=49815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=49815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=49815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}