B31 x v fx A B C D E F G H J K V E66 50 Question #30 995 60 994 60 997 45 1003 45 Hurricanes 1004 40 140 1000 55 994 55 120 942 105 100 1006 30 80 1006 40 942 60 120 1002 40 Wind Speed (knots] 40 986 50 20 983 70 994 65 930 9:40 950 960 970 980 990 1000 1010 940 120 Atmospheric Pressure (mb) 976 80 966 100 982 55 Correlation Coefficient -0.96 6 8 A negative linear relation exist between atmospheric pressure and wind speed 19A % " Conditional Formatting Format as Table v Paste Font Alignment Number 1 Cell Styles v Cells 25 X V fx =CORREL(A2:A21,B2:B21) A B C D E F G H I J 993 50 Question # 30 995 60 994 60 997 45 1003 45 Hurricanes 1004 40 1010 1000 55 994 55 942 105 Atmospheric Pressure (mb 1000 990 1006 30 980 1006 40 970 942 120 960 1002 40 950 986 50 940 983 70 930 994 65 20 40 60 80 100 120 140 940 120 Wind Speed (knots) 976 80 966 100 982 55 Correlation Coefficient -0.96Atmospheric Wind Speed Atmospheric Wind Speed Pressure (mb) (knots) Pressure (mb) (knots) 993 50 1006 40 995 60 942 120 994 60 1002 40 997 45 986 50 1003 45 983 70 1004 40 994 65 1000 55 940 120 994 55 976 942 105 966 100 1006 30 982 55 Source: National Hurricane Center (a) Draw a scatter diagram treating atmospheric pressure as the explanatory variable. (b) Compute the linear correlation coefficient between atmospheric pressure and wind speed. (c) Does a linear relation exist between atmospheric pressure and wind speed