Videos
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)
- Question 3. We want to price a put option with strike price K and expiration T. Two financial advisors estimate the parameters with two different statistical methods: they obtain the same return rate μ, the same volatility σ, but the first advisor has interest r₁ and the second advisor has interest rate r2 (r1>r2). They both use a CRR model with the same number of periods to price the option. Which advisor will get the larger price? (Explain your answer.)arrow_forwardQuestion 5. We consider a put option with strike price K and expiration T. This option is priced using a 1-period CRR model. We consider r > 0, and σ > 0 very large. What is the approximate price of the option? In other words, what is the limit of the price of the option as σ∞. (Briefly justify your answer.)arrow_forwardQuestion 6. You collect daily data for the stock of a company Z over the past 4 months (i.e. 80 days) and calculate the log-returns (yk)/(-1. You want to build a CRR model for the evolution of the stock. The expected value and standard deviation of the log-returns are y = 0.06 and Sy 0.1. The money market interest rate is r = 0.04. Determine the risk-neutral probability of the model.arrow_forward
- Several markets (Japan, Switzerland) introduced negative interest rates on their money market. In this problem, we will consider an annual interest rate r < 0. We consider a stock modeled by an N-period CRR model where each period is 1 year (At = 1) and the up and down factors are u and d. (a) We consider an American put option with strike price K and expiration T. Prove that if <0, the optimal strategy is to wait until expiration T to exercise.arrow_forwardWe consider an N-period CRR model where each period is 1 year (At = 1), the up factor is u = 0.1, the down factor is d = e−0.3 and r = 0. We remind you that in the CRR model, the stock price at time tn is modeled (under P) by Sta = So exp (μtn + σ√AtZn), where (Zn) is a simple symmetric random walk. (a) Find the parameters μ and σ for the CRR model described above. (b) Find P Ste So 55/50 € > 1). StN (c) Find lim P 804-N (d) Determine q. (You can use e- 1 x.) Ste (e) Find Q So (f) Find lim Q 004-N StN Soarrow_forwardIn this problem, we consider a 3-period stock market model with evolution given in Fig. 1 below. Each period corresponds to one year. The interest rate is r = 0%. 16 22 28 12 16 12 8 4 2 time Figure 1: Stock evolution for Problem 1. (a) A colleague notices that in the model above, a movement up-down leads to the same value as a movement down-up. He concludes that the model is a CRR model. Is your colleague correct? (Explain your answer.) (b) We consider a European put with strike price K = 10 and expiration T = 3 years. Find the price of this option at time 0. Provide the replicating portfolio for the first period. (c) In addition to the call above, we also consider a European call with strike price K = 10 and expiration T = 3 years. Which one has the highest price? (It is not necessary to provide the price of the call.) (d) We now assume a yearly interest rate r = 25%. We consider a Bermudan put option with strike price K = 10. It works like a standard put, but you can exercise it…arrow_forward
- In this problem, we consider a 2-period stock market model with evolution given in Fig. 1 below. Each period corresponds to one year (At = 1). The yearly interest rate is r = 1/3 = 33%. This model is a CRR model. 25 15 9 10 6 4 time Figure 1: Stock evolution for Problem 1. (a) Find the values of up and down factors u and d, and the risk-neutral probability q. (b) We consider a European put with strike price K the price of this option at time 0. == 16 and expiration T = 2 years. Find (c) Provide the number of shares of stock that the replicating portfolio contains at each pos- sible position. (d) You find this option available on the market for $2. What do you do? (Short answer.) (e) We consider an American put with strike price K = 16 and expiration T = 2 years. Find the price of this option at time 0 and describe the optimal exercising strategy. (f) We consider an American call with strike price K ○ = 16 and expiration T = 2 years. Find the price of this option at time 0 and describe…arrow_forward2.2, 13.2-13.3) question: 5 point(s) possible ubmit test The accompanying table contains the data for the amounts (in oz) in cans of a certain soda. The cans are labeled to indicate that the contents are 20 oz of soda. Use the sign test and 0.05 significance level to test the claim that cans of this soda are filled so that the median amount is 20 oz. If the median is not 20 oz, are consumers being cheated? Click the icon to view the data. What are the null and alternative hypotheses? OA. Ho: Medi More Info H₁: Medi OC. Ho: Medi H₁: Medi Volume (in ounces) 20.3 20.1 20.4 Find the test stat 20.1 20.5 20.1 20.1 19.9 20.1 Test statistic = 20.2 20.3 20.3 20.1 20.4 20.5 Find the P-value 19.7 20.2 20.4 20.1 20.2 20.2 P-value= (R 19.9 20.1 20.5 20.4 20.1 20.4 Determine the p 20.1 20.3 20.4 20.2 20.3 20.4 Since the P-valu 19.9 20.2 19.9 Print Done 20 oz 20 oz 20 oz 20 oz ce that the consumers are being cheated.arrow_forwardT Teenage obesity (O), and weekly fast-food meals (F), among some selected Mississippi teenagers are: Name Obesity (lbs) # of Fast-foods per week Josh 185 10 Karl 172 8 Terry 168 9 Kamie Andy 204 154 12 6 (a) Compute the variance of Obesity, s²o, and the variance of fast-food meals, s², of this data. [Must show full work]. (b) Compute the Correlation Coefficient between O and F. [Must show full work]. (c) Find the Coefficient of Determination between O and F. [Must show full work]. (d) Obtain the Regression equation of this data. [Must show full work]. (e) Interpret your answers in (b), (c), and (d). (Full explanations required). Edit View Insert Format Tools Tablearrow_forward
- The average miles per gallon for a sample of 40 cars of model SX last year was 32.1, with a population standard deviation of 3.8. A sample of 40 cars from this year’s model SX has an average of 35.2 mpg, with a population standard deviation of 5.4. Find a 99 percent confidence interval for the difference in average mpg for this car brand (this year’s model minus last year’s).Find a 99 percent confidence interval for the difference in average mpg for last year’s model minus this year’s. What does the negative difference mean?arrow_forwardA special interest group reports a tiny margin of error (plus or minus 0.04 percent) for its online survey based on 50,000 responses. Is the margin of error legitimate? (Assume that the group’s math is correct.)arrow_forwardSuppose that 73 percent of a sample of 1,000 U.S. college students drive a used car as opposed to a new car or no car at all. Find an 80 percent confidence interval for the percentage of all U.S. college students who drive a used car.What sample size would cut this margin of error in half?arrow_forward
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL