Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me to understand step by step this case study 1) summaries of every variable with explanation ( customer day browser time page

image text in transcribed

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CFIN

Authors: Scott Besley, Eugene Brigham

5th edition

978-1305666870

Students also viewed these Mathematics questions

Question

Why might firms that are good at OB tend to be more profitable?

Answered: 1 week ago

Question

What are the two primary outcomes in studies of OB?

Answered: 1 week ago

Question

How are correlations interpreted?

Answered: 1 week ago