_________________________ 2. _________________________ 3. _________________________
Lab #2 – Measures of Center and Variation
Objectives: At the end of this lab, you will be able to:
Exercise 1. Refer to the Excel file Lab #1 & 2 to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited. You need to submit a hard copy of your lab.
Data Set: Heavenly Chocolate
Heavenly Chocolate 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 website and began selling its products over the internet. Website sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the website customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales, and the following data were recorded:
Description of the variables:
Customers: the control number of customers that were part of the sample
Day: the day of the week each transaction was made
Browser: the type of browser customers used
Time (min): the time in minutes spent on the website
Page Viewed: the number of website pages viewed per visit
Amount Spent ($): the dollar amount spent per transaction
To learn more about the online customers who visited Heavenly Chocolate Company’s website, complete the following tasks.
Describe the shape of the distribution and identify which measure of central tendency best describe the data. Describe your findings (including the typical amount spent per transaction and variation in the amounts) in the context of the program.
Exercise 2. Open your group project data and guidelines posted on Blackboard. Collaborate with your project partners and produce the Excel outputs for the first analysis listed on the project guidelines below. (You do not have to interpret the outputs yet.) Read and follow the instructions carefully.
The Excel outputs such as tables, graphs, summary statistics produced by using Excel. All statistics should not have more than 2 decimal places. All Excel outputs (such as graphs and summary statistics) for each related analysis must be fitted in one sheet.
2. To analyze the totally number of items purchased, construct an ungrouped frequency distribution, graph, and find the summary statistics by each type of customer (regular/promotion). Label the graphs completely. Describe the shape of the distribution for each type of customer, and discuss similarities or differences by interpreting the graphs and summary statistics. What can you conclude?
3. To analyze customer age, construct a frequency distribution, graph, and find the summary statistics by each type of customer (regular/promotion). (Think whether you should create an ungrouped or grouped frequency distribution.) Label the graphs completely. Describe the shape of the distribution for each type of customer, and discuss similarities or differences by interpreting the graphs and summary statistics. What can you conclude?
***Disregard finding the quartiles for each analysis above for Exercise 2. It will be covered for Section 2.5 Lab #3 in next unit.