COMPLETE A LOGISTIC REGRESSION, AS WELL AS A K-MEANS CLUSTER ANALYSIS IN EXCEL? Using the data to...

50.1K

Verified Solution

Question

Basic Math

COMPLETE A LOGISTIC REGRESSION, AS WELL AS A K-MEANS CLUSTERANALYSIS IN EXCEL?
Using the data to find four clusters of cities. Write a shortreport about the clusters you find. Does the clustering make sense?Can you provide descriptive, meaningful names for the clusters?SHOW GRAPHS PLEASE (Scatter plot/cluster)
Metropolitan_Area Cost_Living Transportation Jobs Education
Abilene, TX 96.32 36.54 17.28 49.29
Akron, OH 47.31 69.68 86.11 71.95
Albany, GA 86.12 28.02 32.01 26.62
Albany-Schenectady-Troy, NY 25.22 82.71 52.97 99.43
Albuquerque, NM 44.48 84.13 90.65 71.67
Alexandria, LA 92.36 42.49 19.26 11.61
Allentown-Bethlehem-Easton, PA 33.72 66.57 29.46 63.45
Altoona, PA 61.76 26.91 12.18 1.69
Amarillo, TX 96.89 60.05 28.32 54.1
Anchorage, AK 15.87 84.41 76.48 41.35
Ann Arbor, MI 7.37 15.86 77.33 83
Anniston, AL 93.21 7.08 7.64 21.81
Appleton-Oshkosh-Neenah, WI 54.4 70.82 79.32 47.3
Asheville, NC 54.11 54.67 54.1 59.77
Athens, GA 62.4 29.46 47.3 45.32
Atlanta, GA 39.38 98.3 99.15 82.71
Atlantic City-Cape May, NJ 30.03 66.85 62.03 20.39
Augusta-Aiken, GA-SC 77.91 35.41 63.45 46.45
Austin-San Marcos, TX 50.43 78.75 98.01 98.3

Answer & Explanation Solved by verified expert

4.4 Ratings (566 Votes)

Kmeans Cluster Analysis costliving transportation jobseducationFinal PartitionNumber of clusters 4Average MaximumWithin distance distanceNumber of cluster sum from fromobservations of squares See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Metropolitan_Area	Cost_Living	Transportation	Jobs	Education
Abilene, TX	96.32	36.54	17.28	49.29
Akron, OH	47.31	69.68	86.11	71.95
Albany, GA	86.12	28.02	32.01	26.62
Albany-Schenectady-Troy, NY	25.22	82.71	52.97	99.43
Albuquerque, NM	44.48	84.13	90.65	71.67
Alexandria, LA	92.36	42.49	19.26	11.61
Allentown-Bethlehem-Easton, PA	33.72	66.57	29.46	63.45
Altoona, PA	61.76	26.91	12.18	1.69
Amarillo, TX	96.89	60.05	28.32	54.1
Anchorage, AK	15.87	84.41	76.48	41.35
Ann Arbor, MI	7.37	15.86	77.33	83
Anniston, AL	93.21	7.08	7.64	21.81
Appleton-Oshkosh-Neenah, WI	54.4	70.82	79.32	47.3
Asheville, NC	54.11	54.67	54.1	59.77
Athens, GA	62.4	29.46	47.3	45.32
Atlanta, GA	39.38	98.3	99.15	82.71
Atlantic City-Cape May, NJ	30.03	66.85	62.03	20.39
Augusta-Aiken, GA-SC	77.91	35.41	63.45	46.45
Austin-San Marcos, TX	50.43	78.75	98.01	98.3