Official ECMT 1010 thread. (1 Viewer)

Joined
Jan 24, 2004
Messages
2,907
Location
northern beaches
Gender
Male
HSC
2004
absolution* said:
descriptive statistics are measures of central tendency and variation. inferential statistics are comments which can be inferred from descriptive statistics and other information which is provided with data.

therefore all you have to do is claculate the mean, median, mode, range, inter-quartile range, stdev, variance etc. when it asks for descriptive stats.

im an idiot, so if im wrong let me know.
oh oh OMG <3
but how do i use excel to show mean, median..etc?
my tutor was going too fast in the workshop and didnt understand a thing :( :mad:
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
i have excel 2000 though id assume itd be similar on all platforms..

go to the top where theres a sigma sign

click the down arrow next to it

then click "more functions" if the ones listed arent the ones you need

then youll find them

mean = average
median = median
standard deviation = stdev

etctectec. youll get the hang of it.
 

NoShadowKick

New Member
Joined
Mar 30, 2005
Messages
7
Gender
Undisclosed
HSC
N/A
adding onto that, choose the statistical data category that provides the most functions i reckon.
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
what are you guys talking about?


and btw, i have a link for phSTAT download if anyone is too tight to buy the text. (ie. moi)
 

stazi

Nightman
Joined
Feb 23, 2003
Messages
14,093
Location
Sydney
Gender
Male
HSC
2004
click tools - data analysis. And theres a descriptive stats option
 

QuaCk

Member
Joined
Apr 29, 2004
Messages
126
Someone has asked this before in this thread but no one seems to have answered it.

for 1d, it says print 2 historgrams with different bin widths
do we make them ourselves in excel? or do we just screenshot the java applet?

i've got no idea how to make it in excel :S
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
i screenshotted them. i have no idea how to do it in excel either. it doesnt say to do it in excel so it shouldnt be a problem
 

sarevok

Member
Joined
Dec 17, 2004
Messages
853
Gender
Undisclosed
HSC
2004
This is the response I got from my tutor:

"Q1(d): they are assuming that you have already experimented on the Java
applet (See the text under "Histogram Demonstration") - now you are expected
to translate this into Excel, and picking out two sets of bin widths that
you think will produce the best histograms of the data, and why they were
the "best"."

But the question is pretty ambiguous so they can't really do anything if you just take a screenshot instead of using Excel. I don't know how much stock to place in what she said anwyay as she obviously misread the question.
 

QuaCk

Member
Joined
Apr 29, 2004
Messages
126
or you can just find min and max first


minimum = min(startCell:endCell)
maximum = max(startCell:endCell)
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top