Question: using the Excel file Facebook Survey , determine if the mean number of hours spent online per week is the same for males as it

using the Excel file Facebook Survey, determine if the mean number of hours spent online per week is the same for males as it is for females.

confidence level 0.05

how should i solve it I want to know by using excel function (data analysis)

Student Gender Hours online/week Friends
1 female 4 150
2 female 10 400
3 female 7 120
4 female 15 500
5 female 9 260
6 female 5 70
7 female 7 90
8 female 5 250
9 female 12 110
10 female 2 30
11 female 6 80
12 female 2 30
13 female 3 200
14 female 6 240
15 female 6 150
16 female 4 90
17 female 8 340
18 female 10 450
19 female 4 50
20 female 4 120
21 male 6 180
22 male 4 280
23 male 5 60
24 male 9 100
25 male 12 380
26 male 8 430
27 male 2 80
28 male 7 170
29 male 6 90
30 male 4 50
31 male 2 50
32 male 5 70
33 male 7 170

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!