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