Reference no: EM132204065
Assignment - This assignment MUST be your own work.
A web developer is interested in how customers are using his online store. He is interested in the following
a) How much time customers spend on web pages searching for goods and if this is related to how much they spend?
b) Any difference between the time of day and the navigation errors customers make.
c) Any difference between male and female customers and time spent browsing.
d) Any relationship between the ages of customers and how much they spend.
The data from his pilot study is shown below:
Customer ID
|
Gender
|
Age
|
Time of day
|
Errors
|
Time spent (minutes)
|
Average spend (£)
|
Cust001
|
M
|
18
|
AM
|
5
|
7.3
|
3.62
|
Cust002
|
M
|
27
|
PM
|
3
|
8.2
|
4.67
|
Cust003
|
F
|
18
|
AM
|
6
|
12.6
|
4.23
|
Cust004
|
F
|
26
|
AM
|
8
|
31.3
|
5.62
|
Cust005
|
M
|
37
|
PA
|
3
|
0.9
|
12.87
|
Cust006
|
M
|
45
|
AM
|
5
|
1.7
|
8.45
|
Cust007
|
M
|
56
|
PA
|
7
|
5.3
|
9.12
|
Cust008
|
F
|
35
|
PM
|
7
|
9.1
|
6.34
|
Cust009
|
F
|
47
|
AM
|
5
|
8.4
|
7.23
|
Cust010
|
M
|
17
|
PM
|
6
|
1.4
|
5.12
|
Cust011
|
M
|
31
|
AM
|
9
|
9.3
|
4.28
|
Cust012
|
F
|
45
|
AM
|
7
|
9.7
|
11.45
|
Cust013
|
F
|
53
|
PM
|
2
|
19.5
|
8.45
|
Cust014
|
F
|
18
|
AM
|
5
|
5.3
|
5.67
|
Cust015
|
M
|
53
|
PM
|
6
|
14.4
|
8.12
|
Cust016
|
F
|
18
|
AM
|
7
|
3.2
|
9.12
|
Cust017
|
F
|
25
|
PM
|
8
|
1.8
|
6.33
|
Cust018
|
M
|
61
|
AM
|
6
|
9.5
|
8.12
|
Cust019
|
F
|
27
|
AM
|
7
|
0.7
|
9.12
|
Cust020
|
M
|
19
|
PM
|
5
|
3.1
|
2.12
|
Cust021
|
M
|
24
|
AM
|
8
|
6.3
|
4.76
|
Cust022
|
F
|
41
|
AM
|
6
|
9.3
|
6.72
|
Cust023
|
M
|
35
|
PM
|
3
|
7.2
|
8.12
|
Cust024
|
M
|
46
|
AM
|
5
|
5.3
|
9.12
|
Cust025
|
M
|
51
|
PM
|
6
|
8.1
|
21.32
|
Cust026
|
F
|
43
|
AM
|
7
|
8.2
|
4.23
|
Cust027
|
F
|
36
|
AM
|
9
|
21.3
|
7.12
|
Cust028
|
M
|
17
|
PM
|
6
|
51.5
|
6.13
|
Cust029
|
M
|
21
|
AM
|
4
|
3.1
|
5.29
|
Cust030
|
F
|
35
|
AM
|
6
|
5.2
|
5.11
|
Cust031
|
F
|
63
|
PM
|
3
|
6.3
|
13.12
|
Cust032
|
F
|
16
|
AM
|
5
|
17.3
|
12.32
|
Cust033
|
M
|
24
|
PM
|
2
|
7.2
|
4.19
|
Cust034
|
F
|
25
|
AM
|
7
|
8.1
|
5.23
|
Cust035
|
M
|
33
|
PM
|
3
|
9.4
|
7.19
|
Cust036
|
M
|
35
|
PM
|
3
|
2.5
|
7.23
|
Cust037
|
M
|
41
|
AM
|
2
|
4.1
|
9.12
|
Cust038
|
F
|
35
|
PM
|
5
|
5.2
|
6.72
|
Cust039
|
F
|
43
|
AM
|
7
|
5.3
|
7.12
|
Cust040
|
M
|
47
|
PM
|
4
|
7.1
|
8.13
|
Cust041
|
M
|
18
|
AM
|
8
|
6.3
|
4.12
|
Cust042
|
F
|
49
|
PM
|
5
|
8.1
|
8.17
|
Cust043
|
M
|
18
|
AM
|
7
|
9.2
|
5.12
|
Cust044
|
F
|
61
|
PM
|
6
|
12.7
|
9.84
|
Cust045
|
M
|
34
|
AM
|
6
|
21.0
|
6.13
|
Cust046
|
F
|
18
|
PM
|
3
|
8.3
|
5.62
|
Cust047
|
F
|
26
|
PM
|
5
|
6.2
|
7.46
|
Cust048
|
M
|
35
|
AM
|
7
|
4.2
|
8.13
|
Cust049
|
F
|
38
|
PM
|
6
|
15.3
|
8.37
|
Cust050
|
F
|
42
|
PM
|
12
|
12.1
|
9.18
|
1. Generate hypotheses for a, b, c and d above (1 sentence per hypothesis).
2. Generate a new hypothesis of your own.
3. List the statistical tests you would use to test the hypotheses for a, b, c, d and the one you have generated yourself.
4. Using SPSS carry out the statistical tests. Show the results of the tests. Do they support or refute your hypotheses?
5. Provide a title
6. Write a 200 word abstract summarising the study and its findings.
7. Explain your sampling strategy (max 200 words).
8. Explain how you would carry out the above study (max 200 words).