Watch the video linked here on sorting and filtering to get counts, means and standard deviations of filtered data and using those statistics to run a unpaired t-test. Unpaired t-test Video [+]

Open the attached Excel sheet smoking.xlsx

You will also need our ESP4 Excel sheet that we use in this course.

Complete the table below for the sample size, mean and sample standard deviation of the number of cigarettes smoked by males and females. 

Note: Make sure you change any values that say "100 or more cigarettes" to 100. Also, filter out any data that has non-numeric data in the Number of cigarettes column.

	Males	Females
Number sampled
Sample mean
Sample standard deviation

Run a two tailed test to see if the mean number of cigarettes smoked for males is significantly different than the mean number of cigarettes smoked by females.

What is the p-value?  

Is there any significant difference between the average number of cigarettes smoked by males compared to females?