- Choose any published database from the internet or Bethel library (such as those from the Census Bureau or any financial sites). You might opt to employ one of the data files provided by the instructor if applicable.
- Get advanced approval from instructor on your chosen database.
- If the file is large, randomly choose 200 of observations from data.
- Elucidate each variable in file which you are analyzing. Be sure your file includes at least 3 scale variables and at least 2 nominal variables.
- Conduct a descriptive analysis on any 2 interval / ratio variables you wish using Descriptive_Statistics.xls and Frequency_Distribution.xls.
Explain the output.
- Conduct 3 dissimilar hypothesis tests of your choice using appropriate variables from the file (note: you should use 3 different tests and not run one test on 3 different variables). In each case, state the variables being tested as well as the hypothesis, decision and conclusion. Use 3 of the following (1-Sample Test for Means, 1-Sample Test for Proportions, 2-Sample Test for Means - Independent Samples, 2-Sample Test for Means - Paired Samples, 2-Sample Test for Proportions, Analysis of Variance, Chi Square Goodness of Fit Test, Chi Square Test of Independence, Correlation Test).
- Build up a model to predict an interval / ratio variable using at least 2 other variables. Use Multiple_Regression.xls and state the regression model and which variables are or are not significant. Also, employ the model to make a calculation by making up values for each of the independent variables.
- Write a one to two page summary of your findings. Consist of the data file in the appendix.