Details of this Paper

1. Choose any published database from either the C...

Description

Solution


Question

1. Choose any published database from either the Census Bureau, the Bureau of Labor Statistics, Federal Statistics, Yahoo! Sports, or any major Web site containing government data, college or professional sports data, or financial data on publicly traded companies. Be sure to cite the source of your data in your course project and either include the data in your appendix or include the link to the specific file. If you choose to use a database that does not meet the stated criteria, please send the file and/or link to your instructor for approval prior to beginning the data analysis project. Note that your chosen file must have several variables in order to allow you to conduct the required analysis stated below. 2. If the chosen file is large, you may randomly choose 100 of the observations from the data (but specify how you chose the data in your project). 3. Explain each variable in the file that you are analyzing. 4. 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. 5. Conduct three different hypothesis tests of your choice using appropriate variables from the file (Note: You must use 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. 6. 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. 7. Write a 1?2 page summary of your findings. Include the data file in the appendix.,Copy all Excel output into a single Word document and address each requirement in the order shown above. Format the document professionally so it flows well. Include a table of contents. Activity Descriptive analysis: Chooses interval/ratio variables. Descriptive analysis: Loads data correctly into Descriptive_Statistics.xls and Frequency_Distribution.xls. (Note that the instructor may deduct points from your overall score if both documents are not correct.) Descriptive analysis: Correctly explains the output. Hypothesis test 1: Chooses appropriate variables and correctly states hypothesis. (Note that the instructor may deduct points from your overall score if both items are not correct.) Hypothesis test 1: Correctly performs statistical procedure. Hypothesis test 1: Correctly states conclusion and reject/not reject decision. Hypothesis test 2: Chooses appropriate variables and correctly states hypothesis. (Note that the instructor may deduct points from your overall score if both items are not correct.).,I appreciate the help in this matter! Wayne

 

Paper#11750 | Written in 18-Jul-2015

Price : $25
SiteLock