Continuous Descriptive Statistics using Excel

How to use Excel to calculate continuous descriptive statistics. Continuous descriptive statistics such as means and standard deviations are utilized for summarizing the characteristics of a sample on a continuous variable. This video demonstrates what type of variables are relevant for summarizing continuous data using a dataset derived from a survey instrument. The survey instrument is presented showing the items measuring the variables for the test. The dataset is shown within Excel being used for the procedure. The formulas for the procedures are demonstrated. The output for the procedures are described. Chapters: 0:06 Statistical test purpose, name and description 0:16 Variable types and number 0:32 Survey instrument description for variable measurement and sample items 0:51 Dataset open in Excel program 1:05 Creating a sorted data worksheet 2:12 Creating a table for frequency counts, means, and standard deviations 2:28 Entering formulas for counting frequencies in the data: =COUNTIF 4:21 Entering formula for calculating the total of measured frequencies: =SUM 4:55 Entering formulas for calculating means: =AVERAGE 6:01 Entering formulas for calculating standard deviations: =STDEV 6:24 Where to find sample output and formulas For more information, visit: https://www.stat-tree.com/