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 income and substitution effects, In November 2010, every Mzumbe U...

In November 2010, every Mzumbe University student had an income of 150000/= per month,facing the price of meal (X) 1000/= and average price of other goods (Y) 1000/=.The initial ut

Average velocity profile-actual velocity profile, 1)  You are developing a ...

1)  You are developing a sampling protocol whereby you're going to insert a probe into a turbulent flow in a circular conduit of radius R. a. Using a description of a velocity p

Long term credit decision, Long Term Credit Decision In no more than o...

Long Term Credit Decision In no more than one typed page, provide a statement of your decision to lend or not lend to this company based on your interpretation of the company'

Expected Value Problems, Ask question #Minimum 1when all factors are taken ...

Ask question #Minimum 1when all factors are taken into account, an insurance company estimates that the probability of my father making a claim for damages to his pontoon boat for

What after the implementation of ifrs, What after the implementation of IFR...

What after the implementation of IFRS?  Manager 1: IFRS is only the first step towards the change that the SEC is trying to bring in. Firstly it is going to take a couple of year

Measures of central tendency, List down various measures of central tendenc...

List down various measures of central tendency and explain the difference between them?

Pivot table, The Pivot table is as below: Values ...

The Pivot table is as below: Values Row Labels Sum of ID Sum of Risk Level A 69

Define wages, Define Wages Income is often associated with production wo...

Define Wages Income is often associated with production workers (sometimes referred to as "blue-collar" workers), non-managers, and other workers whose pay is reliant on time wo

What is the probability that a major defect is detected, Back to the worksh...

Back to the workshop the previous problem but assuming that in each of the three stages of development, there is a certain probability that a major defect is detected. When such a

Linear regression model, Q. Explain Linear Regression model? Ans. ...

Q. Explain Linear Regression model? Ans. Linear correlation measures the strength of a linear relationship, but not the exact numerical relationship. Linear regression, 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