 |
Mathematical and Technological Literacy I |
|
|
|
Mathematical and Technological Literacy I |
|
Please do the following at the beginning of every computer activity.
a. Open a new Word document.
b. Click on the Office Button in the upper left corner, then slide over "Save As". Choose either "Word Document" to save your document as a Word 2007 document or "Word 97-2003 document" to save your document in an early version of Word. If you are not sure which to choose, you should use "Word 97-2003 document". Save the document to the desktop by setting the "Save in" textbox to "Desktop". (Saving to the desktop makes it easy to retrieve your work when you are finished.) Your file name should be entitled something like "Group Activity 1". Last, confirm the save as type in the last box. (*.docx) is the suffix for a Word 2007 document. (*.doc) is the suffix for early versions of Word.
Learning Goals for this Activity
Activity
Open the file CarsAndTrucks_By_Year1970-MostRecent.xls contains data from the Bureau of Labor Statistics number of cars and small trucks on the road from 1970 through 2007.
a. Make an X-Y scatter plot of the data including the trendline and R-squared value. For instructions click here. Note that Excel will, in most cases, put a legend on your graph by default. When there is only one data series (as here), you don't need a legend, and it really should be removed. Paste this chart in your Word document.
b. Predict how many cars and trucks there will be in the US in the year 2012 using the slope and intercept functions in Excel. We recommend using the slope and intercept functions when you are modeling because the equation that Excel puts on the graph is often rounded to only a few decimal places. Using the equation that Excel puts on the graph can lead to aberrant results because of this rounding.
To calculate your prediction, type "slope" in cell B32 and "intercept" in cell B33. (You can actually choose any empty cell that is convenient.) Next, in the neighboring cell, type "=slope(". At this point, Excel will prompt you to select the y-values and the x-values with your mouse.
After selecting the appropriate y-values and x-values, your screen will look like:
Finally, type a closing parenthesis and press enter.
Repeat the process with the "intercept" function:
When are done, you will have the slope and intercept of the least squares best fit line in cells C31 and C32 respectively:
"Slope" and "intercept" are examples of Excel's built-in functions. You can see a list of all the functions available by clicking the "insert function" button
This library of functions is very useful, and we will be using other functions in this library during the course.
To make your prediction, type "=C32*2012+C33" in a cell somewhere. Type your prediction (expressed in the appropriate units) into your Word document.
c. You can double check your prediction in b
using by visually extending the trendline you made in part b. Here is how
you do this: Right click on the trendline and then choose "Format Trendline."
Then click on the Options tab. In the center you will find a box entitled
"Forecast." In the "Forward" box, enter 5 to predict the number of
passenger cars and trucks there will be in 2012. Reading the graph, you can
get an approximate prediction that should be very close the prediction you
got with your equation. Paste the graph with your extended trendline in
your Word document.
Visually extending the trendline is a good check on your algebraic
calculations, and it is highly recommended. Occasionally, the
rough, approximate prediction one can make from the extended trendline on
the graph is sufficient to the task at hand; however, most often, we use the
predictions obtained algebraically from the equations.
d. How much confidence do you have in the prediction you made with your model? Use the language that we discussed in class.
e. Calculate when there were no passenger cars and trucks in the US using the regression equation. Probably the easiest way to accomplish this task is use algebra on a piece of paper. Type your result in your Word document. As in part c, you can also extend the trendline "Backward" as a good check on your work.
f. About when were cars actually invented? (If you don't know, do an Internet search.) In light in the facts about when cars were really invented, how accurate was your model in predicting when there were no cars? Explain why the model performed so badly even though it fits the existing data rather well.
g. Predict the number of cars in US in 2050. How much confidence do you have in your prediction? Explain why.
2. Open the file Coal_Consumption2004.xls containing data from the U.S. Energy Administration. The unit of measure here is quads, a standard measure standing for quadrillion BTU's. (A British Thermal Unit is a unit of energy, the amount of energy needed to raise 1 pound of water 1 degree Fahrenheit when the water is about 39.2 degrees Fahrenheit.)
a. Make an X-Y scatterplot of the data. Add a trendline, including the equation of the line and the R-squared value. Paste this chart into your Word document.
b. Predict coal consumption in the year 2008 using the regression equation and double check your prediction by extending the trendline on the graph. Type your answer and paste your graph in you Word document.
c. Using the equation of the model, predict when coal consumption reach 30 quads?
d. In a short well-written paragraph, discuss social, political, or physical changes which might affect the accuracy of predictions using this model.
3. Linear models occur frequently in real settings not accompanied by data. For each of the described setting, give a formula for the corresponding linear model
a. A calling card offers a price of $0.23 cents per minute at any time during the day with a monthly service charge of $1.00. Express the monthly cost as a function of minutes called.
b. At 0 degrees Celsius, the speed of sound is 350 meters per second and it increases by 0.2 m/s for each increase of 1 degree Celsius. Express the speed of sound as a function of temperature in Celsius.
c. A helicopter takes off from the roof of a building that is 200 feet about the ground. The altitude of the helicopter increases by 150 feet each minute. Express the height of the helicopter as a function of minutes after it starts rising.
d. A car rental agency charges $29.00 plus 6 cents per mile for a one day rental. Express the cost of renting the car as a function of miles driven.
Please do the following at the completion of every computer activity.
a. Save your work to the desktop and close all open windows.
b. Print the Word document, have each group member sign the document, and turn it in.
c. Make sure at least one member of the group saves the completed activity.
Savings your work...
a. To save the document to a disk or flash drive, follow these steps. 1. Save the completed activity to the desktop. 2. Insert the disk or drive. 3. Close all windows. 4. Double click on "My computer" on the desktop. 5. Double click on drive A or E (sometimes D). This should open a window that displays any saved folders on your disk. If this window is maximized (meaning you can't see any of the desktop), click the icon in the middle at the top right corner of the screen to "restore down". 6. Click and drag the icon for your saved Activity 1 from the desktop to the window for your disk. Release. In a moment it will save your activity to the disk. 7. When the work has been saved successfully saved, delete it from the desktop either by right clicking on the icon then clicking on delete or by clicking and dragging the icon into the recycle bin.
While this is not the only way to save to a disk, I have found that is it the most efficient, effective, and safest way.
b. Another option for saving work is to send it to yourself in an email message as an attachment. To do this, follow these steps. 1. Save the completed activity to the desktop. 2. Close all windows except for Internet Explorer. 3. Access your email account. 4. Open a new message and put "Activity 1" in the subject line. 5. Click on "add attachment" and search on the desktop. Choose your saved "Activity 1". 6. Send the message to yourself and/or other group members. You should now be able to retrieve the activity via that message. The process for attaching files varies among internet providers, so if you have questions, just ask.
