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
4 months agoSkye
4 months agoGlenna
4 months agoMiesha
4 months agoBen
5 months agoGerald
5 months agoMerilyn
5 months agoSharan
5 months agoShayne
5 months agoDacia
5 months agoMelodie
5 months agoDorian
5 months agoLashonda
5 months ago