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

Cost accounting, Problems and solutions in marginal costing

Problems and solutions in marginal costing

Characteristics of data in statistics, Important Characteristics of Data ...

Important Characteristics of Data Center - The representative or average value which indicates where the middle of the data is located.   Variation - the measur

Time series, discuss the nature and causes of the components of an economic...

discuss the nature and causes of the components of an economic time series?

Relevant costs to decision-making , Foster Company makes 20,000 units per y...

Foster Company makes 20,000 units per year of a part it uses in the products it manufactures. The unit product cost of this part is computed as follows: Direct materials $24.70 Dir

What is univariate and bivariate data, Q. What is Univariate and Bivariate ...

Q. What is Univariate and Bivariate Data? Ans. Univariate data is data gathered about a single variable. Univariate studies could include a study of the amount paid by Am

Calculate permanent income, Suppose that permanent income, YP (t) is calcu...

Suppose that permanent income, YP (t) is calculated as the average of disposable income (YD t ) over the past 5 years, that is: YP (t) = 0.2(YD t + YD t-1 + YD t-2 + YD t-3

Accounting standards in united states, United States: There are currently ...

United States: There are currently more than 10000 companies that are registered with the SEC (Securities Exchange Commission). Of these, around 1000 are non US companies. The non

Ashland multicomm services, Given all the evidence that you have collected ...

Given all the evidence that you have collected from all your surveys of 50 prospective customers, answer the question will full explanation. How many free premium channels should

Quantitative research, The research should be Quantitative Research: A m...

The research should be Quantitative Research: A means for testing objective theories by examining the relationship among variables. These variables can be measured and analyzed

Role of accountant, What are the roles of accountant, let me know the caree...

What are the roles of accountant, let me know the career opportunity in accounting subject?

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