Data Analysts Week 13 - Revision history

Kdahlquist: fixed template

2024-05-01T20:30:50Z

fixed template

2024-05-01T20:29:04Z

add categories

2024-04-30T16:24:35Z

add category

2024-04-23T21:45:41Z

editing references

2024-04-18T21:59:23Z

continuing with equations

2024-04-18T21:44:18Z

explaining formulas

2024-04-18T21:36:27Z

adding formulas and working on procedure- fstat and p value

2024-04-18T21:31:05Z

writing procedure.

2024-04-18T21:23:55Z

adding data points to fill in later

2024-04-18T21:11:55Z

highlighting log fc

@@ Line 60: / Line 60: @@
 LMU BioDB 2024. (2024). Week 9. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_9
-{{Team Project}}
+{{Yeast Beasts}}
 [[Category:Journal Entry]]
 [[Category:Team Project]]

← Older revision		Revision as of 16:24, 30 April 2024
Line 59:		Line 59:

	LMU BioDB 2024. (2024). Week 9. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_9		LMU BioDB 2024. (2024). Week 9. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_9
		+
		+	{{Team Project}}

← Older revision		Revision as of 21:45, 23 April 2024
Line 55:		Line 55:
	==References==		==References==
	LMU BioDB 2024. (2024). Week 13. Retrieved April 17, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_13		LMU BioDB 2024. (2024). Week 13. Retrieved April 17, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_13
		+
		+	LMU BioDB 2024. (2024). Data Analysis. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Data_Analysis
		+
		+	LMU BioDB 2024. (2024). Week 9. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_9

@@ Line 36: / Line 36: @@
 #Since n=21 and t=7, in the first cell of each Fstat column, we used the formula =((21-7)/7)*(<CHP_ss_HO>-<CHP_SS_full>)/<CHP_SS_full>) and hit enter. This same process was repeated for the control.
 #We replaced the phrase CHP_ss_HO with the cell designation and replaced the phrase <CHP_SS_full> with the cell designation. This was also repeated for the control.
 #Below the CHP_p-value header, we used the formula =FDIST(<CHP_Fstat>,7,21-7) replacing the phrase <CHP_Fstat> with the cell designation. We used this same formula for the Control_p-value column.

@@ Line 28: / Line 28: @@
 #We created the column headers Control_Log_FC_Time and CHP_Log_FC_Time.
 #We used the equation =SUMSQ(<range of cells for logFC_t0-2>)-COUNTA(<range of cells for logFC_t0-2>)*<AvgLogFC_t0-2>^2 and hit enter for each of the rows that were not the average.
-#The amount of data points we used is: ____
+#The amount of data points we have is: 21. Number of time points we have is: 7.
 #We replaced <range of cells for logFC_0-2> with the data range associated with t15 and so on for each time point.
 #We replaced <AvgCHPLogFC_0-2> and <AvgControlLogFC_0-2> with the cell number that we computed the AvgCHPLogFC and AvgControlLogFC for 0-2, and the "^2" squares that value. This was repeated for each of time points across our data set.
@@ Line 34: / Line 34: @@
 #Below this, we used the formula: =sum(<range of cells containing "ss" for each timepoint>) and hit enter.
 #In the next two columns to the right, we created the headers CHP_Fstat and Control_Fstat as well as CHP_p-value and Control_p-value.

← Older revision		Revision as of 21:36, 18 April 2024
Line 31:		Line 31:
	#We replaced <range of cells for logFC_0-2> with the data range associated with t15 and so on for each time point.		#We replaced <range of cells for logFC_0-2> with the data range associated with t15 and so on for each time point.
	#We replaced <AvgCHPLogFC_0-2> and <AvgControlLogFC_0-2> with the cell number that we computed the AvgCHPLogFC and AvgControlLogFC for 0-2, and the "^2" squares that value. This was repeated for each of time points across our data set.		#We replaced <AvgCHPLogFC_0-2> and <AvgControlLogFC_0-2> with the cell number that we computed the AvgCHPLogFC and AvgControlLogFC for 0-2, and the "^2" squares that value. This was repeated for each of time points across our data set.
		+	#We created the column headers CHP_SS_full and Control_SS_full.
		+	#Below this, we used the formula: =sum(<range of cells containing "ss" for each timepoint>) and hit enter.
		+	#In the next two columns to the right, we created the headers CHP_Fstat and Control_Fstat as well as CHP_p-value and Control_p-value.

@@ Line 26: / Line 26: @@
 #In the first cell below this header, we typed =SUMSQ for each of the time points.
 #After this, we highlighted all of the LogFC data in row 2- not the AvgLogFC, and we pressed the enter key.
+#We created the column headers Control_Log_FC_Time and CHP_Log_FC_Time.

@@ Line 24: / Line 24: @@
 # To the right, we then copy and special pasted the values of each Avg_Control_Log_FC_timepoint or Avg_CHP_Log_FC_timepoint columns. To the right of these, we created columns with the the headers Control_ss_HO and CHP_ss_HO.
 #In the first cell below Control_ss_HO, we typed <code>=SUMSQ(B2,C2,D2,J2,K2,L2,R2,S2,T2,Z2,AA2,AB2,AH2,AI2,AJ2,AP2,AQ2,AR2,AX2,AY2,AZ2)</code> and clicked enter, and below CHP_ss_HO, we typed <code>=SUMSQ(F2,G2,H2,N2,O2,P2,V2,W2,X2,AD2,AE2,AF2,AL2,AM2,AN2,AT2,AU2,AV2,BB2,BC2,BD2)</code> and clicked enter.
-#In the first cell below this header, we typed =SUMSQ.
+#In the first cell below this header, we typed =SUMSQ for each of the time points.