Forum Discussion
separate a column
My sample data has a column by Gender and another column for the corresponding Height. I inserted a new column between those two columns. I need all of the Females to be in one column and all the M...
Hello Mathetes. Thank you for your response. I have a data set of Gender and Height. I am trying to find the P value and also do a T test for the Mean. I thought I needed the Mean and Standard Deviation for Males, then for Females and then BOTH. So I did separate the genders and did the mean and standard deviation for all three of them. But I don't know how to plug in the numbers or what numbers to use in order to get the "Standard Error", Null Hypothesis (µ=?) and the "T Test Statistic". I need to do a Left Tailed Test and find the Critical Value and P Value so I can Accept or Reject the Ho.
Now you're asking an altogether different set of questions, ones I can't help you with. (I've never studied statistics or statistical analysis, despite two graduate level degrees.) My only point (and the basis for my question about "Why?") was that Excel could handle whatever analyses and processing you're doing without separating males from females into separate columns. I still will hold to that position, but as to your questions on
"Standard Error", Null Hypothesis (µ=?), the "T Test Statistic", Left Tailed Test, the Critical Value and P Value
I must defer to others. Best wishes.