Question

Formulas that can be used to analyze these survey results

Do you think that you can safely text and drive?	Always 4	Most of the time 4	Some of the time 10	Rarely 17	Never 65
	Every time I drive	Most of the times I drive	Some of the times I drive	Rarely	Never
In the last 30 days have you written text messages while driving?a (Links to an external site.)Links to an external site.	2	3	9	19	67
In the last 30 days have you read text messages while driving?a (Links to an external site.)Links to an external site.	2	5	18	24	52
In the last 30 days have you written email messages while driving?a (Links to an external site.)Links to an external site.	1	1	2	8	88
In the last 30 days have you read email messages while driving?a (Links to an external site.)Links to an external site.	1	3	7	11	79
In the last 30 days have you viewed maps or directions on your phone while driving?a(Links to an external site.)Links to an external site.	3	7	20	13	57
In the last 30 days have you read messages or viewed information on social media apps or sites while driving? (e.g. Facebook, Twitter, Snapchat, etc.)a (Links to an external site.)Links to an external site.	1	4	7	10	78
	Driving at any speed	Driving at low speeds	In stop-and-go traffic	Stopped at a red light	Never
In the last 30 days, when have you written texts while driving?b (Links to an external site.)Links to an external site.	5	5	8	22	60
In the last 30 days, when have you read TEXTS while driving?b (Links to an external site.)Links to an external site.	9	7	9	26	49
In the last 30 days, When have you written email messages while driving?b (Links to an external site.)Links to an external site.	2	3	3	8	84
In the last 30 days, when have you read Email messages while driving?b (Links to an external site.)Links to an external site.	3	3	5	13	36

Answer 1

Relative frequencies in each row.

Relative Frequency =frequency/total row frequency.

Example: In the first row, for 'Always' :

Relative Frequency =4/((4+4+10+17+65) =4/100 =0.04 =4% (So, only 4% of surveyed members think that they can safely text and drive).

Similarly, for others: most of the time, some of the time, etc,.

Similarly, for the remaining rows - to analyze for each row variable separately.

If we want to analyze for the whole, add frequencies in each column to get column totals and calculate relative frequency for each column total.

Eg: Relative frequency for column "Every time I drive" =Total frequency of that column/Total of all columns.

Similarly, for other column totals to know the proportion of such column variables.