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

Calculate the npv of machine, Kenneth Su Gold Corp (KSGC) is considering th...

Kenneth Su Gold Corp (KSGC) is considering the purchase of a new piece of machinery. The new machinery would cost $80,000. You are given the following facts: The new machine

Cost behaviour, variable cost per unit remain constent why

variable cost per unit remain constent why

Histograms, The skewness is a measure of asymmetry and it is positive at 0....

The skewness is a measure of asymmetry and it is positive at 0.15 meaning that it is greater than zero which reveals that the tail extends to the right slightly indicating the dist

Estimate of the population mean, Playbill magazine reported that the mean a...

Playbill magazine reported that the mean annual household income of its readers is $119,155 (Playbill, January 2006). Assume this estimate of the mean annual household income is ba

AMORTIZATION , AMORTIZATION The slow decrease or liquidation of an quantit...

AMORTIZATION The slow decrease or liquidation of an quantity over a time interval according to a specified program (such as, the pension of a debts by sequential repayments to the

Values of income and intrest rate, Now imagine that consumption is given as...

Now imagine that consumption is given as:             C = 400 + 0.9YD - 1,750i And as above:       Y = PE = C + I + G + NX                           (Income identity)

Find a p-value from a t-test, A random sample of 321 New Jersey and 77 Penn...

A random sample of 321 New Jersey and 77 Pennsylvania fast-food restaurants was selected from those fast-food restaurants in this study.  The restaurants were categorised into two

Bond redemption, Bond redemption The regaining of control of bonds formerly...

Bond redemption The regaining of control of bonds formerly issued by expense of amount due to the owner.

Statistics, 1. A search engine site claims that, on average, one out of fi...

1. A search engine site claims that, on average, one out of five visitors clicks on an ad. (a) If 8 users visit the site, what is the probability that at least three click o

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