Question
In: Statistics and Probability
Summarizing Bivariate Data (1) The data in table below represent airline fuel cost per gallon (in...
Summarizing Bivariate Data
(1) The data in table below represent airline fuel cost per gallon (in dollars) for the US
domestic and international carriers with scheduled service by month from July 2014 to
December 2014.
Month Domestic (x) International (y)
July 3 2.84
August 2.98 2.84
September 2.89 2.81
October 2.69 2.67
November 2.58 2.55
December 2.3 2.3
(a) Find the correlation coefficient value r.
(b) If we wish to predict international cost using the domestic cost, identify response and
predictor.
(c) Find slope and intercept of the regression equation of y on x.
(d) Write out the regression equation of y on x.
Solutions
Expert Solution
Excel sheet: Values
| Sxx | Syy | Sxy | ||||||
| Domestic (X) | International (Y) | X2 | Y2 | XY | (X-Xbar)2 | (Y-Ybar)2 | (X-Xbar)(Y-Ybar) | |
| 3 | 2.84 | 9 | 8.0656 | 8.52 | 0.0676 | 0.029469 | 0.044633 | |
| 2.98 | 2.84 | 8.8804 | 8.0656 | 8.4632 | 0.0576 | 0.029469 | 0.0412 | |
| 2.89 | 2.81 | 8.3521 | 7.8961 | 8.1209 | 0.0225 | 0.020069 | 0.02125 | |
| 2.69 | 2.67 | 7.2361 | 7.1289 | 7.1823 | 0.0025 | 2.78E-06 | -8.3E-05 | |
| 2.58 | 2.55 | 6.6564 | 6.5025 | 6.579 | 0.0256 | 0.014003 | 0.018933 | |
| 2.3 | 2.3 | 5.29 | 5.29 | 5.29 | 0.1936 | 0.135669 | 0.162067 | |
| Total | 16.44 | 16.01 | 45.415 | 42.9487 | 44.1554 | 0.3694 | 0.228683 | 0.288 |
| Mean | 2.74 | 2.668333 | ||||||
| Variance | 0.061567 | 0.038114 | Slope | 0.779643 | ||||
| SD | 0.248126 | 0.195228 | intercept | 0.532112 | ||||
| Covariance | 0.048 | |||||||
| Correlation | 0.990893 |
Excel sheet: Formula
| Sxx | Syy | Sxy | ||||||
| Domestic (X) | International (Y) | X2 | Y2 | XY | (X-Xbar)2 | (Y-Ybar)2 | (X-Xbar)(Y-Ybar) | |
| 3 | 2.84 | =B3^2 | =C3^2 | =B3*C3 | =(B3-$B$10)^2 | =(C3-$C$10)^2 | =(B3-$B$10)*(C3-$C$10) | |
| 2.98 | 2.84 | =B4^2 | =C4^2 | =B4*C4 | =(B4-$B$10)^2 | =(C4-$C$10)^2 | =(B4-$B$10)*(C4-$C$10) | |
| 2.89 | 2.81 | =B5^2 | =C5^2 | =B5*C5 | =(B5-$B$10)^2 | =(C5-$C$10)^2 | =(B5-$B$10)*(C5-$C$10) | |
| 2.69 | 2.67 | =B6^2 | =C6^2 | =B6*C6 | =(B6-$B$10)^2 | =(C6-$C$10)^2 | =(B6-$B$10)*(C6-$C$10) | |
| 2.58 | 2.55 | =B7^2 | =C7^2 | =B7*C7 | =(B7-$B$10)^2 | =(C7-$C$10)^2 | =(B7-$B$10)*(C7-$C$10) | |
| 2.3 | 2.3 | =B8^2 | =C8^2 | =B8*C8 | =(B8-$B$10)^2 | =(C8-$C$10)^2 | =(B8-$B$10)*(C8-$C$10) | |
| Total | =SUM(B3:B8) | =SUM(C3:C8) | =SUM(D3:D8) | =SUM(E3:E8) | =SUM(F3:F8) | =SUM(G3:G8) | =SUM(H3:H8) | =SUM(I3:I8) |
| Mean | =B9/6 | =C9/6 | ||||||
| Variance | =(D9/6)-(B10^2) | =(E9/6)-(C10^2) | Slope | =I9/G9 | ||||
| SD | =SQRT(B11) | =SQRT(C11) | intercept | =C10-F11*B10 | ||||
| Covariance | =(F9/6)-(B10*C10) | |||||||
| Correlation | =B13/(B12*C12) |
a) r=0.99
b) Response: International carrier
Predictor: Domestic cost
c) Slope = 0.7796 and intercept = 0.5321
d) y=0.5321+0.7796 x
international carrier = 0.5321+0.7796 Domestic cost
orchestra answered 2 years agoRelated Solutions
Assume the following data represent the cost of a gallon of gasoline ($) at all the...
Assume the following data represent the cost of a gallon of
gasoline ($) at all the various gas stations around town on a given
day. Take a random sample of size 5 from this population.
2.59 3.01 3.15 2.83 2.79 2.59 2.96 3.05 3.19 3.03 2.65 2.74 2.83
2.69 3.05 3.10 2.89 2.84 2.63 3.11 2.76 2.89 2.90 3.09 3.05 2.71
2.84 2.90 2.75 2.90 2.56 2.89 2.76 2.87 2.92 3.05 3.09 2.57 3.20
2.76
a) Describe the individual, variable,...
The accompanying data represent the miles per gallon of a random sample of cars with a...
The accompanying data represent the miles per gallon of a random
sample of cars with a three-cylinder, 1.0 liter engine.
(a)
Compute the z-score corresponding to the individual who
obtained
41.4 miles per gallon. Interpret this result.
(b)
Determine the quartiles.
(c)
Compute and interpret the interquartile range, IQR.
(d)
Determine the lower and upper fences. Are there any
outliers?
32.7
34.0
34.7
35.4
36.0
36.2
37.3
37.6
37.7
37.9
38.1
38.5
38.6
39.0
39.2
39.4
39.9
40.7
41.4
41.8...
The accompanying data represent the miles per gallon of a random sample of cars with a...
The accompanying data represent the miles per gallon of a random
sample of cars with a three-cylinder, 1.0 liter engine.
(a)
Compute the z-score corresponding
to the individual who obtained
36.3
miles per gallon. Interpret this result.
(b)
Determine the quartiles.
(c)
Compute and interpret the interquartile range, IQR.
(d)
Determine the lower and upper fences. Are there any
outliers?
LOADING...
Click the icon to view the data
32.5
35.9
38.0
38.6
39.9
42.4
34.4
36.3
38.1
38.7
40.6
42.7...
The accompanying data represent the miles per gallon of a random sample of cars with a...
The accompanying data represent the miles per gallon of a random
sample of cars with a three-cylinder, 1.0 liter engine. (a)
Compute the z-score corresponding to the individual who obtained
38.4 miles per gallon. Interpret this result. (b) Determine the
quartiles. (c) Compute and interpret the interquartile range,
IQR. (d) Determine the lower and upper fences. Are there any
outliers? 32.5; 35.9; 37.6; 38.6; 40.4; 42.5; 34.0; 36.2; 37.8;
38.9; 40.6; 42.6; 34.7; 37.3; 38.1; 39.4 ;41.3; 43.4; 35.6; 37.4;...
the accompanying data represent the miles per gallon of a random sample of cars with a...
the accompanying data represent the miles per gallon
of a random sample of cars with a three-cylinder, 1.0 liter
engine. (a) compute the z-score corresponding to the individual
who obtained 38.7 miles per gallon. interpret this result. (b)
determine the quartiles. (c) compute and interpret the
interquartile range, iqr. (d) determine the lower and upper
fences. are there any outliers?39.939.9 42.442.4 34.634.6 36.336.3
38.138.1 38.938.9 40.540.5 42.842.8 34.734.7 37.537.5 38.338.3
39.439.4 41.441.4 43.643.6 35.235.2 37.637.6 38.538.5 39.739.7
41.641.6 49.049.0
The accompanying data represent the miles per gallon of a random sample of cars with a...
The accompanying data represent the miles per gallon of a random
sample of cars with a three-cylinder, 1.0 liter engine.
(a)
Compute the z-score corresponding to the individual who
obtained
39.839.8
miles per gallon. Interpret this result.
(b)
Determine the quartiles.
(c)
Compute and interpret the interquartile range, IQR.
(d)
Determine the lower and upper fences. Are there any
outliers?
32.4
34.1
34.5
35.7
36.1
36.3
37.5
37.7
37.9
38.1
38.3
38.5
38.7
39.1
39.5
39.8
39.9
40.6
41.3
41.6...
The accompanying data represent the miles per gallon of a random sample of cars with a...
The accompanying data represent the miles per gallon of a random
sample of cars with a three-cylinder, 1.0 liter engine. (a)
Compute the z-score corresponding to the individual who obtained
32.7 miles per gallon. Interpret this result. (b) Determine the
quartiles. (c) Compute and interpret the interquartile range,
IQR. (d) Determine the lower and upper fences. Are there any
outliers?
32.7
35.9
38.0
38.7
40.2
42.2
34.4
36.2
38.1
38.9
40.7
42.7
34.6
37.5
38.2
39.5
41.5
43.6
35.2
37.8...
Featured below are data on fuel economy (in miles/gallon) for a random sample of 12 mid-size...
Featured below are data on fuel economy (in miles/gallon) for a
random sample of 12 mid-size cars.
X: {25.8, 20.2, 28.7, 24.6, 19.5, 33.1, 30.5, 27.7, 28.4, 30.9,
22.3, 24.2}
Construct a 95% confidence interval for the true mean fuel
economy
Conduct a test to determine whether the true mean is
higher than 25.0 miles/ gallon.
The null and alternative hypothesis
The test statistic
The p-value of the test,
Your decision and the interpretation in the context of the
problem.
The table below contains the overall miles per gallon (MPG) of a type of vehicle. Complete...
The table below contains the overall miles per gallon (MPG) of
a type of vehicle. Complete parts a and b below.
2929
2727
2323
3535
2828
2020
2828
3030
2929
2727
3535
2929
3434
3333
a. Construct a 99% confidence interval estimate for the
population mean MPG for this type of vehicle, assuming a normal
distribution. The 99% confidence interval estimate is from:
MPG to MPG.
(Round to one decimal place as needed.)
b. Interpret the interval constructed in (a)
The table below contains the overall miles per gallon (MPG) of a type of vehicle. 28...
The table below contains the overall miles per gallon (MPG) of
a type of vehicle.
28
29
24
22
29
32
23
25
35
32
35
23
26
34
Construct a 95% confidence interval estimate for the population
mean MPG for this type of vehicle, assuming a normal
distribution.The 95% confidence interval estimate is from ____ MPG
to ____ MPG.
(Round to one decimal place as needed.)
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Singh Development Co. is deciding whether to proceed with Project X. The cost would be $12...
- CS2123 Data Structures - Fall 2019 Assignment 1: Function Runtimes Table Due 9/11/19 by 11:59pm Completing...
- Question 2. Design a 16-1 MUX using any number of lower MUXs, such as 8-1 or...
- . Write a function that takes, as arguments, two objects, value1 and value2. If
- Wii Brothers, a game manufacturer, has a new idea for an adventure game. It can market...
- Consider the distillation of ethanol (C2H5OH) and the combustion of ethanol . Use a bullet point...
- 1.How does Economic exposure to exchange rate movements affect the capital budgeting of a firm? Provide...
ADVERTISEMENT