Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve it by hand Problem #A 50 marks e Note: Solve Problem # A by hand. You can use calculator and mathematical sel (or

Please solve it by hand
image text in transcribed
image text in transcribed
Problem #A 50 marks e Note: Solve Problem # A by hand. You can use calculator and mathematical sel (or geometry box). Do NOT use laptop/computer/mobile, Consider data given in Tables 1 & 2 obtained from a company selling gift products to customers living in the United Kingdom, Australia, Norway, Belgium, and Germany. 32 Tableal Gift Products Data Invoice No Description Qty Unit Price Cust ID Country Cust Pr. 536365 WHITE HANGING 6 2.55 17850 United Kingdom High HEART T-LIGHT HOLDER 536367 ASSORTED COLOUR 32 1.69 13047 United Kingdom Low BIRD ORNAMENT 536371 PAPER CHAIN KIT 50'S 80 2.55 13748 United Kingdom Medium CHRISTMAS 536372 HAND WARMER RED 6 1.85 17850 United Kingdom Low POLKA DOT 536374 VICTORIAN SEWING 10.95 15100 United Kingdom Medium BOX LARGE 536375 WHITE HANGING 6 2.55 17850 United Kingdom High HEART T-LIGHT HOLDER 536389 CHRISTMAS LIGHTS 10 6 8.5 12431 Australia Low REINDEER 536390 CHRISTMAS LIGHTS 10 2 8.5 17511 United Kingdom High REINDEER 581476 PANTRY MAGNETIC 48 1.25 12433 Norway Medium SHOPPING LIST 581493 RETRO PLASTIC 15 0.42 12423 Belgium Medinin POLKA TRAY 581194 RABBIT NIGHT LIGHT 24 1.79 12518 Germany Low 581495 WALL ART BICYCLE 12 5.95 14051 United Kingdom High SAFETY 581570 CHRISTMAS CRAFT 6 2.1 12662 Germany Low TREE TOP ANGEL 581571 HANGING MINI 6 0.63 15311 United Kingdom Low COLOURED BOT- TLES 581574 ROUND SNACK BOXES 6 2.95 12526 Germany Medium SET OF4 WOODLAND 581579 JUMBO BAG PINK 10 1.79 17581 United Kingdom High POLKADOT Table 2: Data Description Invoice No. Invoice number. A 6-digit number uniquely assigned to each trans- action Description Product (item) name. Qty. Quantity: The quantities of each product (item per transaction. Unit Price Product price per unit Cust ID Customer number: A 5-digit integral number uniquely assigned to each customer Country Country name the name of the country where each customer resides Cust Pr. Customer Priority Answer the following questions using data given in Tables 1 & 2: A-1: List all the variables given in Table 1. What is the use of Table 2's data. A-2: Identify the variable types in Table 1. A-3: Segregate the variables in Table 1 into the following terminology Anciliary, Independent and dependent variables A-4: Draw the histogram for Quantity with three bins. Submit all the drawings as one pdf file. A-5: Draw the pie chart for Country. Submit all the drawings as one pil file. A-6: From Quantity's histogram, can you conclude that the distribution is symunetrical? A-7. Find the mean, median and mode for the Unit Price 4-8: Find the variance and standard deviation for the Unit Price A-9: Find the 25 percentile (Q1) and 75 percentile (Q3) for Unit Price. To get the quartiles (01, Q2, Q3) do the following: First, sort the data. Now, Q1 is the median of the first half of the data, Q2 in the median of the full data, and Q3 is the median of the second half of the data A-10: Draw the box-plot for Unit Price, Submit all the drawings as one pdf file

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Lean Audit A Detailed User Guide For The Lean Factory Audit Online

Authors: Isaias Wallaker

1st Edition

B09R3HXJ11, 979-8408651320

More Books

Students also viewed these Accounting questions