ANALYTICS TOOLBOX
Excellent Excel
ARRRRGH!
MARIST FACTS EVERYONE SHOULD KNOW
CLASS OF 85
100

A variable with values like "Green", "Blue", "Red" is called this.

What is Categorical?

100

In an "IF" statement, this is the second of the three pieces of information that are required.

What is value if the logic test is "true"?

100

This is the R function that we use to "see" our data (like an excel file).

What is "View"?

100

This is the year girls first entered Marist.

What is 1976?

100

Name the title of the song or the artist.

200

The best graphic to display the shape of a single continuous variable is this.

What is a Histogram?

200

When we develop a bar chart in Excel, we always start with this.

What is a Pivot Table?

200

This is the function in R that we use to "commit" to a single data file throughout a project - so that we only have to type the name of the variables and not the name of the file everytime.

What is "attach"?

200

The letters "A" and "M" on the Marist Crest mean this.

What is...the AM monogram, borrowed from the crest of the Society of Mary, stands for Ave Maria (Hail, Mary).

200








Name the title of the song or the artist.

300

The best graphic to display a single categorical variable.

What is a bar chart?

300

Given this output, what is the "accuracy" of the model?


What is 43.93%?

300

This is the R function that we used to identify the number of row and columns in a file.

What is dim?

300

The number of football state championships won by Marist teams (if you can name all years, you can double your money).  

What is 3? - 1989, 2003, and 2020.

300

Name the title of the song or the artist.

400

This is the best graphic to display the relationship between two categorical (or ordinal) variables.

What is a 100% stacked bar chart.

400

Given the output below, which variable is the most important to the model?

What is miles?

400

When we run a regression model in R, we use this function.

What is "lm"?

400

This athletic team has won the most state championships (28)

What is Girls Tennis?

400

Name the title of the song or the artist.

 

500

This is the graphic we use to assess the relationship between two continuous variables.

What is a scatterplot?

500

When we develop a regression model, the difference between the "actual" value (like price) and the "predicted" value is called this.

What is a residual?


500

This is the "symbol" that we use in R to assign a value to an object.

What is "<-" or "gets"?

500






This is the oldest active teacher who is also a graduate of Marist.

Who is Mike Coveny ('81)?

FYI - 

Dan Perez ('84)

David Negus ('84)

Jennifer Priestley ('85)

500

Name the title of the song or the artist.

M
e
n
u