USING EXCEL

AND

USING TABLE $6\mathrm{.}4,$ ON SUDES $77,$ LECTURE $1$

DIVIDE THE DATA BY CONTINENT OF ORIGIN, SIX GROUPS

$\backslash$table$[[,,$LETIER$],[$NORTH AMERICA,A$],[$SOUTH AMERICA,B$],[$AFRICA$],[$MIDEAST$,$C$],[,$REST OF CONTINENT,D$],[$ASIA$],[,$AUSTRAUA,E$],[,$REST OF CONTINENT,F$]]$

SKIP EUROPE

CREATE A PLOT OF KW VS API $($API IS THE INDEPENDENT VARIABLE$)$

$($YOU SHOULD HAVE SIX UNES$)$

FIT THE DATA FOR EACH UNE WITH A TREND UNE AND COPY THE EQUATION OF THE FIT

ARE THE SLOPE OF EACH FIT COMPARABLE, SAME VALUE OR ARE THEY DIFFERENT

CREATE A SIMILAR PLOT AS $1$ BUT IN THIS CASE THE INDEPENDENT VARIABLE IS KW AND API IS THE DEPENDENT VARIABLE WHAT CAN YOU OBSERVE AS THE RANGE OF API FOR A NARROW SET OF KW VALUES