Customer Day Browser Time (min) Pages Viewed Amount Spent ($) 1 Mon Safari 12 6 59.5...

 

 

Transcribed Image Text:

Customer Day Browser Time (min) Pages Viewed Amount Spent ($) 1 Mon Safari 12 6 59.5 2 Wed Chrome 18.5 5 86.9 3 Mon Internet Explorer 7.5 3 27.7 4 Tue Firefox 11.4 1 37.7 5 Wed Safari 12.3 2 63.3 6 Sat Firefox 10.5 4 65.8 7 Sun Internet Explorer 10.4 2 32 Y 8 Fri Firefox 4.3 6 59 9 Wed Firefox 12.7 1 62.9 10 Tue Safari 23.7 5 75.7 11 Sat Chrome 13.3 8 52 12 Sun Firefox 15.3 7 40.1 13 Sun Chrome 10.7 6 57.2 14 Mon Firefox 23.4 12 164.5 15 Fri Internet Explorer 8.4 4 81.1 16 Thu Safari 10.6 4 66.2 17 Thu Safari 22.3 6 98.6 27 28 29 30 12222222222225 18 Mon Internet Explorer 15 8 134.4 Fri Chrome 6.6 5 70.5 20 Wed Safari 15.1 6 26.7 Background: Sounders Sweets is a relatively new company that has recently opened up a web site to try to increase its sales and increase its brand recognition in the Seattle Area. Website sales have exceeded the company's expectations, and management is now considering strategies to increase sales even further. To learn more about the website customers, a random sample of 50 Sounders Sweets transactions was selected from the previous month's sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the website, the number of website pages viewed, and ThunceINOCRUNCH GRE PEACE ESPRESSO FLE BAR CONFUSION A Natur GA the amount spent by each of the 50 customers are contained in the data file. Sounders Sweets would like to use the sample data to try to better understand their next business moves. What You Will Do: Questions 1&2: You will start by looking at some summary statistics for some of the variables in the data set. You may find it helpful to use the "Group By" feature in the options screen. Question 2: You will use contingency tables to analyze how customers behave. Sat Firefox 15.3 7 80.6 Tue Safari 10.2 8 73.4 23 Sun Internet Explorer 7 2 31.7 24 Tue Firefox 9 1 49.7 Question 1 Fri Firefox 9.6 26 Wed Safari 11 Sat Internet Explorer 17.9 Sat Firefox 6 Fri Firefox 33.9 Mon Chrome 10.8 Thu Safari 7.1 5263FF4 51.7 43.5 26.7 31.9 11 154.3 11 114.3 48.2 32 Fri Firefox 18 33 Sun Internet Explorer 10.8 34 Fri Safari 10.1 951 139.4 29.2 18 53.1 35 Tue Safari 6.8 4 72.8 36 Mon Firefox 17.5 6 52 Your team begins by looking at some summary stats for all three quantitative variables (Time, Pages Viewed, and Amount Spent), but grouped by browser used. After you generate these summary statistics, report the following: 1) The median value for Amount Spent for those transactions made with the Chrome browser: Answer: $4.30 (Report your answer rounded to 2 decimal places) 2) The mean number of Pages Viewed for transactions that use the Safari browser: Answer pages. (Report your answer rounded to 2 decimal places) 3) The standard deviation of Time for transactions that use the Firefox browser: Answer (Report your answer rounded to 3 decimal places) 37 Thu Firefox 5.2 3 83.2 38 Sat Safari 10.3 6 52,6 Question Help: Post to forum 39 Tue Internet Explorer 11.6 0 33.1 Check Answer 40 Wed Safari 6 3 31.5 41 Tue Chrome 14.9 2 2 67.4 42 Sat Internet Explorer 18.1 43 Fri 44 Mon Firefox Safari 11.8 12.3 45 Mon Internet Explorer 31.1 46 Fri Firefox 13.7 47 Thu Internet Explorer 9.1 48 Fri Safari 9.7 49 Mon Chrome 8.3 50 Fri Safari 12.4 626951352 6 63.1 2 65.4 107.7 7 107.2 62.2 18.8 101.2 45.2 100.8 Customer Day Browser Time (min) Pages Viewed Amount Spent ($) 1 Mon Safari 12 6 59.5 2 Wed Chrome 18.5 5 86.9 3 Mon Internet Explorer 7.5 3 27.7 4 Tue Firefox 11.4 1 37.7 5 Wed Safari 12.3 2 63.3 6 Sat Firefox 10.5 4 65.8 7 Sun Internet Explorer 10.4 2 32 Y 8 Fri Firefox 4.3 6 59 9 Wed Firefox 12.7 1 62.9 10 Tue Safari 23.7 5 75.7 11 Sat Chrome 13.3 8 52 12 Sun Firefox 15.3 7 40.1 13 Sun Chrome 10.7 6 57.2 14 Mon Firefox 23.4 12 164.5 15 Fri Internet Explorer 8.4 4 81.1 16 Thu Safari 10.6 4 66.2 17 Thu Safari 22.3 6 98.6 27 28 29 30 12222222222225 18 Mon Internet Explorer 15 8 134.4 Fri Chrome 6.6 5 70.5 20 Wed Safari 15.1 6 26.7 Background: Sounders Sweets is a relatively new company that has recently opened up a web site to try to increase its sales and increase its brand recognition in the Seattle Area. Website sales have exceeded the company's expectations, and management is now considering strategies to increase sales even further. To learn more about the website customers, a random sample of 50 Sounders Sweets transactions was selected from the previous month's sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the website, the number of website pages viewed, and ThunceINOCRUNCH GRE PEACE ESPRESSO FLE BAR CONFUSION A Natur GA the amount spent by each of the 50 customers are contained in the data file. Sounders Sweets would like to use the sample data to try to better understand their next business moves. What You Will Do: Questions 1&2: You will start by looking at some summary statistics for some of the variables in the data set. You may find it helpful to use the "Group By" feature in the options screen. Question 2: You will use contingency tables to analyze how customers behave. Sat Firefox 15.3 7 80.6 Tue Safari 10.2 8 73.4 23 Sun Internet Explorer 7 2 31.7 24 Tue Firefox 9 1 49.7 Question 1 Fri Firefox 9.6 26 Wed Safari 11 Sat Internet Explorer 17.9 Sat Firefox 6 Fri Firefox 33.9 Mon Chrome 10.8 Thu Safari 7.1 5263FF4 51.7 43.5 26.7 31.9 11 154.3 11 114.3 48.2 32 Fri Firefox 18 33 Sun Internet Explorer 10.8 34 Fri Safari 10.1 951 139.4 29.2 18 53.1 35 Tue Safari 6.8 4 72.8 36 Mon Firefox 17.5 6 52 Your team begins by looking at some summary stats for all three quantitative variables (Time, Pages Viewed, and Amount Spent), but grouped by browser used. After you generate these summary statistics, report the following: 1) The median value for Amount Spent for those transactions made with the Chrome browser: Answer: $4.30 (Report your answer rounded to 2 decimal places) 2) The mean number of Pages Viewed for transactions that use the Safari browser: Answer pages. (Report your answer rounded to 2 decimal places) 3) The standard deviation of Time for transactions that use the Firefox browser: Answer (Report your answer rounded to 3 decimal places) 37 Thu Firefox 5.2 3 83.2 38 Sat Safari 10.3 6 52,6 Question Help: Post to forum 39 Tue Internet Explorer 11.6 0 33.1 Check Answer 40 Wed Safari 6 3 31.5 41 Tue Chrome 14.9 2 2 67.4 42 Sat Internet Explorer 18.1 43 Fri 44 Mon Firefox Safari 11.8 12.3 45 Mon Internet Explorer 31.1 46 Fri Firefox 13.7 47 Thu Internet Explorer 9.1 48 Fri Safari 9.7 49 Mon Chrome 8.3 50 Fri Safari 12.4 626951352 6 63.1 2 65.4 107.7 7 107.2 62.2 18.8 101.2 45.2 100.8