Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Day Mon Wed Mon Tue Wed Sat Sun Fri Wed Tue Sat Sun Sun Mon Fri Thu Thu Mon Fri Wed Sat Tue Sun Tue Fri Wed Sat Sat Fri Mon Thu Fri Sun Fri Tue Mon Thu Sat Tue Wed Tue Sat Fri Mon Mon Fri Thu Fri Mon Fri Browser Time (min) Pages Viewed Amount Spent ($) Internet Explorer 12.0 4 54.52 Other 19.5 6 94.90 Internet Explorer 8.5 4 26.68 Firefox 11.4 2 44.73 Internet Explorer 11.3 4 66.27 Firefox 10.5 6 67.80 Internet Explorer 11.4 2 36.04 Firefox 4.3 6 55.96 Firefox 12.7 3 70.94 Internet Explorer 24.7 7 68.73 Other 13.3 6 54.04 Firefox 14.3 5 48.05 Other 11.7 7 64.16 Firefox 24.4 10 158.51 Internet Explorer 8.4 3 84.12 Internet Explorer 9.6 4 59.20 Internet Explorer 23.3 7 91.62 Internet Explorer 14.0 7 126.40 Other 5.6 4 68.45 Internet Explorer 15.1 5 32.69 Firefox 16.3 5 78.58 Internet Explorer 10.2 6 74.43 Internet Explorer 8.0 3 32.73 Firefox 8.0 2 48.66 Firefox 9.6 3 54.66 Internet Explorer 11.0 2 40.54 Internet Explorer 16.9 5 34.69 Firefox 6.0 4 27.91 Firefox 32.9 10 155.30 Other 11.8 9 120.25 Internet Explorer 7.1 2 41.20 Firefox 18.0 8 134.40 Internet Explorer 11.8 4 37.17 Internet Explorer 9.1 3 52.09 Internet Explorer 7.8 5 71.81 Firefox 16.5 5 59.99 Firefox 6.2 4 84.17 Internet Explorer 11.3 4 55.58 Internet Explorer 10.6 2 39.06 Internet Explorer 5.0 5 36.48 Other 15.9 4 67.44 Internet Explorer 18.1 7 60.14 Firefox 10.8 4 70.38 Internet Explorer 13.3 7 110.65 Internet Explorer 30.1 6 104.23 Firefox 13.7 4 68.17 Internet Explorer 8.1 2 17.84 Internet Explorer 9.7 5 103.15 Other 7.3 6 52.15 Internet Explorer 13.4 3 98.75 Tweety's Cat Care Web Site Transactions Miss Tweety manufactures and sells cat care products at its plant and retail store located in Hialeah, Florida. Last year, the company developed a Web site and began selling its products over the Internet. Web site sales have exceeded the company's expectations, and management is now considering strategies to increase sales even further. To learn more about the Web site customers, a sample of 50 of Tweety's 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 Web site, the number of Web site pages viewed, and the amount spent by each of the 50 customers are contained in the file named \"Ch2 Tweety\". Miss Tweety would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the Web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. Managerial Report Use the methods of descriptive statistics to learn about the customers who visit Tweety's Web site. Include the following in your report. 1. Graphical and numerical summaries for the length of time the shopper spends on the Web site, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Tweety's online shoppers from these numerical summaries. 2. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. What observations can you make about Tweety's business based on the day of the week? Discuss. 3. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. What observations can you make about Tweety's business based on the type of browser? Discuss. 4. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the Web site and the dollar amount spent. Use the horizontal axis for the time spent on the Web site. Discuss. 5. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of Web site pages viewed and the amount spent. Use the horizontal axis for the number of Web site pages viewed. Discuss. 6. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the Web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss. 1. Summary Data -> data Analysis -> Descriptive Analysis Time (min) Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 12.81 0.85748207 6 11.4 11.4 6.06331390 5 36.7637755 1 2.40404907 6 1.44983193 2 28.6 4.3 32.9 640.5 50 Pages Viewed Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness 4.82 0.28811845 6 4.5 4 2.03730514 3 4.15061224 5 0.16878738 5 0.64639039 9 Range Minimum Maximum Sum Count 8 2 10 241 50 Amount Spent ($) Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 68.1282 4.57409810 2 62.15 #N/A 32.3437578 6 1046.11867 2 0.87654645 7 1.04904543 6 140.67 17.84 158.51 3406.41 50 On an average customers spent 13 minutes viewing around 5 pages and spending $68. 2. Summary per week Data -> data Analysis -> Regression Summary is calculated by making pivot table. Day Mon Tue Wed Thu Fri Sat Sun Average of Time Average of Pages Average of Amount Spent (min) Viewed ($) 15.32222222 6.444444444 90.37555556 12.65714286 4 59.26571429 12.43333333 4.166666667 56.97 10.86 3.8 58.806 12.31818182 4.818181818 85.94818182 13.2 5.285714286 54.10571429 11.44 4.2 43.63 3. Summary Browser Browser Firefox Internet Explorer Other Average of Time Average of Pages Average of Amount Spent (min) Viewed ($) 13.475 5.0625 76.763125 12.58518519 12.15714286 4.37037037 6 61.36333333 74.48428571 1. Summary Data -> data Analysis -> Descriptive Analysis Time (min) Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 12.81 0.85748207 6 11.4 11.4 6.06331390 5 36.7637755 1 2.40404907 6 1.44983193 2 28.6 4.3 32.9 640.5 50 Pages Viewed Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness 4.82 0.28811845 6 4.5 4 2.03730514 3 4.15061224 5 0.16878738 5 0.64639039 9 Range Minimum Maximum Sum Count 8 2 10 241 50 Amount Spent ($) Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 68.1282 4.57409810 2 62.15 #N/A 32.3437578 6 1046.11867 2 0.87654645 7 1.04904543 6 140.67 17.84 158.51 3406.41 50 On an average customers spent 13 minutes viewing around 5 pages and spending $68. 2. Summary per week Data -> data Analysis -> Regression Summary is calculated by making pivot table. Day Mon Tue Wed Thu Fri Sat Sun Average of Time Average of Pages Average of Amount Spent (min) Viewed ($) 15.32222222 6.444444444 90.37555556 12.65714286 4 59.26571429 12.43333333 4.166666667 56.97 10.86 3.8 58.806 12.31818182 4.818181818 85.94818182 13.2 5.285714286 54.10571429 11.44 4.2 43.63 3. Summary Browser Browser Firefox Internet Explorer Other Average of Time Average of Pages Average of Amount Spent (min) Viewed ($) 13.475 5.0625 76.763125 12.58518519 12.15714286 4.37037037 6 61.36333333 74.48428571