Buss1020 assignment 400 word + table (due in 12 hours)

profilefanbing910724
BUSS1020_data2017S2.xlsx
Home>Business & Finance homework help>Buss1020 assignment 400 word + table (due in 12 hours)

BUSS1020Assignment2015

Spirit White wine Beer Red wine day number promotion temperature Weekend
70 44 16 27 1 0 20 0
55 73 19 26 2 0 20 0
42 69 19 29 3 0 23 0
41 66 9 17 4 0 26 0
38 28 13 57 5 1 26 0
37 28 9 90 6 1 26 1
37 40 12 24 7 1 29 0
37 39 30 27 8 0 25 0
36 55 20 34 9 1 30 0
34 36 23 41 10 1 25 0
33 39 20 61 11 0 25 0
33 86 13 64 12 0 25 0
32 34 6 31 13 0 26 0
32 22 20 29 14 1 23 0
32 48 160 48 15 0 20 1
32 43 31 50 16 0 26 0
31 33 14 101 17 0 24 1
30 39 157 55 18 0 22 1
30 52 102 51 19 0 28 1
30 29 80 31 20 1 22 0
29 61 95 63 21 1 20 1
29 42 32 75 22 1 24 0
28 31 122 23 23 1 22 1
28 12 111 29 24 0 24 1
28 36 27 30 25 0 20 0
27 67 9 31 26 0 21 0
27 100 24 28 27 0 20 1
26 37 20 38 28 1 26 0
26 35 24 26 29 1 17 0
25 34 35 26 30 0 23 0
24 72 144 78 31 0 22 1
24 28 111 27 32 0 21 1
24 72 62 32 33 0 28 0
24 64 139 37 34 0 24 1
24 28 152 31 35 0 20 1
24 38 31 22 36 0 18 0
23 33 18 31 37 0 19 0
23 45 16 38 38 0 23 0
23 36 30 55 39 0 23 0
23 63 125 0 40 0 20 1
22 36 12 0 41 1 24 0
22 73 37 0 42 0 22 0
22 34 28 35 43 1 20 0
22 53 15 22 44 0 20 0
22 38 22 24 45 1 28 0
21 57 169 19 46 0 22 1
21 25 31 39 47 1 18 0
21 46 51 37 48 0 22 0
20 90 116 39 49 0 20 1
20 36 17 22 50 0 27 0
20 17 42 106 51 1 25 1
19 25 83 33 52 1 20 0
19 41 44 31 53 1 25 0
19 34 23 27 54 1 18 0
19 57 48 46 55 1 22 0
19 27 27 31 56 1 23 0
19 32 141 24 57 1 25 1
19 35 56 35 58 1 17 0
18 30 13 23 59 1 24 0
18 33 6 62 60 1 24 0
18 62 19 47 61 1 24 0
18 44 25 25 62 1 24 0
18 23 48 25 63 1 27 0
18 72 34 27 64 1 20 0
18 23 122 29 65 1 23 1
18 27 33 24 66 1 20 0
17 23 57 20 67 1 29 0
17 35 75 57 68 1 22 0
17 81 43 27 69 0 19 1
17 110 322 25 70 0 28 1
17 109 43 30 71 1 20 1
16 39 18 42 72 0 18 0
16 38 41 36 73 0 24 0
15 26 7 40 74 1 26 0
15 42 77 8 75 1 23 0
14 29 49 18 76 1 17 0
14 54 31 33 77 1 20 0
14 33 16 34 78 1 23 0
14 32 31 16 79 1 20 0
14 47 101 24 80 0 25 1
14 70 42 18 81 0 20 0
13 25 88 25 82 1 20 1
12 41 110 22 83 0 18 1
11 28 4 9 84 1 21 0
10 82 588 50 85 1 28 1
9 32 29 16 86 0 17 0
9 93 113 18 87 1 18 1
9 39 3 17 88 1 26 0
9 32 14 25 89 0 22 0
9 46 28 23 90 0 24 0
8 86 18 24 91 1 18 0
8 64 35 35 92 1 20 0
7 77 10 25 93 0 22 0
6 21 19 51 94 0 26 0
6 102 150 31 95 1 22 1
5 42 36 29 96 0 27 0
5 62 69 21 97 0 20 0
5 80 35 25 98 0 18 0
4 36 123 15 99 1 18 1
4 32 111 55 100 0 26 1

DISCLAIMERS: The data is provided only for BUSS1020 students to gain practice in analysing data and for no other purpose at all. The data have been altered so that no conclusion or estimation from them will have any commercial reliability, accuracy or meaning. Neither the instructors nor the university accept any liability whatsoever for any use which anyone may put this data to. NOTES: The name of the product and store ID are withheld. Column A is the sales of Spirit. Column B is the sales of White wine. Column C is the sales of Beer Column D is the sales of Red wine. Column E is the day (indexed from 1 to 100) when the sales are recorded. Column F indicates whether white wine is on promotion (=1) or not on promotion (=0). Column G is the average outdoor temperature of the day in degrees Celsius. Column H is equal to 1 if the day recorded is during the weekend and 0 otherwise.