Assignment #2

1
January 16, 2014 at 1:37 pm  •  Posted in busad360 by  •  1 Comment

Due Tue, Jan 21

As a vehicle for reviewing some of the introductory concepts, please complete the following exercises with this Excel file: ColoradoCounties.

  1. Install the Excel “Analysis TookPak” – see p 49 in the textbook for instructions.[Mac users might need to try something different.]
  2. Make a Histogram for all 5 variables.
  3. Make a Stemplot for the Per Cap Income variable.
  4. Make a Scatter Plot comparing Med HH Income to HH (household count) and Per Cap Income to Population. 
  5. Calculate Mean, Median, MAD, Variance and Standard Variation for all variables.
  6. Post #1-4 results on your blog.

Leave a Reply