Difference between revisions of "Asandle1 Week 9"
(→Electronic Notebook: saved work) |
(→Electronic Notebook: saved changes) |
||
| Line 42: | Line 42: | ||
20) After completed copied down all the columns. | 20) After completed copied down all the columns. | ||
| + | 21) Created dGLN3_SS_full to the right. | ||
| + | |||
| + | 22) Created the dGLN_Fstat to the | ||
Revision as of 13:59, 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
To User Page: User: Asandle1 To Template: Template:Asandle1
