EXCEL STATISTICAL ANALYSIS

EXCEL

STATISTICAL Functions

Average vs. Weighted Average

Average

Weighted

Average

Average Price

Sum of Prices / Count of Prices

Transaction

Date

5/7/2007

6/7/2007

7/6/2007

8/9/2007

Total:

Average Price:

Item

Coffee

Coffee

Coffee

Coffee

Price Per

Unit

$ 20

$ 25

$ 35

$ 30

20+25+35+30 = 110

110 / 4

= 27.50

Units

Sold

500

750

200

300

Weighted Average Price

¡Æ(Price per Unit * Units Sold) /¡Æ Units Sold

Date

Item

5/7/2007

6/7/2007

7/6/2007

8/9/2007

Coffee

Coffee

Coffee

Coffee

Price Per

Unit

$ 20 X

$ 25 X

$ 35 X

$ 30 X

+

Units

Sold

500

750

200

300

= 10,000

= 18,750

= 7,000

=

9,000

+

44,750

500+750+200+300 = 1,750

Weighted Average Price:

44,750 / 1,750 = $25.57

Weighted Average Exercise

¡°Weighted_Avg¡± sheet

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download