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 office on Isla Mujeres. He explains how difficult 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
politician’s Uncle?
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?
Salary of
island
president
Island
infrastructure
investment
Per
capita
income
Municipal tax
collected
Years
President
1963–1966
A
120,000
15,000
60,000
1900
1967–1970
A
186,000
15,000
100,000
2100
1971–1974
A
250,000
18,000
140,000
2500
1975–1978
B
150,000
31,000
60,000
1300
1979–1982
B
130,000
39,000
54,000
1000
1983–1986
C
230,000
24,000
180,000
1800
1987–1990
C
310,000
26,000
230,000
2300
1991–1994
C
350,000
34,000
225,000
3400
1995–1998
C
450,000
43,000
320,000
4100
1999–2002
D
830,000
68,000
500,000
4900
2003–2006
D
1,200,000
70,000
790,000
5300
2007–2008
D
890,000
72,000
530,000
6100
represents a reminder that in Ex 2.3 numbers are in terms of millions of dollars (U.S.).
 
Search JabSto ::




Custom Search