(a) Make an Excel scatter plot of X = airspeed (nautical miles per hour) and Y =...

Question:

(a) Make an Excel scatter plot of X = airspeed (nautical miles per hour) and Y = cockpit noise level (decibels) for 61 aircraft fights.
(b) Use Excel's =CORREL function to find the correlation coefficient.
(c) What do the graph and correlation coefficient say about the relationship between airspeed and cockpit noise? Why might such a relationship exist? Optional: Fit an Excel trend line to the scatter plot and interpret it.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: