My findings when analyzing the number of returns by state

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

1

Uploaded by SuperFangCobra37

My findings when analyzing the number of returns by state, show that Massachusetts has the highest number of returns. The second and third states with the highest number of returns are Arkansas and Oregon. In Massachusetts the SKU that is being returned the most in the ENT-48-10F with 972 returns. In Arkansas, the ADV-24-10C is being returned (844) and in Oregon the BAS-08-1 C is being returned at a high rate of 840 returns. The reason for these SKU’s being returned have a reason of Defective. SELECT Collaborators.state AS STATE, COUNT(*) AS PRODUCT_SALES_NUMBER FROM Collaborators INNER JOIN Orders ON Collaborators.CollaboratorID = Orders.CollaboratorID GROUP BY STATE ORDER BY PRODUCT_SALES_NUMBER DESC LIMIT 15; I have also gathered data on the percentages of returns. The states that have the highest percentage numbers are Massachusetts (2.6%), Arkansas (2.2%), and Oregon (2.2%). The product SKU that has the highest return rate is BAS-48-1 C (22%). The second and third SKU’s that have a high return percentage are ENT-48-40F (16%), and ENT-48-10F (11%). The return frequency of SKU BAS-48-1 C is 8282. SKU’S ENT-48-40F AND ENT-48-10F have the second and third highest return frequency rate with 6118 and 4287.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help