Answer to Question #148403 in Statistics and Probability for Star Eduah

Question

Throw a rock 10 times into a hat from different distances, like every 3 feet. The distances are the independent variable. The number of times that the rock lands in the hat is the dependent variable. Create a scatter plot of your data. Then add a linear trendline to the graph. Now add the equation of the trendline and the R squared value in the graph. Now create a regression analysis using data analysis in excel. Copy the data graph and output of the regression analysis into the word document of your assignment . Now analyse the data. What does the data show you? Does the distance away from the hat affect he number of times that the rock lands in the hat? Compare the equation of the trendline in the graph to the output coefficients in the output of the regression analysis. Are they same?

Answer 1

x - distance

y - number of times that the rock lands in the hat

A scatter plot with a linear trendline with the equation and the R squared value:

An output of the regression analysis:

What does the data show you?

The data is well described by a linear relationship.

Does the distance away from the hat affect the number of times that the rock lands in the hat?

The greater the distance, the fewer the number of times that the rock lands in the hat.

The coefficients in the trendline in the graph and in the output of the regression analysis are the same.