See below

profilePreference
21stexceldata.xlsx
Home>Business & Finance homework help>Economics homework help>See below

Day Customers

Purchase Purchase
Revenue Cost
27.50 20.89
30.22 22.90
34.99 27.40
18.08 13.53
34.48 25.32
25.55 17.17
19.77 15.49
25.13 18.11
26.16 21.91
29.67 22.75
27.37 22.03
35.71 26.61
28.07 20.31
38.86 26.51
40.88 33.39
37.31 26.83
31.69 26.89
38.59 25.51
26.38 20.55
27.09 18.66
21.78 14.93
21.39 15.38
28.84 19.96
27.39 22.24
20.29 14.72
16.11 11.41
22.60 19.23
32.79 22.50
33.37 26.00
22.14 18.31

Evening Customers

Purchase Purchase
Revenue Cost
35.29 29.00
29.66 22.20
30.87 21.01
31.40 25.60
25.95 21.95
28.69 19.42
28.82 22.89
29.92 20.07
30.15 22.39
27.89 19.99
31.30 25.63
33.44 26.51
27.49 22.36
29.91 22.26
47.78 34.08
32.43 25.81
25.20 16.86
32.99 23.54
21.90 16.19
42.19 31.88
28.48 22.12
39.20 33.09
28.52 19.76
32.15 23.24
30.81 23.79
32.61 22.68
25.29 21.51
26.07 20.27
19.35 16.50
29.90 25.07

All Customers

Purchase Purchase
Revenue Cost
27.50 20.89 Average Purchase Rev
30.22 22.90 Ave Purchase cost
34.99 27.40 29.43 22.25
18.08 13.53
34.48 25.32
25.55 17.17 Total average per purchase
19.77 15.49 7.18
25.13 18.11
26.16 21.91
29.67 22.75 Add a scatter plot
27.37 22.03
35.71 26.61
28.07 20.31
38.86 26.51
40.88 33.39
37.31 26.83
31.69 26.89
38.59 25.51
26.38 20.55
27.09 18.66
21.78 14.93
21.39 15.38
28.84 19.96
27.39 22.24
20.29 14.72
16.11 11.41
22.60 19.23
32.79 22.50
33.37 26.00
22.14 18.31
35.29 29.00
29.66 22.20
30.87 21.01
31.40 25.60
25.95 21.95
28.69 19.42
28.82 22.89
29.92 20.07
30.15 22.39
27.89 19.99
31.30 25.63
33.44 26.51
27.49 22.36
29.91 22.26
47.78 34.08
32.43 25.81
25.20 16.86
32.99 23.54
21.90 16.19
42.19 31.88
28.48 22.12
39.20 33.09
28.52 19.76
32.15 23.24
30.81 23.79
32.61 22.68
25.29 21.51
26.07 20.27
19.35 16.50
29.90 25.07
0

Sheet5