Practice Exercise

Click here to download the excel file.

Basic Statistics using Excel

See the following web page for more help: http://phoenix.phys.clemson.edu/tutorials/excel/stats.html

Measures of Individual Quantitites:

• Functions applicable: FREQUENCY [gives cumulative frequency]

Measures of Central Tendency: [selected_array refers to the cells you select in Excel sheet]

• Median: MEDIAN(selected_array) function

• Mean: AVERAGE (selected_array) function

• Mode: MODE (selected_array) function

Measures of Dispersion:

• Range: Use MIN(selected_array) function for minimum value; MAX(selected_array) function for maximum value

• Standard Deviation: STDEV (selected_array) function

Are you bold enough to try the regression? This is Bivariate analysis. Try to see if Murder rate is linked to Per Capita Income using the following: [Not a part of 2nd test]

Regression Equation: [Equation: Y=a+bX] Y=Dependent variable; X=Independent variable

• Slope [b value in equation]: SLOPE (Known_Ys, Known_Xs) function

• Intercept [a value in equation]: INTERCEPT (Known_Ys, Known_Xs) function

• Person's R: PEARSON (Independent variables, Dependent variables)

• R-square: RSQ(Known_Ys, Known_Xs)