(LO 7-3) Download the “R&D Expenditures and Revenues” dataset in Excel from Connect. Assess the relationship between R&D Expenditures and Sales Revenue by computing correlations and visualizing the relationship.

Required:
1. Calculate the correlation between R&D Expenditures and Revenues. Do the results suggest a positive, negative, or no relationship between R&D Expenditures and Revenues?
2. Plot the results using a X Y (Scatter) chart in Excel with R&D Expenditures on the x axis and Revenues on the y axis.
3. How would a company determine if the investment in R&D Expenditures each year is paying off? What would it need to consider?