How To Add Subcolumns In Prism

Go to parent GraphPad Prism statistical analyses

I measured the activity of the enzyme mannose-6-phosphate isomerase (MPI) in mice.
In that location are 3 genotypes at the mouse locus for MPI:

• Mpi^ff = i
• Mpi^fs = two
• Mpi^ss = 3

Since Prism only accepts numerical information the genotypes are represented by numbers.

I desire to know whether the genotypes accept dissimilar MPI activeness. Because I don't know if sexual activity affects MPI activity, I as well recorded the sexual practice of the mice (also represented by numbers: male = 0; female person = ane). The information (in ΔO.D. units/sec/mg dry weight) are available as a csv file.

Open up the file in WordPad. The data are arranged in a column tabular array.

Open up the file in Prism.
Create a new column tabular array Select to Enter replicate values, stacked into columns Click Create Import the file in the tabular array. The comma is used equally a decimal separator.

Is the file in the correct format for analysis ?
No, when there are 2 grouping variables, Prism expects a grouped tabular array. All 2-cistron analyses are linked to grouped tables.

Earlier you tin can create a grouped table, you accept to choose which group variable to put in the rows and which in the columns, we'll put sex activity in the columns and genotype in the rows. So we create a tabular array with three rows and ii columns with 6 subcolumns each.

Sort the rows according to sex.

For sorting, you need an XY-column with the values that you desire to base the sorting on in the Ten-column. Click the Change table type button in the upper left corner of the data tabular array: In the Data table section of the Format Data Table window: set Kind of table to XY Click OK Select the sex cavalcade, right click and select Cut Select the Ten cavalcade, right click and select Paste Select the former sex column, right click and select Delete Sort the rows: you can observe a detailed description on how to sort based on X-values in the section on sorting rows

At present you can create each of the three rows of the grouped table: each row has to contain the values of one specific genotype, first the six values for the males, then the six values for the females.

Create a table containing the data of the ff genotype.

Selecting specific rows (the ones with the ff genotype) from a table is done by pruning. For pruning you lot need an XY-column with the values that you lot want to base of operations the selection on in the X-column. So instead of the sexual practice column, y'all need the genotype column as the X-column. This means that you first have to switch dorsum to a column table. To change an XY- into a cavalcade table Prism simply deletes the X-column and keeps the Y columns. Of course we want to keep the sexual activity column so first re-create the sex activity column and paste the values in the ID column (we don't need the IDs). Now nosotros can alter the table type back to a column table. Flip back to an XY-tabular array, this time using the genotype column as the X-cavalcade. To prune the rows: Click the Analyze push button in the Assay section of the top toolbar: In the Transform, Normalize... section of the Analyze Data window select Prune rows Click OK In the Ten range to keep section fix to to 1.0 to select the values of the ff genotype Click OK

Do the aforementioned for the fs and the ss genotype.

Shop the information in a grouped tabular array.

Create a new grouped table with 6 replicate values in side-by-side subcolumns. To insert the values: Go to the first pruned tabular array (of the ff genotype) and select the values in the activity cavalcade, right click and select Copy Go to the new grouped table, select the get-go cell of the kickoff row, right click and select Paste Transpose Practice the same for the other two rows. Add column and row names. Remember: these can be text, they do no longer need to be numerical. Give a meaningfull proper noun to the tabular array.

Cheque whether genotype or sexual practice influences MPI activity.

Analyze the data using a Two-way ANOVA (or mixed model) in the Grouped analyses section The RM Blueprint tab: the data is independent: dissimilar mice are used for each measurement The Cistron names tab you have to provide names for the factors The results signal that the interaction term and the effect of sex activity are non-meaning: Notwithstanding, genotype does influence the activity of the enzyme (effect of genotype is significant), admitting not in a sex-specific way (interaction is not significant).

Do all genotypes take dissimilar MPI action ?
Redo the analysis. This fourth dimension become to the Multiple comparisons tab and select to Compare row means (master row effect). The results indicate that only fs and ss are significantly unlike.

Again this exercise shows that oftentimes the most difficult step in Prism is getting your data in the right format.

Source: https://wiki.bits.vib.be/index.php/Exercise_11D:_Comparing_groups_defined_by_two_grouping_variables_in_Prism

Share this post