Hmm, this looks like a classic elbow plot for determining the optimal number of clusters in k-means. I think I'll go with option B - 4 clusters seems like a reasonable choice based on the plot.
I think option C looks the most promising. Grouping by both dept_id and join_date seems like the right approach to get the sum of salaries for each department and join date.
Pete
5 months agoSkye
6 months agoGlenna
6 months agoMiesha
6 months agoBen
6 months agoGerald
6 months agoMerilyn
6 months agoSharan
6 months agoShayne
6 months agoDacia
6 months agoMelodie
6 months agoDorian
6 months agoLashonda
6 months ago