Histogram and Frequency

Original data

MDFAMINC: Median Family Income

LOWINCPT: Percent households with Money Income less than $15,000

Computing mean, skew and SD (Standard Deviation)

(Use of Excel Past Function (fx))

Mean= AVERAGE (each column of original data)

Skew= SKEW (each column of original data)

SD= STDEV (each column of original data)

Sorting function

Descending: high to low (to sort the highest number, the end of alphabet, or the latest data first in the sorted list)

Ascending: low to high (to sort the lowest number, the beginning of the alphabet, or the earliest data first in the sorted list)

Result of descending sorting of MDFAMINC data

Data analysis tool of histogram

(1) Setting bin range

(2) Click “tools” and click “Add-Ins”

(3) Click Data-Analysis

(4) Click “Histogram”

(5)

Histogram

Input

Input range: original data set

Bin range: setting bin range you make

Label 

(6) Result

(7) Making clustered column through Excel graph function (Chart Wizard)

Regression analysis (BASIC)

ANOVA results

Monitoring statistical relationship between LOWINCPT and MDFAMINC

Significant F is 0.000014 (= p-value) < 0.05 significant level, therefore there is a relationship between LOWINCPT and MDFAMINC.

Liner regression model

Y= LOWINCPT

Y= f (MDFAMINC): How much LOWINCPT changes according to 1 unit change of MDFAMINC