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

Managerial, Kody Corporation uses a job-order costing system with a plantwi...

Kody Corporation uses a job-order costing system with a plantwide overhead rate based on machine-hours. At the beginning of the year, the company made the following estimates:

Bunco toss, The game of "Bunco" is played with three standard dice. "Bunco"...

The game of "Bunco" is played with three standard dice. "Bunco" occurs when all three dice show the same number of spots. What is the probability of tossing a "Bunco" on the first

Amortized cost , Amortized cost The par value of its decision enhanced or ...

Amortized cost The par value of its decision enhanced or lowered by any unamortized top quality or lower price.

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

Volume, I have a box that measures 3m x 3m x 3m. What is the volume of the...

I have a box that measures 3m x 3m x 3m. What is the volume of the cube?

Magnetic susceptibility experiment, . Good day, Using 4-inch pole caps and ...

. Good day, Using 4-inch pole caps and a Mettler M5 balance, I got all the values required in order to calculate the magnetic susceptibility of several inorganic compounds such as

Calculate present value-hpr and future value , Semiannual coupon = 10%*$100...

Semiannual coupon = 10%*$100/2 = $5 Since it is one-year semiannual bond, it pays two coupons, one at six months from now and the other at maturity when the bank account will be

Cost of preference sharea, A company wishes to issue new preference shares;...

A company wishes to issue new preference shares; the company will incur flotation cost of 2% per share. the market value of this shares is $90 per share & a nominal value of $100 p

Sampling, Advantages of sampling over population

Advantages of sampling over population

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