Using your dataset, run a regression of Y=GPA and X=# Friends. (do not need your actual data, just the regression results) a) State what this regression is attempting to analyze. “By running this regression, we are attempting to show.....” b) Write out the regression equation and describe what it shows (if Friends increase by 1, then. . . ). c) Find your hypothesized GPA when the # friends equals 17. d) Is the slope of # of Friends significantly different from zero? Include Ho, Ha, decision rule, t statistic from table, tc, decision, and conclusion. e) Is the r-squared of # of Friends significantly different from zero? Include Ho, Ha, decision rule, F statistic from table, Fc, decision, and conclusion.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section: Chapter Questions
Problem 6SGR
icon
Related questions
Question

Using your dataset, run a regression of Y=GPA and X=# Friends.
(do not need your actual data, just the regression results)
a) State what this regression is attempting to analyze. “By running this regression, we are
attempting to show.....”
b) Write out the regression equation and describe what it shows (if Friends increase by 1, then. . . ).
c) Find your hypothesized GPA when the # friends equals 17.
d) Is the slope of # of Friends significantly different from zero?
Include Ho, Ha, decision rule, t statistic from table, tc, decision, and conclusion.
e) Is the r-squared of # of Friends significantly different from zero?
Include Ho, Ha, decision rule, F statistic from table, Fc, decision, and conclusion.

