Answer the following question: Formulate an answer to this elaborate question: What city in the Albany Metropolitan Statistical Area is closely associated with hymn writer Horatio Gates Spafford?
Answer:
Troy, New York