Exam 1: Take Home (Part 1)

September 8, 2015 at 10:19 pm  •  Posted in f15-busad265 by  •  2 Comments

Part 1 – Take Home Instructions

Due date: Wed Sep 16th

Download: GDP-Fertility Data

The last digit of your PID determines which column of data you will use for the exam. If your PID ends in 3 your assigned column is “Dataset 3”. If your PID ends in 4 your assigned column is “Dataset 4”. And so on.

Your assigned column has either a 1 or a 0 in each row. You will include each Country listed with a 1 in your assigned column. Please omit the countries with a 0.

Each country is part one of 3 Regions: (1) the Americas, (2) Europe, Middle East & Africa (EMEA) and (3) Asia Pacific. Use the “Filter” or “Sort” feature to separate your countries by region.


You will analyze the GDP Per Capita data for each of the three regions separately. So, you must complete the following steps 3 times, once for each region.

  1. Create a Stemplot
  2. Create two Histograms using a different “Bucket size” for each
  3. Calculate Quartiles Q1, Q2 and Q3
  4. Create a Box Plot
  5. Calculate the Mean, Median and Standard Deviation

Region Comparison

  • Create a 1-page visual summary for comparing all 3 regions.

Executive Summary

  • Write a 1 page “Executive Summary” analyzing observed regional differences and similarities. What story are the data telling you?

Print Copy

In total, you will prepare 3-5 pages (no more than 5) and submit a print copy in class on Wed Sep 16th. Print copies should be well organized, neat and easy to read. You may use Google Sheets or Excel to complete the analysis. You may also complete the work by hand if you prefer. Either way, appearance, legibility and written communication all count. If your report is sloppy or difficult to read your grade will suffer.

Leave a Reply