logo

Measures of Central Tendency and How to Use Excel Summary 2022

   

Added on  2022-09-12

6 Pages975 Words21 ViewsType: 21
 | 
 | 
 | 
1
Measures of Central Tendency and How to Use Excel
Student’s Name
Institution Affiliation
Measures of Central Tendency and How to Use Excel Summary 2022_1

2
Measures of Central Tendency and How to use Excel
The measures of central tendency include the mean, mode, median. These measurements
help in explaining more characteristics about a particular data set. The means is computed by
adding up all the observed values and diving the total amounts by the total number of
observations. Mode represents the number that appears with a higher frequency amongst all the
observed values. The median is the boundary between the upper and the lower set of the data
(Dretzke, 2013).
In excel, the measures of central tendency are calculated by utilizing the data analysis
tool Pak and then selecting the descriptive statistics options. With reference to factor data with
three groups. The procedure of analyzing the data in excel entails following the procedure below.
After the data is manually keyed -in excel, the analysis is conducted by clicking on the
data analysis tab. A pop-up widow appears as shown below.
After clicking okay, one is prompted to input the range of the data as shown in the pop-up
window.
Measures of Central Tendency and How to Use Excel Summary 2022_2

3
A selection of “Labels int first row” allows the inclusion of data headers in the analysis. The
summary statistics allows for calculation of descriptive statistic and after clicking okay the
results in the table below was generated.
Factor 1 Factor2 Factor3
Mean
85.8571
Mean
82.1429
Mean
85.1429
Median
86.0000
Median
82.0000
Median
82.0000
Mode
86.0000
Mode
77.0000
Mode
79.0000
Standard
Deviation 4.0178
Standard
Deviation 4.9809
Standard
Deviation 8.5133
Sample
Variance 16.1429
Sample
Variance 24.8095
Sample
Variance 72.4762
Kurtosis
2.1863
Kurtosis
(0.9533)
Kurtosis
(1.4694)
Skewness
(1.3652)
Skewness
0.5611
Skewness
0.4200
Range
12.0000
Range
13.0000
Range
23.0000
Minimum
78.0000
Minimum
77.0000
Minimum
75.0000
Maximum
90.0000
Maximum
90.0000
Maximum
98.0000
Sum
601.0000
Sum
575.0000
Sum
596.0000
Count
7.0000
Count
7.0000
Count
7.0000
Measures of Central Tendency and How to Use Excel Summary 2022_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Crime rate descriptive statistics Methodology
|3
|370
|100

Neural Differentiation of iPSCs: Summary Statistics, ANOVA and T-Test Results
|8
|1259
|484

Statistics for Business Phuc Thang Nguyen
|7
|1646
|371

Data Analysis Assignment Solved - DOC
|11
|1748
|253

Descriptive Statistics Summa: Chart of Domestic Boarding in a Recent Year (Top 7 Airlines in the USA) Bar Graph
|7
|1111
|69

Report on Statistical Analysis of Asian and French Cuisine Dataset
|11
|1993
|190