– In a single Word document, complete chapter 2, case problem 1, ” Heavenly Chocolates Web Site Transactions.” If using Excel or Minitab for your calculations, charts, and graphs, please copy and paste your work into the Word document. Do not attach Excel or Minitab as separate documents.
– response should be a minimum of 2-3 pages . The font is Times New Roman, font size should be 12, and the paragraphs are single-spaced. There should be a minimum of one reference supporting your observations. Citations are to follow APA 7.0.double space.
10/26/22, 10:32 PM Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=5994142305022023695824496950&eISBN=9780357131824&id=1635155985&sna 1/3
Chapter 2: Descriptive Statistics: Case Problem 1 Heavenly Chocolates Web Site Transactions
Book Title: Business Analytics
Printed By: Jigar Jitendrak Patel ([emailprotected])
2021 Cengage Learning, Cengage Learning
Chapter Review
Case Problem 1 Heavenly Chocolates Web Site Transactions
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 companys 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
Chocolates transactions was selected from the previous months 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 HeavenlyChocolates. A portion of the
data is shown in the table that follows:
Customer Day Browser Time (min)
Pages
Viewed
Amount
Spent ($)
1 Mon Chrome 12.0 4 54.52
2 Wed Other 19.5 6 94.90
3 Mon Chrome 8.5 4 26.68
4 Tue Firefox 11.4 2 44.73
5 Wed Chrome 11.3 4 66.27
6 Sat Firefox 10.5 6 67.80
7 Sun Chrome 11.4 2 36.04
. . . . . .
https://college.cengage.com/nextbook/business/camm_180959/student/data_files/chapter_02/heavenlychocolates.xlsx
10/26/22, 10:32 PM Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=5994142305022023695824496950&eISBN=9780357131824&id=1635155985&sna 2/3
Customer Day Browser Time (min)
Pages
Viewed
Amount
Spent ($)
. . . . . .
. . . . . .
. . . . . .
48 Fri Chrome 9.7 5 103.15
49 Mon Other 7.3 6 52.15
50 Fri Chrome 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
Use the methods of descriptive statistics to learn about the customers who visit the
Heavenly Chocolates 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 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 chart, and compute the sample correlation coefficient to
explore the relationship between the time spent on the web site and the dollar
10/26/22, 10:32 PM Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=5994142305022023695824496950&eISBN=9780357131824&id=1635155985&sna 3/3
amount spent. Use the horizontal axis for the time spent on the web site.
Discuss your findings.
5. Develop a scatter chart, 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 chart, 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.
Chapter 2: Descriptive Statistics: Case Problem 1 Heavenly Chocolates Web Site Transactions
Book Title: Business Analytics
Printed By: Jigar Jitendrak Patel ([emailprotected])
2021 Cengage Learning, Cengage Learning
2022 Cengage Learning Inc. All rights reserved. No part of this work may by reproduced or used in any form or by any means –
graphic, electronic, or mechanical, or in any other manner – without the written permission of the copyright holder.
SHOW MORE…
assignment 1 Modern Management I must have ORIGINAL work only. with up to date references PLEASE read and follow all INSTRUCTIONS!!
Your first assignment, Personal Assessment of Managerial Skills, is due next week. If you haven’t already done so, you will need to complete the Apply Your Skills Engagement Exercise: Aptitude Questionnaire on pages 3031 in Chapter 1 of the textbook. You will then write a 34 page paper in which you summarize your results, identify resources for improvement, and describe how your strengths can promote a positive culture in a global environment.To prepare:
Complete the Apply Your Skills Engagement Exercise: Aptitude Questionnaire from the textbook.
Review the assignment requirements in the course guide to ensure that you understand all criteria.
Make sure to ask questions early and as needed.
Review your assessment findings from the aptitude questionnaire and write a 34 page paper in which you address the following: 1. Summarize findings of your strengths and weaknesses in the conceptual, human, and technical skills areas, providing clear rationale. Explain why you think you scored the way you did in each of the skills. 2. Identify at least one resource to improve each skill areaconceptual, human, technicalfor a minimum of three resources. Provide clear rationale for each resource. Use Basic Search: Strayer University Online Library or, in your Blackboard classroom, go to Career and search LinkedIn to locate resources. 3. Describe how your strengths can promote a positive culture in a global environment, providing examples. 4. Use at least three sources to support your writing. Choose sources that are credible, relevant, and appropriate. Cite each source listed on your source page at least one time within your assignment. For help with research, writing, and citation, access the library or review library guides. This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. The specific course learning outcome associated with this assignment is: Analyze the conceptual, human, and technical skills necessary for promoting a positive culture in a global environment.
This is the Aptitude Questionnaire from page 30-31
CH1 Apply Your Skills: Engagement Exercise Aptitude Questionnaire Rate each of the following questions according to the following scale: 1 I am never like this. 2 I am rarely like this. 3 I am sometimes like this. 4 I am often like this. 5 I am always like this. 1. When I have a number of tasks or homework to do, I set priorities and organize the work around deadlines. 1 2 3 4 5 2. Most people would describe me as a good listener. 1 2 3 4 5 3. When I am deciding on a particular course of action for myself (such as hobbies to pursue, languages to study, which job to take, or special projects to be involved in), I typically consider the long-term (three years or more) implications of what I would choose to do. 1 2 3 4 5 4. I prefer technical or quantitative courses rather than those involving literature, psychology, or sociology. 1 2 3 4 5 5. When I have a serious disagreement with someone, I hang in there and talk it out until it is completely resolved. 1 2 3 4 5 6. When I have a project or assignment, I really get into the details rather than the big picture issues. 1 2 3 4 5 7. I would rather sit in front of my computer than spend a lot of time with people. 1 2 3 4 5 8. I try to include others in activities or discussions. 1 2 3 4 5 9. When I take a course, I relate what I am learning to other courses I took or concepts I learned elsewhere. 1 2 3 4 5 10. When somebody makes a mistake, I want to correct the person and let her or him know the proper answer or approach. 1 2 3 4 5 11. I think it is better to be efficient with my time when talking with someone, rather than worry about the other persons needs, so that I can get on with my real work. 1 2 3 4 5 12. I have a long-term vision of career, family, and other activities and have thought it over carefully. 1 2 3 4 5 13. When solving problems, I would much rather analyze some data or statistics than meet with a group of people. 1 2 3 4 5 14. When I am working on a group project and someone doesnt pull their fair share of the load, I am more likely to complain to my friends than to confront the slacker. 1 2 3 4 5 15. Talking about ideas or concepts can get me really enthusiastic or excited. 1 2 3 4 5 16. The type of management course for which this book is used is really a waste of time. 1 2 3 4 5 17. I think it is better to be polite and not hurt peoples feelings. 1 2 3 4 5 18. Data and things interest me more than people. 1 2 3 4 5 30 PART 1 INTRODUCTION TO MANAGEMENT Copyright 2022 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. Scoring and Interpretation: Subtract your scores for questions 6, 10, 14, and 17 from the number 6, and then add the total points for the following sections: 1, 3, 6, 9, 12, 15 Conceptual skills total score __________ 2, 5, 8, 10, 14, 17 Human skills total score __________ 4, 7, 11, 13, 16, 18 Technical skills total score __________ These skills are three of the skills needed to be a good manager. Ideally, a manager should be strong (though not necessarily equal) in all three. Anyone noticeably weaker in any of these skills should take courses and read to build up that skill. For further background on the three skills, refer to the explanation in the Management Skills section of the chapter. In-Class/Online Application Break into groups of three to four members, either physically or virtually, depending on the format of the course, and discuss your respective scores. What do your respective scores suggest about possible management aptitudes