Row LabelsSum of SALESClassic Cars3919615.66Motorcycles1166388.34Planes975003.57Ships714437.13Trains226243.47Trucks and Buses1127789.84Vintage Cars1903150.84(blank)9291501.08Grand Total19324129.93
| |
|
| Cancelled |
59242.81 |
| Disputed |
26012.87 |
| In Process |
57760.66 |
| On Hold |
49039.65 |
| Resolved |
25799.34 |
| Shipped |
3701760.33 |
| Disputed |
31821.9 |
| On Hold |
4992.61 |
| Shipped |
1129573.83 |
| Cancelled |
35432.71 |
| Disputed |
3843.84 |
| On Hold |
34727.53 |
| Resolved |
34532.92 |
| Shipped |
866466.57 |
| Cancelled |
56665.65 |
| Disputed |
3070.4 |
| On Hold |
23664.61 |
| Resolved |
39863.71 |
| Shipped |
591172.76 |
| Cancelled |
5082.42 |
| On Hold |
5808.48 |
| Shipped |
215352.57 |
| In Process |
43026.41 |
| On Hold |
20193.29 |
| Resolved |
20472.75 |
| Shipped |
1044097.39 |
| Cancelled |
38063.89 |
| Disputed |
7463.85 |
| In Process |
43942.89 |
| On Hold |
40553.02 |
| Resolved |
30049.56 |
| Shipped |
1743077.63 |
| (blank) |
9291501.08 |
| B. Make summary of Products Sales by providing |
|
|
| |
|
|
|
| 1. Total Sum of Sales |
|
|
=SUM(E2:E2824) |
| 2. Average of Sales |
|
|
=AVERAGE(E2:E2824) |
| 3. Standard Deviation of Sales |
|
|
=STDEV(E2:E2824) |
| 4. Variance of Sales |
|
|
=VAR(E2:E2824) |
| 5. Maximum Sales |
|
|
=MAX(E2:E2824) |
| 6. Minimum Sales |
|
|
=MIN(E2:E2824) |
| |
|
|
|
| |
|
|
|