Mathematics Lab Assignment | Online Homework Help

_________________________ 2. _________________________ 3. _________________________                               

Lab #2 – Measures of Center and Variation

 

Objectives: At the end of this lab, you will be able to:

 

• Find descriptive statistics to identify central tendency and variation for quantitative data.
• Identify the best measure of central tendency to describe the distributions
• Use the mean, median, and mode to describe the shape of the distributions
• Compare distributions in terms of variability
• Identify possible unusual/extreme values
• Interpret the results in the context of the problem

 

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.

 

1. For Lab #1 Part B, you constructed the ungrouped frequency distribution for the variable, Pages Viewed. Find the descriptive statistics for this variable using the data analysis tool. Describe the shape of the distribution and identify which measure of central tendency best describe the data.  Interpret your findings (including the typical value and variation of the data) in the context of the program.

 

1. For Lab #1 Part C, you constructed the frequency distribution and histogram for the dollar amount spent per transaction (Amount Spent). Find the descriptive statistics using the data analysis tool.

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.

 

 

1. Using a graphical and/or descriptive approach you have learned, summarize the number of transactions, the total dollars spent, and the typical amount spent per transaction for each day of week. What observations can you make about Heavenly Chocolate’s business based on the day of the week?

 

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.