BoxPlots
Histograms
Basic Excel Functions
If Statements
Sumif and Countif
100
What is the 5 number summary?
Min, Q1, Med, Q3, Max
100
True or False:
There is no difference between a bar graph and a histogram.
False.
Bar graph displays categorical data on the x-axis, where a histogram displays quantitative data in ranges.
100
All formulas begin with this.
=
100
What are the 3 arguments in an if function?
=if( criteria, value_if_true, value_if_false)
100
What is the Count IF Function?
Counts the number of cells within a rage that meet the given criteria (or...conditional count)
200
What is the formula for the lower bound for outliers in a boxplot?
Q1-1.5(IQR)
200
What best describes the shape of this distribution?
Right-Skewed
200
The function that finds the smallest number in a list of values.
=min()
200
True or False: You can only nest two IF functions in Excel.
False. You can nest up to 64 IF functions in a formula.
200
Write a formula to count how many employees work in the "Sales" department.
=COUNTIF(B2:B9, "Sales")
300
What percentage of the data is below the 1st quartile?
25%
300
In how many seasons did the pitcher have 101-125 strikeouts?
3
300
What function returns the amount of entries in a data set?
=count()
300
Write an if statement that returns "Yes" is the value of A1 cell is greater than or equal to 10, and "No" if its not.
=if(a1>=10, "Yes", "No")
300
Use a conditional formula to count the number of employees whose sales exceed $1000.
=COUNTIF(C2:C9, ">1000")
400
8
400
Several farms were studied to see how many acres of land they spanned across. The amount of acres and the number farms with those acre amounts are displayed in the histogram above. What conclusion can be made from this study using the histogram?
It can be concluded that most farms contain more than 12 acres of land, with most having between 25 and 48 acres of land
400
The ^ symbol is used for what type of calculation?
Exponents
400
Write an if function that returns "Outstanding" if A1 is greater than 95 and if B1 says "No issues", otherwise it should return "No"
=if(and(A1>95, b1="No issues", "Outstanding", "No")
400
Write a formula to calculate the total sales made by employees in the "Sales" department.
=SUMIF(B2:B9, "Sales", C2:C9)
500
What is the average of the median temperatures over the 3 month span?
20
500
Monthly expenditures of Rahul's and Sushant's families are given in the histograms below. How many more months of $51-$60 monthly expenditures did Rahul's family have compared to Sushant's family?
30
500
What does it mean if the cell displays "####"?
The cell is not wide enough.
500
Create a nested =IF formula that either calculates the parking charges or displays the message Free Parking. (Use A1 to refer to a cell) Use these rules to help you:
If the hours parked > 8, the driver should pay $1 per hour
If the hours parked >5, the driver should pay $1.50 per hour
Anything less should display Free Parking
=if(A1>8, 1*A1, if(A1> 5, 1.5*A1 , "Free Parking"))
500
Write a formula to calculate the total sales of employees with a "Performance Rating" of "Excellent."
=SUMIF(D2:D9, "Excellent", C2:C9)