You are curious to see how strong of a correlation there is between the average...

70.2K

Verified Solution

Question

Statistics

image

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students