Microsoft Office Tutorials and References
In Depth Information
major tourist destination for many foreigners and Mexicans. One evening, while
vacationing there, you are dining in a local restaurant. A young man seated at
a table next to yours overhears you boasting about your prowess as a quantita-
tive data analyst. He is local politician that is running for the position of Island
President, the highest ofﬁce on Isla Mujeres. He explains how difﬁcult it is to
unseat the Murillos, but he believes that he has some evidence that will per-
suade voters that it is time for a change. He produces a report that documents
quantitative data related to the island’s administration over 46 years. The data
represent 11 four year presidential terms and the initial two years of the current
term. Presidents are designated as A–D, for which all are members of the Murillo
clan, except for B. President B is the only non-Murillo to be elected and was the
uncle of the young politician. Additionally, all quantities have been converted to
2008 USD (US Dollars)
a. The raw data represent important economic development relationships for
the Island. How will you use the raw data to provide the young politician
information on the various presidents that have served the Island? Hint—
Think as an economist might, and consider how the president’s investment in
the island might lead to improved economic results.
b. Use your ideas in a. to prepare a graphical analysis for the young politician.
This will require you to use the raw data in different and clever ways.
c. Compare the various presidents, through the use of graphical analysis, for
their effectiveness in running the island. How will you describe the young
d. How do you explain the changes in Per Capita Income given that it is stated in
2008 dollars? Hint—There appears to be a sizable increase over time. What
might be responsible for this improvement?
∗ represents a reminder that in Ex 2.3 numbers are in terms of millions of dollars (U.S.).