Scribd
Upload
52 views4 pages

Rocinante 36 Performance Metrics

The document contains data from two car tests - Rocinante 36 and Marengo 32. It includes statistics such as mean, standard deviation, sample size, t-tests and p-values for mileage (km/ltr) and top speed (km/hr) from each test. The t-tests indicate there are no statistically significant differences between the observed means and hypothesized means for any of the variables tested at the 95% confidence level.

Uploaded by

Vanisha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
52 views4 pages

Rocinante 36 Performance Metrics

The document contains data from two car tests - Rocinante 36 and Marengo 32. It includes statistics such as mean, standard deviation, sample size, t-tests and p-values for mileage (km/ltr) and top speed (km/hr) from each test. The t-tests indicate there are no statistically significant differences between the observed means and hypothesized means for any of the variables tested at the 95% confidence level.

Uploaded by

Vanisha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Rocinante 36 Marengo 32 Rocinante 36 - Mileage

Car No. Mileage Top Car No. Mileage Top


(km/ltr) speed (km/ltr) speed
(km/hr) (km/hr)
1 21.2 151.9 1 15.04 211.3 Sample Mean 21.62

2 21.79 147.6 2 15.41 207 Std. Deviation 0.927

3 21.87 145.6 3 15.43 206.2 Hyp. Mean 22.00

4 22.71 136.1 4 15.92 213.4 Sample Size 20

5 22.52 139.7 5 15.2 204.2 Alpha 0.05

6 21.41 146.1 6 15.22 208.7 Deg of freedom 19

7 22.71 139.6 7 14.6 200

8 21.71 143 8 14.41 210.9 T-test 0.207349

9 19.95 136.4 9 14.79 208.5 Test stat (t) -1.835075

10 20.65 146.6 10 14.81 214.2 P-value 0.9589

11 22.86 139.9 11 15.61 215.8 0.9089

12 21.12 136.6 12 15.76 215.8

13 22.8 148.5 13 14.97 215.2 Rocinante 36 - Top Speed

14 20.89 143.4 14 14.71 218.7

15 22.49 134.2 15 15.55 208 Sample Mean 140.97

16 20.94 140.5 16 15.19 212.2 Std. Deviation 5.40

17 20.37 137.8 17 15.36 219.7 Hyp. Mean 140

18 22.72 135.1 18 15.93 216.4 Sample Size 20

19 20.54 138.8 19 14.54 205.8 Alpha 0.05

20 21.14 132 20 14.76 209 Deg of freedom 19

T-test 1.207065

Test stat (t) 0.803602

P-value 0.2158

0.1658
Rocinante 36

Mileage (km/ltr) Top speed (km/hr)

Mean 21.6195 Mean 140.97

Standard Error 0.207348518 Standard Error 1.20706

Median 21.56 Median 139.8

Mode 22.71 Mode #N/A

Standard Deviation 0.927290762 Standard Deviation 5.39816

Sample Variance 0.8598681579 Sample Variance 29.14011

Kurtosis -1.298498562 Kurtosis -0.741706

Skewness -0.066108989 Skewness 0.328217

Range 2.91 Range 19.9

Minimum 19.95 Minimum 132

Maximum 22.86 Maximum 151.9

Sum 432.39 Sum 2819.4

Count 20 Count 20

Confidence Level(95.0%) 0.4339854357 Confidence Level(95.0%) 2.526416

t-Test: Two-Sample Assuming Equal Variances

Mileage (km/ltr) Top speed (km/hr)

Mean 21.6195 140.97

Variance 0.8598681579 29.1401052631579

Observations 20 20

Pooled Variance 14.999986711

Hypothesized Mean Differ 0

df 38

t Stat -97.44931835

P(T<=t) one-tail 1.653201E-47

t Critical one-tail 1.6859544602


P(T<=t) two-tail 3.306403E-47
t Critical two-tail 2.0243941639
Marengo 32 - Mileage Marengo 32 - Top Speed

Sample Mean 15.16 Sample Mean 211.05

Std. Deviation 0.459 Std. Deviation 5.15

Hyp. Mean 15.00 Hyp. Mean 210

Sample Size 20 Sample Size 20

Alpha 0.05 Alpha 0.05

Deg of freedom 19 Deg of freedom 19

T-test 0.102591 T-test 1.150755

Test stat (t) 1.564459 Test stat (t) 0.912445

P-value 0.0671 P-value 0.1865

0.0171 0.1365
Marengo 32

Mileage (km/ltr) Top speed (km/hr)

Mean 15.1605 Mean 211.05

Standard Error 0.102591359 Standard Error 1.150754901

Median 15.195 Median 211.1

Mode #N/A Mode 215.8

Standard Deviation 0.458802503 Standard Deviation 5.146332368

Sample Variance 0.2104997368 Sample Variance 26.484736842

Kurtosis -1.006213683 Kurtosis -0.433355406

Skewness 0.1250452287 Skewness -0.207142237

Range 1.52 Range 19.7

Minimum 14.41 Minimum 200

Maximum 15.93 Maximum 219.7

Sum 303.21 Sum 4221

Count 20 Count 20

Confidence Level(95.0%) 0.2147261811 Confidence Level(95.0%) 2.4085576885

You might also like