2.Variable Definitions & Descriptive Statistics

As a professional it is likely that you will be asked to conduct analyzes and present your findings in a report to stakeholders such as company directors and executive board members. This assignment will prepare you for that capacity.

You will analyze a secondary data set and work on this project while applying the techniques you learn in class. Secondary data, as opposed to primary data, refers to data that has already been collected by others. This could be internal organizational records, public government data, market data, and surveys. The instructor has data sets that you can select on a first come, first selected basis.

Which variable is the dependent variable and what are the independent variables? What do the variables mean and what are their units of measurement? Present this in a table in Word.

Present descriptive statistics for the dependent variable by using Excel to calculate the mean, median, mode and standard deviation. Present this in a table in your Word document.

Use Excel to create histogram of your dependent variable. Copy this histogram to your Word document and comment on whether it is skewed and unimodal, bimodal or multimodal.

Use Excel to create correlation matrix for all variables. Copy this correlation matrix to your Word document and comment on the degree of correlation among the independent variables.

Make a scatter diagram of the dependent variable and the independent quantitative variable having the highest correlation with your dependent variable.