ECON 2500
Spring 2009
Dr. Tufte
Homework 31
Due: Friday, April 17, at the start of class.
Homework 32
Due: Monday, April 20, submitted to Aplia before the start of class.
If possible, answer questions in the space provided.
Homework 31 is below, and it is due Friday.
Homework 32 in on Aplia, and it is due Monday.
Homework 31
Excel does statistics two ways: with functions, and with add-ins. Functions are always
“there”, you just need to figure out which one to use. To use the add-in, go through the
same procedure we’ve used to load Solver, and at the last step select “Analysis Tool-
Pak”. You can use whichever you prefer; the great thing about the Analysis Tool-Pak is
that it does a bunch of things at once, which saves you time.
For homework 31, you should go to the class folder on the G drive and download the
spreadsheet called “2009_S_E2500_Homework_31.xlsx”.
Immediately change the name of the file from “2009_S_E2500_Homework_31” to your
last name. Do your work in this file and e-mail it back to me (everyone’s file will have a
different name, so it will be easy for me to keep track of them).
For the first 11 questions, you can use whichever method you like, but for the last one
you have to use the Analysis Tool-Pak.
