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

Correlation and regression, What is regression analysis ? Discuss the relat...

What is regression analysis ? Discuss the relation between ''correlation coefficient'' and the ''regression coefficients''?

Internal rates of return , A consumer product firm finds that its brand of ...

A consumer product firm finds that its brand of laundry detergent is losing market share, so it decides that it needs to "freshen" the product. One strategy is to maintain the curr

Trial balance, paid installation charges of machinery rs1100

paid installation charges of machinery rs1100

What is prime cost, What is prime cost? Primary price is the combin...

What is prime cost? Primary price is the combination of a manufactured item's expenditures of immediate materials and immediate labor. In other words, prime price represent

Calculate the average profit, A machine is used for machining of a manufact...

A machine is used for machining of a manufactured product. At the beginning of each business day inspection reveals the machine's condition. There are three possible states: 0, 1 a

Estimate the probability, A football coach recorded in the practice session...

A football coach recorded in the practice sessions how many attempts were needed for a certain player to kick a field goal from the 25-yard line, and got the following numbers 3

Stock control, Two components, A and B, are used as follows: normal usage -...

Two components, A and B, are used as follows: normal usage - 50 per week each minimum usage - 25 per week each maximum usage - 75 per week re-order quantity - A:300; B:500 re-order

T test, Ten students are given coaching for environmental statistics. The s...

Ten students are given coaching for environmental statistics. The score obtained in tests 1 and 5 are given below: Sl No of student 1 2 3 4 5 6 7 8 9 10 Marks in 1st test 50 52 53

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