HEAD M EXCEL PROBLEM #1 - PIPE VOLUME VS. PIPE LENGTH o Using Excel, & Create...

Transcribed Image Text:

HEAD M EXCEL PROBLEM #1 - PIPE VOLUME VS. PIPE LENGTH o Using Excel, & Create a table which computes the volume (in cm3) of a cylinder with a diameter of 1/2" and lengths 6 in 60 inches, in increments of 6 inches. = & Repeat this calculation in a second column but set the diameter of the cylinder to 1". FLO & Create a X Y Scatter Chart (with straight lines) of your table. Label the two volume columns as "1/2 ID" and "1 ID", respectively. Add X and Y axis titles as "Length, in" and "Volume,cm3" and set the Chart Title to "Pipe Volume vs. Length." DASTATE JIO Notes: Excel uses the function pi() for п. COLLES HEAD M EXCEL PROBLEM #1 - PIPE VOLUME VS. PIPE LENGTH o Using Excel, & Create a table which computes the volume (in cm3) of a cylinder with a diameter of 1/2" and lengths 6 in 60 inches, in increments of 6 inches. = & Repeat this calculation in a second column but set the diameter of the cylinder to 1". FLO & Create a X Y Scatter Chart (with straight lines) of your table. Label the two volume columns as "1/2 ID" and "1 ID", respectively. Add X and Y axis titles as "Length, in" and "Volume,cm3" and set the Chart Title to "Pipe Volume vs. Length." DASTATE JIO Notes: Excel uses the function pi() for п. COLLES

Answer rating: 100% (QA)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 A B 12 Diameter in Length ... View the full answer