Share
Explore BrainMass

Data Analysis

See attached files.

I. I chose a published database containing government data; U.S. Bureau of Labor Statistics. The chosen file must have several variables in order to conduct the required analysis stated below.

Bureau of Labor Statistics (See attachment)
Table 1. Mass layoff events and initial claimants for unemployment insurance, October 2006 to September 2010, seasonally adjusted
http://www.bls.gov/news.release/mmls.t01.htm

II. Conduct a descriptive analysis on any two interval/ratio variables you wish using the Descriptive_Statistics.xls and the Frequency_Distribution.xls. file. Explain the output.
a.) Descriptive_Statistics.xls (File)
b.) Frequency_Distribution.xls

III. Conduct three different hypothesis tests of your choice using appropriate variables from the file (Note: enter three different tests; not run one test on three different variables). In each case, state the variables being tested as well as the hypothesis, decision, and conclusion.
a.) Hypothesis Test Two Samples
b.) Chi Square
c.) ANOVA

IV. Develop a model to predict an interval/ratio variable using at least two other variables. Use the Multiple Regression document and state the regression model and which variables are or are not significant. Also, use the model to make a prediction by making up values for each of the independent variables.
a.) Multiple Regression

NOTE: Summarize the findings. Copy all Excel output into a single Word document and address each requirement in the order shown above.

Attachments

$2.19