Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use descriptive statistics and other graphical and numerical summaries (Excel data analysis output tables, pivot tables/charts, scatter plots, etc.) to learn about the customers

image text in transcribedimage text in transcribed

Use descriptive statistics and other graphical and numerical summaries (Excel data analysis output tables, pivot tables/charts, scatter plots, etc.) to learn about the customers who visit the Lake Champlain Chocolate website. The result for submission into Canvas is a written analysis and interpretation of the required elements in your report with graphical and numerical summaries as part of the report. 1. Descriptive statistics for the time spent on the website, the number of pages viewed, and the amount spent on the website--the mean amount spent per transaction. Discuss what you learn about Lake Champlain Chocolates' online shoppers from these graphical and numerical summaries. Hint: Histograms are an excellent visual summary of the information inserted with the normal distribution curve. 2. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of the week. What observations can you make about Lake Champlain Chocolates' business based on the day of the week? Then, analyze and interpret your analysis results for this question. 3. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each browser type. What observations can you make about Lake Champlain Chocolates' business based on the browser type? Discuss. Analyze and interpret your analysis results. 4. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between the time spent on the website and the dollar amount spent. Use the horizontal axis for the time spent on the website. Discuss. Analyze and interpret your analysis results. 5. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between the number of website pages viewed and the amount spent. Use the horizontal axis for the number of website pages viewed. Discuss. Analyze and interpret your analysis results. 6. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between the time spent on the website and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss. Analyze and interpret your analysis results. Customer Day 1234561 Mon Browser Chrome Time (min) Pages Viewed Amount Spent (S) 12.0 4 54.52 Wed Other 19.5 Mon Chrome 8.5 Tue Firefox 11.4 Wed Chrome 11.3 Sat Firefox 10.5 7 Sun Chrome 11.4 8 Fri Firefox 4.3 9 Wed Firefox 12.7 10 Tue Chrome 24.7 11 Sat Other 13.3 12 Sun Firefox 14.3 13 Sun Other 11.7 14 Mon Firefox 24.4 15 Fri Chrome 8.4 16 Thu Chrome 9.6 17 Thu Chrome 23.3 18 Mon Chrome 14.0 19 Fri Other 5.6 20 Wed Chrome 15.1 21 Sat Firefox 16.3 22 Tue Chrome 10.2 23 Sun Chrome 8.0 24 Tue Firefox 8.0 25 Fri Firefox 9.6 26 Wed Chrome 11.0 27 Sat Chrome 16.9 28 Sat Firefox 6.0 29 Fri Firefox 32.9 30 Mon Other 11.8 31 Thu Chrome 7.1 32 Fri Firefox 18.0 33 Sun Chrome 11.8 34 Fri Chrome 9.1 35 Tue Chrome 7.8 36 Mon Firefox 16.5 37 Thu Firefox 6.2 38 Sat Chrome 11.3 39 Tue Chrome 10.6 40 Wed Chrome 5.0 41 Tue Other 15.9 99999998 42 Sat Chrome 18.1 43 Fri Firefox 10.8 44 Mon Chrome 13.3 45 Mon Chrome 30.1 46 Fri Firefox 13.7 47 Thu Chrome 8.1 48 Fri Chrome 9.7 49 Mon Other 7.3 50 Fri Chrome 13.4 642462637657934TL4556323254920434427642563 94.90 26.68 44.73 66.27 67.80 36.04 55.96 70.94 68.73 54.04 48.05 64.16 10 158.51 84.12 59.20 91.62 126.40 68.45 32.69 78.58 74.43 32.73 48.66 54.66 40.54 34.69 27.91 10 155.30 120.25 41.20 134.40 37.17 52.09 71.81 59.99 84.17 55.58 39.06 36.48 67.44 60.14 70.38 110.65 104.23 68.17 17.84 103.15 52.15 98.75

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Differential Equations and Linear Algebra

Authors: Jerry Farlow, James E. Hall, Jean Marie McDill, Beverly H. West

2nd edition

131860615, 978-0131860612

More Books

Students also viewed these Mathematics questions

Question

What is the use of bootstrap program?

Answered: 1 week ago

Question

What is a process and process table?

Answered: 1 week ago

Question

What is Industrial Economics and Theory of Firm?

Answered: 1 week ago