Plotting Rainfall Graphs and Hyetographs

This Microsoft Excel tutorial guides users through plotting a hydrograph and mass curve of rainfall using provided data. It covers calculating incremental rainfall and rainfall intensity, and demonstrates how to plot these using Excel's scatter and bar graphs. The tutorial concludes with a call to action for viewers to subscribe and continue learning.

What is the first step in the tutorial for plotting rainfall graphs?

• Calculate incremental rainfall

• Insert a pie chart

• Plot the hyetograph

• Calculate the total rainfall

How is the incremental rainfall calculated in Excel?

• By adding the cumulative rainfall

• By subtracting the previous cumulative rainfall from the current

• By multiplying the cumulative rainfall by two

• By dividing the cumulative rainfall by the time period

Why is the incremental rainfall multiplied by two to find the rainfall intensity?

• Because the data is for a 15-minute period

• To convert the data into millimeters

• To adjust for a 30-minute period to an hourly rate

• To account for data errors

Which type of chart is used to plot the mass curve of rainfall?

• Pie chart

• Bar chart

• Scatter plot with smooth lines and markers

• Line chart

What are the x and y values used for plotting the mass curve of rainfall?

• Time in minutes and rainfall intensity

• Cumulative rainfall and time in minutes

• Incremental rainfall and time in hours

• Rainfall intensity and cumulative rainfall

Which chart type is selected for plotting the hyetograph?

• Pie chart

• Line graph

• Bar graph

• Scatter plot

What does the hyetograph represent in the tutorial?

• Average rainfall per month

• Total rainfall in a day

• Rainfall intensity over time

• Cumulative rainfall over time

What is the series name given to the hyetograph in the tutorial?

• Rainfall intensity graph

• Rainfall distribution

• Itograph

• Mass curve of rainfall

What is the purpose of the tutorial's conclusion?

• To discuss the history of Excel

• To summarize the graphs created and encourage further learning

• To provide a detailed analysis of rainfall data

• To introduce new Excel features

What does the tutorial encourage viewers to do at the end?

• Download the Excel file

• Attend a live webinar

• Subscribe to the channel

• Share the video with friends