Difference between revisions of "Asandle1 Week 9"
(→Electronic Notebook: saved changes) |
(test adding media) |
||
| Line 51: | Line 51: | ||
| − | + | [Media:AS&CK_BIOL367_S24_microarray-data_dGLN3.xlsx] | |
Revision as of 14:05, 14 March 2024
Contents
Electronic Notebook
1) Downloaded the gln3 data
2) Opened in Excel
3) Enabled Editing
4) Saved File with AS&CK_ before the rest of its name
5) Add a new sheet called ANOVA_dGLN3
6) Copied the Data from the Master_Sheet_dGLN3 to the new ANOVA_dGLN3
7) Created columns for Average Log called dGLN3_AvgLogFC_t for each time period adding 15,30,60,90, and 120 at the end.
8) Then we computed the average for the first row of t 15 time points of 2 through 5.
9) We copied down the formula all the rows
10)We noticed a DIV/0 Error for some rows since the data was blank.
11)Repeated the same process for the rest.
12)Creating a column for dGLN3_ss_HO for the sum of squares.
13) Highlighted the columns for all times for this and did =sumsq(all relevant data in the row)
14) Created Columns for dGLN3_ss_t15 through t120
15) Did the same process highlight the data in a row that applied to the specific time t.
16) Double clicked to expand
17) Was not the correct equation so deleted everything in the sumsq= that we just did except for the dGLN_ss_HO which was still correct
18) Instead we do number 14 in the worksheet.
19) For dGLN_ss_t15 the equation was =SUMSQ(D2:G2)-COUNTA(D2:G2)*X2^2
20) After completed copied down all the columns.
21) Created dGLN3_SS_full to the right.
22) Created the dGLN_Fstat to the
[Media:AS&CK_BIOL367_S24_microarray-data_dGLN3.xlsx]
To User Page: User: Asandle1
To Template: Template:Asandle1
