Summarize the frequency, the total dollars spent

Assignment Help Business Management
Reference no: EM13972820

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 site pages viewed, and the amount spent by each of the 50 customers are contained in the file named Shoppers. A portion of the data is shown in the table that follows:

Customer

Day

Browser

Time (min)

Pages Viewed

Amount Spent ($)

1

Mon

Internet Explorer

12.0

4

54.52

2

Wed

Other

19.5

6

94.90

3

Mon

Internet Explorer

8.5

4

26.68

4

Tue

Firefox

11.4

2

44.73

5

Wed

Internet Explorer

11.3

4

66.27

6

Sat

Firefox

10.5

6

67.80

7

Sun

Internet Explorer

11.4

2

36.04

?

?

?

?

?

?

48

Fri

Internet Explorer

9.7

5

103.15

49

Mon

Other

7.3

6

52.15

50

Fri

Internet Explorer

13.4

3

98.75

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

1. Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates Web site. Include the following in your report.

2. 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.

3. 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 Heavenly Chocolates' business based on the day of the week? Discuss.

4. 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 Heavenly Chocolate's business based on the type of browser? Discuss.

5. 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.

6. 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.

7. 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.

Reference no: EM13972820

Questions Cloud

Explain the purpose of the calculation : Explain the calculations in each of the three panels below, one at a time. Explain the purpose of the calculation and the procedure of the calculation, i.e., how the data inputs determine the output - the result. Bond Questions Support Sheets.xlsx (p..
Find out the realized taxable income : Determine whether the taxpayers in each of the following situations have realized taxable income:
Write a paper that discusses a recent crisis in the news : Write a paper that discusses a recent crisis in the news and how it was handled from a PR standpoint (e.g. BP oil spill). How would you have handled the situation as a PR expert and why? What tactics and techniques would you have used and why?
The analyst used the overall beta to value : The risk-free rate is 2% and the implied equity premium is 6 %. Your firm's overall bottom-up unlevered beta is 1.2. When examining the latest valuations for a potential investment in a new factory, however, you notice that the analyst used the overa..
Summarize the frequency, the total dollars spent : 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 Heavenly Chocolates' business based on the day of the week? Discuss.
Determine the work and heat transfer for each process : A piston-cylinder assembly contains 2 lb of water, initiall, at 100 lbf/in.2 and 400°F. The water undergoes two processe: in series: a constant-pressure process followed by a constant volume process. At the end of the constant-volume process the temp..
The overall concept of cm is pretty straightforward : The overall concept of CM is pretty straightforward- it is how much each unit contributes to covering fixed costs and eventually, profit, after variable costs are taken care of.
Calculate the monthly mortgage payment. : Calculate the loan balance at the end of years 1, 2, 3, and 4. (Note: the unpaid mortgage balance at any time is equal to the present value of the remaining payments, discounted at the contract [face] rate of interest).
The company produces a single product : Under wald Corporation has provided the following production and average cost data for two levels of monthly production volume. The company produces a single product.

Reviews

Write a Review

 

Business Management Questions & Answers

  Employees accessing inappropriate websites at work

A customer service representative at an electronics store is surfing the Internet using one of display computers. She accesses a website which shows graphic images of crime scene.

  Change in economic structure

how do politics and government regulation factor into the changes we see to economic activity on both a domestic and global scale?

  Determine the current state of ruling

Is Microsoft the contemporary equivalent of Standard Oil or some other monopoly? Determine the current state of ruling?

  Calculate the market equilibrium price and quantity

calculate the market equilibrium price and quantity for the market demand system:

  Csr for all employees within an organizationsome assume

csr for all employees within an organizationsome assume that nowadays corporate responsibilities toward the environment

  Depict a model with methods and procedures

These attitudes and perceptions are manifested in the practices and behaviors of individuals in the organization.Design a model with methods and procedures for analyzing diversity and how you would implement the results in a cultural diversity tra..

  International human rights issuesexplain what do you think

international human rights issuesexplain what do you think should be the role of mncs toward human rights issues in

  Important information about conflict in the

important information about conflict in the workplaceconflict in the workplace is inescapable. however there are ways

  Genentech: after the acquisition by roche

What impact will the Roche buyout have on Genentech? Will it be possible for Roche to own Genentech without destroying its ability to innovate?

  Personality traits management style and leadership qualities

Describe the personality traits, management style, and leadership qualities that helped him or her lead the company to a successful implementation of new practices.

  How could other industries apply the cooperative model

Explain how could other industries apply the cooperative model used by Avalanche to achieve efficiencies in areas other than software support? Explain.

  Leader-s vision and strategies help to overcome resistance

What are the personal and professional characteristics of a change leader? How can a leader's vision and strategies help to overcome resistance?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd