WorksheetsGSDSA Quiz on Predictive Analytics
Total questions: 50
Worksheet time: 38mins
Predictive analytics mainly uses ______ to forecast future events.
Assumptions
Historical data
Random numbers
Surveys
Which of the following is NOT a key concept of predictive analytics?
Simple Linear Regression
Multiple Regression
Polynomial Regression
T-test
In predictive analytics, the process of cleaning and preparing data is called:
Data evaluation
Data mining
Data preparation
Model deployment
Which industry uses predictive analytics to detect fraud?
Education
Retail
Financial Services
Manufacturing
Predictive analytics in healthcare is commonly used to:
Write medical reports
Identify high-risk patients
Increase medicine prices
Assign doctors
Which step comes after model building?
Data cleaning
Model evaluation
Predictive charting
Visualization
Which question can predictive analytics answer?
Why do customers complain?
Which customers are likely to churn?
What is the company mission?
Who is the CEO?
A major challenge of predictive analytics is:
Too many analysts
Incomplete and inaccurate data
High employee turnover
Too much profit
Predictive analytics improves business by:
Increasing inventory waste
Removing customers
Improving decision making
Blocking databases
A predictive model becomes biased when:
Data is accurate
Model is transparent
Training data contains bias
Variables are strong
Simple linear regression analyzes the relationship between:
Two variables
Three variables
Multiple variables
No variables
In regression, “x” is the:
Dependent variable
Intercept
Independent variable
Residual
The regression formula is:
y=abx
y=bx+a
y=x+b2
y=a/x
Residuals represent
Predicted values
Errors
Intercepts
Correct outputs
Residuals with curved patterns indicate
Regression is correct
Linear model might not fit
Regression equation is perfect
Data is random
A fan-shaped residual pattern indicates
Heteroscedasticity
Normality
Homoscedasticity
Linearity
An extreme value that influences the regression line is
Mean
Median
Outlier
Mode
In Excel regression, the slope is found in the
ANOVA table
Coefficients table
Residual table
Summary tool
R-square measures
How curved the model is
How much variation in y is explained by x
Number of variables
Data size
The F-test in ANOVA tests
If the model is significant
If x=y
Data size
Trend slope
Multiple regression uses
One dependent and one independent variable
Several dependent variables
One dependent, many independent variables
No variables
In multiple regression, the dependent variable is the one being
Predicted
Counted
Stored
Deleted
The formula for MLR is
y=ax
y=b1x1+b2x2+⋯+a
y=x/y
y=x1+x2
A variable is significant when its p-value is
>0.10
<0.05
>1
=100
MLR is useful when analyzing
A single factor
Multiple predictors
Only categorical variables
Random noise
An example of a dependent variable in education
Hours of study
Student performance
Number of seats
Type of classroom
Independent variables in the TV show example include
Ratings
Viewers’ engagement
Production cost
Network name
The error term ( ϵ ) represents:
Perfect predictions
Unexplained variation
The slope
The intercept
When a model includes unnecessary variables, it may suffer from:
Underfitting
Perfect accuracy
Overfitting
No bias
In Excel MLR, which must be checked?
Fonts
Border colors
P-values
Cell color
Polynomial regression is used for relationships that are:
Straight
Nonlinear
Constant
Random
Polynomial equation includes terms such as:
x1 only
x2 , x3
x−1
log(x)
Adding x2 creates a:
Linear model
Quadratic model
Logistic model
Exponential model
A very high polynomial degree may cause:
Perfect interpretation
Overfitting
Simplicity
No residuals
In Excel, polynomial regression uses:
Pie chart
Polynomial trendline
Frequency table
Histogram
R2 tells us the:
Trend angle
Goodness of fit
Chart color
Number of records
When teaching hours increase then decrease motivation, the pattern is:
Linear
Constant
Curvilinear
Random
Overfitting occurs when the model:
Fits the general trend
Fits noise too closely
Uses correct order
Has simple variables
Logistic regression predicts:
Continuous values
Binary outcomes
Colors
Shapes
The logistic regression curve is:
Straight
S-shaped
Circular
Downward
Which is a valid example of logistic regression?
Predicting grades
Predicting pass/fail
Predicting height
Forecasting sales
Logistic regression estimates:
Probability of an event
Number of events
Cost
Weight
Logistic regression in Excel requires:
Sorting
Solver
Pivot table
Conditional formatting
In logistic regression, a higher number of practice essays increases:
Costs
Probability of passing
Uncertainty
Randomness
Independent variables in logistic regression may include:
Intercepts
Probabilities
Hours studied
Sig. values
The TREND function returns:
Only future values
Linear trend values
Shapes
Colors
FORECAST function predicts:
Past values
Future values
Intercepts only
Trends only
The LINEST function returns:
Regression statistics
Colors
Shapes
Pivot tables
TREND must be entered as:
Regular formula
Array formula
Chart label
Macro
FORECAST and TREND produce the same values when performing:
Nonlinear modeling
Linear forecasting
Logistic regression
Random projection
