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

Appropriate relationship of varibles, How to write it with business implica...

How to write it with business implication of the analysis?

Explain the effects of the transactions, Explain the effects of the transac...

Explain the effects of the transactions on Accounting Equation under a Financial Accounting System. Ans. Under the Double Entry System each of the financial transaction bring the

Galvanometer to voltameter, a millemeter ammeter of resistance 5m amp is to...

a millemeter ammeter of resistance 5m amp is to be used to measure a potential difference of 50volt.calculate the multiplier resistance

Job order costing, what are the procedure of job order costing

what are the procedure of job order costing

Binomial probability distribution, if the probability of getting caught cop...

if the probability of getting caught copying someone else s exam is 0.2 find the probability of not getting caught in 3 attempts assume independence

Calculates the value of variance and standard deviation, You are a psycholo...

You are a psychologist who has collected the subjective well-being scores of a number of elderly people aged 90 or above who are residents of an independent living facility or who

Rebate, Refund can be defined as return of a part of a purchase price by a ...

Refund can be defined as return of a part of a purchase price by a seller to a buyer, usually on a purchase of a specified quantity or a value of goods within a specified period.

Change in the performance of the lamps between the dates, Q.2. (ii) A compa...

Q.2. (ii) A company making lamps has drawn a sample from its production line and measured the light output from each. The results, in microamps, are as follows: 9.1 9.8 9.5

Hom, (A) Find the binomial probability P(x = 5), where n = 15 and p = 0.50....

(A) Find the binomial probability P(x = 5), where n = 15 and p = 0.50. (B) Set up, without solving, the binomial probability P(x is at most 5) using probability notation. (C) H

Conditional probability, The U.S. Department of Transportation reported tha...

The U.S. Department of Transportation reported that during November, 83.4% of Southwest Airlines’ flights, 75.1% of US Airways’ flights, and 70.1% of JetBlue’s flights arrived on t

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