Question
RowNumber VendorName DiscountRate ProdCat ProdID UnitsPurch TotalCosts Count of non-null values 453 443 453 453 453 453 452 Count of null values 0 10 0
RowNumber | VendorName | DiscountRate | ProdCat | ProdID | UnitsPurch | TotalCosts | |
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 | NA | 1.79 | 2.05 | 10.31 | 231.19 | $6,315 |
Median | 227 | NA | 1.5 | 2 | 9 | 228 | $4,671 |
Max | 453 | NA | 100 | 3 | 25 | 449 | $21,550 |
Min | 1 | NA | 0 | 1 | 1 | -150 | $18 |
Number of Unique Values | 451 | 27 | 8 | 8 | 25 | 298 | 438 |
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. In preparing your email, you can refer to How to Write a Professional Email in the Additional Resources folder as a guide. To receive full credit, you should identify at least four items that cause concerns and the steps you would take to address each concern.
Step by Step Solution
3.54 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
Hi John Doe I have gone through the output summary of the data shared with me of ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started