You are interested in learning if fuel consumption is influenced by factors asso
ID: 3135127 • Letter: Y
Question
You are interested in learning if fuel consumption is influenced by factors associated with weather conditions such as tempeture and humidity. You are able to collect data by driving the same vehicle under various weather conditions. You find a course, measure the miles and over many months, you track the three variables as shown below. Data were collected from 14 separate trips. You believe that the range of conditions will enable you to determine if fuel consumption is influenced by factors like tempetures and humidity. Listed below are the results of your data collection efforts
Conduct a thorough analysis of the data. You do not have to run a multivariate regression analysis.
Temp Humidity MPG 27.0 18 8.4 28.0 68 10.7 32.5 59 12.4 39.0 69 12.8 45.9 35 9.4 57.8 10 9.9 58.1 33 10.8 62.5 74 12.5 88.5 34 14.4 49.0 57 10.8 45.9 18 9.4 17.0 46 8.4 48.0 55 11.7 32.5 68 11.4Explanation / Answer
The data is given below:
Temp
Humidity
MPG
27.0
18
8.4
28.0
68
10.7
32.5
59
12.4
39.0
69
12.8
45.9
35
9.4
57.8
10
9.9
58.1
33
10.8
62.5
74
12.5
88.5
34
14.4
49.0
57
10.8
45.9
18
9.4
17.0
46
8.4
48.0
55
11.7
32.5
68
11.4
We will first give the summary of the data:
Temp
Humidity
MPG
Mean
45.12143
46
10.92857
Standard Error
4.86401
5.717719
0.466508
Median
45.9
50.5
10.8
Mode
32.5
18
8.4
Standard Deviation
18.19946
21.39374
1.745512
Sample Variance
331.2203
457.6923
3.046813
Kurtosis
1.243338
-1.27886
-0.38071
Skewness
0.7998
-0.33127
0.260488
Range
71.5
64
6
Minimum
17
10
8.4
Maximum
88.5
74
14.4
Sum
631.7
644
153
Count
14
14
14
The
correlation matrix of 3 variables Temp, Humidity, MPG respectively is given below:
Matrix CORR1
1.00000 -0.21193 0.59905
-0.21193 1.00000 0.50365
0.59905 0.50365 1.00000
From the correlation matrix it is clear that,
MPG and Temp has correlation as 0.59905 .
MPG and Humidity has correlation as 0.50365 .
i.e fuel consumption is influenced by factors like temperature and humidity.
Temp
Humidity
MPG
27.0
18
8.4
28.0
68
10.7
32.5
59
12.4
39.0
69
12.8
45.9
35
9.4
57.8
10
9.9
58.1
33
10.8
62.5
74
12.5
88.5
34
14.4
49.0
57
10.8
45.9
18
9.4
17.0
46
8.4
48.0
55
11.7
32.5
68
11.4
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.