excel problem, homework help

In this problem there

is
2

assignment
: extend and Analyze.

i
provide

data file
for both

assignment
. please look at the attachnment