Home / Expert Answers / Statistics and Probability / ga-attendance3-2981-3-17-68-3-3588-3-17-83-3-6-93-2-0360-1-54-62-3-6397-3-17-81-3-18-64-1-58-75-3-21-pa434

(Solved): GA Attendance3.2981%3.17 68%3.3588%3.17 83%3.6 93%2.0360%1.54 62%3.6397%3.17 81%3.18 64%1.58 75%3.21 ...





A superintendent of a school district wants to understand the link between attendance and grade point average, or GPA. The GP
GA Attendance
3.2981%
3.17 68%
3.3588%
3.17 83%
3.6 93%
2.0360%
1.54 62%
3.6397%
3.17 81%
3.18 64%
1.58 75%
3.2195%
3.8797%
3.2967%
1.74 75%
2.8668%
2.0552%
3.0482%
3.97 88%
3.1 70%
3.4898%
1.63 77%
2.16 59%
3.2392%
1.19 72%
314 93%
3.5581%
3.2981%
2.8986%
3.14 94%
A superintendent of a school district wants to understand the link between attendance and grade point average, or GPA. The GPA is out of \( 4.0 \) points, with \( 4.0 \) being the highest possible. The percent attendance and GPA of 30 randomly sampled students from the superintendent's district were collected. This sample data is provided below. Use Excel to calculate the correlation coefficient \( r \) between the two data sets. Round your answer to two decimal places.


We have an Answer from Expert

View Expert Answer

Expert Answer


solutions: correlation , r can be found by the formula: r= Or by using CORREl( Data array 1, data arrray2) formula in excel. r=0.
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe