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

Accrue definition in accounts, To history income and expenditures/expenses ...

To history income and expenditures/expenses when they connect with the identification requirements of the finance form engaged regardless of when the money action happens.

Calculate the probability , In the 2009 Season, the Toronto Blue Jays finis...

In the 2009 Season, the Toronto Blue Jays finished the season with a record of 75-87. In 47 of those games, both the offense and defense performed adequately, and in 42 of them, ne

Marginal and absorption costing, the guinegog is a trader in portable cd-ma...

the guinegog is a trader in portable cd-man. His budgeted output is 5000 units per quarter. The following data was available for the year 1998: Direct labour @ $6 Direct material @

Poisson distribution, uuuuioooooo zAZ az; z;;ZuazA; Zazx A Za zA ZA xza XZ ...

uuuuioooooo zAZ az; z;;ZuazA; Zazx A Za zA ZA xza XZ Axz AZX A xA XZ axz AZX A zxA ZXa oxz aOX AxzAAX axz

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

Red candy, Test the claim that 10% of a candy makers candies are red. Use a...

Test the claim that 10% of a candy makers candies are red. Use a 0.05 significance and the table to answer the following questions: Find the proportion of the candies that are red?

How this works, So I can send you a word problem & you van send the answers...

So I can send you a word problem & you van send the answers back in excel for me?

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

Discuss the role that racism played in public policies, Discuss the role th...

Discuss the role that racism played in public policies related to urban housing throughout the twentieth century. Did this racism manifest itself solely on an individual level (i.e

Find the probability density function, The lifetime T (in days) of an elect...

The lifetime T (in days) of an electrical component has reliability function given by: R(t) = e - 0 : 01 t for time t > 0. An electrical system consists of four such component

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