Question

1 Approved Answer

Posted on Sep 22, 2024

5. Mr. Allan wants to know the average stay by the operating system, connection, and browser. Using this data as an example, how would you

5. Mr. Allan wants to know the average stay by the operating system, connection, and browser.

Using this data as an example, how would you accomplish question 5?

image text in transcribed

Add To Favorites Yes No Yes 750 255 - Visitor Numb. IP Address Operating System 1 999.010.210.133 Windows 2 999.250.150.140 Linux 3 999.111.233.190 Windows 4 999.140.152.160 Windows 5 999.180.007.222 Macintosh 6 999.204.209.208 Linux 7 999.215.233.111 Macintosh 8 999.177.166.144 Macintosh 9 999.133.205.212 Macintosh 10 999.101.203.011 Windows 11 999.111.233.190 Windows 12 999.104.202.251 Macintosh 13 999.250.150.140 Linux 14 999.111.233.190 Windows 15 999.140.152.160 Windows 16 999.180.007.222 Macintosh 17 999.204.209.208 Windows 18 999.215.233.111 Macintosh 19 999.177.166.144 Windows 20 999.133.205.212 Macintosh 21 999.101.203.011 Windows 22 999.111.233.190 Windows 23 999.104.202.251 Macintosh 24 999.010.210.133 Windows 25 999.250.150.140 Windows 26 999.111.233.190 Windows 27 999.140.152.160 Windows 28 999.180.007.222 Macintosh 29 999.204.209.208 Windows 30 999.215.233.111 Macintosh Browser Site Connection MS Internet Explorer HotBot Mozilla Yahoo Netscape Lycos MS Internet Explorer AltaVista MS Internet Explorer Dogpile Unknown WebCrawler Safari Askjeeves Mozilla About MS Internet Explorer Google MS Internet Explorer MSN MS Internet Explorer MSN Mozilla Askjeeves Mozilla Yahoo Netscape Lycos MS Internet Explorer Google Safari Dogpile Unknown WebCrawler Safari Askjeeves Mozilla About MS Internet Explorer Google MS Internet Explorer MSN MS Internet Explorer MSN Mozilla Askjeeves MS Internet Explorer HotBot Mozilla Yahoo Netscape Lycos MS Internet Explorer Google MS Internet Explorer Dogpile Unknown WebCrawler MS Internet Explorer Askjeeves Entry Exit Visit Duration Bandwidth Viewed Pages 10/10/2008 11:25:59 10/10/2008 11:50:33 0:24:34 400 10/3/2008 11:21:52 10/3/2008 11:33:55 0:12:03 1 10/3/2008 13:58:07 10/3/2008 14:34:02 0:35:55 250 10/5/2008 10:19:03 10/5/2008 10:41:23 0:22:20 10/5/2008 14:41:41 10/5/2008 14:58:00 0:16:19 10/6/2008 1:13:19 10/6/2008 1:28:59 0:15:40 100 10/6/2008 2:49:24 10/6/2008 3:03:35 0:14:11 20 10/7/2008 15:03:37 10/7/2008 15:33:24 0:29:47 300 10/9/2008 5:26:28 10/9/2008 5:36:57 0:10:29 190 10/11/2008 3:53:40 10/11/2008 4:11:00 0:17:20 400 10/11/2008 12:24:18 10/11/2008 13:02:40 0:38:22 10/13/2008 7:17:18 10/13/2008 7:42:33 0:25:15 250 10/13/2008 18:06:50 10/13/2008 18:15:28 0:08:38 750 10/13/2008 22:42:52 10/13/2008 22:51:03 0:08:11 10/15/2008 15:48:21 10/15/2008 16:27:49 0:39:28 10 10/15/2008 19:40:22 10/15/2008 20:06:51 0:26:29 10/17/2008 8:52:44 10/17/2008 8:56:10 0:03:26 10/17/2008 15:10:49 10/17/2008 15:39:20 0:28:31 100 10/19/2008 11:27:05 10/19/2008 11:34:29 0:07:24 20 10/19/2008 19:34:33 10/19/2008 20:11:31 0:36:58 300 10/21/2008 14:26:05 10/21/2008 14:51:01 0:24:56 10/22/2008 1:37:26 10/22/2008 1:51:45 0:14:19 400 10/23/2008 21:07:34 10/23/2008 21:47:29 0:39:55 1 10/25/2008 13:08:46 10/25/2008 13:39:35 0:30:49 250 10/27/2008 9:16:25 10/27/2008 9:26:03 0:09:38 750 10/28/2008 21:50:06 10/28/2008 21:53:11 0:03:05 255 10/29/2008 8:05:57 10/29/2008 8:08:01 0:02:04 100 10/29/2008 16:20:40 10/29/2008 16:58:53 0:38:13 20 10/29/2008 23:35:49 10/30/2008 0:14:08 0:38:19 300 10/31/2008 23:20:51 10/31/2008 23:37:58 0:17:07 190 No Om tomt 9 - 100 190 No Yes No NO Add To Favorites Yes No Yes 750 255 - Visitor Numb. IP Address Operating System 1 999.010.210.133 Windows 2 999.250.150.140 Linux 3 999.111.233.190 Windows 4 999.140.152.160 Windows 5 999.180.007.222 Macintosh 6 999.204.209.208 Linux 7 999.215.233.111 Macintosh 8 999.177.166.144 Macintosh 9 999.133.205.212 Macintosh 10 999.101.203.011 Windows 11 999.111.233.190 Windows 12 999.104.202.251 Macintosh 13 999.250.150.140 Linux 14 999.111.233.190 Windows 15 999.140.152.160 Windows 16 999.180.007.222 Macintosh 17 999.204.209.208 Windows 18 999.215.233.111 Macintosh 19 999.177.166.144 Windows 20 999.133.205.212 Macintosh 21 999.101.203.011 Windows 22 999.111.233.190 Windows 23 999.104.202.251 Macintosh 24 999.010.210.133 Windows 25 999.250.150.140 Windows 26 999.111.233.190 Windows 27 999.140.152.160 Windows 28 999.180.007.222 Macintosh 29 999.204.209.208 Windows 30 999.215.233.111 Macintosh Browser Site Connection MS Internet Explorer HotBot Mozilla Yahoo Netscape Lycos MS Internet Explorer AltaVista MS Internet Explorer Dogpile Unknown WebCrawler Safari Askjeeves Mozilla About MS Internet Explorer Google MS Internet Explorer MSN MS Internet Explorer MSN Mozilla Askjeeves Mozilla Yahoo Netscape Lycos MS Internet Explorer Google Safari Dogpile Unknown WebCrawler Safari Askjeeves Mozilla About MS Internet Explorer Google MS Internet Explorer MSN MS Internet Explorer MSN Mozilla Askjeeves MS Internet Explorer HotBot Mozilla Yahoo Netscape Lycos MS Internet Explorer Google MS Internet Explorer Dogpile Unknown WebCrawler MS Internet Explorer Askjeeves Entry Exit Visit Duration Bandwidth Viewed Pages 10/10/2008 11:25:59 10/10/2008 11:50:33 0:24:34 400 10/3/2008 11:21:52 10/3/2008 11:33:55 0:12:03 1 10/3/2008 13:58:07 10/3/2008 14:34:02 0:35:55 250 10/5/2008 10:19:03 10/5/2008 10:41:23 0:22:20 10/5/2008 14:41:41 10/5/2008 14:58:00 0:16:19 10/6/2008 1:13:19 10/6/2008 1:28:59 0:15:40 100 10/6/2008 2:49:24 10/6/2008 3:03:35 0:14:11 20 10/7/2008 15:03:37 10/7/2008 15:33:24 0:29:47 300 10/9/2008 5:26:28 10/9/2008 5:36:57 0:10:29 190 10/11/2008 3:53:40 10/11/2008 4:11:00 0:17:20 400 10/11/2008 12:24:18 10/11/2008 13:02:40 0:38:22 10/13/2008 7:17:18 10/13/2008 7:42:33 0:25:15 250 10/13/2008 18:06:50 10/13/2008 18:15:28 0:08:38 750 10/13/2008 22:42:52 10/13/2008 22:51:03 0:08:11 10/15/2008 15:48:21 10/15/2008 16:27:49 0:39:28 10 10/15/2008 19:40:22 10/15/2008 20:06:51 0:26:29 10/17/2008 8:52:44 10/17/2008 8:56:10 0:03:26 10/17/2008 15:10:49 10/17/2008 15:39:20 0:28:31 100 10/19/2008 11:27:05 10/19/2008 11:34:29 0:07:24 20 10/19/2008 19:34:33 10/19/2008 20:11:31 0:36:58 300 10/21/2008 14:26:05 10/21/2008 14:51:01 0:24:56 10/22/2008 1:37:26 10/22/2008 1:51:45 0:14:19 400 10/23/2008 21:07:34 10/23/2008 21:47:29 0:39:55 1 10/25/2008 13:08:46 10/25/2008 13:39:35 0:30:49 250 10/27/2008 9:16:25 10/27/2008 9:26:03 0:09:38 750 10/28/2008 21:50:06 10/28/2008 21:53:11 0:03:05 255 10/29/2008 8:05:57 10/29/2008 8:08:01 0:02:04 100 10/29/2008 16:20:40 10/29/2008 16:58:53 0:38:13 20 10/29/2008 23:35:49 10/30/2008 0:14:08 0:38:19 300 10/31/2008 23:20:51 10/31/2008 23:37:58 0:17:07 190 No Om tomt 9 - 100 190 No Yes No NO