EXCEL STATISTICAL ANALYSIS
[Pages:134]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
Item
Coffee Coffee Coffee Coffee
Price Per Unit $ 20 $ 25 $ 35 $ 30
Units Sold 500 750 200 300
Total:
20+25+35+30 = 110
Average Price: 110 / 4 = 27.50
Weighted Average Price
(Price per Unit * Units Sold) / Units Sold
Date
5/7/2007 6/7/2007 7/6/2007 8/9/2007
Item
Coffee Coffee Coffee Coffee
Price Per Units Unit Sold
$ 20 X 500 $ 25 X 750 $ 35 X 200 $ 30 X 300
+
500+750+200+300 = 1,750
= 10,000 = 18,750 = 7,000 = 9,000
+ 44,750
Weighted Average Price: 44,750 / 1,750 = $25.57
Weighted Average Exercise
"Weighted_Avg" sheet
Weighted Average Solutions
"Weighted_Avg" sheet
Wt. Avg. with SumProduct() Exercise
"Weighted_Avg_SumProduct" sheet
=SumProduct(Array1,Array2)
Multiplies corresponding numbers in two or more different ranges together then sums them.
Date
5/7/2007 6/7/2007 7/6/2007 8/9/2007
Item
Coffee Coffee Coffee Coffee
Price Per Unit $ 20 $ 25 $ 35 $ 30
Units Sold 500 750 200 300
Array 1 Array 2
20*500 = 10,000 25*750 = 18,750 35*200 = 7,000 30*300 = 9,000
44,750
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- dwq guidance for calculation of 80 percentile storm event
- a simple but accurate excel user defined function to
- quartile deciles and percentiles
- common compensation terms formulas
- how to calculate percentiles in microsoft excel google
- excel statistical analysis
- calculating ranks and percentiles using excel formula and
- z score practice worksheet
- microsoft excel dataanalysis
- excel basics university of washington
Related searches
- statistical analysis tests
- examples of statistical analysis reports
- which statistical analysis to use
- what statistical analysis should i use
- statistical analysis test types
- types of statistical analysis pdf
- statistical analysis system sas institute
- inferential statistical analysis example
- what statistical analysis to use
- statistical analysis calculator
- statistical analysis examples
- statistical analysis examples in research