Solution
Let for convenience of representation, x denote ERA and y represent Win%
[NOTE: Formulas and Answers are given below. Detailed Working follow at the end.]
Q1 Part (a)
First quartile, Q1 = average of the second and the third observation in the ordered set
= (0.022 + 0.026)/2
= 0.024
Third quartile, Q3 = average of the sixth and the seventh observation in the ordered set
= (0.028 + 0.030)/2
= 0.029
IQR = Q3 – Q1
= 0.005 Answer
Q1 Part (b)
Covariance = (1/n)Σ(i = 1, n){(xi – Mean X)(yi – Mean Y)}
= - 0.00027 Answer
Q1 Part (c)
V(X) = (1/n)Σ(i = 1, n)(xi – Mean X)2
V(Y) = (1/n)Σ(i = 1, n)(yi – Mean Y)2
Correlation coefficient = Covariance/sqrt{V(X).V(Y)}
= - 0.00027/(0.0049 x 0.0843)
= - 0.6653 Answer
Details of Working
Let for convenience of representation, dxi = (xi – Mean X) and dyi = (yi – Mean Y)
|
i |
x (ERA) |
y(Win%) |
dxi^2 |
dyi^2 |
(dxi)(dyi) |
|
1 |
0.028 |
0.53 |
1.40625E-07 |
0.00099225 |
-1.2E-05 |
|
2 |
0.021 |
0.542 |
4.38906E-05 |
0.00038025 |
0.000129 |
|
3 |
0.038 |
0.432 |
0.000107641 |
0.01677025 |
-0.00134 |
|
4 |
0.03 |
0.57 |
5.64063E-06 |
7.225E-05 |
2.02E-05 |
|
5 |
0.028 |
0.62 |
1.40625E-07 |
0.00342225 |
2.19E-05 |
|
6 |
0.022 |
0.74 |
3.16406E-05 |
0.03186225 |
-0.001 |
|
7 |
0.026 |
0.554 |
2.64062E-06 |
5.625E-05 |
1.22E-05 |
|
8 |
0.028 |
0.504 |
1.40625E-07 |
0.00330625 |
-2.2E-05 |
|
Total |
0.221 |
4.492 |
0.000191875 |
0.056862 |
-0.0022 |
|
Mean |
0.0276 |
0.5615 |
2.39844E-05 |
0.00710775 |
-0.00027 |
|
Square Root of Variance |
0.0049 |
0.0843 |
|||
Ordered Set
| 0.021 |
| 0.022 |
| 0.026 |
| 0.028 |
| 0.028 |
| 0.028 |
| 0.03 |
| 0.038 |
DONE
19 ERA 20 Win% 21 0.021 0.028 0.028 0.530 0.038 0.432 0.03 0.022 0.026 0.554 0.028...
Just need the answers please.
Engine Size
Mean
2.7917
Standard Error
0.0756
Median
2.7917
Mode
2.7297
Standard Deviation
0.6326
Sample Variance
Kurtosis
-0.6958
Skewness
0.0122
Range
Minimum
1.6130
Maximum
4.2186
Sum
Count
70.0000
Q1
2.2954
Q3
3.3191
Hwy Fuel Efficiency
Mean
33.9857
Standard Error
1.0510
Median
35.5000
Mode
46.0000
Standard Deviation
8.7931
Sample Variance
Kurtosis
-1.3320
Skewness
-0.1543
Range
Minimum
19.0000
Maximum
47.0000
Sum
Count
70.0000
Q1
26.0000
Q3
42.0000
The U.S. Department of Energy's Fuel Economy Guide provides fuel...
Note: Ahswer Questions S-8 Dy Using the Excel output The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. (See exercise 35 on page 63 in your textbook for a similar problem.) Use the data in the FuelData sheet in this workbook to generate excel output to answer the following questions. Please note that units are "liters" for engine size and "miles per gallon" for highway fuel efficiency. Put the output in given space...
I just need help on questions 7 and 8
The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. (See exercise 35 on page 77 in your textbook for a similar problem.) Use the data in the FuelData sheet in this workbook to generate excel output to answer the following questions. Please note that units are "liters" for engine size and "miles per gallon" for highway fuel efficiency. Put the output in given space...