ty

i have now added excel file !

Problem 3-25 (Static) [The following information applies to the questions displayed below.] The manager of a seafood restaurant was asked to establish a pricing policy on lobster dinners. Experimenting with prices produced the following data: Click here for the Excel Data File Problem 3-25 Part b (Static) b. Determine the correlation coefficient and interpret it. (Include the negative sign, as appropriate, directly before the value. Enter your " r " answer to 4 decimal places. Enter your first " r2n answer as a proportion (between 0 and 1 ) and to 2 decimal places. Then enter the next answer as the percentage equivalent to the nearest whole number percent.) b. Determine the correlation coefficient and interpret it. (Include the negative sign, as appropriate, directly before the value. Enter your " r " answer to 4 decimal places. Enter your first " r2 answer as a proportion (between 0 and 1 ) and to 2 decimal places. Then enter the next answer as the percentage equivalent to the nearest whole number percent.) \begin{tabular}{|c|c|c|c|} \hline AverageNumberSoldPerDay,y & Price, x & AverageNumberSoldPerDay,y & Price, x \\ \hline 200 & $6.00 & 155 & $8.25 \\ \hline 190 & $6.50 & 156 & $8.50 \\ \hline 188 & $6.75 & 148 & $8.75 \\ \hline 180 & $7.00 & 140 & $9.00 \\ \hline 170 & $7.25 & 133 & $9.25 \\ \hline 162 & $7.50 & & \\ \hline 160 & $8.00 & & \\ \hline \end{tabular}