SLR Output Table, Graph, and Residual Plot

Helpful guiding videos

Only Use Dataset thatTHE BELOW CONTEXT APPLIES TODATASETS
ALL
First Letter, Last Name
Business Ma
Response Variable: See Survey Question Below*
Categorical Variable: Student’s Major
Might students of different majors hold different views
regarding whether the primary purpose of college is to
acquire work skills, and if yes or if no, what might be a
plausible explanation or outcome for the test result?
*Survey Question Prompt: The primary importance of
college is to gain work skills.
1
= Strongly Disagree; 7 = Strongly Agree
Alpha = .10
Majagement\Gen Bus
6
6
7
4
5
3
3
4
1
1
5
Only Use Dataset that Falls Under the First Letter of Your Last Name ~ Only Use Dataset that Falls Under the First Letter of Your L
First Letter, Last Name: A through G
First Letter, Last Name: H through O
Business Major
Business Major
Marketing
4
7
5
4
6
5
2
3
3
4
6
Accounting\MIS
7
4
7
6
6
6
6
7
7
3
6
Majagement\Gen Bus
1
1
6
6
4
5
3
2
4
5
4
Marketing
5
5
5
6
3
4
4
5
4
5
3
he First Letter of Your Last Name ~ Only Use Dataset that Falls Under the First Letter of Your Last Name
me: H through O
First Letter, Last Name: P through Z
Major
Business Major
Accounting\MIS
5
6
7
5
7
5
3
7
6
4
5
Majagement\Gen Bus
5
3
5
3
4
2
5
3
6
4
2
Marketing
5
7
5
6
4
5
4
6
6
6
7
Your Last Name
me: P through Z
Major
Accounting\MIS
6
7
6
5
7
7
4
5
5
4
7
Use Dataset with Column Letter that is the Same as the First Letter of Your Last Name ●
Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1
25
20
23
22.5
25
15
13
20
16.5
15.5
22.5
17.5
17
20
22
19.5
15
22.5
18.5
22
12.5
17
17.5
4.5
17.5
17
21
19
23
17.5
18.5
18.5
16.5
19
19
23.5
17
13
14.5
22
21
19
11
16
17
21
19.5
23.5
21
17.5
19.5
19
16
14.5
23.5
17.5
16
21.5
22
19.5
14
15
20.5
14.5
15
16
19
14
15.5
22
17
13.5
17.5
22
18.5
15
20.5
24.5
17
18.5
26
21
21.5
21
17
19.5
23
3.5
17.5
14.5
15
19
22.5
16
19.5
18
17.5
20
21.5
21.5
23
17
16
18
20
21.5
20.5
22.5
22.5
17.5
17
21.5
22
18.5
20.5
20.5
23.5
21
20.5
18.5
19
23
18
22.5
19
21
17
17.5
22
18
18
17.5
23
20.5
19
13.5
18.5
21
15
18.5
17.5
22.5
21.5
21
23
18.5
21.5
22
18.5
18.5
20.5
20.5
22.5
13
23.5
19
19
16.5
13
25.5
19
18.5
18
21.5
15
20.5
21
20
17
20.5
18.5
22.5
18
17
18.5
20
18.5
19
20.5
15.5
Note: Some scores may be greater than 25 because of bonus points.
Copy Data He
our Last Name ●
Copy Data Heading along with Data ● Use Dataset with Column Letter that is the Same as the First Letter of Your L
Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1
22.5
14.5
21
21
21.5
18.5
25
16.5
19.5
14
16
22.5
24.5
18
21.5
14.5
14.5
25
14.5
23
19
20.5
16
14.5
21
21
19
17.5
18.5
16
17.5
20
16
21
20.5
20
19.5
19.5
18
20.5
20.5
19.5
24
20.5
21
17.5
16.5
16.5
12
20.5
18.5
16.5
14
19.5
17
15
17
18
25.5
15
20
14.5
19
14.5
18.5
17.5
20.5
18
14.5
21.5
12.5
21
23.5
17.5
19.5
20
18.5
15
18
18
19.5
19
17
22.5
20.5
21.5
20
19
13
18
17
19.5
17.5
21.5
14.5
22
20
17.5
15.5
21.5
17
20
21
16
7
17
22
16.5
20.5
19.5
23.5
18.5
19.5
15
21.5
18
24
15
19.5
11.5
18.5
18.5
14
18
21
22.5
18
11
16
21.5
15
21.5
24
22
17
19
21.5
16.5
18
14.5
21.5
22
18.5
20
20.5
11
18
12.5
15
15.5
21.5
16
17.5
20
22
22
16
20
16.5
15.5
19
14.5
16.5
22.5
13
24
22
21
18
21
17
17.5
18
17
21
8
25.5
18.5
21
20
Same as the First Letter of Your Last Name ● Copy Data Heading along with Data
Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1 Midterm 1
16.5
20.5
18.5
19
21
20.5
22.5
22.5
24
19.5
16
20
17
17.5
20
20
22.5
19.5
19
21
13.5
18.5
22.5
22.5
17
18
21
19.5
23
24
22
22
20
22
21
19
13
23.5
23
23
17.5
23
19.5
21
18
21.5
23.5
22.5
14.5
18
25
19.5
22.5
18
21.5
18
17
18.5
19
18
20
23
18
21
20
18.5
20
15.5
22.5
22.5
23
22.5
19
16.5
21
16.5
21
18.5
25
19
17.5
21
16.5
19
23.5
18.5
23.5
23.5
18.5
21
19
16
17
15.5
23.5
23.5
23.5
22
19.5
16
14.5
22.5
20.5
21
23.5
18.5
19.5
15
20.5
14
20.5
19.5
14
16
15.5
17
13.5
14.5
25.5
25
18
19
24.5
18.5
24
17.5
18
22.5
20
21
23
17.5
22.5
19.5
23
22
20.5
21
18
20
17
25
19.5
23
23
19.5
20
20.5
20
19
19.5
24.5
18.5
19
25
20.5
17.5
20
17.5
20.5
Use Dataset with Column Letter that is the
Written Report Writen Report Written Report Writen Report Written Report Writen Report
25
19
24.5
23
25
20
11.5
26.5
17.5
19.5
21.5
21
17
24.5
15.5
19.5
18.5
7
20
19.5
17
17.5
18.5
17
20
13.5
15.5
22
19
16.5
24
20
20
20
18
19.5
24
19
18
20.5
22
16.5
16.5
17.5
14.5
17
15
12.5
17.5
23.5
20.5
15
24.5
22
22.5
19
20.5
19.5
13.5
25.5
18.5
21
23
17
18
18
21.5
19.5
19.5
18
19.5
24
21.5
22
19.5
20
23
19.5
21.5
22.5
17.5
19.5
20.5
18.5
19
18.5
22
17.5
17.5
15
15.5
21.5
20
13.5
20.5
21.5
24
17
20.5
20
19
17.5
12.5
21
17
21.5
17.5
12
17
20.5
15
22.5
23.5
20.5
19.5
19
19.5
17.5
21
19.5
Note: Some scores may be greater than 25 because of bonus points.
Dataset with Column Letter that is the Same as the First Letter of Your Last Name ●
Copy Data Heading along with Data ● Use Dat
Written Report Writen Report Written Report Writen Report Written Report Writen Report
12.5
22.5
17.5
24.5
14
22
16
14.5
22.5
16
19.5
21.5
17.5
19
25.5
16.5
23.5
20
15.5
17.5
25
17
18
16
19
18.5
21.5
20
20.5
18
16
20.5
12.5
16
16.5
13
9
18.5
20.5
18.5
18
18
23.5
17.5
15
15
17
19.5
6.5
17.5
24.5
24
21
18.5
6.5
19
16
20.5
17
19
16
21
22
16
23
19
23
22
21
22
20.5
21
21
20
20.5
18.5
19
22
20
21
18
12
20
12.5
25.5
21.5
19.5
18
13
20
24
22
23.5
19
22.5
19
22
18.5
21.5
20
14.5
18.5
24.5
20
17
21.5
22
19.5
20.5
21.5
19
16
22
12.5
22
21
14.5
16
17
17.5
bonus points.
Heading along with Data ● Use Dataset with Column Letter that is the Same as the First Letter of Your Last Name ●
Written Report Writen Report Written Report Writen Report Writen Report Written Report
23.5
22.5
18.5
25
16.5
22
23.5
15.5
21
19
12.5
25.5
23.5
16.5
16
22.5
22.5
21.5
18.5
19
18
22.5
20
23
19.5
17
23.5
22.5
21
19
13
22
20
14.5
15
16.5
20
24.5
16
19
11
21
24
20
12
17.5
13.5
22.5
20
18.5
14
16.5
19.5
20
19.5
21
18.5
17
15
18.5
19.5
16
22.5
18.5
20
15.5
20.5
18
5
17
20.5
16.5
18
18.5
15.5
24
20.5
23
20.5
20
13.5
14.5
24
20
19
16
20.5
22.5
22
16
17.5
12
20.5
22.5
17.5
19
11.5
14
15.5
21
15.5
21
17.5
18.5
19.5
19.5
18.5
14.5
24.5
22.5
22
16.5
20.5
16
20
8
25.5
19
22
21.5
Copy Data Hea
of Your Last Name ●
Copy Data Heading along with Data
Writen Report Written Report Writen Report Written Report Writen Report Written Report
16.5
24.5
17.5
21.5
21.5
22.5
23
13.5
15.5
23
19
18.5
20
18
18.5
19
15.5
21.5
16
19.5
20.5
16.5
24
17
19
23
22
21
12.5
21
21
20.5
22
22.5
17
20.5
14.5
17.5
25.5
20
19.5
19
16
20.5
21.5
18.5
19
24.5
21.5
19
23
15.5
22.5
21.5
19.5
17.5
19
16.5
25.5
17
20.5
23.5
17
17.5
25
19
18
24
16.5
18.5
21.5
14.5
22.5
22
19.5
20.5
12.5
24.5
22
17.5
16.5
18.5
20.5
16
17
15.5
12.5
17.5
15
16.5
18
18.5
22
17.5
23
24
19
20.5
25.5
19
20
20
22
22
18
21
16
25.5
18
22
24
22
19
24.5
13
21.5
25
20
21
23
Writen Report Written Report
19.5
19.5
19
19
26.5
26.5
24.5
24.5
19.5
19.5
21
22
20.5
17
25
22
24.5
21.5
18
20
22.5
22.5
22
22
25
22
22
22
24.5
25.5
20
26.5
22.5
24.5
23.5
19.5
22
23.5
18.5
23.5
Data Column Survey Question
A
To the nearest value what is your GPA?
B
How many units are you taking this semester?
C
To the nearest amount, how much school debt do you expect to have upon graduati
D
My major & career choice is done in pursuit of what I love.
E
I am optimistic about the world’s future.
F
I am motivated by tangible rewards (money, bonuses, gifts, etc)
G
I am really enjoy networking.
H
I have extensively researched the field\career I plan to enter upon graduating.
I
I regularly write down and review my goals.
J
How much do you expect to get paid upon graduating and landing your first job?
K
What is your gender?
L
What is your major?
M
What do you value more? Time or Money
N
At least 1 of my parents attended college? True or False
ct to have upon graduation?
etc)
r upon graduating.
anding your first job?
Response Scale: 1 (strongly disagree) to 7 (stongly agree)
Response Scale: 1 (strongly disagree) to 7 (stongly agree)
Response Scale: 1 (strongly disagree) to 7 (stongly agree)
Response Scale: 1 (strongly disagree) to 7 (stongly agree)
Response Scale: 1 (strongly disagree) to 7 (stongly agree)
Response Scale: 1 (strongly disagree) to 7 (stongly agree)
agree)
agree)
agree)
agree)
agree)
agree)
GPA
3.75
3.25
3.50
4.00
4.00
2.75
3.75
3.75
2.75
3.75
3.25
3.75
3.50
4.00
4.00
2.50
4.00
2.75
2.75
3.50
3.75
4.00
3.00
2.75
3.50
Units
12
16
12
15
12
14
12
12
16
16
18
14
14
12
15
19
12
16
18
14
12
15
17
18
16
School Debt Pursue What Love Optimistic: Future
$5,000
6
5
$20,000
6
6
$0
6
5
$10,000
7
5
$15,000
7
4
$20,000
4
7
$0
7
5
$5,000
5
5
$15,000
5
6
$10,000
5
6
$30,000
3
7
$0
6
5
$15,000
5
6
$0
7
7
$0
6
6
$40,000
4
6
$5,000
7
5
$20,000
4
6
$15,000
5
6
$5,000
6
5
$10,000
6
3
$5,000
7
6
$10,000
5
7
$25,000
6
7
$10,000
6
6
Rewards
4
7
3
5
4
6
3
5
5
4
7
5
6
7
4
7
5
6
7
7
6
7
6
7
5
Networking
5
6
4
5
4
7
3
6
7
5
7
4
5
5
7
5
6
7
6
4
6
6
7
7
6
Career Research
4
5
6
7
4
5
6
6
6
7
4
7
2
7
6
3
7
4
4
6
6
6
3
3
5
Write Goals Exp Starting Salary
4
$60,000
6
$75,000
4
$60,000
3
$50,000
6
$45,000
7
$80,000
2
$45,000
3
$60,000
6
$75,000
5
$65,000
7
$85,000
3
$60,000
4
$70,000
3
$50,000
5
$60,000
6
$100,000
3
$55,000
2
$80,000
7
$100,000
4
$65,000
1
$65,000
1
$50,000
7
$75,000
6
$100,000
5
$70,000
Gender
Male
Male
Female
Female
Female
Male
Female
Female
Male
Female
Male
Male
Female
Female
Female
Male
Female
Female
Male
Female
Female
Female
Male
Male
Female
Student Major
Marketing
Marketing
Management
Accounting
Accounting
Marketing
Accounting
Management
Management
Marketing
Marketing
Management
Management
Accounting
Marketing
Marketing
Accounting
Management
Marketing
Accounting
Marketing
Management
Marketing
Management
Marketing
Value: T\M
Time
Money
Time
Time
Time
Money
Money
Money
Time
Time
Money
Time
Time
Time
Time
Money
Money
Money
Money
Time
Time
Time
Money
Money
Time
Parent –> College
No
Yes
Yes
No
No
Yes
No
Yes
Yes
Yes
Yes
No
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Last
Name:
Click or tap here to enter text.
First
Name:
Click or tap here to enter text.
Written Statement Here (Delete This)
SLR Graph Here (Delete This)
Residual Graph Here (Delete This)
SLR OUTPUT TABLE HERE (Delete This)
(1 Number per Cell)
STEP 1: INPUT Red ID →
1
2
3
4
5
6
7
8
9
X-variable
STEP 2: PASTE Data*, Starting in Cells M3 & N3 →
(*Get Data from the Class Survey Data File — link on the
Canvas Homepage — Include Data Headings )
STEP 3: See Data Results by
CLICKING on the SLR Output
Table & Graphs tab below
Y-variable
Ignore Empty Table Below
SLR RELATATIONHSIP BETWEEN 2 ASSESSMENTS
r
RSQ
b
m
CM
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0.00
Student
0
0
Predicted Residual
1
0.00
0.00
#DIV/0!
#DIV/0!
2
0.00
0.00
#DIV/0!
#DIV/0!
3
0.00
0.00
#DIV/0!
#DIV/0!
4
0.00
0.00
#DIV/0!
#DIV/0!
5
0.00
0.00
#DIV/0!
#DIV/0!
6
0.00
0.00
#DIV/0!
#DIV/0!
7
0.00
0.00
#DIV/0!
#DIV/0!
8
0.00
0.00
#DIV/0!
#DIV/0!
9
0.00
0.00
#DIV/0!
#DIV/0!
10
0.00
0.00
#DIV/0!
#DIV/0!
11
0.00
0.00
#DIV/0!
#DIV/0!
12
0.00
0.00
#DIV/0!
#DIV/0!
13
0.00
0.00
#DIV/0!
#DIV/0!
14
0.00
0.00
#DIV/0!
#DIV/0!
15
0.00
0.00
#DIV/0!
#DIV/0!
16
0.00
0.00
#DIV/0!
#DIV/0!
17
0.00
0.00
#DIV/0!
#DIV/0!
18
0.00
0.00
#DIV/0!
#DIV/0!
19
0.00
0.00
#DIV/0!
#DIV/0!
20
0.00
0.00
#DIV/0!
#DIV/0!
r
#DIV/0!
Student
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SLR RELATIONSHIP BETWEEN 2 ASSESMENTS
RSQ
b
m
CM
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0
0
Predicted
Residual
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
25
20
15
10
Table & Charts Will Update When Red ID and Data is Inpu
FORMAT GRAPH — SEE DIRECTIONS — FORMAT GRAPH — SEE DIRECTIONS
Chart Title
25
20
15
10
5
0
0
0
0
0
0
1
1
↑↑↑ SLR GRAPH ↑↑↑
1
1
1
1
ate When Red ID and Data is Inputed into SLR Input Data-Locked Sheet
FORMAT GRAPH — SEE DIRECTIONS — FORMAT GRAPH — SEE DIRECTIONS
Chart Title
1.00
0.90
0.80
0.70
0.60
0.50
0.40
0.30
0.20
0.10
0.00
0
5
10
15
↑↑↑ RESIDUAL PLOT ↑↑↑
20
H — SEE DIRECTIONS
20
↑↑↑
25
SLR Output Table, Graph, and Residual Plot
CONTEXT
Business, Production, and The Environment is a 400-level course at College. Student grades are based on
the following 4 assessments:
WEEK
ASSESSEMENT
4
MIDTERM 1
6
WRITTEN REPORT
14
MIDTERM 2
16*
PRESENTATION
*The semester is 16 weeks long.
Total Grade:
POINT VALUE
25
25
25
25
100
You will analyze the relationship between the Points earned for one of the following pairs:
1.
2.
3.
4.
5.
6.
X-VARIABLE
MIDTERM 1
MIDTERM 1
MIDTERM 1
WRITTEN REPORT
WRITTEN REPORT
MIDTERM 2
Y-VARIABLE
MIDTERM 2
WRITTEN REPORT
PRESENTATION
MIDTERM 2
PRESENTATION
PRESENTATION
Directions
1. Open the Excel SLR Tool Kit (provided with the Assignment).
2. Follow Steps 1, 2, and 3 on the SLR Input Data-Locked sheet.
3. The SLR Output Table & Graphs sheet will create an SLR Output Table, SLR Graph, and Residual Plot.
4. You will need to format the SLR Graph and Residual Plot –> See Below.
SLR Graph — Formatting
3. Click anywhere on the graph.
4. Select Chart Design from the ribbon bar.
5. Select Add Chart Element
A\ Add a Descriptive Chart Title
B\ Add X & Y axis Labels
C\ Format anything to your liking – data point colors\size, font, chart color, gridlines, etc.
D\ Extend the trendline to the Y-axis – see next page
Note: The A1-Ch2 Assignment covered formatting charts so you can review that material if need be.
7\ Extending the Trendline to the Y-axis: Either –
a\ right click on the trendline and select Format Trendline or
b\ click on the graph, click on Add Chart Elements in the ribbon bar,
click on Trendline, More Trendline Options
Whether you do “a” or “b”, the popup box to the right appears –Put in a single-digit number for Backwards Period.
This will extend the trendline towards the Y-axis.
Adjust number as needed. See Green Arrow 1.
Note: Below Forecast, if you want, you can easily add the
Regression Equation or RSQ to your chart by clicking on
those options. See Green Arrows 2 & 3.
8\ Format Trendline
a\ right click on the trendline*
b\ select Format from the Ribbon Bar
c\ click on Shape Outline and the following
dropdown box appears
1
2
3
If you want and\or to make your
graph look professional:
Change Trendline Color
Change Trendline Thickness
Make Trendline a Solid or Dashed
*You can also format the trendline by using the Format Trendline dropdown box shown at the top of
this page by selecting the icon identified by the BLUE ARROW.
RESIDUAL PLOT
1\ Format, title, and label the Residual Plot as needed.
C. Complete Assignment Submission Form:
1\ Copy & Paste -● the SLR Relationship Between 2 Assessments Table on page 2, as indicated
● the SLR graph with Trendline in the lower left box (on page 1), as indicated
● the Residual Plot in the lower right box (on page 1), as indicated
2\ Write your analysis/interpretation in the text box at the top of page 1, as indicated
Where to start your statement?
A\ What is your model? Is it good? Not Good? So-So? And what is the basis of your decision?
B\ Following A, since your output is unique to yourself, this analysis is open-ended. More than required
topics, the following is offered to get you thinking of the wide spectrum of issues that can be addressed.
While limited, do use the allotted space (10 pts assignment) to spotlight your best issues in a coherent
statement based on your specific data –● Strength/direction of the relationship, line of best fit, etc. (SLR Output Table)?
● Isolating the slope\marginal input\output?
● Visually (SLR Graph with Trendline) does the data fit the model?
● Does the Residual Plot support the use of a linear model?
● Any applicable “Key Concepts” from this chapter or “Cautionary Notes” from last chapter?
● Specific Over\Underperformers and possible explanations?
● Implications of model, for students? For Instructors?
● Inferences that can be made based upon the level of r\RSQ?
● Inferences that can be made regarding the type\timing of the assessments (see page 1)?
● Inferences that can be made about the population (as you identify it) of students, perhaps
about their ability, learning, motivation, schedules, etc.?
● What does your r suggest? Is the value of your r a good thing in application?
● Might your r-value be too high (What would a very high r-value suggest?)?
Your statement -● Should contain data i(even parenthetically) to support your statements.
● Should be a blend of descriptive writing and inferential writing,
● May include any issue\analytical tool from earlier chapters to support your statement.