Can you help me to understand step by step this case study 1) summaries of every variable with explanation ( customer day browser time page viewed amount spent )2) graphical representations of every variables comment on trends and distribution ? Can you explain me by photos all steps in excel ? If it's possible thanks
Customer Day Browser Time (minages Viewbunt Spent ($) Mon Chrome 12,0 54,52 + Bondi Sports Inc. is a company specialised in surfing equipment and kit. Its store is Wed Other 19,5 94,90 Mon Chrome 8.5 26,68 located in Sydney, Australia. Two years ago, the company began selling online and Nmtion Tue Firefox 11,4 44,73 website traffic had exceeded the company's expectations. The management wants to Wed Chrome 11,3 66,27 Sat Firefox 10,5 67,80 consider strategies to increase sales and would like you to analyse the dataset. A Sun Chrome 11,4 36,04 Fri Firefox 4,3 55,96 10 Wed Firefox 12,7 70,94 11 10 Tue Chrome 24,7 68.73 12 11 Sat Other 13,3 54.04 13 12 Sun Firefox 14,3 48.05 14 13 Sun Other 11,7 64,16 15 14 Mon Firefox 24,4 158,51 15 Fri Chrome 84,12 17 16 Thu Chrome 9.6 59,20 18 17 Thu Chrome 23,3 91,62 19 1 Mon Chrome 14,0 126,40 20 1 Fri Other 5,6 68,45 sample of 50 transactions was collected from the previous month's sales in Australian 21 Wed Chrome 15,1 32,69 Dollars (see below a snap shot). 22 2 Sat Firefox 16.3 78.58 22 Tue Chrome 10,2 74,43 23 Sun Chrome 8,0 32,73 Customer Day Browser Time Pages Amount 25 24 Tue Firefox 8,0 48,66 (min) Viewed Spent ($) 26 Fri Firefox 9.6 54,66 27 26 Wed Chrome 11,0 40,54 27 Sat Chrome 16,9 34,69 Mon Chrome 12.0 54.52 29 28 Sat Firefox 27,91 29 Fri Firefox 32.9 155,30 Mon 11,8 120,25 Wed Other 19.5 94.90 30 Other N 32 31 Thu Chrome 7,1 41,20 33 32 Fri Firefox 18,0 134,40 8,5 26.68 34 33 11,8 37, 17 m Mon Chrome Sun Chrome 35 34 Fri Chrome 9,1 52,09 36 35 Tuc Chrome 7,8 71,81 Tue Firefox 11.4 44.73 37 36 Mon Firefox 16,5 59,99 38 37 Thu Firefox 6,2 84,17 39 38 Sat Chrome 11,3 55,58 11.3 40 39 Chrome 10,6 9,06 Wed Chrome 66.27 Tue 41 40 Wed Chrome 5,0 Nint 36,48 42 41 Tue 15,9 67,44 Sat Firefox 10.5 67.80 43 42 Sat Chrome 18,1 60,14 44 43 Fri Firefox 10,8 70,38 45 44 Mon Chrome 13.3 1 10,65 Sun Chrome 11.4 36.04 46 4 Mon Chrome 30,1 104,23 47 46 Fri Firefox 13,7 68, 17 48 47 Thu Chrome 8,1 17,84 Data includes the Day of the Week, the type of browser a customer used, time spent 49 48 Fri Chrome 9.7 103,15 50 49 Mon Other 7.3 52,15 on the website, the number of pages browsed and the amount spent by a customer. 51 50 Fri Chrome 134 98 75 Sheet1
