Explore BrainMass

Explore BrainMass

    Data Analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 12:39 am ad1c9bdddf