having trouble understanding what to do. can someone help please I have Excel it's not working
The given data can be further analyzed as per below table
Hence the cumulative frequency distribution can be sketched as per below
The ogive is also the same plot, except that the y-values are scaled from 0 to 100, 100 being achieved at the maximum frequency value viz. 35. So it looks like below
The median can be calculated by finding the value at which the ogive is crossing the value of 50. Clearly, that value is in the range $28,000 – 29,000.
However, to get the more accurate value, we can go back to the table baove and extrapolate the values to find the precise value at which the cumulative relative frequency should be 0.5. This value comes to be
That is, the median is approximately $28,722
having trouble understanding what to do. can someone help please I have Excel it's not working...
6. The starting annual salaries for a sample of 35 liberal arts graduates Note: you could answer this question using excel or by hand. Your choice Starting Salary ($thousands) Relative Frequency Frequency 0.086 0.086 0.143 0.257 0.257 0.114 0.029 0.029 25 - (26) 26 - (27) 27 - (28) 28 - (29) 29 - (30) 30 - (31) 31 - (32) 32 - (33) 4 Construct the cumulative frequency distribution b.Construct the cumulative relative frequency distribution Plot the ogive Using...