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

Define Betterment, Define Betterment An inclusion created to, or modify cr...

Define Betterment An inclusion created to, or modify created in, an investment resource, other than servicing, that is estimated to improve its predicted useful life or to improve

Impact of government regulation on managerial decision, Impact of governme...

Impact of government regulation on managerial Decision making Impact of government regulation on managerial Decision making how methods of control can influence market prices.

Compute the data using both Megastats and Excel Data, AA major razor blade ...

AA major razor blade manufacturer advertises that its twin-blade disposable razor “gets you lots more shaves” than any single-blade disposable razor on the market. A rival company

Correlation coefficient for X and Y, Calculate Correlation coefficient for ...

Calculate Correlation coefficient for X and Y, Statistics Homework • Variable X x • Variable Y y • Calculate: • z-scores for all values in the variables • correlation coefficien

Calculate the npv of machine, Kenneth Su Gold Corp (KSGC) is considering th...

Kenneth Su Gold Corp (KSGC) is considering the purchase of a new piece of machinery. The new machinery would cost $80,000. You are given the following facts: The new machine

Accounts payable in accounting, Volumes due to personal individuals or comp...

Volumes due to personal individuals or companies for products and/or services obtained by the state. Records Due does not involve amounts due to other companies, resources, or othe

Statistics in plural and singular form, how to deffine statistics in plura...

how to deffine statistics in plural and singilar form

Are depreciation, Are depreciation, depletion and amortization similar? ...

Are depreciation, depletion and amortization similar? In accounting the terms depreciation, depletion and amortization often involve the movement of costs from the balance s

Reproduction rates, Reproduction rates: if the majority of births are thos...

Reproduction rates: if the majority of births are those of boys the population is bound to decrease while the reverse will be the case if the majority of births are girls. Similar

Explain what is signal reliability ration, A. If CD players are able to use...

A. If CD players are able to use the LDD strategy better than pure chance then explain what happens to the signal reliability ration as a CD player detects more cautiously B. As

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