Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, 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 Heavenly Chocolate 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 pages viewed, and the amount spent by each of the 50 customers are contained in the file named Heavenly Chocolates. A portion of the data is shown in the table that follows:
Heavenly Chocolates 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
- 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 Heavenly Chocolates’ 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. Discuss the observations you can make about Heavenly Chocolates’ business based on the day of the week?
- 3. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Heavenly Chocolates’ business based on the type of browser?
- 4. Develop a
scatter diagram , and compute the samplecorrelation 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 your findings. - 5. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings.
- 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 your findings.
1. Provide the graphical and numerical summaries for the length of time that the shopper spends on the website, the number of pages viewed, and the mean amount spent per transaction. Explain that is observed from the numerical summaries.
2. Give a summary for the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Give interpretation.
3. Give a summary for the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Give interpretation.
4. Give a scatter diagram and calculate the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Give interpretation.
5. Give a scatter diagram and calculate the sample correlation coefficient to explore the relationship between the number of web pages viewed and the dollar amount spent. Give interpretation.
6. Give a scatter diagram and calculate the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Give interpretation.
Answer to Problem 1C
1. Numerical summaries:
The frequency distribution and percent frequency distribution for the length of time that the shopper spends on the website are given below:
The frequency distribution and percent frequency distribution for the number of pages viewed are given below:
The frequency distribution and percent frequency distribution for the amount spent are given below:
The mean amount spent per transaction is obtained as 68.13.
Graphical summary:
The histogram for the length of time that the shopper spends on the website is shown below:
The bar chart for the number of pages viewed is shown below:
The histogram for the amount spent is shown below:
2. The frequency, the total dollars spent, and the mean amount spent per transaction for each day of week are as follows:
3. The frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser are as follows:
4. The scatter diagram of the time spent on the web site and the dollar amount spent are shown below:
The sample correlation coefficient that explores the relationship between the time spent on the web site and the dollar amount spent is 0.58.
5. The scatter diagram of the number of web pages viewed and the dollar amount spent are given below:
The sample correlation coefficient that explores the relationship between the number of web pages viewed and the dollar amount spent is 0.72.
6. The scatter diagram of the time spent on the web site and the number of pages viewed are shown below:
The sample correlation coefficient that explores the relationship between the time spent on the web site and the number of pages viewed is 0.60.
Explanation of Solution
1.
Numerical summary:
Step-by-step procedure to create frequency distribution and percent frequency distribution for the length of time the shopper spends on the website using an Excel:
- Select Insert > PivotTable.
- In Select a table or range, select the data of Time (min) and click OK.
- In PivotTable Fields, move Time (min) to Rows and Σ Values.
- Right click on a value from Row Labels and select Group.
- Enter 5 in By.
- Click on Time (min) from Σ Values.
- Select Value Field settings.
- In Summarize value field by, choose Count and click OK.
- Again, move Time (min) to Rows and Σ Values.
- Click on Time (min) from Σ Values.
- Select Value Field settings.
- In Show Values As, choose % of Grand Total and click OK.
Thus, the frequency distribution and percent frequency distribution for the length of time the shopper spends on the website are obtained.
Step-by-step procedure to create frequency distribution and percent frequency distribution for the number of pages viewed using an Excel:
- Select Insert > PivotTable.
- In Select a table or range, select the data of Pages Viewed and click OK.
- In PivotTable Fields, move Pages Viewed to Rows and Σ Values.
- Right click on a value from Row Labels and select Group.
- Enter 5 in By.
- Click on Pages Viewed from Σ Values.
- Select Value Field settings.
- In Summarize value field by, choose Count and click OK.
- Again, move Pages Viewed to Rows and Σ Values.
- Click on Pages Viewed from Σ Values.
- Select Value Field settings.
- In Show Values As, choose % of Grand Total and click OK.
Thus, the frequency distribution and percent frequency distribution for the number of pages viewed are obtained.
Step-by-step procedure to obtain the mean amount spent per transaction using an Excel:
- In cell F52, enter “=AVERAGE(F2:F51)”.
- Click Enter.
Thus, the mean amount spent per transaction is obtained as 68.13.
From the numerical summaries, it is clear that the highest percent frequency for length of time that the shopper spends on the website is 9.3 hours to 14.3 hours. Also, the highest percent frequency for the number of pages viewed is 4.
Graphical summaries:
Step-by-step procedure to obtain a histogram for the length of time that the shopper spends on the website using an Excel:
- Select the data of class interval and percent frequency.
- Select Insert.
- Choose Clustered Column under Charts.
- Click on a bar in the graph.
- In Format Data Series, enter Gap width as 0%.
Thus, the histogram for the length of time that the shopper spends on the website is obtained.
Step-by-step procedure to obtain a bar chart for the number of pages viewed using an Excel:
- Select the data of class interval and frequency.
- Select Insert.
- Choose Clustered Column under Charts.
Thus, the bar chart for the number of pages viewed is obtained.
Step-by-step procedure to obtain a histogram for the amount spent using Excel:
- Select the data of class interval and percent frequency.
- Select Insert.
- Choose Clustered Column under Charts.
- Click on a bar in the graph.
- In Format Data Series, enter Gap width as 0%.
Thus, the histogram for the amount spent is obtained.
2.
Step-by-step procedure to obtain the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week using an Excel:
- Select Insert > PivotTable.
- In Select a table or range, select the data of Customer, Day, and Amount Spent ($) and click OK.
- In PivotTable Fields, move Day to Rows and Customer and Amount Spent ($) to Σ Values.
- Click on Amount Spent ($) from Σ Values.
- Select Value Field settings.
- In Summarize value field by, choose Sum and click OK.
- Again, move Amount Spent ($) to Σ Values.
- Click on Amount Spent ($) from Σ Values.
- Select Value Field settings.
- In Summarize value field by, choose Average and click OK.
Thus, the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week are obtained.
It is clear from the output that the average amount spent on Monday is higher than other days. However, the sum of amount spent is higher on Friday. This is because the number of customers on Friday is more than the number of customers on Monday.
3.
Step-by-step procedure to obtain the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser using an Excel:
- Select Insert > PivotTable.
- In Select a table or range, select the data of Customer, Browser, and Amount Spent ($) and click OK.
- In PivotTable Fields, move Browser to Rows and Customer and Amount Spent ($) to Σ Values.
- Click on Amount Spent ($) from Σ Values.
- Select Value Field settings.
- In Summarize value field by, choose Sum and click OK.
- Again, move Amount Spent ($) to Σ Values.
- Click on Amount Spent ($) from Σ Values.
- Select Value Field settings.
- In Summarize value field by, choose Average and click OK.
Thus, the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser are obtained.
It is clear from the output that the average amount spent for Firefox is higher than other browsers. However, the sum of amount spent is higher for chrome. This is because that the number of customers using Chrome is higher than the number of customers using Firefox.
4.
Step-by-step procedure to obtain a scatter diagram of the time spent on the web site and the dollar amount spent using an Excel:
- Select the data of Time (min) and Amount Spent ($).
- Select Insert.
- Choose Scatter under Charts.
Thus, the scatter diagram of the time spent on the web site and the dollar amount spent are obtained.
Step-by-step procedure to obtain the sample correlation coefficient that explores the relationship between the time spent on the web site and the dollar amount spent using an Excel:
- In an empty cell, type “=CORREL(D2:D51, F2:F51)”.
- Click Enter.
The sample correlation coefficient that explores the relationship between the time spent on the web site and the dollar amount spent is obtained as 0.58.
It is clear that there is a positive linear correlation between the time spent on the web site and the dollar amount spent. That is, as time spent on the web site increases, the dollar amount spent also increases.
5.
Step-by-step procedure to obtain a scatter diagram of the number of web pages viewed and the dollar amount spent using an Excel:
- Select the data of Pages Viewed and Amount Spent ($).
- Select Insert.
- Choose Scatter under Charts.
Thus, the scatter diagram of the number of web pages viewed and the dollar amount spent is obtained.
Step-by-step procedure to obtain the sample correlation coefficient that explores the relationship between the number of web pages viewed and the dollar amount spent using an Excel:
- In an empty cell, type “=CORREL(E2:E51, F2:F51)”.
- Click Enter.
The sample correlation coefficient that explores the relationship between the number of web pages viewed and the dollar amount spent is 0.72.
It is clear that there is a positive linear correlation between the number of web pages viewed and the dollar amount spent. That is, as number of web pages viewed increases, the dollar amount spent also increases.
6.
Step-by-step procedure to obtain the scatter diagram of the time spent on the web site and the number of pages viewed using an Excel:
- Select the data of Time (min) and Pages Viewed.
- Select Insert.
- Choose Scatter under Charts.
Thus, the scatter diagram of the time spent on the web site and the number of pages viewed are obtained.
Step-by-step procedure to obtain the sample correlation coefficient that explores the relationship between the time spent on the web site and the number of pages viewed using an Excel:
- In an empty cell, type “=CORREL(D2:D51, E2:E51)”.
- Click Enter.
The sample correlation coefficient that explores the relationship between the time spent on the web site and the number of pages viewed is 0.60.
It is clear that there is a positive linear correlation between the time spent on the web site and the number of pages viewed. That is, as the number of pages viewed increases, the time spent on the web site also increases.
Want to see more full solutions like this?
Chapter 2 Solutions
Essentials of Business Analytics (MindTap Course List)
- The following data show the year to date percent change (YTD % Change) for 30 stock-market indexes from around the word (The Wall Street Journal, August 26, 2013). a. What index has the largest positive YTD % Change? Round your answer to once decimal place. index with a YTD % Change of % b. Using a class width of 5 beginning with -20 and going to 40, develop a frequency distribution for the data. YTD % Change Frequency -20 - -15 -15 - -10 -10 - -5 -5 - 0 0 - 5 5 - 10 10 - 15 15 - 20 20 - 25 30 - 35 c. 1. 2. 3. 4.arrow_forwardThe following data show the year to date percent change (YTD % Change) for 30 stock-market indexes from around the word (The Wall Street Journal, August 26, 2013). Click on the datafile logo to reference the data. DATA file Country Australia Index S&P/ASX200 YTD % Change 10.2 Belgium Bel-20 12.6 Brazil São Paulo Bovespa -14.4 Canada S&P/TSX Comp 2.6 Chile Santiago IPSA -16.3 China Shanghai Composite -9.3 Eurozone EURO Stoxx 10.0 France CAC 40 11.8 Germany DAX 10.6 Hong Kong Hang Seng -3.5 India S&P BSE Sensex -4.7 Israel Tel Aviv 1.3 Italy FTSE MIB 6.6 Japan Nikkei 31.4 Mexico IPC All-Share -6.4 Netherlands AEX 9.3 Singapore Straits Times -2.5 South Korea Kospi -6.4 Spain IBEX 35 6.4 Sweden Switzerland SX All Share 13.8 Swiss Market 17.4 Taiwan Weighted 2.3 U.K. FTSE 100 10.1 U.S. S&P 500 16.6 U.S. DJIA 14.5 U.S. Dow Jones Utility 6.6 U.S. Nasdaq 100 17.4 U.S. Nasdaq Composite 21.1 World DJ Global ex U.S. 4.2 World DJ Global Index 9.9 a. What index has the largest positive YTD %…arrow_forwardDescribe a three step process you choose to determine how many elementary schools there are in the city of 5 million people.arrow_forward
- Quiz: Exam 1 (Ch 1-4) z Scores Table-3.pdf x + edu/courses/308627/quizzes/2442507/take/questions/48957332 Canvas Hall It browser 5 Connect Set as default incorrect. • This exam is NOT resumable. Meaning, once you start the exam, you must complete it in its entirety. Any blank questions will be marked as By taking this exam, you agree to adhere to the academic integrity standards, which consist of NOT cheating in any way. To get the highest possible score, you are encouraged to review your notes before taking the exam. You may use your notes during the exam, but note that you should be familiar with the concepts and formulas before taking exam. z Scores Table.pdf Question 3 3 pts Here is a data from a survey asking young children how many hours they spend playing video games. The researchers reported the percent of boys and girls who played no games, less than 1 hour per day, 1-3 hours per day, or greater than 3 hours per day. The most common number of hours per day that boys played is…arrow_forwardWrite a Regression summary explaining significance of mode, explaining regression coefficients, significance of the independent variables, R and R square. Premiums earned Net income Dividends Underwriting Gain/ Loss 30.2 1.6 0.6 0.1 47.2 0.6 0.7 -3.6 92.8 8.4 1.8 -1.5 95.4 7.6 2 -4 100.4 6.3 2.2 -8.1 104.9 6.3 2.4 -10.8 113.2 2.2 2.3 -18.2 130.3 3.0 2.4 -21.4 161.9 13.5 2.3 -12.8 182.5 14.9 2.9 -5.9 193.3 11.7 2.9 -7.6arrow_forward1- Let A = {A1, A2, ...), in which A, A, = 0, when i j. a) Is A a π-system? If not, which element(s) should be added to A to become a π-system? b) Prove that σ(A) consists of the finite or countable unions of elements of A; i.c., A E σ(A) if and only if there exists finite or countable sequence {n} such that A = U₁An (Hint: Let F be such class; prove that F is a σ-filed containing A.) c) Let p ≥ 0 be a sequence of non-negative real numbers with Σip₁ = 1. Using p₁'s, how do you construct a probability measure on σ(A)? (Hint: use extension theorem.) 2- Construct an example for which P(lim sup A,) = 1 and P(lim inf An) = 0.arrow_forward
- In a town with 5000 adults, a sample of 50 is selected using SRSWOR and asked their opinion of a proposed municipal project; 30 are found to favor it and 20 oppose it. If, in fact, the adults of the town were equally divided on the proposal, what would be the probability of observing what has been observed? Approximate using the Binomial distribution. Compare this with the exact probability which is 0.0418.arrow_forwardGood explanation it sure experts solve itarrow_forwardBest explains it not need guidelines okkarrow_forward
- Activ Determine compass error using amplitude (Sun). Minimum number of times that activity should be performed: 3 (1 each phase) Sample calculation (Amplitude- Sun): On 07th May 2006 at Sunset, a vessel in position 10°00'N 010°00'W observed the Sun bearing 288° by compass. Find the compass error. LMT Sunset: LIT: (+) 00d 07d 18h 00h 13m 40m UTC Sunset: 07d 18h 53m (added- since longitude is westerly) Declination (07d 18h): N 016° 55.5' d (0.7): (+) 00.6' Declination Sun: N 016° 56.1' Sin Amplitude = Sin Declination/Cos Latitude = Sin 016°56.1'/ Cos 10°00' = 0.295780189 Amplitude=W17.2N (The prefix of amplitude is named easterly if body is rising, and westerly if body is setting. The suffix is named same as declination) True Bearing=287.2° Compass Bearing= 288.0° Compass Error = 0.8° Westarrow_forwardOnly sure experts solve it correct complete solutions okkarrow_forward13. In 2000, two organizations conducted surveys to ascertain the public's opinion on banning gay men from serving in leadership roles in the Boy Scouts.• A Pew poll asked respondents whether they agreed with "the recent decision by the Supreme Court" that "the Boy Scouts of America have a constitutional right to block gay men from becoming troop leaders."A Los Angeles Times poll asked respondents whether they agreed with the following statement: "A Boy Scout leader should be removed from his duties as a troop leader if he is found out to be gay, even if he is considered by the Scout organization to be a model Boy Scout leader."One of these polls found 36% agreement; the other found 56% agreement. Which of the following statements is true?A) The Pew poll found 36% agreement, and the Los Angeles Times poll found 56% agreement.B) The Pew poll includes a leading question, while the Los Angeles Times poll uses neutral wording.C) The Los Angeles Times Poll includes a leading question, while…arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL