Description Methods in Regression and Correlation 1. Discuss how the linear correlation coefficient is used to evaluate the association between an independent and dependent variable. 2. You will perform a regression analysis of the data within the provided attachment. The following items must be provided within this analysis: Identify the independent and dependent variable. Create a scatterplot and perform a trendline analysis in Excel. This analysis will provide you with your regression equation and coefficient of determination. Upload this Excel file containing these results to your main discussion post. Go to You Tube and perform a search on terms that include your version of Excel, create scatterplot, and trendline to access hundreds of video tutorials. Choose the tutorial that matches your version Excel. State your regression equation in terms of your independent and dependent variable. Interpret what the slope and y-intercept represent within the context of this application. State and interpret your coefficient of determination within the context of this application. If you take the square root of your coefficient of determination, you will obtain the correlation coefficient. Determine the correlation coefficient and interpret it within the context of this application