## Sheet1

Number of At Bats | Number of Hits | ||||||||||

51 | 19 | ||||||||||

67 | 25 | ||||||||||

77 | 30 | ||||||||||

44 | 20 | ||||||||||

55 | 23 | ||||||||||

39 | 16 | ||||||||||

45 | 18 | ||||||||||

Correlation | 0.9676250827 |

World Series: No. of Hits vs. At Bats

Number of Hits 51 67 77 44 55 39 45 19 25 30 20 23 16 18

No. of At Bats

No. of Hits

Now that you have worked with some actual data, you will use data to create and analyze a visual display commonly known as a scatter plot using Excel. You may choose one of the data sets listed below to create a scatter plot to analyze, or use a data set that you found in Unit 2. If you choose one of the data sets listed below, try to choose one not used by your classmates. If you create your own data set, make sure the data is quantitative and contains two variables. Please share in great detail what you chose as your variables, your quantitative data, and where you found the data. Data sets that you create should contain a minimum of 10 data pairs.

Datasets may be chosen from:

· Section 2.4 – exercise questions 5–14

· Review exercises (at end of Chapter 2) – questions 27–28

· Section 10.1 – exercise questions 11–27

· [*You do not need to read this section, you are just using one of the data sets to create a scatterplot, if you so choose.*]

PLEASE NOTE: You are not following the directions for any of these sections, you are just using the data sets. Use the instructions below to create and analyze your scatter plot.

For your first post, you will create a scatter plot using one of the data sets listed above, or your own data set. For instructions on creating your scatter plot, see the Excel Step-by-Step instructions on pages 104–105 of your textbook.

Post 1: Initial Response

After creating your scatter plot, attach your Excel spreadsheet or take a __snippet__ of your scatterplot to post with your responses to the following questions:

· Which variable is the independent variable?

· Which variable is the dependent variable?

· Does your scatterplot appear to have a *positive linear, negative linear, nonlinear,* or *no relationship*? How do you know?

Post 2: Reply to a Classmate

· Do you agree or disagree with their identification of the independent and dependent variables on your classmate’s scatterplot? Explain.

· As you look at your classmate’s scatter plot, do you agree with the relationship they identified? Explain.

Post 3: Reply to Another Classmate

· Choose a post you have not already responded to; do you agree or disagree with their identification of the independent and dependent variables? Explain.

· How would you describe the relationship between the two variables that your classmate used in their scatterplot? Example: As the number of accidents increased, the number of injuries increased.

Response 1

For this week’s discussion I decided to use question 18 from the chapter 10-1 exercise questions. The data set shows the correlation between the number of hits and number of at bats for a World Series player. Unfortunately, the data set doesn’t give a time period of when these stats were recorded. While not necessary to plot this, it would be nice to know how many years this covered. In this example the independent variable would be the number of at bats. The dependent variable would be the number of hits, as this would be the outcome of what is being studied. As one might guess, there appears to be a positive linear relationship between the increased amount of “at bats” and the “number of hits”. It kind of follows the law of averages that the more chances you have to hit, the more hits you will get. There is also a positive correlation of 0.968.

References

Bluman, A. G. (2019). Elementary Statistics: A Step by Step Approach, a Brief Version, 8th edition. New York: McGraw-Hill Education.

Response 2

According to this section of data, the independent variable would be the student test scores, and the dependent variable would be the course 101/course 102.

This splatter graph data appears to show a positive linear relationship. points fall in an ascending straight line and both the x and y values increase at almost the same time.