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.

My Homework Nest
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.