Stats Investigation: Meaning of R-Square (Individuals)
Determine if a regression analysis using random numbers can
yield an r-square value of 50% or more.
Instructions: Set up a regression analysis in Excel using integer x-values from 0 to 9. Use a random number from 0 to 10 for the y-values. Run this simulation 100 times. Calculate the average r-square and record the highest r-squared value. Record the three highest r-square values obtained in the class.