Data Analytics Exam 3 Questions and
All Correct Answers 2026.
OLAP is different than data mining bc like a pivot table... - Answer OLAP can tell you what is
happening, or what has happened
Data mining is different than OLAP analysis bc like what we do with R... - Answer Data mining
can tell you why it is happening, and help predict what will happen
Data Mining and Predictive Analytics is - Answer Extraction of implicit, previously unknown,
and potentially useful information from data
Exploration and analysis of large data sets to discover meaningful patterns
Decision Trees - Answer Used to classify data according to a pre-defined outcome
Based on characteristics of that data
Uses of Decision Trees - Answer Predict whether a customer should receive a loan
Flag a credit card charge as legitimate
Determine whether an investment will pay off
Clustering - Answer Used to determine distinct groups of data
Based on data across multiple dimensions
Uses of Clustering - Answer Customer segmentation
Identifying patient care groups
Performance of business sectors
Association Mining - Answer Find out which events predict the occurrence of other events
,Often used to see which products are bought together
Uses of Association Mining - Answer What products are bought together?
Amazon's recommendation engine
Telephone calling patterns
R - Answer Software development platform and language
Open source
Many, many, many statistical add-on "packages" that perform data analysis
RStudio - Answer Integrated Development Environment for R
Nicer interface that makes R easier to use
Requires R to run
The Basics: Calculations and Variables in R - Answer R will do math for you (12+23=35)
-Type commands into R and it will give you an answer
R has variables (x=5)(name<-"David")
-<- and = do the same thing
-x, y, and z are objects that can be manipulated
rm() - Answer removes the variable from memory
rm(x)
sort() - Answer puts the scores in order but doesn't change the original collection
c(), min(), max(), and sort() are - Answer functions
, functions - Answer accept parameters and return a value
Arrays of values - Answer Called a vector or collection
min(scores)
[1] 50
>teamData <- read.cvs("2009BaseballTeamSats.cvs") - Answer reads data from CSV file and
creates collections using the headers and the data
>summary(teamData$HomeRuns) - Answer reference a collection using
datasetname$variablename
>if (!require("psych")) {install.packages("psych") + require("psych") } - Answer Downloads
and installs the package (once per R installation)
Looking for differences across groups: The analysis - Answer descriptive statistics
t-test
descriptive statistics example - Answer > describeBy(teamData$Runs, teamData$league)
t-test example - Answer >t.test(teamData$Runs~teamData$League);
Plotting data - Answer plot()
first parameter - x data values
second parameter - y data values
xlab parameter - label for x axis
ylab parameter - label for y axis
title()
sets title for chart
Drawing a regression (trend) line - Answer Calculates the regression line (lm())
And plots the line (abline())
All Correct Answers 2026.
OLAP is different than data mining bc like a pivot table... - Answer OLAP can tell you what is
happening, or what has happened
Data mining is different than OLAP analysis bc like what we do with R... - Answer Data mining
can tell you why it is happening, and help predict what will happen
Data Mining and Predictive Analytics is - Answer Extraction of implicit, previously unknown,
and potentially useful information from data
Exploration and analysis of large data sets to discover meaningful patterns
Decision Trees - Answer Used to classify data according to a pre-defined outcome
Based on characteristics of that data
Uses of Decision Trees - Answer Predict whether a customer should receive a loan
Flag a credit card charge as legitimate
Determine whether an investment will pay off
Clustering - Answer Used to determine distinct groups of data
Based on data across multiple dimensions
Uses of Clustering - Answer Customer segmentation
Identifying patient care groups
Performance of business sectors
Association Mining - Answer Find out which events predict the occurrence of other events
,Often used to see which products are bought together
Uses of Association Mining - Answer What products are bought together?
Amazon's recommendation engine
Telephone calling patterns
R - Answer Software development platform and language
Open source
Many, many, many statistical add-on "packages" that perform data analysis
RStudio - Answer Integrated Development Environment for R
Nicer interface that makes R easier to use
Requires R to run
The Basics: Calculations and Variables in R - Answer R will do math for you (12+23=35)
-Type commands into R and it will give you an answer
R has variables (x=5)(name<-"David")
-<- and = do the same thing
-x, y, and z are objects that can be manipulated
rm() - Answer removes the variable from memory
rm(x)
sort() - Answer puts the scores in order but doesn't change the original collection
c(), min(), max(), and sort() are - Answer functions
, functions - Answer accept parameters and return a value
Arrays of values - Answer Called a vector or collection
min(scores)
[1] 50
>teamData <- read.cvs("2009BaseballTeamSats.cvs") - Answer reads data from CSV file and
creates collections using the headers and the data
>summary(teamData$HomeRuns) - Answer reference a collection using
datasetname$variablename
>if (!require("psych")) {install.packages("psych") + require("psych") } - Answer Downloads
and installs the package (once per R installation)
Looking for differences across groups: The analysis - Answer descriptive statistics
t-test
descriptive statistics example - Answer > describeBy(teamData$Runs, teamData$league)
t-test example - Answer >t.test(teamData$Runs~teamData$League);
Plotting data - Answer plot()
first parameter - x data values
second parameter - y data values
xlab parameter - label for x axis
ylab parameter - label for y axis
title()
sets title for chart
Drawing a regression (trend) line - Answer Calculates the regression line (lm())
And plots the line (abline())
