8/6/2017 Is there a correlation between the two bowlers themselves? In other wor

Question

8/6/2017

Is there a correlation between the two bowlers themselves? In other words – does Aron’s score in each game depend on Mjorgan’s score at all? You might want to create a data table of each bowler’s score in each respective game to find out. Develop a statistical model to estimate Aron’s score based on Mjorgan’s score, then interpret its findings and its accuracy.

Aron 1 2 3 4 Average

8/6/2017

90 138 118 105 112.8 8/19/2017 162 101 120 145 132 9/16/2017 101 129 132 111 118.3 Average 117.7 122.7 123.3 120.3 121

Explanation / Answer

We first arrange the data in the below manner

Using the corellation functon in excel =CORREL () we find the correlation coefficeint

The correlation coefficient = 0.01048

Using regression we find the below results

Here we see that the significance F = 0.97 which is more than 0.05 hence the model is imsignificant

Using the model we can say Arons score = 119.61 + 0.014821 * Mjorgan

As the significance is not good the equations accuracy will we extremely poor

Arons Mjorgan 90 115 138 88 118 94 105 102 162 89 101 75 120 77 145 90 101 74 129 110 132 117 111 90

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.