Calculate descriptive statistics for your variables

Reference no: EM131151264

Data Exploration and Descriptive Statistics.

For the final you will pick 4 variables to work with. At least one of them has to be an interval-ratio variable; please consult me if you are having trouble finding an interval-ratio variable. Your other variables can be nominal,ordinal, or interval ratio.

Part .Data Exploration

a) Run a histogram for each interval ratio variable. Cut and paste those onto your word file. Briefly describe the shape of the distribution, making note of its overall shape and also looking for any outliers.

b) Build a scatter plot if you have two or more interval ratio variables. What type of relationship, if any, can you observe between the variables?

Now, turn to your categorical variables (if you have any).

c) Run a frequency distribution for each of your categorical variables- you can use either the tab or fre command. Cut and paste the output in your word file and briefly describe the distribution of the variable. Note which category has the most observations, and note categories which have very few observations.

d) If you have two or more categorical variables run a cross-tab to examine the relationship between two of them using the tab command and either column or row percentages. Briefly describe the relationship between the variables. Cut and paste your output into a word file.

Part. Descriptive Statistics

Now, calculate descriptive statistics for your variables using the sum command. You can do all four variables at once.

a) Make sure you describe the mean of each variable. If the mean is not a good measure of central tendency for a particular variable please explain why. Do the same for the standard deviation and the range.

Of course, the type of correlation that you should calculate depends upon the type of variables you are working with. At the minimum you should calculate Three correlations but you must be very careful to use the right type of correlation coefficient for your data.

Just a few reminders:

1) To correlate interval-ratio variables, use pearson's r. Make sure you display a scatter plot before you run your correlation.

2) To correlate ordinal variables use spearman's rho. Make sure you display a cross tab before you run your correlation.

3) To correlate nominal variables use lambda. Make sure you display a crosstab before you run your correlation.

For each of your three correlations make sure you describe the size, statistical significance and, when applicable, the direction of the relationship.

Notice that the three correlations your report could be very different depending on the types of variables you are working with.

Regression and Multiple Regression

Now you will build a series of regression models. Before you begin keep the following in mind:

-Your outcome variable MUST be interval ratio.
-The interpretation of the regression coefficients depends upon the type of variable you are using and it's coding.
-For categorical predictors you might want to do some recoding. If you recode any variables make sure that you SAVE your data and that you describe how you recoded in your homework.

Part 1.
Estimate a regression model with a single predictor. Interpret the regression coefficient and it's p-value, the intercept and the R2.

Part 2.
Add another predictor variable to the model you estimated in Part 1. Describe any change in the coefficient of the original variable (and it's associated p-value) and interpret the coefficient and p-value of the new variable. Note any change in the R2

Part 3.
Add a third predictor variable. Describe any changes in the coefficients and p-values for the variables you entered into the previous models. Interpret the coefficient and p-value for your new variable. Note any change in the R2.

Effect size, prediction, and diagnostics

There are multiple ways to think about "effect size" in a multiple regression context. In this section:

1) Use the listcoef command after your regression models to obtain standardized coefficients. Briefly interpret the standardized coefficients using 2-3 sentences.

2) Now, calculate some "effect sizes" as I show in the video and the notes. The way that you do this section will depend upon the types of variables that you have. For categorical variables it probably makes most sense to calculate and effect at the mode. For interval ratio variables you might want to use the 25th and 75th percentiles. Do whatever makes sense for the type of data you are working with.

Take a few sentences to describe what you have calculated. Which variable appears to be the most important now?

Predicted values:

1) Create 2-4 "archetypes" or "representative cases" and calculate predicted values for those cases. How you do this will depend upon what types of variables you are working with. Please show your work and explain your archetypes.

Residuals

1) Calculate the residuals from your final regression model. Plot those residuals on a histogram and cut and paste the histogram into your word file. Do the residuals follow a normal distribution?

Heteroscedasticity

1) Plot your residuals against your fitted values using a scatter plot (paste the scatter plot into your word file). Do you see visual evidence of heteroscedasticity?

2) Test for heteroscedasticity using the Breusch-Pagan/ Cook-Weisberg test. What does this test tell you? Make sure you paste the output of the test into your word file.
Multicollinearity

1) Calculate VIFs for your model and paste the output into your word file? Does your model have multicollinearity problems?

Reference no: EM131151264

Questions Cloud

Name the titles of the financial reports : Name the titles of the financial reports in theIntel Corp. annual report that provide specific information about economic resources.

Which is characteristic of most effective training practices : What would you call a meeting that is typically done once a year to identify and discuss job-relevant strengths and weaknesses of individuals or work teams?

Applied for job promotion at marketing firm : A 43-year old male, Mike, applied for a job promotion at a marketing firm, along with four other employees. He is notified that he did not get the job, but his 32-year-old female co-worker, JoAnn, will be promoted. Mike feels he was equally qualified..

Potential effects of the political turmoil : In early 2011, political revolution started in many Middle Eastern and African countries. Discuss the actual, probable and potential effects of the political turmoil on MNCs that operate in these countries. Specifically, describe the risk MNCs face w..

Calculate descriptive statistics for your variables : Build a scatter plot if you have two or more interval ratio variables. What type of relationship, if any, can you observe between the variables?

Compute the depletion charge per ton : Compute the depletion charge per ton. - Compute the depletion expense that Mertz should record for the year.

Context of organizational behavior theory : Each student will be required to assess the overall effectiveness of a company/institution/agency in Albany or any other city in the context of Organizational Behavior theory. Students will be required to collect data using interviews or surveys and ..

Prepare your comments about the two companies performances : You will calculate and compare the financial ratios listed further down this documentfor the fiscal year ending 2014, and prepare your comments about the two companies' performances based on your ratio calculations.

The objectives of generally accepted accounting principles : What are the objectives of generally accepted accounting principles in their application to the income statement?

User Account

All Pages