Question

(a)	Which of these best describes the shape of the distribution of the data given in the table?				Days traveled per year	Frequency
	i)    Bell-shaped				0-6	15
	ii)   Skewed right				7-13	21
	iii) Skewed left				14-20	27
					21-27	9
					28-34	2
(b)	Extend the frequency table given at the right to include a column for relative frequency. The column should include the values of relative frequency for each given interval of days traveled per year.				35 and above	1

Answer 1

(a) The step-by-step instructi ons to obtain a Frequency Histogram using Excel2010 Store the data in the Excel2010 worksheet Select the ranges of the frequency columns Choose Column chart 2D column Choose Design ->Chart Layouts ->Layout8Style37. *Click Ok The Frequency Hi stogram using Exce2010

The frequency histogram 30 25 20 15 10 5 0 14-20 35 and 0-6 7-13 21-27 28-34 above Days travelled per year(X) Frequency

-------------------------------------------------------------------------------------------------------------------------------------------

Interpretation:

The frequency histogram of the random variable x is defined as the days traveled per year delineate the distribution is skewed to the right. The mean is greater than that of the median in this case. Hence, we can justify that the distribution is skewed to the right.

--------------------------------------------------------------------------------------------------------------------------------------------------------------

(b) The frequencies and relative frequencies for the observed values of the days traveled per year x) is given below The Computati on Table: Frequency Relative Frequency, 0-6 15 0.2 7-13 21 0.28 14-20 27 0.36 21-27 9 0.12 28-34 2 0.026667 35 and above 1 0.013333 i-1 75