Log in

View Full Version : Statistics/excel


Skanusis
Nov 17, 2011, 07:36 AM
Hello , I am struggling with few tasks in excel/maths , hope u can help me .I have several question and Im not quite sure I'm doing it the right way.

There is given this data:
Wage of employee(£) frequency
120 to less than 125 10
125 to less than 150 38
150 to less than 200 24
200 to less than 250 18
250 to less than 350 7
350 to less than 450 3


And the questions are :

1)If a frequency polygon were to be plotted for the above table, what point(s) would be used on the x-axis to represent the 250 to less than 350 group?
a)250 to 350
b)300
c)250
d)350
2)From the options below, which would be the most appropriate graph type to display the data in the table?
a pie chart
a bar chart
a line graph
a histogram

3)Calculate the frequency density of the 200 to less than 250 group
4) If a cumulative frequency curve (ogive) were to be plotted of the above data, what point(s) would be used on the x-axis to represent the 250 to less than 350 group?
250 to 350
300
250
350
5)What is the modal group of wages in the firm?
120 to <125
125 to <150
150 to <200
200 to <250
250 to <350
350 to <450
6)Calculate the mean wage for data in above table, to the nearest whole number.
7)From the table above estimate the wage located at the lower quartile and indicate from the options below the answer closest to your own:
£125
£135
£145
£155
8) Which of these measures would best be used to describe the data?
mode
median
mean
range
9)
In the table above in which group would the median value be located?
£120 to less than £125
£125 to less than £150
£150 to less than £200
£200 to less than £250
£250 to less than £300
£300 to less than £400
10)Calculate the standard deviation for the sample data presented in the table above. Give your answer to two decimal places

Unknown008
Nov 17, 2011, 12:10 PM
What is your attempt? Please, do show us what you tried. The first question itself is based on theory which you should know if you did the chapter in class.

Skanusis
Nov 17, 2011, 03:08 PM
Lower Li Uper Li Frequency Midpoint(x) Fx Class Width Frequency Density Cumulative Frequency
120 125 10 122.5 1225 5 2.0 10
125 150 38 137.5 5225 25 1.5 48
150 200 24 175 4200 50 0.5 72
200 250 18 225 4050 50 0.4 90
250 350 7 300 2100 100 0.1 97
350 450 3 400 1200 100 0.0 100
100 18000


mean £180.00
modal Class 120-125
median 50.5


This is what I done so far

Skanusis
Nov 17, 2011, 03:10 PM
Lower Li Uper Li Frequency Midpoint(x) Fx Class Width Frequency Density Cumulative Frequency
120 125 10 122.5 1225 5 2.0 10
125 150 38 137.5 5225 25 1.5 48
150 200 24 175 4200 50 0.5 72
200 250 18 225 4050 50 0.4 90
250 350 7 300 2100 100 0.1 97
350 450 3 400 1200 100 0.0 100
100 18000




I don't know how to copy it the right way..


mean £180.00
modal Class 120-125
median 50.5

Unknown008
Nov 18, 2011, 10:52 AM
You are still not answering the first question, though you're putting a lot of information :rolleyes:

Skanusis
Nov 19, 2011, 05:04 AM
The answer to the first question is b)300 ,because it's the midpoint..

Unknown008
Nov 19, 2011, 05:26 AM
Okay, and the second?

Skanusis
Nov 19, 2011, 06:14 AM
2) histogram 3) 0,4... ah your no help at all :)

Unknown008
Nov 19, 2011, 06:32 AM
Well, you posted those questions without specifying anything, so my guess was that you have a problem with the whole number... :rolleyes:

2) Right
3) 0.4, okay, but to be more precise, 0.36

If you have a specific problem, do say so. Otherwise, I'll be waiting for what you get for the remaining parts.

stiffy93
Nov 13, 2012, 11:39 AM
What's the answer to the other questions guys?

Thanks!