0
   

Excel,cumulative frequency,grouped data, midpoint,median

 
 
Reply Thu 17 Nov, 2011 08:31 am
Hello , i am struggling with few tasks in excel/statistics , hope u can help me .I have several question and Im not quite sure im 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



  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 2,183 • Replies: 1
No top replies

 
jespah
 
  1  
Reply Thu 17 Nov, 2011 09:41 am
@skanusis,
Good Lord, this is a lotta stuff.

About the only thing I can tell you is that this is progressive data, e. g. you're moving from one range to another. Try to visualize what that should look like. At the absolute minimum, you should be coming up with something that isn't a pie chart (which is used for fractional data), see question #2.
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » Excel,cumulative frequency,grouped data, midpoint,median
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.04 seconds on 05/06/2024 at 08:27:38