This assignment is due Week 4Please see

This assignment is due Week 4Please see attachment for assignment notes. You now know the difference between correlation and causation. Although there are several different ways to make predictions, a regression analysis is one way to do so. The video above explains how to do a simple correlation, regression, and scatterplot in Excel.Remember, you can always visit your Lifeline for more help. For this assignment, imagine you are looking for a link between soda consumption and weight. Here is your data set:Amount of Soda Consumed and Individual’s WeightParticipantNumber of 12 ounce sodas consumed per dayWeight15125210180301104211055130682057110583130915200ASSIGNMENT INSTRUCTIONSFollowing the instructions in the video, enter your data set on an Excel worksheet. Be sure and use the labels provided in the data set. Then:Perform a correlation and regression on the data in Excel.Create a scatterplot with a regression line for your data using ExcelIn a separate Word document, discuss your findings (3-4 paragraphs). Is there a significant relationship between soda consumption and weight? Explain how you know this. Using your regression, predict how a person’s soda consumption will impact their weight.Submit your completed Excel worksheet and Word document.