MEEEEEEOOOOOWWWW-Extra Credit

2 10 2010

Today’s assignment is all about the box and whiskers!

You need to click here. If that site doesn’t work, just copy and paste the web site:

www.eia.doe.gov/emeu/steo/realprices/real_prices.xls

You are going to download a file that is going to take awhile.

The file is gas prices from today, back until a way long time ago. Like 2008. Even back to when there were dinosaurs on Earth, like 1920.

I doubt many of you have much experience with Microsoft Excel, so here are your instructions once you open the file:

Look at the very bottom of the Excel file. There are tabs at the bottom. Click the one called Gasoline A (It’s the 2nd tab).

Now you have a graph. You will need to put your mouse over the blue line, and we can get the actual price of gasoline for each year. Here are the years I want you to write down the prices of gasoline:

1920,1930, 1940, 1960, 1970, 1980, 1990, 2000, 2002, 2006 and 2008. Label and write these down on your paper.

Next, all you have to do is make a box and whiskers of the numbers you found.

Lastly, you are required to reflect- what did you notice about the gas prices? Did they go up considerably over a certain time period? What reasons can you think of that would cause that, if it did happen? I need to see 3-5 sentences.

Grading-

up to 3 points for getting the correct numbers from the chart

up to 5 points for correcting creating the box and whiskers plot

up to 2 points for reflecting in 3-5 sentences

Advertisement

Actions

Information

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s




Follow

Get every new post delivered to your Inbox.