2.    Divide the total distance obtained above by the number of loops in the pattern to determine the distance between adjacent Nodes, d. Enter the result in cell B26.

3.    Using the fact that the distance between adjacent Nodes is one-half the wavelength, calculate the wavelength of the sound, and enter in cell B27.

4.    Calculate the velocity of sound in air for frequency f₁ , as: v₁ = f₁ l. Enter the result in cell B28.

5.     Repeat the calculations of the total distance between first and last nodes, the distance between adjacent nodes, the wavelength, and the velocity of the sound of frequency f₂, and enter the results in cells C25:C28.

6.    Repeat the calculations of the total distance between first and last nodes, the distance between adjacent nodes, the wavelength, and the velocity of the sound of frequency f₃, and enter the results in cells D25:D28.

7.    From the three values for the velocity of sound in air, calculate the average velocity of sound in air vavg at the temperature of the laboratory, and enter this value in cell D30.

8.    Compare your value for v_avg with the Actual Value that is calculated in cell D35, and compute the percentage difference. Enter this value in cell D36.

9.    From the data in cells E17:E22, enter the total distance in cell E25, the distance between nodes nodes d in cell E26, and the wavelength l of the mystery tone in cell E27.

10.    Using the average velocity of sound in air at laboratory temperature, calculate the unknown frequency, f_xfrom: f_x = v_avg / l , and enter the value in cell E32.

11.    Submit the completed Worksheet as part of your lab report.