Assignment 10

For the answers which you are asked to type below, please create one MS Word document, which has the name:
ma103Assignment10YOURNAME. Saving in MS Word should automatically give this file the proper extension of .doc or .docx. You should upload this file in Moodle prior to the deadline. Clearly label which Activity and problem you are answering. It might be helpful to put in a "Page Break" between the answers for Activities, where appropriate.

Anywhere below, when you are asked to paste a graph created in Excel into your Word document, you may simply paste the graph. You do NOT need to import the entire worksheet associated with it.

Wednesday, 19.Mar
A. Read Topic 11 in the textbook, and work the assigned Exploration problems as listed for each day on the course web-site.

B. Activity 11.1 The specific questions for Activity 11.1 are on pg. 503 - 508 in your textbook, where you can find directions for using Excel 2003. If you are using Excel 2007, you can find directions on how to use it for Activity 11.1 at the link Excel 2007 Instructions for Activity 11.1

• Type your answers for #1.
• Type your answer for #2, and give any additional cutoffs if you used them.
• For #3, retrieve the data file, EA11.1 Cities.xls, as specified, and save it to your U: drive.
• For #4, devise your population ranking as specified, and briefly explain your rationale. It does not need to be linear or equate to a function, but you should assign the rankings in some systematic way.
• For #5, devise your temperature ranking as specified, and briefly explain your rationale. It does not need to be linear or equate to a function, but you should assign the rankings in some systematic way.
• Follow the directions in #6.
• For #7, devise your rankings for the three additional characteristics you chose in #6, and briefly explain your rationale for each. They not need to be linear or equate to a function, but you should assign the rankings in some systematic way.
• For #8, pick the weights for your chosen characteristics, type them into your MS Word document, and explain your rationale.
• For #9, calculate the weighted sum as specified in the directions. Copy and paste your worksheet into your MS Word document. You may delete a few of the given columns (population, unemployment, etc.) to help it fit.
• Type your answers for #10 - #13.

Monday, 21.Mar
C. Read Topic 14 in the textbook, and work the assigned Exploration problems as listed for each day on the course web-site.

D. Activity 14.1 The specific questions for Activity 14.1 are on pg. 543 - 550 in your textbook, where you can find directions for using Excel.

• For #1 - #2, follow the directions and type your answers, using the file, EA14.1 State Population.xls.
• Follow the directions for #3.
• Type your answer for #4.
• You should do #5 and #6 (similar examples will have been discussed in class), but you do NOT need to include the answers in your MS Word document.
• For #7 and #8, follow the directions and type your answers. In addition, copy and paste the resulting spreadsheet into your MS Word document.
• For #9 and #10, follow the directions and type your answers.
• You should do #11 (similar examples will have been discussed in class), but you do NOT need to include the answer in your MS Word document.
• For #12, follow the directions.
• Type your answer for #13.
• For #14, follow the directions and type your answer.
• For #15, follow the directions and type your answers. In addition, copy and paste the resulting spreadsheet into your MS Word document. For formatting purposes, you only need to include three columns: State, Seats Using Hamilton's Method, and Seats Using Lowndes' Method.
• Type your answers for #16 and #17.