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, A machine that cuts corks for wine bottles operates in such a ...

A machine that cuts corks for wine bottles operates in such a way that the distribution of the diameter of the corks produced is well approximated by a normal distribution with mea

Depression screening measures , A study of a new anti-depressant drug took ...

A study of a new anti-depressant drug took a sample of 10 individuals with high depression screening measures (DSM) and gave them the drug for three months.  At the end of the thre

What is accounting system , The methods and records established to recogniz...

The methods and records established to recognize, set up, evaluate, move, record, and report the state’s purchases and to maintain responsibility for its obligations and resources

Accounting Assumption, What are the consequences of non-compliance to each ...

What are the consequences of non-compliance to each accounting concepts?

Best subsets” method to identify a “best” model for the data, Use the “best...

Use the “best subsets” method to identify a “best” model for the data. Explain what you think is the best model and why.

What is the speed of the block, A prevent of huge m = 10 kg is drawn by a p...

A prevent of huge m = 10 kg is drawn by a power F = 100 N at a position q = 30o with the horizontally along a sleek horizontally exterior. What is the speed of the block? (g = 10 m

Royalty accounts, Ritu acquired a mine on lease from Richa for a period of ...

Ritu acquired a mine on lease from Richa for a period of 8 years at a royalty of ` 60 per tonne of coal produced subject to minimum rent of ` 1,00,000 for the first year, increasin

What is the net book value of a noncurrent asset, What is the net book valu...

What is the net book value of a noncurrent asset? The net publication value of a noncurrent resource is the net quantity revealed on the stability piece for a long-term resourc

Marginal costing and break-even analysis, Marginal costing and Break-even a...

Marginal costing and Break-even analysis According to C.I.M.A. Manchester, "Marginal Price means the quantity at any given variety of result by which get worse scenario costs ar

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

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