Hanze

Go back to the main page
Go back to the Excel overview page

Excel Data Visualization

Solutions

Exercise 1

See the Excel file here for the solution.

Or the figure below:

figure

There are 19 genes that pass this criteria. As you can see, they are sorted lowest to highest.

Exercise 2

See the Excel file here for the solution.

Or the figure below:

figure

Exercise 3

See the Excel file here for the solution.

Or the figure below:

figure

Exercise 4

See the Excel file here for the solution.

Or the figure below:

figure

Exercise 5

See the Excel file here for the solution.

First we need to sum each of the different categories. The UNIQUE() function can be used to retrieve the unique categories. The SUMIF() function can be used to calculate the sum of each category for the Expression values without stimulus.

Thereafter, a PIE chart can be generated.

Or the figure below:

figure

Exercise 6

See the Excel file here for the solution.

Or the figure below:

figure

Signal transduction proteins shows the lowest median value.

Exercise 7

See the Excel file here for the solution.

Or the figure below:

figure

Signal transduction proteins shows the lowest IQR value (lowest height of the Whisker box).

Exercise 8

See the Excel file here for the solution.

Or the figure below:

figure

Chicken number 4 and 5 on Diet number 3 gained the most in weight.

Exercise 9

See the Excel file here for the solution.

Or the figure below:

figure

Alice shows a relatively low concentration of potassium for the sodium concentration (or a relatively low sodium concentration for the potassium concentration).

Exercise 10

See the Excel file here for the solution.

Or the figure below for the line plot (without Puromycin):

figure

Or the figure below for the line plot (with and without Puromycin):

figure

Puromycin acts as an activator. The measured values of the treated condition are higher than those of the untreated condition.

Exercise 11

Data can be cleaned in various ways. You can use (for instance) the Text to Columns feature to split on a space. But there are other strategies as well (like the RIGHT or LEFT formula).

See the Excel file here for the solution.

Or the figure below:

figure

Motor proteins show the highest expression levels.
Signal transducing proteins the lowest expression values.

Go back to the main page
Go back to the Excel overview page
⬆️ Back to Top

This web page is distributed under the terms of the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited. Creative Commons License: CC BY-SA 4.0.