Data Analysts Week 14

Continuing Milestone 3

Hailey Ivanson helped Katie and I with the Bonferroni and B-H values.

1. We used the formula =IFCHP_Bonferroni_p-value>1,1,CHP_Bonferroni_p-value) and =IFControl_Bonferroni_p-value>1,1,Control_Bonferroni_p-value)
2. we inserted a new worksheet named "CHP_ANOVA_B-H" and "Control_ANOVA_B-H."
3. we copied and pasted the "MasterIndex", "ID", and "Standard Name" columns from our previous worksheet into the first two columns of the new worksheet.
4. We used Paste special > Paste values and copied our unadjusted p values from our ANOVA worksheet and pasted it into Column D.
5. We selected all of columns A, B, C, and D and sorted by ascending values, smallest to largest.
6. We typed "Rank" in cell E1. we typed "1" into cell E2 and "2" into cell E3. Then we selected both cells E2 and E3 and double clicked on the plus sign to fill the column with a series of numbers from 1 to 4697.
7. Hailey Ivanson assisted us in calculating the Benjamini and Hochberg p value correction. We typed CHP_B-H_p-value and repeated for the control. We copied that equation to the entire column. =(D2*4697)/E2
8. We then typed "CHP_B-H_p-value" into cell G1.