The following steps need to be put into an Excel spreadsheet

profiletutor4helpyou
question.docx
Home>Mathematics homework help>Numerical analysis homework help> The following steps need to be put into an Excel spreadsheet

Some information about auto theft rates (number of auto thefts per 100,000 population) for a sample of 178 cities in two different years is summarized below. Express the statistical information in words. What changes were there in the overall shape of the distribution of this variable? In central tendency? In dispersion?

1990 2010

Mean 150.32 125.17

Median 117.17 123.01

Standard Deviation 12.23 7.01