please write 2-3 sentences on each graph

Please write a small explanation what each graph is and what it tells us.

SPSS Assignment 6
N
Statistic
23
Beta
D/E Ratio
23
Effective Tax
rate
Valid N
(listwise)
23
Range
Statistic
.88491948658
7051
1.7490680257
38549
.18556580909
8840
Descriptive Statistics
Minimum
Maximum
Mean
Std. Deviation Variance
Statistic
Statistic
Statistic
Std. Error
Statistic
Statistic
.69798811946 1.5829076060 1.1555772265 .04622580793 .22169118690
.049
8734
55785
03270
8608
2578
.07576537402 1.8248333997 .52144594724 .10678846110 .51213946809
.262
8940
67489
0731
5958
8007
.00737385905 .19293966815 .09724930441 .01046118675 .05017008921
.003
5738
4579
9770
5323
2438
23
N is for the number of Betas that are available on the sheet. Range statistics is the difference between each variable’s highest and
lowest numbers. Minimum is the lowest number available; maximum is the highest number available. The mean is the arithmetic average of
the data, and the variance measures dispersion from the mean. The standard deviation statistics tell us how far the numbers are from each
other. In this table, we can see that the effective tax rate is closer to the mean; on the other hand, the D/E ratio has a bigger std which is
expected. Industries have a similar effective tax rate but usually use different Debt to Equity ratios in their financial objectives.
What does my variable mean:
Beta: is how close do the industry average move compared with the countries average (Dow jones & S&P 500)
D/E ratio: is the debt-to-equity ratio
Effective tax rate: Income/ how much taxes they pay
Range Statistics is subtracting the highest with the lowest. The farthest two for beta, D/E, and Effective Tax are 0.8849, 1.749, and 0.18556
respectively.
The average of the betas found on the excel sheet is 1.1555 and the std error is 0.462258
The average of the D/E Ratio found on the excel sheet is 0.5214 and the std error is 0.106788
The average of the D/E Ratio found on the excel sheet is 0.0972 and the std error is 0.01046
Standard deviation tells us how spread out the normal distribution curve will look. Meaning how disperse are the number for each variable are.
The standard deviation is the variance to the power 0.5.
Variance is the square root of standard deviation.
Frequencies
Statistics
SPSS Assignment 6
Beta
N
Valid
Missing
23
0
Valid .69798811946873
4
.75438848401831
5
.81936464501292
0
.91562861731458
4
.93412874253081
2
1.0891943033566
15
1.1027466358300
21
1.1085751411224
29
1.1172141898724
21
1.1293063217758
33
1.1624244348249
13
1.1749812758826
84
1.1871342649276
13
1.1988227196576
00
1.2156865359252
68
Beta
Frequenc
y
Percent
1
4.3
Valid
Percent
4.3
Cumulative
Percent
4.3
1
4.3
4.3
8.7
1
4.3
4.3
13.0
1
4.3
4.3
17.4
1
4.3
4.3
21.7
1
4.3
4.3
26.1
1
4.3
4.3
30.4
1
4.3
4.3
34.8
1
4.3
4.3
39.1
1
4.3
4.3
43.5
1
4.3
4.3
47.8
1
4.3
4.3
52.2
1
4.3
4.3
56.5
1
4.3
4.3
60.9
1
4.3
4.3
65.2
SPSS Assignment 6
1.2265825725549
80
1.2810483683110
93
1.2867471319469
85
1.3404215229301
83
1.3520952869467
55
1.3980688847319
37
1.5028204045767
19
1.5829076060557
85
Total
1
4.3
4.3
69.6
1
4.3
4.3
73.9
1
4.3
4.3
78.3
1
4.3
4.3
82.6
1
4.3
4.3
87.0
1
4.3
4.3
91.3
1
4.3
4.3
95.7
1
4.3
4.3
100.0
23
100.0
100.0
SPSS Assignment 6
Frequencies
Statistics
D/E Ratio
N
Valid
Missing
23
0
Valid .07576537402894
0
.16647110863329
8
D/E Ratio
Frequenc
y
Percent
1
4.3
1
4.3
Valid
Percent
4.3
Cumulative
Percent
4.3
4.3
8.7
SPSS Assignment 6
.18746796430604
5
.19467998368155
5
.19861674408482
4
.21416055920061
4
.22390780550833
0
.22620996680124
5
.26940667634309
4
.27941729605600
9
.29451430025008
5
.31596235793287
4
.31676618830492
7
.34574382241332
2
.41648568717876
4
.44756890147504
0
.47398021946182
4
.51467129744635
6
.60115246866073
1
1.1682226809811
33
1.5333125621607
48
1
4.3
4.3
13.0
1
4.3
4.3
17.4
1
4.3
4.3
21.7
1
4.3
4.3
26.1
1
4.3
4.3
30.4
1
4.3
4.3
34.8
1
4.3
4.3
39.1
1
4.3
4.3
43.5
1
4.3
4.3
47.8
1
4.3
4.3
52.2
1
4.3
4.3
56.5
1
4.3
4.3
60.9
1
4.3
4.3
65.2
1
4.3
4.3
69.6
1
4.3
4.3
73.9
1
4.3
4.3
78.3
1
4.3
4.3
82.6
1
4.3
4.3
87.0
1
4.3
4.3
91.3
SPSS Assignment 6
1.7039394218595
73
1.8248333997674
89
Total
Frequencies
1
4.3
4.3
95.7
1
4.3
4.3
100.0
23
100.0
100.0
SPSS Assignment 6
Statistics
Effective Tax rate
N
Valid
Missing
23
0
Effective Tax rate
Frequenc
y
Percent
Valid .00737385905573
1
4.3
8
.03883579619007
1
4.3
9
.03897168350051
1
4.3
7
.04527469178499
1
4.3
0
.04955132970534
1
4.3
8
.05324955670929
1
4.3
7
.05758560332121
1
4.3
8
.06829798051845
1
4.3
6
.07236611706674
1
4.3
4
.07934785420443
1
4.3
6
.08191187973286
1
4.3
3
.10017554955486
1
4.3
3
.10121764420030
1
4.3
5
.10174590583258
1
4.3
1
Valid
Percent
4.3
Cumulative
Percent
4.3
4.3
8.7
4.3
13.0
4.3
17.4
4.3
21.7
4.3
26.1
4.3
30.4
4.3
34.8
4.3
39.1
4.3
43.5
4.3
47.8
4.3
52.2
4.3
56.5
4.3
60.9
SPSS Assignment 6
.11544603978801
6
.12060383686062
5
.13003752134769
2
.13617137324474
2
.14689496714795
3
.14760296237609
2
.17031362769732
8
.18081855366024
8
.19293966815457
9
Total
1
4.3
4.3
65.2
1
4.3
4.3
69.6
1
4.3
4.3
73.9
1
4.3
4.3
78.3
1
4.3
4.3
82.6
1
4.3
4.3
87.0
1
4.3
4.3
91.3
1
4.3
4.3
95.7
1
4.3
4.3
100.0
23
100.0
100.0
SPSS Assignment 6
Graph
Regression
Variables Entered/Removeda
Mode Variables
Variables
l
Entered
Removed Method
1
Effective
. Enter
Tax rate,
D/E Ratiob
a. Dependent Variable: Beta
b. All requested variables entered.
Model Summary
SPSS Assignment 6
Mode
l
1
R
Adjusted R Std. Error of
R
Square
Square
the Estimate
a
.451
.203
.123 .207563489
394960
a. Predictors: (Constant), Effective Tax rate, D/E
Ratio
ANOVAa
Sum of
Squares
.220
Mean
Square
.110
Model
df
1
Regressio
2
n
Residual
.862
20
.043
Total
1.081
22
a. Dependent Variable: Beta
b. Predictors: (Constant), Effective Tax rate, D/E Ratio
F
2.548
Sig.
.103b
Coefficientsa
Unstandardized
Coefficients
B
Std. Error
1.231
.100
.156
.089
-1.610
.905
Model
1
(Constant)
D/E Ratio
Effective Tax
rate
a. Dependent Variable: Beta
Standardize
d
Coefficients
Beta
Curve Fit
Model Description
Model Name
Dependent Variable 1
Equation
1
MOD_1
Beta
Linear
.360
-.364
t
12.355
1.757
-1.778
Sig.