Official ECMT 1010 thread. (2 Viewers)

stazi

Nightman
Joined
Feb 23, 2003
Messages
14,093
Location
Sydney
Gender
Male
HSC
2004
absolution* said:
hah, such a stupid question...

what did you guys say for 2 f)

i said there is little symmetry but im having trouble getting my graphs to accurately show that..
How do they show symmetry? This is symetry:

-------------||||-------------

its equal on all sides the graphs are different. The mean, mode etc arent equal either.

-----------------------------------------------------------------------------

Big question!!:
WHAT THE HELL IS WITH THIS QUADRANTS CRAP!
The formula in the lecture notes is
Q1=1(n+1)
--------
4

So, how come when you work it out manually, you get a different answer from excel?

i.e. 1(20+1)
---------- = 5.25
4

So, this would mean the 5.25th term in the sequency is the value for Q1.

So, I gather to work out Q1 and the 5.25th term, we have to do the following:
(6th term - 5th term)
---------------------------- = x
4

then we add x to the 10th term.

So, in the case of the question we do the following:
(0.97-0.93)
-------------- = .04/4 = 0.01
4

Then we add x to the .93 term = 0.94

Yet in excel the answer is the following when i type in the formula:
=QUARTILE(A1:A20),1
The answer here is:
0.96

AHHHHHH! WHERE DOES THE 0.96 come from????
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
1Time4thePpl said:
Big question!!:
WHAT THE HELL IS WITH THIS QUADRANTS CRAP!
The formula in the lecture notes is
Q1=1(n+1)
--------
4

So, how come when you work it out manually, you get a different answer from excel?

i.e. 1(20+1)
---------- = 5.25
4

So, this would mean the 5.25th term in the sequency is the value for Q1.

So, I gather to work out Q1 and the 5.25th term, we have to do the following:
(6th term - 5th term)
---------------------------- = x
4

then we add x to the 10th term.

So, in the case of the question we do the following:
(0.97-0.93)
-------------- = .04/4 = 0.01
4

Then we add x to the .93 term = 0.94

Yet in excel the answer is the following when i type in the formula:
=QUARTILE(A1:A20),1
The answer here is:
0.96

AHHHHHH! WHERE DOES THE 0.96 come from????
Which question are you referring to?
 

stazi

Nightman
Joined
Feb 23, 2003
Messages
14,093
Location
Sydney
Gender
Male
HSC
2004
2f)
The histograms for age and salary are not symetrical. The bulk of the data falls into the 300-400 bin, with the rest of the data being unevenly distributed.
 

stazi

Nightman
Joined
Feb 23, 2003
Messages
14,093
Location
Sydney
Gender
Male
HSC
2004
absolution* said:
Which question are you referring to?
Question 4: We have to work out the quadrant 1 and 2 for each call center. I'm using the first one I think.
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
dude dude dude..


im pretty sure you just have arrange in ascending order

then find the number in between the 5th and 6th (for 1st quad)

and between 15th and 16th for 3rd quad


Central Office One –
First quartile 0.95
Third Quartile 3.515
Central Office Two –
First Quartile 0.6
Third Quartile 3.525
 

stazi

Nightman
Joined
Feb 23, 2003
Messages
14,093
Location
Sydney
Gender
Male
HSC
2004
But for some reason the excel quadrant formula is getting: 0.96 for the first quartile in office 1
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
oh shit

no wait..

it would be

6th number - 5th number

divided by 4

+ 5th number


to find the 25% number
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
1Time4thePpl said:
But for some reason the excel quadrant formula is getting: 0.96 for the first quartile in office 1
how does the quadrant eqn work in excel? i cant seem to work it?
 

stazi

Nightman
Joined
Feb 23, 2003
Messages
14,093
Location
Sydney
Gender
Male
HSC
2004
Click on the equations button underneath the toolbar. Click statistics. Quadrant. Then enter what you need to :)
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
1Time4thePpl said:
Click on the equations button underneath the toolbar. Click statistics. Quadrant. Then enter what you need to :)
what do i enter!?!?!
 

stazi

Nightman
Joined
Feb 23, 2003
Messages
14,093
Location
Sydney
Gender
Male
HSC
2004
ahhhh so how come the figures from working it out manually differ from the excel ones?
 

Airazer

New Member
Joined
Mar 28, 2005
Messages
22
Gender
Undisclosed
HSC
2010
can i ask how long are your completed sections? do we hafto do a line space in between every content line? e.g

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
 

Airazer

New Member
Joined
Mar 28, 2005
Messages
22
Gender
Undisclosed
HSC
2010
Umm foir the PHstat stuff u gotta enable the macros security to moderate and change a few things/.. read the the readme.. but i'm sure i'm just repeating someone here.. lol.
 
Joined
Jan 24, 2004
Messages
2,907
Location
northern beaches
Gender
Male
HSC
2004
Q2
a)....i'm not getting any messages from Excel?..what am i doing wrong?

i highlighted the salary column (figures only) and clicked phstat --> descrp. stats---> box&whisk, dot..everything
 

sarevok

Member
Joined
Dec 17, 2004
Messages
853
Gender
Undisclosed
HSC
2004
why are you trying to make a box and whisker plot for question 2?

for 1d) has any one figured out what we're meant to do with the histograms yet? like, use the java applet or use excel? i emailed my tutor but she hasn't replied. thx...
 

NoShadowKick

New Member
Joined
Mar 30, 2005
Messages
7
Gender
Undisclosed
HSC
N/A
umm i get an error when i try to do a geo mean with the salary stats.. is that the msg?
 

absolution*

ymyum
Joined
Sep 27, 2003
Messages
3,474
Gender
Male
HSC
2004
ToO LaZy ^* said:
ok..now i'm REALLY lost
what am i suppose to do for Q2 a)....how do i produce descriptive statistics?

if anyone could help us out, it would be much appreciated :) :) <3 <3 <3 <3 <3 <3
msn: abc123.byoung@gmail.com
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.
 

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

Top