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

Standard error of the differnce between means., IN two separate studies, th...

IN two separate studies, the actual difference between the means of a treated group and untreated group is 3 points. However, in one study sm1-m2 is very large and so the 3 points

Linear modelling, what is a difference between a linear model and a linear ...

what is a difference between a linear model and a linear model

Probebility., what is probebility? and how to solve the sums of this?

what is probebility? and how to solve the sums of this?

Force, The 70-m microwave transmission tower

The 70-m microwave transmission tower

Histogram and Historigram, What are the differences between Histogram and H...

What are the differences between Histogram and Historigram, list out the points.

Transitioning from gaap to ifrs, How important do you think knowledge trans...

How important do you think knowledge transfer and training will be to help in transitioning from GAAP to IFRS? Manager 1: Knowledge transfer is going to be extremely importan

LINEAR REGRESSION, Y=C+1075x,when x was 2, and y was 239, given that y inte...

Y=C+1075x,when x was 2, and y was 239, given that y intercept was 11. calculate the residual.

Topic 4 Anova excel worksheet, systolic blood pressure in different age gr...

systolic blood pressure in different age groups. the following table contains a random sample of 40 women partitioned into three groups...

Illustrate linear correlation, Q. Illustrate Linear Correlation? Ans. ...

Q. Illustrate Linear Correlation? Ans. In bivariate studies we are often interested in finding out whether there is a relationship between two sets of data. Are SAT score

F2 test x, What is F2 Test,  X, Y Arithmetic Means  The above method of fi...

What is F2 Test,  X, Y Arithmetic Means  The above method of finding out regression equation is tedious. The calculations can very much be simplified if instead of dealing with th

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