Asandle1 Week 9
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.
To User Page: User: Asandle1
To Template: Template:Asandle1
