The essay geekThis will let you know whether to make the r value positive or negative when you take the square root of r^2. If the r^2 valu

you can look at the slope of the scatter plot to see if the slope is positive. This will let you know whether to make the r value positive or negative when you take the square root of r^2.If the r^2 value is say .0382 then you will click on an excel cell and type=.0382^.5Note the ^ key is above the 6 keyThis will be your r value and you will make it negative if your slope is negative otherwise leave it positive.If you have a different version of excel then you may want to search to see how to form a trendline. These instructions work with Office 365 and Office 2010.Then follow these instructions:Attach your excel worksheet with your scatter plot r value and regression line along with your post if possible. What did you get for your regression line? What was your r value? What did this tell you?What would be a scenario where you might need to use this application? Oct 16 2021