Descriptive analysis , statistics, Basic Statistics

Assignment Help:
All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below. Format the document professionally so it flows well. Include a table of contents.

* Choose any published database from the internet or Bethel library (such as those from the Census Bureau or any financial sites). You may opt to use one of the data files provided by the instructor if applicable.
* Get advanced approval from the instructor on your chosen database.
* If the file is large, randomly choose 200 of the observations from the data.
* Explain each variable in the file that 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 different hypothesis tests of your choice using appropriate variables from the file (note: you must 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).
* Develop 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, use the model to make a prediction by making up values for each of the independent variables.
* Write a one to two page summary of your findings. Include the data file in the appendix.


Related Discussions:- Descriptive analysis , statistics

Probability, 1) A certain brand of batteries has a lifetime that has a norm...

1) A certain brand of batteries has a lifetime that has a normal distribution with a mean of 3,800 hours and a standard deviation of 390 hours. b) What lifetime should the manufac

Demonstrate the potential risk from financing in eurodollars, You have the ...

You have the following information about rates in London for Eurocurrency loans of one-year duration, the exchange rate between the USD and euros, the currency in which you want fi

What is cut-off date, What is cut-off date A chosen manually date whereby ...

What is cut-off date A chosen manually date whereby transactions usually are stopped to give for closing of the books of accounts for a known period: for audit purposes,

Normal Approximation to Binomial Probability Distribution, A machine that f...

A machine that fills quart milk cartons is set up to average 32.2 oz per carton, with a standard deviation of 1.2 oz. Assume a normal distribution for all of the cartons filled, wh

ANOVA, If 9 population means are not all equal with a conclusion from ANOVA...

If 9 population means are not all equal with a conclusion from ANOVA, we should expect that?

Quantitative analysis, How has quantitative analysis changed the current sc...

How has quantitative analysis changed the current scenario in the management world today?

Material & labour variances, standard material qty per unit- 2 kg standard ...

standard material qty per unit- 2 kg standard price per kg - 4 rs actual value of material purchased- 4000 rs closing stock- 200 kg actual usage- 2.5 kg finished stock sold- 200 u

Power supply, A source of electrical power. A device or system which delive...

A source of electrical power. A device or system which delivers electrical and or other types of energy to a corresponding device or system. Are commonly referred to as PSU (Power

Define mortality, Define Mortality: The following rates are used for measur...

Define Mortality: The following rates are used for measuring mortality. Crude death rate The annual crude death rate is defined as  Crude death rate = annual deaths / annual

Study guide, Can you provide me a study guide for accounting please? Can yo...

Can you provide me a study guide for accounting please? Can you give me picture examples & instructions on how to do things that are really easy to understand? I need this for doin

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd