Question

Fully answer each part of each question that follows. Be sure to give your reasons and completely answer the questions. This means that I am looking for several sentences of analysis in your answer. Be precise and comprehensive. This assignment is worth a large part of your grade. Cut and paste your answer (from Excel as appropriate) into this document below each question. Proof your final answers and your writing. Submit this document with your answers in it.

1. Tommy’s cab company transports riders using 2 routes. Use the following data to determine the mean driving time and the variance in the driving time.

Route 1	Route 2
54	61
69	62
58	63
47	53
72	58
56	65
66	59
	67

Run Excel descriptive statistics for the data above.

Comment on any differences between the data.

Answer 1

Descriptive Statistics
	Route 1	Route 2
Count	7	8
Sum	422	488
Mean	60.2857	61
Sample Variance	80.9048	19.1429
Coefficient of variation	14.9201	7.1726

The mean dring time for both Route is nearly same.

The variance in the driving time of Route 1 is greater than Route 2. i.e There is larger variability in the driving time of Route 1.

Also From Coefficient of variation(CV) , the CV of Route 2 is less than CV of Route 1 i.e. Route 2 driving time is more consistent.