Summary Statistics, the correct use of sumproduct?

$Go Back$		Math Help Forum > Pre-University Math Help > Basic Statistics and Probability
$Reload this Page$ Summary Statistics, the correct use of sumproduct?

$Reply$

Thread Tools

Display Modes

$Old$ November 5th, 2009, 11:11 AM

allyourbass2212 $allyourbass2212 is offline$

Member

Join Date: May 2008

Posts: 123

Country:

Thanks: 77

Thanked 0 Times in 0 Posts

$allyourbass2212 is on a distinguished road$

$Default$ Summary Statistics, the correct use of sumproduct?

Lets use the following scenario

Subdivision Name Price Total Units
Estates 168k 98
Villas not listed 16

Lets say I only wanted to know the sumproduct of those subdivisions with a price range listed.

Would the correct calculation here be

1. (168*98)/98 = 168k

or
2. (168*98)+(0*16)/114
-the 114 denominator here is 98 + 16 total units. In other words INCLUDING a subdivision wit no price

$Reply With Quote$

$Reply$

« Am I doing this correctly? - Z test | Top | What is the difference between Selections and Arrangements/Permutaions? »

Thread Tools
$Show Printable Version$ Show Printable Version $Email this Page$ Email this Page
Display Modes
$Linear Mode$ Linear Mode $Hybrid Mode$ Switch to Hybrid Mode $Threaded Mode$ Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off

Forum Jump

All times are GMT -7. The time now is 08:47 AM.

Math Help Forum is a community of maths forums with an emphasis on maths help in all levels of mathematics.
Register to post your math questions or just hang out and try some of our math games or visit the arcade.