You are curious to see how strong of a correlation there is

Last updated: 8/8/2023

You are curious to see how strong of a correlation there is between the average temperature in your area and the total amount of popsicles you sell monthly Assume the data below is from 2022 Total number of popsicles sold Avg temp for the month in degrees F Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 238 364 418 428 508 718 842 746 580 508 450 324 51 57 63 70 76 84 83 82 80 69 64 57 1 Using Microsoft Excel create a scatter plot with the data above Be sure to label your scatterplot Create a linear trendline line of best fit to go with your scatterplot Display the correlation coefficient r and the equation for the line of best fit on your scatter plot