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

Question from inventory, CASE STUDY 1 3 MARKS An audit of the...

CASE STUDY 1 3 MARKS An audit of the accounting records of Loch Ness Ltd. for the year ending 30 June 2012 discovered that the ending inventory balance

Calculate the point price elasticity of demand, Bambridge Associates LLP ha...

Bambridge Associates LLP has hired you to analyze the demand in 30 regional markets for custom financial plans for high net worth individuals (Y). A statistical analysis of demand

Help with homework, 1. Penny Pincher, Inc. had a contribution margin of $33...

1. Penny Pincher, Inc. had a contribution margin of $33,000 on sales of $50,000 and had fixed costs of $18,000. Calculate its break-even point in sales dollars. 2. Krueger Company

Homework, Problems 15. An art professor was interested in seeing what si...

Problems 15. An art professor was interested in seeing what size group is best to prime the pump so to speak to encourage strangers to gather together in front of various exhibi

Difference between an unadjusted trial balance and an adjust, Difference be...

Difference between an unadjusted trial balance and an adjusted trial balance? The variations between unadjusted test stability and altered test stability are the amounts registe

Linear regression model, Q. Explain Linear Regression model? Ans. ...

Q. Explain Linear Regression model? Ans. Linear correlation measures the strength of a linear relationship, but not the exact numerical relationship. Linear regression, o

What is bond premium and face value of bond, Defining of bond premium in te...

Defining of bond premium in terms of the amount paid over the face value of the bond. And the amount over and above the Face Value of bond which the purchaser pays is called Bond P

Balance sheet-actual reserves , (a)   The bank's excess reserves are its ac...

(a)   The bank's excess reserves are its actual reserves less required reserves. Actual reserves are given as $450 from its balance sheet. Required reserves are given by the produc

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