EXCEL VISUALIZATIONS
CLASS OF 1985
EXCEL FUNCTIONS
MARKET RESEARCH
MARIST FACTS EVERYONE SHOULD KNOW
100
Bar Charts and Pie Charts always start here.
What is a pivot table?
100
Name the song or the artist...
100
If we want to categorize a continuous variable (like test scores) into two groups (like pass or fail), the best EXCEL function to use is this.
What is an "IF" Function?
100
When doing Market Research - like the market sizing exercise for the pregnant women - you were asked to only access websites with these two extensions (only need one to get the answer correct).
What are .gov and .org websites?
100
MARIST SCHOOL WAS FOUNDED THIS YEAR
When was 1901?
200
The primary difference between bar charts and pie charts is this.
What is...bar charts communicate absolute values while pie charts communicate percentages of a whole?
200
Name the song or the artist...
200
If you need to identify the lowest value in a long array (column) of data, you should use this function.
What is the "MIN" function?
200
This is one of two reasons why we always use an odd number of options in a linear scale survey question.
What is:
1) it provides the respondent with a neutral option
2) it does not force the respondent to take a position
200
The Marist Crest includes four stars. What do these stars represent?
What is "Georgia - the fourth state in the union"?
300
The best way to represent percentages of whole is to use this kind of graphic.
What is a pie chart?
300
Name the song or the artist...
300
In an IF function, this is the third (final) piece of information that you need to provide.
What is the value if FALSE?
300
"This" kind of survey question is a great way to collect ALOT of information at one time.
What is a "grid" multiple choice question?
300
Girls were first admitted to Marist in this year.
What is 1976?
400
When we use a pivot table to create a bar chart, we will always have to change the "field setting" from sum to "this" when the variable of interest is numeric.
What is "count"?
400
Name the song or the artist...
400
What will this function return in cell B5?:
What is "HIGH"?
400
This is the term we use to describe data that has been collected by another company or government agency and used for a different purpose.
What is "Secondary Data"?
400
This Marist coach became a head coach at Marist in 1985 and is in the Georgia Sports Hall of Fame.
Who is Alan Chadwick?
500
When we examined the Titanic data...The best visualization to show the side by side distribution of one binary variable (like gender) versus a second binary variable (like survival status) is to use this kind of chart.
What is a 100% stacked bar chart?
500
Name the song or the artist...
500
What value will be returned in cell A7?
What is "5"?
500
When calculating a Net Promoter Score, we subtract the percentage of these types of responses (less than 6) from these types of responses (9-10). Must get both names correct.
What are Detractors and Promoters?
500
This is the oldest active teacher at Marist who is also a graduate.
Who is Mr. Coveny? Class of 81.