As a financial analyst, you receive the following summary output containing basic descriptive statistics for a full
Fantastic news! We've Found the answer you've been seeking!
Question:
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 |
Posted Date: