Management
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)?
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
