Spring 2024 MAT205 Project #3 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 2023: Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Avg temp for the month (in degrees F) 50 56 64 70 76 84 86 88 82 70 64 58 Total number of popsicles sold 215 365 410 430 500 720 840 750 580 510 410 320 Note: Microsoft 365 is free to all WilmU students. Click on the link below for more information: https://www.wilmu.edu/techres/microsoft-365-for-students.aspx 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 coefficient of determination (r2) and the equation for the line of best fit on your scatter plot as well. Label your graph where appropriate. 2. Using your answer from #1, find the following: a. What is the correlation coefficient (r)? b. Describe the correlation here (Ex: strong negative, weak positive, etc.). Use the value for r to justify your reasoning. c. Do you feel there is causation here? Why or why not? 3. Choose a temperature between 75- and 95-degrees Fahrenheit. Using the line of best fit from your scatter plot, how many popsicles would you need to plan to have prepared for a future month if the average temperature (in degrees F) for that month is predicted to the temperature you selected? Round to the