Using the data in the Excel file Demographics, determine if a linear relationship exists between unemployment rates and cost of living indexes by constructing a scatter chart. Visually, do there appear to be any outliers? If so$,$ delete them and then find the best$-$fitting function using the Trendline tool. What would you conclude about the strength of any relationship?

Demographic Data

$\backslash$table$[[$Metropolitan Area,State,$\backslash$table$[[$Unemploymen Cost of Living$],[($July $1999)]],],[$ANCHORAGE$,$AK$,3\mathrm{.}60\%,125\mathrm{.}90],[$BIRMINGHAM$,$AL$,2\mathrm{.}70\%,99\mathrm{.}10],[$HUNTSVILLE$,$AL$,2\mathrm{.}70\%,95\mathrm{.}20],[$MOBILE$,$AL$,3\mathrm{.}60\%,91\mathrm{.}80],[$MONTGOMERY$,$AL$,2\mathrm{.}90\%,92\mathrm{.}40],[$LITTLE ROCK,AR$,3\mathrm{.}20\%,87\mathrm{.}20],[$PHOENIX$,$AZ$,2\mathrm{.}60\%,99\mathrm{.}90],[$TUCSON$,$AZ$,2\mathrm{.}30\%,99\mathrm{.}70],[$BAKERSFIELD$,$CA$,12\mathrm{.}50\%,106\mathrm{.}10],[$FRESNO$,$CA$,13\mathrm{.}80\%,105\mathrm{.}80],[$LOS ANGELES,CA$,6\mathrm{.}30\%,122\mathrm{.}00]]$