See attached files.
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)
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
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.