Unit III: Assignment
Download
Name:
Date:
Chapter Three:
Relationships
Section 3.1: Scatterplots
Spreadsheet activity:
Copy and paste
these data into Excel and create a scatterplot (see
directions for regression in Section 3.3, steps 1-3, if you are not sure how to
do this). Then copy and paste the
scatter plot into your word-processing document for handing in.
Hint: To simplify your graph,
express the car weights in hundreds of pounds, rounded. For example, Acura
Integra will be 27.
Auto Weights and Mileage
|
Car |
Weight (pounds) |
City MPG |
|
Acura
Integra |
2705 |
25 |
|
Buick
LeSabre |
3470 |
19 |
|
Cadillac
Seville |
3935 |
16 |
|
Chevrolet
Lumina |
3195 |
21 |
|
Chevrolet
Astro |
4025 |
15 |
|
Dodge
Colt |
2270 |
29 |
|
Ford
Festiva |
1845 |
31 |
|
Ford
Aerostar |
3735 |
15 |
|
Geo
Metro |
1695 |
46 |
|
Hyundai
Scoupe |
2285 |
26 |
|
Lincoln
Continental |
3695 |
17 |
|
Mazda
626 |
2970 |
26 |
|
Mitsubishi
Mirage |
2295 |
29 |
|
Pontiac
Firebird |
3240 |
19 |
|
Subaru
Justy |
2045 |
33 |
|
Volvo
240 |
2985 |
21 |
|
Mean |
2899 |
24.25 |
Source: Journal of Statistical Education (1993)
online data sets.
(Insert your scatterplot here)
Do exercises 7
and 8.
(Insert you answers here)
Go
to http://istics.net/stat/Correlations/ and explore the materials that Professor Marden at the University of Illinois has developed. There
are statistics games and data sets that you may want to use with your class.
Go
to the link about correlations, and play the Guessing Correlations game. An
important part of statistics is making guesses about a given set of data.
Hit “New Plots,” and match the correlation
coefficient to the appropriate graph. Click on “Answers” to see how many you
got right. Do this at least 5 times.
Now
write a couple sentences to tell us what you think about Guessing Correlations.
(Insert your answer here)
Find the correlation of the
above car data using Excel.
CORRELATION IN EXCEL:
1)
Enter the data,
and then click on the cell where you’d like the correlation to appear.
2)
Type the
following: =CORREL(
3)
Select the values
of your X variable (i.e. B2:B17)
4)
Type a comma “,”
and then select the values of your Y variable (i.e. C2:C17).
5)
Close the
parentheses, hit Enter/Return, and you’re done!
(Insert
you answer here)
Section 3.3: Regression
Do exercise 3
using your graphing calculator. If your calculator does not show an r-value, go
to the CATALOG menu and turn Diagnostics to “On”.
(Insert you answer here)
Do exercise 4 using Excel.
REGRESSION IN EXCEL:
1)
Enter the data in
the first two columns.
2)
Highlight these
columns and go to Insert -> Chart…
3)
Click on XY
(Scatter) and then Finish (or you can hit Next > if you want to customize
your plot).
4)
Select your
chart, and one of the top menu items should now be Chart. Go to Chart -> Add
Trendline…
5)
Linear Regression
should already be selected, so click on Options at the top, and then on
“Display equation on chart.” You can also select “Display R-squared value on
chart” if that interests you.
6)
Click ok, and
you’re done!
(Insert your scatterplot with the regression line here)
Now answer the other
questions in exercise 4:
a.
Identify the
outlier. (Insert your answer here)
b.
Find the
correlation of these data. (Insert your answer here)
d.
(Insert your
answer here)
Section 3.4
Read section 3.4 and do
exercises 2 and 3.
(Insert you answer here)
The Dead Grandmother
Syndrome:
Read the article found at http://www.easternct.edu/~adams/Resources/Grannies.pdf,
and then write a paragraph answering the following questions:
Ø What is wrong with Dr.
Adams' argument?
Ø How are statistics misused
in this article?
Ø What are some possible
confounding variables?
(Insert you answer here)
Data Collection and
Analysis Activity:
Question: Is there a
relationship between amount of television watched and amount of physical
activity done? Do people who watch a lot of TV not do as much physical
activity?
To answer this question,
do the following:
1. Write down the number
of hours a week you watch TV and the number of hours you do physical activity.
2. If you have access to a
high school or college classroom, take a survey of the students to record their
hours of TV watching and hours of physical activity per week. If you do not
have access to a classroom of students, survey at least 25 of your friends.
3. Make a scatterplot of your data with hours of TV watched on the
x-axis and hours of physical activity on the y-axis.
4. Find the correlation
coefficient of your data.
5. Find the equation of
the line that best fits the data using the least squares method.
6. Does watching TV cause
one to be less active? Explain.
(Insert your answers to
the above questions here)
Teaching Unit
Prepare a teaching unit
for a topic of your choice from Chapter Three.
Each unit must include at least one calculator activity and one computer activity.
Now
submit this document and your teaching unit through the Module Hand In System using your MTL login and password.
You
are finished with Unit 3 of the Statistics Module.