(Solved): A news reporter wants to assess the top 30 college quarterbacks. The reporter recorded the number ...

A news reporter wants to assess the top 30 college quarterbacks. The reporter recorded the number of plays and the number of passes a quarterback completed in one season. 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. A news reporter wants to assess the top 30 college quarterbacks. The reporter recorded the number of plays and the number of passes a quarterback completed in one season. 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. \begin{tabular}{|cc} \hline Plays & Passes \\ \hline 430 & \( 47.4 \) \\ \hline 542 & \( 49.4 \) \\ \hline 357 & \( 74.7 \) \\ \hline 642 & \( 99.6 \) \\ \hline 592 & \( 54.3 \) \\ \hline 417 & \( 62.5 \) \\ \hline 701 & \( 84.7 \) \\ \hline 457 & 48 \\ \hline 815 & \( 119.8 \) \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Plays & Passes \\ \hline 701 & \( 84.7 \) \\ \hline 457 & 48 \\ \hline 815 & \( 119.8 \) \\ \hline 394 & \( 45.8 \) \\ \hline 514 & \( 59.4 \) \\ \hline 527 & \( 55.7 \) \\ \hline 494 & \( 44.4 \) \\ \hline 487 & \( 49.6 \) \\ \hline 305 & \( 43.5 \) \\ \hline \end{tabular} Downioad CSV answer to two decimal places. swer to two decimal places. Provide your answer below: \[ r= \]