Looking at the draining time of water over a certain distances

  • Context: High School 
  • Thread starter Thread starter Big Drop
  • Start date Start date
  • Tags Tags
    Time Water
Click For Summary
SUMMARY

The discussion focuses on visualizing the draining time of water over specific distances using a scatter graph. The user has collected data on water heights and corresponding velocities, specifically noting the ranges of water heights (120-90 mm, 90-60 mm, etc.) and their respective velocities (1.30E-03 m/s, 1.20E-03 m/s, etc.). The key question raised is whether the ranges can be used as x-axis values in Excel. The response confirms that Excel allows the designation of any contiguous cell array as x-axis labels, enabling the user to create the desired scatter graph.

PREREQUISITES
  • Understanding of scatter graph creation in Excel
  • Basic knowledge of data visualization principles
  • Familiarity with interpreting velocity and height data
  • Experience with Excel functions and charting tools
NEXT STEPS
  • Learn how to create scatter graphs in Excel 2021
  • Research data visualization best practices for scientific experiments
  • Explore advanced Excel charting techniques for better data representation
  • Investigate the impact of water height on velocity in fluid dynamics
USEFUL FOR

Students conducting experiments in physics or engineering, data analysts visualizing experimental results, and anyone interested in learning how to effectively use Excel for data representation.

Big Drop
Messages
5
Reaction score
0
Hi,

Basically I'm doing a experiment, and part of is looking at the draining time of water over a certain distances.

I've got the data but unsure how to put it into a graph. The data goes something like this:

Water heights [mm] Velocity of water [m/s]

120 - 90 1.30E-03
90 - 60 1.20E-03
60 - 30 9.38E-04
30 - 0 4.23E-04

I want to put this into a scatter graph, comparing the two, water heights on the x-axis. But I'm unsure if i can use the points '120-90' as x-axis values. Can I?


Thanks
 
Physics news on Phys.org
In an Excel graph, you can designate any array of contagious cells as the x-axis labels.
 

Similar threads

  • · Replies 14 ·
Replies
14
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 18 ·
Replies
18
Views
2K
  • · Replies 4 ·
Replies
4
Views
8K
  • · Replies 152 ·
6
Replies
152
Views
11K
  • · Replies 12 ·
Replies
12
Views
4K
  • · Replies 10 ·
Replies
10
Views
6K
Replies
3
Views
12K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K