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

Limitation of the accounting, Limitation of the Accounting. It informati...

Limitation of the Accounting. It information only accounting purchase, it is restricted to the accounting purchase only, and for example other elements which are not having any

What is a purchase discount, What is a purchase discount? A buy lower pr...

What is a purchase discount? A buy lower price is a deduction that may be available to a customer if the client will pay an account within a prescribed time. For example, a supp

Linear power supply, Linear Power Supply Uses a transformer to convert volt...

Linear Power Supply Uses a transformer to convert voltage from the mains (wall outlet) to a different voltage. With a transformer present, almost any voltage can be obtained. If a

Time seires, explain time series analysis

explain time series analysis

What is sample population, Q. What is Sample Population? Choosing a sam...

Q. What is Sample Population? Choosing a sample population is one of the most important factors in gathering statistical data because all of the claims will be based on the sam

Project, The trial balance of the Parton Wholesale Company contained the fo...

The trial balance of the Parton Wholesale Company contained the following accounts at December 31, 2010 the end of the company’s calendar year. PARTON WHOLESALE COMPANY Trial Bala

Need help, PART 1 Shown below are the sales revenue and advertising cost da...

PART 1 Shown below are the sales revenue and advertising cost data for seven companies published by International Advertising Age. COMPANY ADVERTISING ($ MILLIONS) SALES ($ BILLION

Home Assignments, A survey was conducted among the residents of Pune City, ...

A survey was conducted among the residents of Pune City, its suburbs and the Pune Cantonment area. The following three pie diagrams show their respective preferences for living in

Define Nuclear force, Nuclear force Is a short range force extending upto...

Nuclear force Is a short range force extending upto 10 fm. It is fifty-sixty times stronger than electromagnetic force. Nuclear force is independent of charge. Nuclear force betw

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