This data consists of Temperature readings taken in a greenhouse over a period of days.
We have Date, Time, temperature in Celsius, and temperature in Fahrenheit.
So, first, how many readings do we have?
you’re able to see that we have over 9000 readings total.
How many reading per day is this?
If I add Date as a row label, we get a breakdown by day.
And you’re able to see that on most days, we have 720 readings.
If you want to see a breakdown by hour, you could use time as a column label.
you might see there are generally 30 readings per hour, so one reading every 2 minutes.
Next, what are the maximum and minimum temperatures recorded each day?
This data would also work well as a Pivot Chart.
Next, what’s the average temperature at each hour of each day?
Finally, one last question:
How can these temperatures be visualized with color?
To achieve this, we can use a Color Scale applied with conditional formatting.
The result is a colorful table that clearly shows which times during the day have warmer and cooler temperatures.
