Financial Markets and Institutions (2-downloads)

www.pearsonhighered.com/mishkin_eakins

) will maintain an updated list of cur-

rent URLs for your reference.

Collecting and Graphing Data

The following Web exercise is especially important because it demonstrates how to

export data from a Web site into Microsoft Excel for further analysis. We suggest

you work through this problem on your own so that you will be able to perform this

activity when prompted in subsequent Web exercises.

---

10

Part 1 Introduction

Web Exercise

You have been hired by Risky Ventures, Inc., as a consultant to help the company ana-

lyze interest-rate trends. Your employers are initially interested in determining the

historical relationship between long- and short-term interest rates. The biggest task

you must immediately undertake is collecting market interest-rate data. You know

the best source of this information is the Web.

1. You decide that your best indicator of long-term interest rates is the 10-year

U.S. Treasury note. Your first task is to gather historical data. Go to