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
Get step-by-step solutions from verified subject matter experts
