Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel and so on (Summary Statistics Using Excel Functions (third quartile,…
Excel and so on
Summary Statistics Using Excel Functions
mean
=Average()
median
=median()
first quartile
=quartile exc(array,1)
(n+1)/4
third quartile
=quartile exc(array,3)
3(n+1)/4
IQR
=third quartile-first quartile
coefficient of variation
=standard deviation/mean
use percentage symbol
Generating Summary Statistics Using Data Analysis ToolPak
click data tab in the navigation bar
choose data analysis
Countifs Function
when needs: two pieces of information that you need to tell Excel
type "=countifs" and open the blacket
back to the database
click the first column that we need to create the criteria range 1
click a ","
type the value which we should count in the first column
click another ","
click the second column that we need to create the criteria range 2
1 more item...
Percentage Distribution
= and click distribution value in the first range
/
the sum value(
we should change this value into absolute form by click F4
)
choose percentage style in the middle of the navigation bar
increase decimal
drag this form to other rows
split the screen
windows key+ ⬅/windows key+➡
construct a Pivot Table
inset
Pivot Table
drag data to row, column and values
value field setting
change sum to count
Percentage of Column Total
value field setting
show values as
percentage of column
How to draw a Pivot Chart
click on the pivot table
analyse tab
pivot chart(on the right hand of the navigation bar )
notice
field button
hide all field buttons
＋ icon
axis titles
avoid using abbreviations
chart title
gridlines
click a gridline (not the head, bottom or middle ones)
click "delete" to hide lines
change the decimal number of the pivot table
increase/ decrease decimal button in the middle of the navigation bar
Drawing Bar Charts - using Excel
choose the range in the table that you need use
adjust scale of the row and column by drag the scale of the table
click the bar in the chat
delete the bar that we need not use
click "select data icon" in the navigation bar
remove the criteria that we need not use
highlight a large range of data
shift+ctrl+⬇
Changing a Chart Type