excel

Question 1

count

Answer 1

(=COUNT)

Question 2

count if a condition is met

Answer 2

(=COUNTIF)

Question 3

mean

Answer 3

(=Average)

Question 4

standard deviation

Answer 4

(STDEV)

Question 5

median

Answer 5

(=MEDIAN)

Question 6

interquartile range

Answer 6

(=QAURTILE)

Question 7

how to see the range in excel

Answer 7

so one cell could be D4 .
another cell can be J14.
when looking at the range look at the top left and then the bottom right.
this will give the range and the its ration would be D4:J14.
The colon represents ration-Through

Question 8

how can you move right and left

Answer 8

use the tab key

Question 9

to move left in excel

Answer 9

press shift and tab

Question 10

to move right in excel

Answer 10

just press tab

Question 11

how to copy content of 1 cell to another- can also be done when a range of cells are selected

Answer 11

Control key + C or could just use the normal copy button

Question 12

how to paste a content of 1 cell to another

Answer 12

control + V

Question 13

how to completely clear the content of a cell

Answer 13

select the cell, or a range of cells can be selected
1. one way it can be done is right click and then clicking clear content
2. second way it can be done is by going on the home tab then editing section and clicking and clear all, or just formats

Question 14

how to undo clearing content

Answer 14

Control+ Z

Question 15

to insert a new column

Answer 15

for example if its needed above number 1 then right click on number 1 and click insert

Question 16

how to insert a new blank column

Answer 16

just click on the top row for example on letter A and insert it there

Question 17

how to ensure all the text fits into its column

Answer 17

press in the middle of the column letters to lengthen the width.
To do it quicker select all columns and double click between the letters.

Question 18

how to update figures in a whole column

Answer 18

use find + replace, going to the home tab in the editing group click on the magnifying glass click on the arrow on it, click on find and replace and enter the figures
-control + H can also be used

Question 19

how to move content of the cell to another column

Answer 19

select the cell then then using the edges of the cell drag it along

Question 20

how to multiply

Answer 20

c2*d2 and press enter
the asterisk represents multiplication symbol
-or more than 2 is =PRODUCT(c3:e7)

Question 21

how to copy the formula

Answer 21

use the autofill handle and double click

Question 22

referece formula

Answer 22

E2*G5

Question 23

Absolute formula

Answer 23

E5*$4G$5 - the dollar signs help refer to a separate new column that has been recently added to then apply the same formula to other numbers in the same column

Question 24

how to divide

Answer 24

/

Question 25

how allow certain data in columns

Answer 25

1. select the column
   2.go on data tab
   3.click on data validation

Question 26

distributional shape

Answer 26

pattern of subject responses across range of possible values

Question 27

statistic

Answer 27

fact or piece of data obtained from a study of a large quantity of numerical data

Question 28

mean

Answer 28

add all values and divide by total numbers of values you have

Question 29

what does excel use for mean

Answer 29

(AVERAGE(A1:B2)

Question 30

Standard deviation

Answer 30

STDEV(A1:A7

Question 31

median

Answer 31

put values in size order from smallest to largest and the one in the middle will be the median

Question 32

what does excel use for median

Answer 32

MEDIAN(A1:B2)

Question 33

inter-quartile range (IQR)

Answer 33

range from the lower quartile (LQ) value (also known as the 25th percentile) and the upper quartile (UQ) value (also known as the 75th percentile)

Question 34

if there is continuous(normally distributed), what summary statistic is needed?

Answer 34

mean and standard deviation(SD)

Question 35

continuous(skewed) discrete, what summary statistic is needed?

Answer 35

median and inter-quartile range(IQR)

Question 36

binary, what summary statistic is needed?

Answer 36

N and % yes

Question 37

ordinal, what summary statistic is needed?

Answer 37

N and % in each group/giving each response option

Question 38

what is the standard deviation and inter-quartile range measures of?

Answer 38

Measures of spread or how far values could be from the middle area