We can chart a regression in Excel by highlighting the data and charting it as a scatter ... is a statistical measure of the goodness of fit of a linear regression model (from 0.00 to 1.00), ...

Building a linear regression model So far, I have explored the dataset in detail and got familiar with it. Now it is time to create the model and see if I can predict Yearly Amount Spent.