Data Analysis with Excel
Data Analysis
Series 1 (Blue) represents Stock Quantity - Series 2 (Orange) represents Stock Sold
Each Product/Profit Graph
The graph shows that while profiting from almost every product, having loss from "NISSAN GTR" & "NISSAN R32"
The graph also shows that "MERCEDES C CLASS" has the best profit among all products.
Total Costs Graph
If we look above, we can see the Total costs chart, "Toyota Supra" has the biggest value among all products, while NISSAN GTR & "FORD SHELBY GT500" has the least cost among all products comparing between Total Costs.
Total Sales Graph
If we look above again, now we can see the pie chart comparison of "Total Sales" among all the products that are listed. Toyota Supra again has the major value on "Total Sales", looking to least gained from sales is the product "NISSAN GTR".
Add some commentary and you all gucci x
ReplyDelete