Ron Jones Logo

Contact RJ
Ron Jones Bio
CorporateWellness
Coach & Train
Exercise Library
Handouts
Health & Fitness
KETTLEBELLS
Products by RJ
Site Map

RJ Foot Fitness Logo

TheLeanBerets.Com "Avengers of Health!"

Coach RJ Blog

KIN 610: Week #4 Directions
(Last Updated 10-7-01)

This is how I think it is supposed to be done.  I was confused with the other directions, so I made my own outline of what I "think" she is trying to say.  

  1. Go back to Week #3 data, copy it, and insert into new Excel worksheet.  Delete stuff you don't need but keep n and x values of course.

  2. Make new columns you need for this week.  You need five columns total.  Then do the new calculations for X squared, Y squared, X times Y, and SUM each column.

x y x^2 y^2 x*y

Now the hard stuff:

  1. Correlation Coefficient (This is the long formula off the website but you can't enter it exactly like it is into the Excel formula bar.  It's really tricky--double parenthesis, etc.) This is how the formula should look (red brackets [ ] represent cell boundaries).  You'll need to plug in the numbers:
  • [=(n*åxy-(åx*åy))/sqrt((n*åx^2-(åx)^2)*(n*åy^2-(åy)^2))]
  1. Pearson Correlation  
  • Array 1=x and Array 2=y
  • My range of cells for A is x=a2:a38 and y=b2:b38 so Excel Pearson Formula would be: [=pearson(a2:a38,b2:b38)]
  1. Data Analysis=Tools>Data Analysis>Correlation>to the "Correlation" data entry box:
  • Input=Highlight BOTH x & y columns TOGETHER for this box.
  • Check the "Output" button
  • Output=blank cell (see next bullet!)
  • "Output" Cell Alert! This is simply a blank cell that will end up being the UPPER LEFT CORNER of your generated data analysis table.  It will fill from this point out towards the right and down.  Find an open spot so you don't have to move your table, then shove it in and pray for mercy!  Also use this method for the Regression step...don't forget prayer part!
  1. Regression Equation (Use Excel's "Data Analysis")
  2. "Present the regression equation" means to write it out but only for the "significant" relationships as she stated.
  • For problem A, it should say: 

Regression Equation Presented:
y=1.277*x-142.7
weight=1.277*height-142.7
Other Related Stuff:
y=mx+b (so for A & B, the equation in Excel would look like this:)

[=(m*x variable*2.54+b)*2.2)] (you have to plug in numbers)

m=slope (x variable on table); 
x variable=total inches of person; 
2.54=conversion factor for getting inches into centimeters; 
b=y intercept (intercept in table); 
2.2=conversion factor for getting kilograms into pounds
  1. Estimate weight or heart rate for individuals ONLY for equations that are significant.
  • I'm still a little confused on this one but you have to convert inches back into cm.  So multiply total inches by 2.54 to get centimeters.  For example:
    • 6'2"=6x12+2=74 inches. 
    • 74 x 2.54=187.96 cm
    • 187.96 cm~74 inches
  1. Keep all this on just ONE worksheet.  ALERT! When I tried to do all the cutting and pasting, I lost my original formulas in the cells because I moved them from one worksheet to a new worksheet.  Try to insert all this data analysis stuff in a place on ONE worksheet where you don't have to move it around to a different worksheet and risk screwing it up.  Refer back to last bullet in #5 for details.  Questions? Back to prayer step!

 RonJones.Org | Back to Top | Back to CSUN 610 | Site Map

Ron Jones/www.ronjones.org (10-7-01)

 

                      Get Fit.  Be Strong.
                                 Corporate Wellness · Consulting · Health Promotion