Difference between revisions of "Asandle1 Week 9"
(→Electronic Notebook: saving progress) |
(→Electronic Notebook: saved work) |
||
| Line 34: | Line 34: | ||
16) Double clicked to expand | 16) Double clicked to expand | ||
| − | 17) Was not the correct equation so deleted everything in the sumsq= that we just did | + | 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. | 18) Instead we do number 14 in the worksheet. | ||
| Line 40: | Line 40: | ||
19) For dGLN_ss_t15 the equation was =SUMSQ(D2:G2)-COUNTA(D2:G2)*X2^2 | 19) For dGLN_ss_t15 the equation was =SUMSQ(D2:G2)-COUNTA(D2:G2)*X2^2 | ||
| + | 20) After completed copied down all the columns. | ||
Revision as of 13:55, 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.
To User Page: User: Asandle1
To Template: Template:Asandle1
