3.31 Download from the McGraw-Hill Connect

^()

website the full data set of measurements of cockpit noise level for an older commercial jet airliner (only the first 2 and last 2 data values are shown). (a) Use Excel to make a scatter plot, placing Airspeed on the

x

-axis and Noise Level on the

Y

-axis. Add titles and modify the default colors, fonts, etc., as you judge appropriate to make the scatter plot effective. (b) Describe the relationship (if any) between

x

and

Y

. Weak? Strong? Negative? Positive? Linear? Nonlinear? Hint: You may need to rescale the

x

and

Y

axes to see more detail.\ \\\\table[[Obs,Airspeed (knots),Noise Level (dB)],[\\\\table[[1],[2]],\\\\table[[250],[340]],\\\\table[[83],[89]]],[\\\\table[[60],[61]],\\\\table[[405],[250]],\\\\table[[

dots

3.31 Download from the McGraw-Hill Connect (website the full data set of measurements of cockpit noise level for an older commercial jet airliner (only the first 2 and last 2 data values are shown). (a) Use Excel to make a scatter plot, placing Airspeed on the X-axis and Noise Level on the Y-axis. Add titles and modify the default colors, fonts, etc., as you judge appropriate to make the scatter plot effective. (b) Describe the relationship (if any) between X and Y. Weak? Strong? Negative? Positive? Linear? Nonlinear? Hint: You may need to rescale the X and Y axes to see more detail