ISP 120 Final Review

You should also review the homework assignments and in-class activities.

1.  The following table list the 1998 average daily circulation of ten newspapers with the largest daily circulation in the US.

a. How many times is the circulation of the Wall Street Journal greater than the circulation of the Chicago Tribune?

b. By how many percent is the circulation of the Chicago Tribune larger than the circulation of the Chicago Sun-Times?

c. The newspaper that had the larger circulation in the world was Yomiuri Shimbun in Japan.  Its 1998 circulation was 14,532,694.  By how many percent is its circulation larger than the circulation of the Wall Street Journal?

d. The circulation of the Chicago Tribune in 1988 was 774,045. By how many percent did the circulation drop from 1988 to 1998?

2.  In the period January 2000 to March 2000, stock for Sapient Corporation, a consulting company that helps businesses put their operations on the internet, dropped 51% and then rose by 49%.  By how many percent did price change over the whole period?

3. Cigarette in the US has decreased over the last 20 years, even though the rate is still relatively high.  In 1998, 277 of every 1000 individuals in the US over the age of 12 reported that they were smoking, a 28% decrease since 1985.  What was the rate in 1985?

4. deleted

5. Carefully describe a) what the CPI is, b) how it is constructed, and c) what the meaning of actual index numbers is (e.g., the CPI in 1999 was 166.6; what does 166.6 mean?)

1. Using the CPI, add a column to the table in which you calculate defense spending for these years in constant 2002 dollars, and cut and paste the table into your word document.
2. Create an XY graph showing spending in constant 2002 dollars for the period 1960-2002.

3. In a well written paragraph describe the graph you made in c.

7. Open LeaningTowerOfPisa.xls file.  Make a linear model of this data (an X,Y scatter graph of the data with a trendline with equation and R-squared value). 

    a) What does the R-squared value tell you about the data.  

    b) Use the equation to make a prediction for the size of the lean in 2002.  How much confidence do you have in the prediction?  What factors affect your confidence?  

    c) In what year was the size of the lean 0 meters?  How much confidence do you have in the prediction?

8. Carbon dioxide emissions from the burning of fossil fuels is almost surely a cause of global warming.  One of the difficulties in negotiating a treaty for the reduction of carbon dioxide emissions is the discrepancy in emission levels between developing and developed nations.  For example, in 1999, Brazil emitted 89 million metric tons of carbon into the atmosphere, while Canada, a much less populous country, emitted 151 million metric tons.  Brazil’s emissions, however, are growing at 4.1% per year, while Canada’s are growing at 0.8%.

1. In Excel, make an exponential model for Brazil’s and Canada’s carbon emissions.
    

2. Using your model, predict when Brazil’s emissions will exceed Canada’s.
    

3. How much confidence you have in your prediction in b?
    

4. Find formula for the exponential function which models Brazil’s emissions (using 1999 as year 0).
    

5. Using the formula for Brazil’s model, predict Brazil’s emissions in 2010.

9. In 1994, 24 samples from the archeological site at Oslonki, Poland were dated using carbon 14.  The archeological site is significant for the large quantities of copper implements and jewelry found there.  One of the samples had 47.8% of the carbon 14 that would normally be present in a living organism.  Approximately, how old is the sample?  (Carbon 14 decays approximately 1.202% every 100 years.) Please include the Excel table you used to calculate your answer; if you didn't use an Excel table to calculate your answer, briefly describe your calculation.

10. You deposit $2500 in a savings account yielding 4.7% compounded quarterly. 

a. If no money is withdrawn for 8 years, what will be value of the account.

b. How long will it take for this account to double in value?

c.  What is annual percentage yield of this account?

11. In order to buy a house, you take out a 30 year loan for $180,000 at an interest rate of 6.5%.

a. What is your monthly payment?

b. What are your total payments over the entire term of the loan, assuming that you will make no prepayments of any kind?

c. How much interest will you pay over the entire term of the loan?

d. Make an amortization table for this loan, showing the balance for each month and the interest for each month.

e. Using your amortization table, determine approximately how much interest you save over the term of the loan if you paid $1200 each month instead of $1137.72.

12. Richter scale values (R) are related to earthquate intensities (I) by the following formula:

R = log(I)

a. What is then intensity of an earthquake that measures 4.2 on the Richter scale?

b. What is the Richter value of an earthquake that has an intensity of 13,857,300?