Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As a financial analyst, you receive the following summary output containing basic descriptive statistics for a full dataset. The Company has a total of 60

As a financial analyst, you receive the following summary output containing basic descriptive statistics for a full dataset. The Company has a total of 60 products that customers purchase across 3 categories.

REQUIRED

In an email to your manager, list the concerns you have with the data and discuss what steps you would take for each concern you identified. Identify at least four items that cause concerns and the steps you would take to address each concern.

row number vendor name discount rate prod cat prod iD units purch total costs
count of non-null values 453 443 453 453 453 453 452
count of null values 0 10 0 0 0 0 5
mean 227.0 NA 1.79 2.05 10.31 231.19 $6,315
median 227.0 NA 1.50 2.00 9.00 228.00 $4,671
max 453 NA 100.0 3.0 25.0 449.0 $21,550
min 1 NA 0 1 1 -150 $18
number of unique values 451 27 8 8 25 298 438

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

A First Course in General Relativity

Authors: Bernard Schutz

2nd edition

521887054, 978-0521887052

More Books

Students also viewed these Mathematics questions

Question

=+23. Advertising strategies EVPI.

Answered: 1 week ago

Question

6. What are the three characteristics associated with resilience?

Answered: 1 week ago

Question

1. What is community psychology?

Answered: 1 week ago