Descriptive Statistics Practical

W3.CSS

Descriptive Statistics

Note: Practicals can be done in MS-Excel or any Spreadsheet

Topics for practical
1. Introduction to Excel Understanding Data Tools UnderstandingFormula Tools,insert functional library using insert function Add-Ins Analysis Toolpacks
2. Using Formulae and Charts Formulawriting,Functions,usingCellreference Understanding InsertTool:ChartTools,Different typesofchartsandtheiruse
3. DataEntry and manipulation Tools for data entry and accuracy:Quick Access Toolbar customization, Formtool. Data Transposition to Fit Excel(as an Array) Data Conversion with the Logical IF, VLOOKUP, HLOOKUP.Pivottable, Pivotchart. Data Conversion of Text from Non–ExcelSources, UsingText To Column(From Data tool) Data Queries with Sort, Filter,and Advanced Filter Exactfunction dataentry comparison
4. Data Validation Specifying a valid range of values for a cell Specifying a list of valid values for a cell Specifying custom validations based on formula for a cell
5. Measures of central tendency Calculating Mean, Median,Mode, Minimum, Maximum, range with cell reference Using Summary statistics Calculate A.M., G.M., H.M. State the Findings of all above exercise
6. Measuresof Dispersion, Skewness & Kurtosis Calculate Range, QuartileDeviation, Meanabsolutedeviation, Standard deviation with cell reference Using summary statistics Measures of Skewness Coefficient of skewness based on moments.Measureof Kurtosis. Graphicalrepresentation of Skewness. State the Finding of exercise
7. Graphical Presentation with Excel -1 Producing a Histogram Improving the Graph Producing a Cumulative Frequency Diagram Producing a Histogram of subgroups of data
8. Graphical Presentation with Excel–2 Producingabar chartof subgroupsofdata Peratochart Combined variance(derivation for 2groups),Combined standard deviation. Coefficientofvariation(C.V.)
9. Correlation Use of formula for calculating correlation and Co-variance. Use of error checking (UsingExact(),IF) Use of frequently used financial functions(e.g.NPV) with suitable example of correlation State the Findings of all above exercise.
10. Regression analysis Using Summary statistics/Crosssectional Data:Descriptive Statistic Linear Regression and visual analysis(Chart) Multiple Regression equation with coefficient standard error and visual chart State the Findings of all above exercise.