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

Activity based costing, Traditional cost accounting has been based on alloc...

Traditional cost accounting has been based on allocating a subjective or calculated range of indirect expenses to direct costs. Activity Based Costing (ABC) offers an alternative a

Ms 4, 2. From the following cost, production and sales data of Decors Motor...

2. From the following cost, production and sales data of Decors Motor Ltd., prepare comparative income statement for three years under (i) absorption costing method, and (ii) margi

Business tax accounting , 1. Passive losses are fully deductible as long as...

1. Passive losses are fully deductible as long as they do not exceed $50,000 during the year. A) True B) False 2. Wages are considered "active income." A) True B) False 3. A de

Strategy nash equilibrium, Consider a population of consumers uniformly dis...

Consider a population of consumers uniformly distributed along the interval from left-hand (x = 0) to right-hand (x=1). The mass of consumers is 1. There are two firms (F1 and F2)

Impulse-momentum theorem, Impulse and Momentum Theorem   Impulse is known...

Impulse and Momentum Theorem   Impulse is known as the change in momentum of any object:  j  = Δ p   Momentum  is a product of the mass & the velocity of an object, and is a v

Analyse resources and accountability, The unfortunately-named (and fictitio...

The unfortunately-named (and fictitious) town of Avalanche, Utah maintains a vibrant and growing ski industry.  As Director of Avalanche's search-and-rescue operations, you are alw

Illustrative statistics with statistics, Company statistics is the technolo...

Company statistics is the technology of good selection in the face of concern and is used in many professions such as financial statistics, econometrics, auditing, generation and f

Probability, How can you use probability to improve your chances of winning...

How can you use probability to improve your chances of winning at a casino

Administering agency solutions, Administering agency solutions A professio...

Administering agency solutions A professional specific by the Office of Economical Control to provide common management of economic sales action. An administering agency is also a

Role of statistics, what is the role of statistics in other sciences?

what is the role of statistics in other sciences?

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