Use Excel to make a simple dashboard with the iris dataset

Crystal X
5 min readNov 6, 2024

In an earlier blog post I discussed how to perform an analysis on the iris dataset, and that blog post can be found here:- https://medium.com/@tracyrenee61/use-excel-to-analyse-the-iris-dataset-7891b1c7e1d9

In this video I intend to discuss how to make a simple dashboard for the iris dataset.

The iris dataset is a well known dataset in the field of machine learning and statistics. This dataset was introduced by the British biologist and statistician Ronald Fischer as an example of discriminant analysis. The dataset is composed of 150 examples of three species of iris. Each species is composed of 50 examples each.

The three species of iris are:-

  1. Setosa, which is a small size,
  2. Versicolor, which is a moderate size, and
  3. Virginica, which is a large size.

The dataset is composed of four features, which are:-

  1. Sepal length
  2. Sepal width
  3. Petal length
  4. Petal width

The iris dataset can be found in Python’s machine learning library, SciKit Learn, but I have been able to obtain a copy of the dataset in Excel, which has enabled me to use the spreadsheet program to analyse it and to…

--

--

Crystal X
Crystal X

Written by Crystal X

I have over five decades experience in the world of work, being in fast food, the military, business, non-profits, and the healthcare sector.

No responses yet