# Question: a Make an Excel scatter plot of X airspeed

(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.

(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.

**View Solution:**## Answer to relevant Questions

An executive's telephone log showed the lengths of 65 calls initiated during the last week of July. (a) Sort the data. (b) Find the mean, median, and mode. (c) Do the measures of center agree? Explain. (d) Are the data ...Given P (A) = .70, P (B) = .30, and P (A ∩ B) 5 .00, find (a) P(A ∪ B) and (b) P(A | B). (c) Sketch a Venn diagram. Given P (A) = .40, P (B) = .50. If A and B are independent, find P (A ∩ B). A baseball player bats either left-handed (L) or right-handed (R). The player either gets on base (B) or does not get on base (B). (a) Enumerate the elementary events in the sample space. (b) Would these elementary events be ...A drug test for athletes has a 5 percent false positive rate and a 10 percent false negative rate. Of the athletes tested, 4 percent have actually been using the prohibited drug. If an athlete tests positive, what is the ...Post your question