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-26T14:57:34+00:00",
|
|
"source_file": "2-Working-With-Data/06-non-relational/assignment.md",
|
|
"language_code": "sw"
|
|
}
|
|
-->
|
|
# Faida za Soda
|
|
|
|
## Maelekezo
|
|
|
|
Faili ya [Coca Cola Co spreadsheet](../../../../2-Working-With-Data/06-non-relational/CocaColaCo.xlsx) inakosa baadhi ya mahesabu. Kazi yako ni:
|
|
|
|
1. Hesabu Faida Ghafi za FY '15, '16, '17, na '18
|
|
- Faida Ghafi = Mapato ya Uendeshaji Halisi - Gharama za bidhaa zilizouzwa
|
|
1. Hesabu wastani wa faida zote ghafi. Jaribu kufanya hili kwa kutumia kipengele.
|
|
- Wastani = Jumla ya faida ghafi zilizogawanywa na idadi ya miaka ya kifedha (10)
|
|
- Nyaraka kuhusu [kipengele cha AVERAGE](https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6)
|
|
1. Hii ni faili ya Excel, lakini inapaswa kuweza kuhaririwa katika jukwaa lolote la spreadsheet
|
|
|
|
[Chanzo cha data kimepewa sifa kwa Yiyi Wang](https://www.kaggle.com/yiyiwang0826/cocacola-excel)
|
|
|
|
## Rubric
|
|
|
|
Bora Zaidi | Inaridhisha | Inahitaji Kuboresha
|
|
--- | --- | --- |
|
|
|
|
---
|
|
|
|
**Kanusho**:
|
|
Hati hii imetafsiriwa kwa kutumia huduma ya kutafsiri ya AI [Co-op Translator](https://github.com/Azure/co-op-translator). Ingawa tunajitahidi kuhakikisha usahihi, tafadhali fahamu kuwa tafsiri za kiotomatiki zinaweza kuwa na makosa au kutokuwa sahihi. Hati ya asili katika lugha yake ya awali inapaswa kuzingatiwa kama chanzo cha mamlaka. Kwa taarifa muhimu, tafsiri ya kitaalamu ya binadamu inapendekezwa. Hatutawajibika kwa kutoelewana au tafsiri zisizo sahihi zinazotokana na matumizi ya tafsiri hii. |