Bivariate Analysis [Analysis of relationships between two variables]

Statistical Testing of relationships between two variables

• Chi square: Test that a joint distribution (e.g. frequency) between two variables has random (i.e. NO) relationship

• Student's T-test: Test that two variables have different means

Inferential Statistics

Regression Analysis: Test relationship between two interval variables

Equation of the form Y = b + mX, where

• Y= predicted value of Dependent variable

• X= value of Independent variable

• b = constant [INTERCEPT value]

• m = slope [regression coefficient]

• R-square = Percentage of variation in the dependent variable that is explained by the independent variable [R=correlation coefficient]

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 upto]

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

Regression Equation: [Equation: Y=b+mX] Y=Dependent variable; X=Independent variable

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

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

• Correlation coefficient (R): PEARSON (Independent variables, Dependent variables)

• R-square: RSQ(Known_Ys, Known_Xs)

You can also get all the Descriptive Statistics by selecting "Descriptive Statistics" which can be found in "Data Analysis" under the "Tools" menu [if you do not find the "Data Analysis", click "Add-Ins" under "Tools" menu, and then click on  "Analysis Toolpack" to turn on the Data Analysis toolpack].