Unit I: Assignment Download

 

Name:

Date:

 

Answer your questions on the NCTM Standards Here:

 

(Insert your answers here)

 

Chapter 1:

 

Section 1.1-

 

You may want to refer to the introduction to Excel on the web at http://mstemac4.ed.uiuc.edu/courses/ci300ps/Excel.html if you are a new Excel user.

 

Some results of the 2002 Winter Olympics are shown here, by kind of medal won. Cut and paste the data below into Excel, and save the file for future use.

 

Medal Count: by Country

 

 

Gold

Silver

Bronze

Total

1

Germany

12

16

7

35

2

United States

10

13

11

34

3

Norway

11

7

6

24

4

Canada

6

3

8

17

5

Russia

6

6

4

16

6

Austria

2

4

10

16

7

Italy

4

4

4

12

8

France

4

5

2

11

9

Switzerland

3

2

6

11

10

Netherlands

3

5

0

8

11

China

2

2

4

8

12

Finland

4

2

1

7

13

Sweden

0

2

4

6

14

Croatia

3

1

0

4

15

South Korea

2

2

0

4

16

Estonia

1

1

1

3

17

Britain

1

0

2

3

18

Bulgaria

0

1

2

3

19

Australia

2

0

0

2

20

Spain

2

0

0

2

21

Czech Republic

1

0

1

2

22

Japan

0

1

1

2

23

Poland

0

1

1

2

24

Belarus

0

0

1

1

25

Slovenia

0

0

1

1

 

Reference:  http://www.usatoday.com/olympics/saltlake/main_index_results.htm

 

Use Data Sort to find the top five countries in terms of number of gold medals won. Find three countries whose rankings are improved when this is done. Find three countries whose ranking goes down.

 

(Insert you answer here)

 

Also do exercise 7.

 

(Insert you answer here)

 

 

Section 1.2-

 

Read Section 1.2 and do these exercises

 

Stem and leaf plots:

The table below is a stem and leaf plot. It shows the weekly earnings, in dollars, of a group of students.

 

 

STEM  LEAF

 

1            6, 7

 

2            9, 9, 9, 2, 7, 7, 8, 3, 5

 

3            4, 5, 1, 2, 6, 6, 3, 9

 

4            6, 9, 7, 7, 7, 5, 9, 8, 6, 3, 0, 3, 4, 8, 3

 

5            3, 5, 3, 7, 7, 9

 

6            3, 2, 2, 4, 4, 0, 0

 

7            7, 4

 

Key: “1 6” means $16.00.

 

 

Stem and leaf plots tend to be available in more advanced statistical packages (such as SAS or SPSS). For our purposes, we can simply create stem and leaf plots as a word processing document like the one that is shown above.

 

 

You will answer these questions below:

 

1. What is the smallest amount of student weekly earnings in the above plot? What is the largest amount?

 

(Insert you answer here)

 

2. Make a new stem and leaf table by ordering the remaining rows. The median of a set of data is the middle score. Find the median weekly earnings of the students in the stem and leaf table.

 

(Insert you answer here)

 

3. The mean of a set of data is the ordinary arithmetic average. Just add up the data and divide by the number of data points. Find the mean of the weekly earnings of the students.

 

(Insert you answer here)

 

Now do exercises 4 and 6.

 

(Insert you answers here)

 

 

Section 1.3 Pie Charts

 

Do exercise 4.

Use Excel to construct a circle graph for all employees and a separate circle graph comparing 9:00 to 9:30. Paste these into this Word document. 

 

(Insert you answer here)

 

 

Section 1.4 Frequency Histograms

 

Do exercises 3 and 6 by following the instructions in the Calculator Supplement. For exercise 6, you should enter the left endpoint of each interval in L1 and the frequency in L2, and then set “Freq” to L2. Use GraphLink to download your histograms to this document for handing in. Don’t forget to answer part b of each problem!

 

(Insert you answers here)

 

Section 1.5 Density Histograms

 

Read section 1.5 and do exercise 2.

 

(Insert you answer here)

 

Section 1.6 Misusing Statistics

 

Read Section 1.6 and do exercise 8.

 

(Insert you answer here)

 

 

Teaching Unit

Prepare a teaching unit for a topic of your choice from Chapter One.

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 1 of the Statistics Module.