Week 1 AssignmentQuestion 1The following information was reported

Week 1 AssignmentQuestion 1The following information was reported after a baking competition in Missouri.  NameRankingResidenceAgeCurrentMarital StatusNumber of Children Chloe Fort1Independence22married0 Manny Hill2Belton31single1 Carlos Sanchez 3Kansas City62single3 Lana Tyler4Jefferson City55married6 Amos Orchard5St. Louis47single2 Zoe Lane6Kearney25single2 Cade Jenkins7Liberty66married8 Stone Walker8Concordia18single01. 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 60Create a dot plot from this data. Make sure thatThe 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.  MonthPrice ($) 12.15 22.22 32.25 42.40 52.52 62.53 72.59 82.701. 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 AssignmentQuestion 1The following information was reported after a baking competition in Missouri.  NameRankingResidenceAgeCurrentMarital StatusNumber of Children Chloe Fort1Independence22married0 Manny Hill2Belton31single1 Carlos Sanchez 3Kansas City62single3 Lana Tyler4Jefferson City55married6 Amos Orchard5St. Louis47single2 Zoe Lane6Kearney25single2 Cade Jenkins7Liberty66married8 Stone Walker8Concordia18single01. 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 60Create a dot plot from this data. Make sure thatThe 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.  MonthPrice ($) 12.15 22.22 32.25 42.40 52.52 62.53 72.59 82.701. 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)?