SOLUTION: You generate a scatter plot using Excel. You then have Excel plot the trend line and report the equation and the r2 value. The regression equation is reported as y=12.46x+29.97 and
Algebra.Com
Question 1088987: You generate a scatter plot using Excel. You then have Excel plot the trend line and report the equation and the r2 value. The regression equation is reported as y=12.46x+29.97 and the r2=0.5476.
What is the correlation coefficient for this data set?
r =
Answer by Fombitz(32388) (Show Source): You can put this solution on YOUR website!
Take the square root and notice that your slope is positive.
RELATED QUESTIONS
Using your favorite statistics software package, you generate a scatter plot with a... (answered by Theo)
Instructions: For each exercise, use Excel, or MegaStat to make an attractive,... (answered by Fombitz)
Where do you find the coefficients readout? Is this in excel? I am really confused. I... (answered by stanbon)
8. This question is to give you practice at using Excel to input data, draw a scatterplot (answered by ikleyn)
8. This question is to give you practice at using Excel to input data, draw a scatterplot (answered by ikleyn)
on a scatter plot of data,a trend line passes through the points (-6,7) and (-2,10).... (answered by stanbon)
12.3 Data Set Telephone Hold Time (min.) for Concert Tickets CallWait
Operators (X) Wait (answered by stanbon)
The following table compares the age of moviegoers X with the amount of money Y they... (answered by stanbon)
(d) Using the Excel Home Market Value
a. Identify if there is any outlier in square... (answered by ikleyn)