Week 1 Assignment

Question 1

The following information was reported after a baking competition in Missouri.

Name

Ranking

Residence

Age

Current

Marital Status

Number of Children

Chloe Fort

1

Independence

22

married

0

Manny Hill

2

Belton

31

single

1

Carlos Sanchez

3

Kansas City

62

single

3

Lana Tyler

4

Jefferson City

55

married

6

Amos Orchard

5

St. Louis

47

single

2

Zoe Lane

6

Kearney

25

single

2

Cade Jenkins

7

Liberty

66

married

8

Stone Walker

8

Concordia

18

single

0

1. How does the textbook define “element?” Name THREE elements in the above data set.

2. How does the textbook define “variable?” Name TWO variables in this data set.

3. How does the textbook define “observation?” Provide the observation for Stone Walker.

4. Ranking, age, and number of children are all numbers, but they are NOT all quantitative. Why not?

5. List all categorical variables on the chart.

Question 2

A sample of the ages of 12 employees of a company is shown below.

**20 30 30 30 50 60**

**30 30 20 20 40 60**

Create a dot plot from this data. Make sure that

The ages are on the x axis.

The frequency is on the y axis.

Dots are stacked like the snowballs of a snowman.

There are both a strong title and axis labels.

Question 3

The following data shows the price of PAO, Inc. stock over the last eight months.

Month

Price ($)

1

2.15

2

2.22

3

2.25

4

2.40

5

2.52

6

2.53

7

2.59

8

2.70

1. In Excel, develop a scatter diagram and with a trendline for the points. Trendlines (linear) can be made by creating a scatter diagram in Excel and then clicking the green plus sign that appears outside the upper righthand corner of the graph. Remember strong titles, axes labels etc.

2. Do trendlines go through every point on the graph? Why or why not?

3. What do trendlines tell us?

4. According to the trendline, What kind of relationship exists between stock price and time (negative, positive, or no relation)?

Week 1 Assignment

Question 1

The following information was reported after a baking competition in Missouri.

Name

Ranking

Residence

Age

Current

Marital Status

Number of Children

Chloe Fort

1

Independence

22

married

0

Manny Hill

2

Belton

31

single

1

Carlos Sanchez

3

Kansas City

62

single

3

Lana Tyler

4

Jefferson City

55

married

6

Amos Orchard

5

St. Louis

47

single

2

Zoe Lane

6

Kearney

25

single

2

Cade Jenkins

7

Liberty

66

married

8

Stone Walker

8

Concordia

18

single

0

1. How does the textbook define “element?” Name THREE elements in the above data set.

2. How does the textbook define “variable?” Name TWO variables in this data set.

3. How does the textbook define “observation?” Provide the observation for Stone Walker.

4. Ranking, age, and number of children are all numbers, but they are NOT all quantitative. Why not?

5. List all categorical variables on the chart.

Question 2

A sample of the ages of 12 employees of a company is shown below.

**20 30 30 30 50 60**

**30 30 20 20 40 60**

Create a dot plot from this data. Make sure that

The ages are on the x axis.

The frequency is on the y axis.

Dots are stacked like the snowballs of a snowman.

There are both a strong title and axis labels.

Question 3

The following data shows the price of PAO, Inc. stock over the last eight months.

Month

Price ($)

1

2.15

2

2.22

3

2.25

4

2.40

5

2.52

6

2.53

7

2.59

8

2.70

1. In Excel, develop a scatter diagram and with a trendline for the points. Trendlines (linear) can be made by creating a scatter diagram in Excel and then clicking the green plus sign that appears outside the upper righthand corner of the graph. Remember strong titles, axes labels etc.

2. Do trendlines go through every point on the graph? Why or why not?

3. What do trendlines tell us?

4. According to the trendline, What kind of relationship exists between stock price and time (negative, positive, or no relation)?