This web page has the answers to the eight "basic" questions from the statistics assignment, but not the required memo.  I did all eight in SPSS even though you were to use Excel for the first four.

# Q1: Average length of time; Procedure = Frequencies

 Output Created 23-FEB-2004 14:38:31 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics are based on all cases with valid data. FREQUENCIES VARIABLES=length /STATISTICS=STDDEV RANGE MINIMUM MAXIMUM MEAN MEDIAN MODE /ORDER= ANALYSIS . 18724 0:00:00.11

 N 50 0 43.56 35 87 29.91 96 3 99

# Q2: Users by domain; Procedure = Frequencies

 Output Created 23-FEB-2004 14:40:06 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics are based on all cases with valid data. FREQUENCIES VARIABLES=domain /PIECHART PERCENT /ORDER= ANALYSIS . 18724 0:00:00.09

Domain

Frequency Percent Valid Percent Cumulative Percent
Valid com 11 22.0 22.0 22.0
edu 6 12.0 12.0 34.0
gov 15 30.0 30.0 64.0
mil 8 16.0 16.0 80.0
net 5 10.0 10.0 90.0
other 5 10.0 10.0 100.0
Total 50 100.0 100.0

# Q3: Clicks thru to any ad; Procedures = Recode, Frequencies

 Output Created 23-FEB-2004 14:44:29 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics are based on all cases with valid data. FREQUENCIES VARIABLES=any_ad /PIECHART PERCENT /ORDER= ANALYSIS . 18724 0:00:00.13

Frequency Percent Valid Percent Cumulative Percent
Valid Yes 32 64.0 64.0 64.0
No 18 36.0 36.0 100.0
Total 50 100.0 100.0

# Q4: Usage by Start hour; Procedures = Compute (truncate function), Frequencies, Bar chart

 Output Created 23-FEB-2004 14:50:53 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics are based on all cases with valid data. FREQUENCIES VARIABLES=start_hr /BARCHART FREQ /ORDER= ANALYSIS . 18724 0:00:00.06

Start hour

Frequency Percent Valid Percent Cumulative Percent
Valid 1 2 4.0 4.0 4.0
2 3 6.0 6.0 10.0
5 1 2.0 2.0 12.0
6 1 2.0 2.0 14.0
7 1 2.0 2.0 16.0
8 1 2.0 2.0 18.0
9 2 4.0 4.0 22.0
10 3 6.0 6.0 28.0
11 4 8.0 8.0 36.0
12 1 2.0 2.0 38.0
13 2 4.0 4.0 42.0
14 3 6.0 6.0 48.0
15 2 4.0 4.0 52.0
16 4 8.0 8.0 60.0
17 5 10.0 10.0 70.0
18 2 4.0 4.0 74.0
19 4 8.0 8.0 82.0
20 3 6.0 6.0 88.0
21 2 4.0 4.0 92.0
22 3 6.0 6.0 98.0
23 1 2.0 2.0 100.0
Total 50 100.0 100.0

# Q5: Usage by Day Part; Procedures = Recode, Frequencies

(Note: Good practice is to go back to the original data rather than base one calculated variable on another.)
 Output Created 23-FEB-2004 14:58:18 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics are based on all cases with valid data. FREQUENCIES VARIABLES=day_part /PIECHART PERCENT /ORDER= ANALYSIS . 18724 0:00:00.16

Day Part

Frequency Percent Valid Percent Cumulative Percent
Valid Overnight 8 16.0 16.0 16.0
Day 22 44.0 44.0 60.0
Evening 20 40.0 40.0 100.0
Total 50 100.0 100.0

# Q6: User domain vs. Accept cookie; Procedure = Crosstabs, looking at "row percentages"

 Output Created 23-FEB-2004 15:02:09 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table. CROSSTABS /TABLES=domain BY cookie /FORMAT= AVALUE TABLES /CELLS= COUNT ROW . 2 14563 0:00:00.13

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Domain * Accepted cookie (Y/N) 50 100.0% 0 .0% 50 100.0%

Domain * Accepted cookie (Y/N) Crosstabulation

no yes
Domain com Count 8 3 11
% within Domain 72.7% 27.3% 100.0%
edu Count 4 2 6
% within Domain 66.7% 33.3% 100.0%
gov Count 9 6 15
% within Domain 60.0% 40.0% 100.0%
mil Count 4 4 8
% within Domain 50.0% 50.0% 100.0%
net Count 1 4 5
% within Domain 20.0% 80.0% 100.0%
other Count 3 2 5
% within Domain 60.0% 40.0% 100.0%
Total Count 29 21 50
% within Domain 58.0% 42.0% 100.0%

# Q7: User domain vs. Any ad; Procedure = Crosstabs (after recode), looking at "row percentages"

 Output Created 23-FEB-2004 15:07:12 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table. CROSSTABS /TABLES=domain BY any_ad /FORMAT= AVALUE TABLES /CELLS= COUNT ROW . 2 14563 0:00:00.18

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Domain * Clicks to any ad (Y/N) 50 100.0% 0 .0% 50 100.0%

Domain * Clicks to any ad (Y/N) Crosstabulation

Clicks to any ad (Y/N) Total
Yes No
Domain com Count 11
11
% within Domain 100.0%
100.0%
edu Count 3 3 6
% within Domain 50.0% 50.0% 100.0%
gov Count 9 6 15
% within Domain 60.0% 40.0% 100.0%
mil Count 3 5 8
% within Domain 37.5% 62.5% 100.0%
net Count 4 1 5
% within Domain 80.0% 20.0% 100.0%
other Count 2 3 5
% within Domain 40.0% 60.0% 100.0%
Total Count 32 18 50
% within Domain 64.0% 36.0% 100.0%

# Q8: "Attractiveness" of ads; Procedures = Recode, Frequencies

(Note: Question was somewhat poorly worded; the banner ad out-ranked any other ad, but not the other ads as a group.)
 Output Created 23-FEB-2004 15:16:00 W:\courses\is208A\s04\web_data.sav 50 User-defined missing values are treated as missing. Statistics are based on all cases with valid data. FREQUENCIES VARIABLES=ad_distr /BARCHART PERCENT /ORDER= ANALYSIS . 18724 0:00:00.31

 N 32 18