Assignment 06

For the answers which you are asked to type below, please create one MS Word document, which has the name:
ma103Assignment06YOURNAME. 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.

Friday 15 .Feb
C. Read Topic 5 in the textbook, and work the assigned Exploration problems as listed for each day on the course web-site. You do NOT need to turn in the Exploration problems, but they are useful in preparing for the written exam.

D. Activity 5.2 The specific questions for Activity 5.2 are on pg. 441 - 445 in your textbook, where you can also find directions for using Excel.

• For #1, simply download the file, EA5.2 Major League Salaries.xls .
• For #2, you should calculate the average rate of change "by-hand," but you do NOT need to type your answer.
• For #3, follow the Excel directions to calculate the average rate of change, and then paste this spreadsheet into your Word document.
• Type your answers for #5 parts (a) thru (f).
• Hand-write a plot of the function for #6. You do NOT need to turn in this graph, but it is important for you to do it.
• Follow the Excel directions for #7 to create the graph, and paste this graph into your Word document.
• Type your answers to #8 - #11.

Monday 18 .Feb
A. Read Topic 6 in the textbook, and work the assigned Exploration problems as listed for each day on the course web-site. You do NOT need to turn in the Exploration problems, but they are useful in preparing for the written exam.

B. Activity 6.1 The specific questions for Activity 6.1 are on pg. 446 - 451 in your textbook, where you can also find directions for using Excel.

• For #1(a), type your answer.
• For #1(b), follow the Excel directions to calculate the Genie's offers, and then paste this spreadsheet into your Word document.
• Type your answers for #1(c) - #1(f).
• For #1(g), type your formula.
• For #1(h), type each sentence and fill-in the blank for each.
• For #1(i), type your answer.
• For #1(j), plot the graph in Excel and paste this graph into your Word document.
• For #2(a), type your answer.
• For #2(b), follow the Excel directions to calculate the value of the appliance, and then paste this spreadsheet into your Word document.
• Type your answers for #2(c) - #2(i).

Wednesday 20.Feb
C. Activity 6.2 The specific questions for Activity 6.2 are on pg. 452 - 458 in your textbook, where you can also find directions for using Excel 2003. If you are using Excel 2007, you can find directions on how to use it for Activity 6.2 at the link Excel 2007 Instructions for Activity 6.2.

• For #1, sketch what you think is the best-fit line for each of the four plots. You do not need to turn your sketches in, but you should type your estimate of the sign of the slopes for #1(a) - #1(c), and type your answer for #1(d).
• Similarly, for #2(a), you should draw the vertical distances to the least-squares line, but you do NOT need to turn this graph in.
• Type your answers for #2(b) - #2(d).
• For #3 and #4, use the file, EA6.2.1 Verbal SAT Data.xls to create the scatterplot, add the regression line, and then paste this graph into your Word document.
• Type your answers for #5 - #7.
• For #8, just type your prediction, you do not need to mark the graph.
• For #9, use EA6.2.2 Data Movies and Vid.xls. Create the first scatterplot (with trendline) using all the data (even the outlier), and paste this graph into your Word document.
• Use this first graph to answer #9(a) - #9(c).
• For #9(d) create another scatterplot (with trendline), this time with out the outlying data value. Paste this graph into your Word document and then type your answer.