.
.
Math Central - mathcentral.uregina.ca
Quandaries & Queries
Q & Q
. .
topic card  

Topic:

grouped data

list of
topics
. .
start over

2 items are filed under this topic.
 
Page
1/1
Statistics from grouped data 2003-10-09
From Rebecca:

I have to use a suitable computer package (ie. Excel) to work out the mean and standard deviation of the following:

 Price Range            No of Houses        No of Houses 
£`000                  Area 1              Area 2   

45 and under 50         4                   5 
50 and under 55        7                   12 
55 and under 60        14                  16 
60 and under 70        19                  18 
70 and under 80        8                   3 
80 and under 100       5                   2 

I have used excel to work out mean and standard deviation before, but not in a more complicated example like this.

Any advice on where to start would be greatly appreciated.


Answered by Penny Nom.
Variance 2002-10-29
From Ade:
I am trying to solve a standard deviation question, I have 30 data points to use, should I group the data before solving for variance or should I just use the raw data.
Answered by Andrei Volodin.
 
Page
1/1

 

 


Math Central is supported by the University of Regina and the Imperial Oil Foundation.

CMS
.
* Registered trade mark of Imperial Oil Limited. Used under license.

 

Home Resource Room Home Resource Room Quandaries and Queries Mathematics with a Human Face About Math Central Problem of the Month Math Beyond School Outreach Activities Teacher's Bulletin Board Canadian Mathematical Society University of Regina Imperial Oil Foundation