# simple excel assignment due in 2 hours

.

Now that you have Excel, you’re going to need to use it. If you have no idea how, see the document “Intro to Excel” on the course webpage.

You have three major goals in this exercise. First, you’re going to convert the numbers in a data table from one unit to another. Second, you’re going to make a plot of your converted numbers. Third, you’ll use your plot to interpolate between the data points; that is, use the numbers that are there to figure out one that isn’t. A person buys five different quantities of apples on five different days. Each time they pay a slightly different price per pound. The pounds they bought and the price in dollars are listed in this table. Enter these data into a blank Excel spreadsheet. Each data piece should be in a separate cell, just like the table below. Give each of your columns a title (again, like the table).

When you enter numerical data, just enter the numbers and no units. This will let you perform calculations on them later.

Pounds

Apples

Price

(U.S. Dollars)

1.30

2.31

2.11

3.43

3.69

7.31

4.20

7.60

5.12