Data Analysts Week 14

From LMU BioDB 2024
Revision as of 13:32, 23 April 2024 by Ckapla12 (talk | contribs) (punctuation)
Jump to navigation Jump to search

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.
  9. In cell G2: we used the equation =IF(F2>1,1,F2) and copied that equation to the entire column.
  10. We selected columns A through G and sorted them in ascending order.
  11. We copied column G and used Paste special > Paste values to paste it into the next column of our ANOVA sheet.
  12. We zipped and uploaded the .xlsx file.


Acknowledgements

This procedure was adapted from the Data Analysis page Milestone 3 protocol, linked here: Data Analysis The procedure for Milestone 3 was also adapted from the steps outlined in the Week 9 assignment page. Our quality assurance, Hailey Ivanson was a key part in completing this milestone, and her help was very valuable. Except for what is noted above, this individual journal entry was completed by Katie and Charlotte and not copied from another source.

Ckapla12 (talk) 14:28, 23 April 2024 (PDT)

References

LMU BioDB 2024. (2024). Week 14. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_14

Retrieved from "https://xmlpipedb.lmucs.org/biodb/spring2024/index.php?title=Data_Analysts_Week_14&oldid=3453"