I need help with this excel, i attached a document below.

ROC Project RubricExplanation
Criteria
Level 4
40 points
Level 3
30 points
Level 2
20 points
Document clearly explains
the approach taken. This
includes:
Document explains the approach
taken. This may include these
elements, but one of the following
exists:
Document explains the approach
taken. This may include these
elements, but two of the following
exist:
justification for variables selected a priori reasoning and/or support
from the extant literature. Some of
the justification may make
assumptions that are unsupported
justification for variables selected a priori reasoning and/or support
from the extant literature. Some of
the justification may make
assumptions that are unsupported
statistics calculated on variables of
interest – statistics may be backed
by incorrect assumptions or
conclusion drawn may be incorrect
or too far-reaching. Some statistics
or numerical manipulations that
should be done are not provided.
statistics calculated on variables of
interest – statistics may be backed
by incorrect assumptions or
conclusion drawn may be incorrect
or too far-reaching. Some statistics
or numerical manipulations that
should be done are not provided.
graphs of variables of interest graph scaling is off or common
scaling not used making it difficult
to compare variables. Helpful
graphs may not be supplied.
graphs of variables of interest graph scaling is off or common
scaling not used making it difficult
to compare variables. Helpful
graphs may not be supplied.
writing and document are not
professional – presentation is
sloppy, numerous typos or
grammatical errors
writing and document are not
professional – presentation is
sloppy, numerous typos or
grammatical errors
your thought process is not clearly
articulated
your thought process is not clearly
articulated
the impact of your independent
variables is unexplained
the impact of your independent
variables is unexplained
1. justification for variables
selected – a priori
reasoning and/or support
from the extant literature
offers a full explanation
of your reasoning
2. statistics calculated on
variables of interest
3. graphs of relationships
among variables of
interest
4. writing and document are
professional
5. an explanation that offers
background information
on the data and your
decision-making process
you used to develop the
model
6. an explanation to a
potential user of your
model that explains the
influence of your
predictors.
Note that these five elements
speak to your process of
discovery more so than
correct answers.
Level 1
10 points
Document is poorly crafted and
missing a number of elements.
Three of the following exist:
justification for variables selected a priori reasoning and/or support
from the extant literature. Some of
the justification may make
assumptions that are unsupported
statistics calculated on variables of
interest – statistics may be backed
by incorrect assumptions or
conclusion drawn may be incorrect
or too far-reaching. Some statistics
or numerical manipulations that
should be done are not provided.
graphs of variables of interest graph scaling is off or common
scaling not used making it difficult
to compare variables. Helpful
graphs may not be supplied.
writing and document are not
professional – presentation is
sloppy, numerous typos or
grammatical errors
your thought process is not clearly
articulated
the impact of your independent
variables is unexplained
Level 0
0 points
Section is missing
or entire project is
not submitted.
Computation
Criteria
Level 4
60 points
Level 3
50 points
1. Spreadsheet is neatly
formatted.
2. All necessary calculations
are presented and performed
correctly. This includes
Solver and the logistics
function, an ROC curve,
confusion matrix that
calculates automatically, an
analysis of predictive power
of intermediate and final
models, an input area where
predictions of success can
be made for future values,
and confirmation that your
model is robust across all
ranges of inputs.
3. The outcome can be divined
at a glance. Cells are
highlighted appropriately.
Explanatory text boxes are
included.
4. Multiple spreadsheets are
included in the workbook
with supporting calculations
on secondary spreadsheets
(all neatly labeled).
5. The explanation provided in
the accompanying document
properly and thoroughly
explains what was done.
6. A key (index or table of
contents) is provided in your
first (leftmost) spreadsheet.
Note that these elements are
more about good results that
are easily digested by an
informed reader. However, an
ease of use element is
contained in these criteria.
40 points
Level 1
20 points
Level 0
0 points
A spreadsheet is provided, but
one of the following conditions
exists:
A spreadsheet is provided,
but two of the following
conditions exist:
A spreadsheet is provided,
but three or more of the
following conditions exist:
This section is omitted or
the project is not
submitted.
Spreadsheet is poorly formatted
Spreadsheet is poorly
formatted
Spreadsheet is poorly
formatted
A necessary calculation
may be missing.
A necessary calculation may
be missing.
A calculation may be
incorrect.
A calculation may be
incorrect.
The outcome is difficult to
find or follow.
The outcome is difficult to
find or follow.
Intermediate steps may be
missing. The explanatory
text may not sufficiently
explain all elements of the
spreadsheet/workbook.
Intermediate steps may be
missing. The explanatory text
may not sufficiently explain
all elements of the
spreadsheet/workbook.
A key (index or table of
contents) may not be
provided.
A key (index or table of
contents) may not be
provided.
A necessary calculation may be
missing.
Level 2
A calculation may be incorrect.
The outcome is difficult to find
or follow.
Intermediate steps may be
missing. The explanatory text
may not sufficiently explain all
elements of the
spreadsheet/workbook.
A key (index or table of
contents) may not be provided.