You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
33 lines
1.6 KiB
33 lines
1.6 KiB
<!--
|
|
CO_OP_TRANSLATOR_METADATA:
|
|
{
|
|
"original_hash": "f824bfdb8b12d33293913f76f5c787c5",
|
|
"translation_date": "2025-08-31T10:57:41+00:00",
|
|
"source_file": "2-Working-With-Data/06-non-relational/assignment.md",
|
|
"language_code": "en"
|
|
}
|
|
-->
|
|
# Soda Profits
|
|
|
|
## Instructions
|
|
|
|
The [Coca Cola Co spreadsheet](../../../../2-Working-With-Data/06-non-relational/CocaColaCo.xlsx) is missing some calculations. Your task is to:
|
|
|
|
1. Calculate the Gross profits for FY '15, '16, '17, and '18
|
|
- Gross Profit = Net Operating revenues - Cost of goods sold
|
|
1. Calculate the average of all the gross profits. Try to do this using a function.
|
|
- Average = Sum of gross profits divided by the number of fiscal years (10)
|
|
- Documentation on the [AVERAGE function](https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6)
|
|
1. This is an Excel file, but it should be editable in any spreadsheet platform
|
|
|
|
[Data source credit to Yiyi Wang](https://www.kaggle.com/yiyiwang0826/cocacola-excel)
|
|
|
|
## Rubric
|
|
|
|
Exemplary | Adequate | Needs Improvement
|
|
--- | --- | --- |
|
|
|
|
---
|
|
|
|
**Disclaimer**:
|
|
This document has been translated using the AI translation service [Co-op Translator](https://github.com/Azure/co-op-translator). While we strive for accuracy, please note that automated translations may contain errors or inaccuracies. The original document in its native language should be regarded as the authoritative source. For critical information, professional human translation is recommended. We are not responsible for any misunderstandings or misinterpretations resulting from the use of this translation. |