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

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.

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

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

You are still not answering the first question, though you're putting a lot of information :rolleyes:

The answer to the first question is b)300 ,because it's the midpoint..

Okay, and the second?

2) histogram 3) 0,4... ah your no help at all :)

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.

What's the answer to the other questions guys?

Thanks!