Official ECMT 1010 thread. (2 Viewers)

[absolution*]

umm i get an error when i try to do a geo mean with the salary stats.. is that the msg?

YESYESYESYEYSYEEYWYS

 

[ToO LaZy ^*]

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

 

[absolution*]

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]

adding onto that, choose the statistical data category that provides the most functions i reckon.

 

[sarevok]

zzzzzzzzzzzz

 

[NoShadowKick]

yeah i got that too. is that rite??

 

[sarevok]

zzzzzzzzzzzzzz

 

[absolution*]

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]

click tools - data analysis. And theres a descriptive stats option

 

[spin spin sugar]

how smart is absolution *swoon*

 

[stazi]

absolution's about 17 smart

 

[ToO LaZy ^*]

^ uberly smart *

btw..for Q2 b)..what does (*) indicate?

EDIT: does it mean to multiply?

 

[QuaCk]

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*]

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]

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.

 

[Australian_Idol]

How do you find the range? I have no idea which one is the range in the list of functions.

 

[NoShadowKick]

u use the order icon and the you minus biggest and smallest.

 

[Australian_Idol]

Where's the order icon?

 

[QuaCk]

or you can just find min and max first


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

 

[ToO LaZy ^*]

tools-->data analysis---> descriptive statistics