Calculated attributes only look at the current record - e.g. if you are creating this on a project object instance, then only the project's own fields are available.
Aggregated calculated attributes, if created on a project, allow you to perform a calculation over it's subobject records. Like a count of team members, or the earliest task start date (which may not be equal to the project start date), things like this.