Data Analysis: Net Earnings Calculation with Excel Functions

This practical assignment focuses on analyzing a dataset using Microsoft Excel functions to calculate and analyze net earnings. The solution demonstrates the use of functions such as SUM, AVERAGE, MAX, and MIN to determine total, average, highest, and lowest net earnings from the dataset. Additionally, the assignment uses SUMIF and AVERAGEIF to calculate total and average net earnings based on specific criteria and COUNTIF to count net earnings that meet certain conditions (greater than or less than £50000). The assignment also includes a list of references.

Information Communication Technology
Part - 2

Analyzing data set using excel functions
Dataset B

Continued

Continued
Total Net earnings = SUM(F4:F9) Average Net earnings =
AVERAGE(F4:F9)

Continued
Highest Net Income =
MAX(F4:F9)
Lowest Net Income = MIN(F4:F9)

Continued
Total Net Earnings of position 2 =
SUMIF(C4:C9,”2”,F4:F9)
Average Net earnings of position 1
= AVERAGEIF(C4:C9,”1”,F4:F9)

Continued
Count of Net Earnings >£50000 =
COUNTIF(F4:F9,”>50000”)
Count of Net Earnings <£50000 =
COUNTIF(F4:F9,”<500000”)

Continued

REFERENCES
 Vyas, S., and et.al., 2019, February. Study on use of ai and big data for commercial
system. In 2019 Amity International Conference on Artificial Intelligence (AICAI) (pp.
737-739). IEEE.
 Steele, S., and et.al 2019. “Always read the small print”: a case study of commercial
research funding, disclosure and agreements with Coca-Cola. Journal of public health
policy, 40(3), pp.273-285.