Question

We are Social and Hootsuite reported that the typical American spends 2.02 hours (121 minutes) per day accessing the Internet through a mobile device.
You wonder if males and females spend differing amounts of time per day accusing the Internet through a mobile device.
You select a sample of 60 friends and family (30 males and 30 females), collect times spent per day accessing the Internet through a mobile device (in minutes), and store the data collected in InternetMobileTime2

Gender	Minutes
F	72
F	144
F	48
F	72
F	36
F	360
F	44
F	30
F	432
F	24
F	288
F	144
F	144
F	240
F	432
F	144
F	144
F	144
F	576
F	216
F	72
F	72
F	144
F	288
F	144
F	36
F	288
F	48
F	288
F	144
M	432
M	2304
M	108
M	72
M	24
M	12
M	1728
M	720
M	144
M	432
M	432
M	432
M	576
M	576
M	432
M	144
M	216
M	576
M	96
M	288
M	48
M	144
M	144
M	432
M	144
M	36
M	72
M	24
M	288
M	240

Is there evidence of a difference between males a females in the mean time spent per day accessing the Internet via a mobile device? population variance for males = 2.25 and population variance for females = 3.75. Use a 0.05 level of significance.

Kindly provide step by step solution for excel with the conclusion.

Answer 1

Suppose, random variables X and Y denote internet use time (in hours) of male and female respectively.

Population variance is known. So, we have to perform two sample z-test.

We have to test for null hypothesis

against the alternative hypothesis

The EXCEL output is as follows.

Level of significance

We reject our null hypothesis if

Here, we observe that

So, we reject our null hypothesis.

Hence, based on the given data we can conclude that there is significant evidence that there is difference between males and females in the mean time spent per day accessing the Internet via a mobile device.