In the Excel file Facebook Survey, find the average and median hours online/week and number of friends in the sample using the appropriate Excel functions. Compute the midrange and compare all measures of location. (I need to know how to compute the answer myself in Excel).

the data is as follows:

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