1
V9
4
5
AutoSave
Undo
File Home Insert Draw Page Layout
Ready
A
Paste
Clipboard
v
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Calc Avg
27 Calc sample stddev
28 sample variance
29
Off
B
1
X✓ fx
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
S
18
19
20
Sheet1
с
$ 65 70 75 75 60 45682272 65 65 3 4 1 60 69 69
77
Height
73
74
Morris Data Set ✓
Calibri
71
B I
D
Weight
131
165
260
180
180
190
140
130
214
165
195
187
140
190
230
190
167
95
135
150
U
E
GPA
4
3
2.7
2.75
2.8
3.4
2.9
3
2.9
2.85
3
3
3.6
3.22
2.8
3
3.2
3.8
4
3
Font
Formulas Data Review
✓11
F
Study
3
1
3.5
3
2
2
5
5
4
3.5
2
4
3
4.5
3
2.5
4
4
4
2
✓
G
G
TV
3
1
2.5
4
1
3
2
4
4
2
4
0.5
0
2
2
4.5
2
1
2
A^
A
1
3
2
H
Computer FamilySz
2
5
5
6
5
3
4
3
6
5
5
5
6
4
4
4
4
5
4
6
3
0
3
2
2.5
2
3
1
1
2
1.5
2
5
A
1
3
S
Q Search
4
4
View Automate
Alignment
Floors
2
2
2
2
1
2
1
3
1
22
2
2
2
3
2
3
Search
2
2
1
3
K
stairs
13
14
13
26
1
23
0
26
0
13
13
16
13
26
1
26
13
16
13
26
+
friends
5
8
15
3
2
6
3
3
4
15
8
12
2
5
6
4
8
1
N
5
5
Help
←0
.00 →.0
M
female
1
0
0
0
1
0
1
1
0
0
0
0
1
1
0
0
0
1
Number
1
0
2.375
2.3
4.55
3
14.6
70.05 171.7 3.146 3.25
6
4.9148 38.47227 0.403738 1.094243 1.296503 1.389813 0.887041 4.518966 8.999415 4.013136
24.15526 1480.116 0.163004 1.197368 1.680921 1.931579 0.786842 20.42105 80.98947 16.10526 0.252632
HWK 2 Q6 Project 1
Project 2
Project 3
N
Acctg
1
0
0
1
0
0
0
1
0
0
1
0
1
1
1
0
0
0
0
0
(DELL
S
O
Mgmt
0
0
0
0
0
1
0
0
1
1
0
1
0
0
0
0
0
0
1
0
I
0
0
P
Mktg
0
1
1
0
0
0
0
0
0
0
0
0
0
0
1
0
Conditional Formatting ✓
0
1
Format as Table
Cell Styles
Q
Fin
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Styles
0
R
Econ
0
0
0
0
0
0
0
0
0
0
0
0
0
ooooo
0
qb
S
Other
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
0
1
0
0
Insert
x Delete
NE
S Morris
T
Format ✓
Cells
U
m
V
WE
Σ 28-
Ov
a
Comments
Editing
W
X
Share
Analyze
Data
Analysis
Y
Z
X
+ 72%
10:19 PM
4/5/2023
Transcribed Image Text:1 V9 4 5 AutoSave Undo File Home Insert Draw Page Layout Ready A Paste Clipboard v 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Calc Avg 27 Calc sample stddev 28 sample variance 29 Off B 1 X✓ fx 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 S 18 19 20 Sheet1 с $ 65 70 75 75 60 45682272 65 65 3 4 1 60 69 69 77 Height 73 74 Morris Data Set ✓ Calibri 71 B I D Weight 131 165 260 180 180 190 140 130 214 165 195 187 140 190 230 190 167 95 135 150 U E GPA 4 3 2.7 2.75 2.8 3.4 2.9 3 2.9 2.85 3 3 3.6 3.22 2.8 3 3.2 3.8 4 3 Font Formulas Data Review ✓11 F Study 3 1 3.5 3 2 2 5 5 4 3.5 2 4 3 4.5 3 2.5 4 4 4 2 ✓ G G TV 3 1 2.5 4 1 3 2 4 4 2 4 0.5 0 2 2 4.5 2 1 2 A^ A 1 3 2 H Computer FamilySz 2 5 5 6 5 3 4 3 6 5 5 5 6 4 4 4 4 5 4 6 3 0 3 2 2.5 2 3 1 1 2 1.5 2 5 A 1 3 S Q Search 4 4 View Automate Alignment Floors 2 2 2 2 1 2 1 3 1 22 2 2 2 3 2 3 Search 2 2 1 3 K stairs 13 14 13 26 1 23 0 26 0 13 13 16 13 26 1 26 13 16 13 26 + friends 5 8 15 3 2 6 3 3 4 15 8 12 2 5 6 4 8 1 N 5 5 Help ←0 .00 →.0 M female 1 0 0 0 1 0 1 1 0 0 0 0 1 1 0 0 0 1 Number 1 0 2.375 2.3 4.55 3 14.6 70.05 171.7 3.146 3.25 6 4.9148 38.47227 0.403738 1.094243 1.296503 1.389813 0.887041 4.518966 8.999415 4.013136 24.15526 1480.116 0.163004 1.197368 1.680921 1.931579 0.786842 20.42105 80.98947 16.10526 0.252632 HWK 2 Q6 Project 1 Project 2 Project 3 N Acctg 1 0 0 1 0 0 0 1 0 0 1 0 1 1 1 0 0 0 0 0 (DELL S O Mgmt 0 0 0 0 0 1 0 0 1 1 0 1 0 0 0 0 0 0 1 0 I 0 0 P Mktg 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 Conditional Formatting ✓ 0 1 Format as Table Cell Styles Q Fin 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Styles 0 R Econ 0 0 0 0 0 0 0 0 0 0 0 0 0 ooooo 0 qb S Other 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 1 0 0 Insert x Delete NE S Morris T Format ✓ Cells U m V WE Σ 28- Ov a Comments Editing W X Share Analyze Data Analysis Y Z X + 72% 10:19 PM 4/5/2023
sc
Undo
E5
1
2
3
←
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
File
<
◄
My PennWest Login
A
Home - myPennWes X
Home Insert
Paste
Excel Morris Data Set - Saved ✓
Clipboard
B
SUMMARY OUTPUT
ANOVA
Calibri
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
Regression
Residual
Total
Morris Data Set.xlsx X D2L WEBWork CMAT 23 X b↑ € My PennWest X
https://sshe-my.sharepoint.com/:x:/r/personal/mor88107_pennwest_edu/_layouts/15/doc2.aspx?sourcedoc=%7BABED4FC3... A
Intercept
friends
BIUD ab H ♡
0.331981567
0.110211761
0.060779081
0.391276072
df
20
eCampus: Choosing...
Draw Page Layout
1
18
19
✓11
Font
D
SS
0.341334641
2.755745359
3.09708
Coefficients Standard Error
3.346392157 0.160206916
-0.033398693 0.022367764
> = Sheet1
Sheet2 HWK 2
Calculation Mode: Automatic Workbook Statistics
Q6
Α Α΄
E
https://ecampus.vit... WeBWork: CMAT_2...
Search (Alt + Q)
Formulas Data
D
Project 1
P
F
Alignment
G
Significance F
MS
F
0.341334641 2.229532387 0.152716443
0.153096964
Wrap Text
Merge & Center ✓
Q Search
Review
H
Project 2 Project 3 +
I
General
t Stat
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
20.88793823 4.54442E-14 3.009809917 3.682974397 3.009809917 3.682974397
-1.493161876 0.152716443 -0.080391622 0.013594236 -0.080391622 0.013594236
View Automate Help
$%95.000.000
Ch. 1 Introduction -...
Number
a
K
use the "printout" b X
(DELL)
L
Start Here, Go Any...
Conditional Format As Styles
Formatting ✓ Table ✓
Styles
M
N
https://vdi.pennwes X
qb
Comments
O
Insert Delete Format
X
The Best Summary...
P
Cells
☆
Q
+
Editing
Editing
R
Give Feedback to Microsoft
S
Share ✓
Analyze
Data
Analysis
SM
T
- 71% +
▲
X
C
O
+
10:17 PM
4/5/2023
Transcribed Image Text:sc Undo E5 1 2 3 ← 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 File < ◄ My PennWest Login A Home - myPennWes X Home Insert Paste Excel Morris Data Set - Saved ✓ Clipboard B SUMMARY OUTPUT ANOVA Calibri Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations Regression Residual Total Morris Data Set.xlsx X D2L WEBWork CMAT 23 X b↑ € My PennWest X https://sshe-my.sharepoint.com/:x:/r/personal/mor88107_pennwest_edu/_layouts/15/doc2.aspx?sourcedoc=%7BABED4FC3... A Intercept friends BIUD ab H ♡ 0.331981567 0.110211761 0.060779081 0.391276072 df 20 eCampus: Choosing... Draw Page Layout 1 18 19 ✓11 Font D SS 0.341334641 2.755745359 3.09708 Coefficients Standard Error 3.346392157 0.160206916 -0.033398693 0.022367764 > = Sheet1 Sheet2 HWK 2 Calculation Mode: Automatic Workbook Statistics Q6 Α Α΄ E https://ecampus.vit... WeBWork: CMAT_2... Search (Alt + Q) Formulas Data D Project 1 P F Alignment G Significance F MS F 0.341334641 2.229532387 0.152716443 0.153096964 Wrap Text Merge & Center ✓ Q Search Review H Project 2 Project 3 + I General t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 20.88793823 4.54442E-14 3.009809917 3.682974397 3.009809917 3.682974397 -1.493161876 0.152716443 -0.080391622 0.013594236 -0.080391622 0.013594236 View Automate Help $%95.000.000 Ch. 1 Introduction -... Number a K use the "printout" b X (DELL) L Start Here, Go Any... Conditional Format As Styles Formatting ✓ Table ✓ Styles M N https://vdi.pennwes X qb Comments O Insert Delete Format X The Best Summary... P Cells ☆ Q + Editing Editing R Give Feedback to Microsoft S Share ✓ Analyze Data Analysis SM T - 71% + ▲ X C O + 10:17 PM 4/5/2023
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax