Data tables

xlorixlullabyx

New member
Joined
Jan 9, 2019
Messages
1
using a tabular method to find out complete the cumulative frequencies , mean and standard deviation

how would I do this










Expenditures (£)
Frequency
Under 40033
400 and under 60027
600 and under 80018
800 and under 100011
1000 and under 12008
1200 and under 14002
1400 and under 16003
1600 and under 18002
1800 and over1
Total:105

 
using a tabular method to find out complete the cumulative frequencies , mean and standard deviation

how would I do this

Expenditures (£)

Frequency
Under 40033
400 and under 60027
600 and under 80018
800 and under 100011
1000 and under 12008
1200 and under 14002
1400 and under 16003
1600 and under 18002
1800 and over1
Total:105


Presumably you have been shown a particular way to fill out this table; it would be best to follow that example. I can tell you what I would do ...

First, they want cumulative frequencies; so make a third column and put 33 in the first row, 33+27 = 60 in the second, and so on.

Then they want the mean. For this you'll need a specific number to associate with each class, for which we typically use the midpoint. So make a fourth column (I'd have put it second) containing (0+400)/2 = 200 in the first line, and so on. Call this x. Then make a fifth column in which you put the frequency times the value for each row (fx), and add them up.

And so on. As I said, you have presumably been taught this, so I shouldn't have to teach the whole thing again; that's not what we're here for. What we want on this site is to see what you have tried and where you are stuck, so we can help you where you need it. (See our submission guidelines.)

When it comes to standard deviation, there are several different formulas that can be used, so I'd definitely want to see which you are learning before showing you anything.
 
Top