Scribd
Upload
16 views6 pages

2 Functions Intro (Practice File)

The document presents a summary of job titles, years of experience, annual salaries, and bonuses for various data-related positions. It includes statistics on average salaries and counts of employees meeting specific job goals related to experience and salary thresholds. Additionally, it outlines common error types in formulas used in data analysis, along with their descriptions.

Uploaded by

Muhammad Hassan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
16 views6 pages

2 Functions Intro (Practice File)

The document presents a summary of job titles, years of experience, annual salaries, and bonuses for various data-related positions. It includes statistics on average salaries and counts of employees meeting specific job goals related to experience and salary thresholds. Additionally, it outlines common error types in formulas used in data analysis, along with their descriptions.

Uploaded by

Muhammad Hassan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Experience Annual Salary

Job Title (Years) ($USD) Bonus Max ($USD)


Data Scientist 5 120000 10000
Machine Learning Engineer 4 135000 12000
Data Analyst 2 75000 5000
Business Intelligence Dev 6 110000 8000
Data Engineer 3 125000 11000
Statistician 7 90000 7000
Data Architect 10 150000 15000
Research Scientist 8 130000 13000
AI Specialist 3 140000 14000
Big Data Engineer 5 115000 9000
Average (by Cell) 5.3 119000 10400
Average (AVERAGE()) 5.3 119000 10400
Total Count 10 10 10
Meets Goals Count 6 9 0
Meets Goals Count 6 9
Job Goals:
Experience (<=) 5
Total Salary (>=) 90000
Experience Annual Salary Bonus Max
Job Title (Years) ($USD) ($USD)
Data Scientist 5 120000 10000
Machine Learning Engineer 4 135000 12000
Data Analyst 2 75000 5000
Business Intelligence Dev 6 110000 8000
Data Engineer 3 125000 11000
Statistician 7 90000 7000
Data Architect 10 150000 15000
Research Scientist 8 130000 13000
AI Specialist 3 140000 14000
Big Data Engineer 5 115000 9000
Average (by Cell) 5.3 119000 10400
Average (AVERAGE()) 5.3 119000 10400
Total Count 10 10 10
Meets Goals Count 6 9
Meets Goals Count 6 9
Meets Both - Meets Both -
Formula Only AND() Job Goals:
1 TRUE Experience (<=) 5
FALSE FALSE Total Salary (>=) 90000
FALSE FALSE
TRUE TRUE
FALSE FALSE
TRUE TRUE
TRUE TRUE
TRUE TRUE
FALSE FALSE
TRUE TRUE
Error Type Formula
#DIV/0! =1/0
#VALUE! =B4 + "text"
#REF! =#REF!
#NAME? =COUNTT(A3:A9)
Err:502 =VLOOKUP("Value", A1:A10, 2, FALSE)
Err:502 =SQRT(-1)
#REF! =SUM(A1:A10 B1:B10)
Description
The formula is trying to divide by zero
The formula includes an argument of the wrong type
The formula refers to a cell that isn’t valid (usually deleted cell)
The formula uses a name that Excel doesn’t recognize
The formula is referring to a cell whose data isn’t available
There is a problem with the value in the formula
The formula is trying to use an intersection of two ranges that don’t intersect

You might also like