Question

Can someone help me out? I need to use Excel for a couple of things but don't know how

Answer 1

We can't help unless you ask :-)

Answer 2

true, ok let me know if you know how to do any of this, something is better than nothing, a box and whiskers plot, and use excel commands (given) to find the:
Mean =AVERAGE(array) (note, MEDIAN is similar)
Median =MEDIAN(array)
Standard Deviation =STDEV(array)
Variance =VAR(array)
Minimum =MIN(array) (note, MAX is similar)
Quartile 1=QUARTILE(array, 1) (note, Q3 is similar)

Answer 3

the way these functions work is that you replace the "array" with the list of numbers you want to compute

ex:

you have the following values: 1, 2, 5, 6, 7

Mean = AVERAGE(array)

Mean = AVERAGE(1, 2, 5, 6, 7)

Mean = ???

type the command " = AVERAGE(1, 2, 5, 6, 7)" into excel without quotes and tell me what you get

Answer 4

ok brb

Answer 5

ok

Answer 6

it said error there's a problem with the data

Answer 7

what did you type in

Answer 8

= AVERAGE1, 2, 5, 6, 7
and also tried
= AVERAGE 1, 2, 5, 6, 7

Answer 9

you need parenthesis around the set of numbers

Answer 10

ohhhhhhh quotes mybad

Answer 11

no quotes

Answer 12

4.2

Answer 13

I just wrote it in quotes to tell you what to type exactly (you don't type in the quotes though)

Answer 14

good

Answer 15

the good news is that you don't have to type in a very long list of numbers for each function

Answer 16

all you have to do is write all your numbers in one row or column (column is better)

then you can apply the function to a whole column or subset of that column

Answer 17

so say your data is in cells A1, A2, ..., A10

you can do it the long way

=AVERAGE(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10)

or better yet, you can use the shortcut

=AVERAGE(A1:A10)

Answer 18

what A1:A10 means is that it's going to use every data value from A1 to A10 (including both endpoints)

Answer 19

Ok, now my question is this, I'm have the information for a histogram, so my A's are like this: 0-50, 50-100, etc. and my B's represent how many there are in each category, so which should I put in the equation line A, B or all the information at once?

Answer 20

so in column A, you have values that range from 0 to 100 (ie test scores it looks it)

and in column B you have your frequencies right?

Answer 21

and you wanted to graph this histogram?

Answer 22

they range from 0 to 600, but are in intervals of 50 and I graphed the histogram, but now need to use these commands on excel to get the information, I know how to do it w/ a calculator, not on excel which is what you're teaching me now :)

Answer 23

i gotcha

Answer 24

well with frequency distributions, it's a bit different, one sec

Answer 25

ok, thanks

Answer 26

what are your class intervals btw (all of them)?

Answer 27

it ranges from 0 to 600 and it goes by 50, so it's

0-50
51-100
101-150
etc etc
all the way up to 600 right?

Answer 28

0-50
50-100
100-150
150-200
200-250
250-300
300-350
350-400
400-450
450-500
500-550
550-600
my teacher wants a histogram where the bars are touching each other...

Answer 29

ok and what are your frequencies for each class interval

Answer 30

in order:
2
30
8
4
0
1
1
1
0
2
1
0

Answer 31

thanks

Answer 32

the note. In order to get statistic function to work you type
1 type
=yourfun(

2. then use mouse to highlight your data. All the cells you want

3. close it with a ) then hit enter