Question

In: Statistics and Probability

A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:                        &

  1. A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:                                              

   X Speed   45        52         49         60         67         61        

  Y MPG    22         26         21         28         33         32        

                                                                                                                                 

  1.    Draw Scatter plot
  2. Compute the coefficient of correlation, and make a comment about that.
  3. Compute the coefficient of determination, and make a comment about that.
  4. Compute the coefficient of Non- determination, and make a comment about that.
  5. Find Regression Line and make a comment about that. Also, at what location the line crosses    the y-axis.
  6. What is the “Residual’ at speed of 60?
  7.    What is the predicted fuel consumption at speed of 75 mph.

  1. Determine at the 0.05 significance level whether the correlation in the population is greater than zero.

Solutions

Expert Solution

Dear student, we can answer only four subparts at a time, please help to upload other parts separately.

a)

b)

The coefficient of correlation comes out to be 0.944(shown in excel).

It is a strong positive correlation, which means an increase in X leads to an increase in Y and vice-versa.

c)

The coefficient of determination comes out to be 0.89. It means 89% of the variation in Y can be explained by the variation in X.

d)

coefficient of non-determination = 1 - coefficient of determination = 1 - 0.89 = 0.11

The coefficient of Non-Determination explains the amount of unexplained, or unaccounted for, the variance between two variables, or between a set of variables (predictors) in an outcome variable. Where the Coefficient of Non-Determination is simply 1 – R2.

11% of the unexplained variation in Y is present, it can not be determined.

e)

We will be applying the Linear regression model here, it can be done by using the function LINEST(y_value, x_value, TRUE, TRUE) where y_values contain values of X here and x_values have Y values.

Select 5 rows and 2 columns and then write the formula in the first cell and after that, press Shift + Ctrl + Enter.    

The equation comes out to be -

Y = -4.41 + 0.56*X


Related Solutions

A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:                        &
A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:                                                   X Speed   45        52        49         60         67         61          Y MPG    22         26        21        28        33         32                                                                                                                                             Draw Scatter plot Compute the coefficient of correlation and make a comment about that. Compute the coefficient of determination and make a comment about that. Compute the coefficient of Non- determination and make a comment about that. Find Regression Line and make a comment about that. Also, at what location the line crosses               the y-axis. What is the “Residual’ at...
A fuel consumption study is conducted for two types of automobiles. One representative vehicle of each...
A fuel consumption study is conducted for two types of automobiles. One representative vehicle of each type is selected, and the mileage performance is observed for 10 tanks of fuel in each car. The data obtained, expressed in miles per gallon (mpg), are as follows: Car 1: 24.7 24.9 24.8 24.6 24.9 23.9 24.7 24.9 24.5 24.6 Car 2: 41.7 42.8 42.3 42.4 41.6 39.9 39.5 40.8 41.9 39.6 a) Using the appropriate distribution model and a 95% confidence interval,...
The following data were collected as part of a study of coffee consumption among graduate students....
The following data were collected as part of a study of coffee consumption among graduate students. The following reflect cups per day consumed: 3          4          6          8          2          1          0          2 X X2 0 0 1 1 2 4 2 4 3 9 4 16 6 36 8 64 26 134 Compute the sample mean. Compute the sample standard deviation. Compute the median. Compute the first and third quartiles. Which measure, the mean or median, is a better measure of...
The data below are from a study conducted by a consumer research group on the fuel...
The data below are from a study conducted by a consumer research group on the fuel efficiency (rated based on city miles per gallon) of the 30 top-selling U.S. automobiles. 23 20 16 13 34 27 24 10 16 12 34 26 14 31 15 12 16 36 18 22 15 19 28 38 10 16 14 23 19 44 1. Enter the data into a spreadsheet. Be sure to clearly label and neatly format your spreadsheet. 2. Calculate the...
A traffic study conducted on an interstate highway shows that vehicle speeds (in mph) are normally...
A traffic study conducted on an interstate highway shows that vehicle speeds (in mph) are normally distributed with a mean of 61.3 and a standard deviation of 3.3. a) Sketch the distribution of vehicle speeds. Show 3 steps of standard deviation above and below the mean. b) If a vehicle is randomly checked, what is the probability that its speed is greater than 70? Include a sketch. c) If 5 vehicles are randomly sampled, what is the probability that their...
The following data was collected in a laboratory experiment conducted at 305.2 K. A.) Determine the...
The following data was collected in a laboratory experiment conducted at 305.2 K. A.) Determine the complete rate law for this simple chemical process A → B Time Concentration 0 4.804 0.5 3.26799191 1 2.279801588 1.5 1.573137404 2 1.047454686 2.5 0.713650161 3 0.52422989 3.5 0.366551798 4 0.218181335 4.5 0.183699478 5 0.132508896 5.5 0.097326158 6 0.033145439 6.5 0.036526291 7 0.005104128 7.5 0.017253798 8 0.01185835 8.5 0.008150117 9 0.025601488 9.5 0.016150157 10 0.002645956 10.5 0.018181463 11 0.018750139 11.5 0.020859016 12 0.020590393 12.5...
The accompanying data show spot speeds collected at a section of highway located in a residential...
The accompanying data show spot speeds collected at a section of highway located in a residential area. (i) Using the student’s t test, determine whether there was a statistically significant difference in the average speeds at the 95% confidence level. (ii) Also report for before and after the following: mean speed, standard deviation, 85th percentile speed and percentage of traffic exceeding the posted speed limit of 30 MPH. (iii) using the data, draw the histogram frequency distribution, cumulative percentage distribution...
The consumption rates of two aviation fuels, A and B, are compared. The sample from fuel...
The consumption rates of two aviation fuels, A and B, are compared. The sample from fuel A have 12 specimens with a mean burning rate of 21 cm/s and the sample from fuel B have 10 specimens with a mean burning rate of 18 cm/s. If the standard deviation in burning rates of the fuels are 3.5 cm/s and 3 cm/s for fuel A and fuel B, respectively, test the hypothesis that the burning rate of fuel A is more...
The consumption rates of two aviation fuels, A and B, are compared. The sample from fuel...
The consumption rates of two aviation fuels, A and B, are compared. The sample from fuel A have 12 specimens with a mean burning rate of 21 cm/s and the sample from fuel B have 10 specimens with a mean burning rate of 18 cm/s. If the standard deviation in burning rates of the fuels are 3.5 cm/s and 3cm/s for fuel A and fuel B, respectively, test the hypothesis that the difference in mean burning rates of fuels is...
The consumption rates of two aviation fuels, A and B, are compared. The sample from fuel...
The consumption rates of two aviation fuels, A and B, are compared. The sample from fuel A have 12 specimens with a mean burning rate of 21 cm/s and the sample from fuel B have 10 specimens with a mean burning rate of 18 cm/s. If the standard deviation in burning rates of the fuels are 3.5 cm/s and 3cm/s for fuel A and fuel B, respectively, test the hypothesis that the difference in mean burning rates of fuels is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT