Question 1

What are the three main measures of central tendency in Excel?

Accepted Answer

The three measures of central tendency are mean, median, and mode. In Excel, calculate the mean using the AVERAGE function, the median using the MEDIAN function, and the mode using the MODE.SNGL function. Each function is applied to a selected range of data. The mean represents the arithmetic average, the median is the middle value when data is ordered, and the mode is the most frequently occurring value.

Question 2

How does skewness indicate asymmetry in a dataset?

Accepted Answer

Skewness measures the asymmetry of data distribution around the mean using the Excel SKEW function. Skew values closer to zero indicate more symmetry in the data. Positive skew shows the right tail is longer, while negative skew indicates the left tail is extended. This quantitative measure determines whether data points are concentrated on one side of the distribution.

Question 3

What does positive kurtosis reveal about a distribution?

Accepted Answer

Positive kurtosis, measured using the Excel KURT function, indicates a distribution with a sharper peak and heavier tails compared to a normal distribution. This means fewer values concentrate in the center while more values appear in the tails. Positive kurtosis reveals a leptokurtic distribution with greater extremity in the data.

Question 4

How does negative kurtosis differ from positive kurtosis?

Accepted Answer

Negative kurtosis indicates a flatter peak with lighter tails than a normal distribution, showing more values in the center and fewer in the tails. This platykurtic distribution contrasts with positive kurtosis, which shows a sharper peak and heavier tails. Both are calculated using the Excel KURT function for the selected data range.

Question 5

Why is the median preferred over the mean for skewed data?

Accepted Answer

The median is less affected by outliers and skewed data compared to the mean, which is sensitive to extreme values. When data is asymmetrical with extended tails, the median provides a more representative central value. This makes the median a more robust measure of central tendency for datasets with significant skewness.

Question 6

What do skewness and kurtosis measure together?

Accepted Answer

Skewness and kurtosis are measures of asymmetry that determine the departure from symmetry in a distribution. Skewness quantifies the direction and extent of tail extension, while kurtosis measures the sharpness of the peak and concentration of values in the tails. Together, they provide comprehensive insight into the shape and extremities of data distributions.

Question 7

How can Excel functions help analyze data distribution shape?

Accepted Answer

Excel provides specialized functions to analyze distribution shape: AVERAGE, MEDIAN, and MODE.SNGL for central tendency; SKEW for asymmetry; and KURT for tailedness. These functions enable performing simple data analysis using Excel functions to quantify how data deviates from symmetry and normality, supporting comprehensive statistical assessment.

Microsoft Excel：寻找集中趋势、偏度和峰度

Browse More Videos