Question

Using Excel, calculate the mean, standard deviation, standard error, median, sample variance, kurtosis, skewness, range, minimum, maximum, sum, count, largest(1), smaller(1)

of your distribution and interpret their meanings.

Column

Mean

Standard error

Median

Mode

Standard Deviation

Sample variance

Kurtosis

Skewness

Range

Minimum

Maximum

Sum

Count

Largest(1)

Smallest(1)

Answer 1

Columni 21.26315789 1.928308815 22 8.405303255 70.64912281 0.997013006 0.382976808 Meani Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Largest(1) Smallest(1) Confidence Level(95.0%) 404 Noooooo 4.051226483 Sheet1 Sheet2 Sheet3
ji
Page No.: Date: 2 meani- mean is a sum of observation divided by number of observation standard enor: The standard error is a statistical tem that measures the accuracy with which a sample distribution represents a populations by standard using sto deviation. SE = So I sample site Medians - Median is the value of middle most abservation in the dates when the observation are arranged in increasing for decreasing order of their valuud Mode' frequency is called The or a observation with maximum the most repeated observation mode. standard deviation measure variability or dispersion for of data from mean. the amount of subject set sample variance: - The variance mathematically defined as the of the squared difference from mean. I CX-532 is average the

Pago No UVA YOU vustosis - It is the property of a which expresses its relative peakedness. distribution skewness skewness is a measure the asymmetry of of the probability distribation of real- valued random variable about it. mean skewn est value can be positive, . or negative, or andefted undefined. og Range : - Range is a crude measure of dispersion IF Lis the largest abservation and sis the smallest observation then range is the difference between L and S , this - Range = t-s 18 Minimum " Maximum SUM! - mimmum value or observation in dataset max.value or observation in - dataset Total (2 ] just mean to add up" - Total addition in dataset. number of observation. - largest observation or value in data set :- smallest observation or value in B counti- Larget u) Amallest i data set.