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

Allowable moving costs , Allowable moving costs Except as mentioned in Sub...

Allowable moving costs Except as mentioned in Subsection 60.20.20 and within certain restrictions, allowable moving costs involve the prices associated with moving family products

Binomial expansion, what is the largest coefficient of (1+3x)^4 is ?

what is the largest coefficient of (1+3x)^4 is ?

Spatial working memory , Preamble For the assignment you have been give...

Preamble For the assignment you have been given brief background details of a research project and you are required to produce a portfolio of short reports. Portfolios are to b

Calculate the probability of bmi, A file on DocDepot in the assignments fol...

A file on DocDepot in the assignments folder on doc-depot called bmi.mtp contains data on the Body Mass Index (BMI) of a population of Ottawa residents. The first column identifies

Give the appropriate choice of the null hypothesis, 1 . Below are the point...

1 . Below are the points scored by the winning team in Week 10 of NFL professional football games this Fall, 2011. 24 17 44 13 21 24 30 20 37 26 17 22 27 37 37 45 a) Use thes

Confidence interval for a proportion, The quick method for a confidence int...

The quick method for a confidence interval for a proportion uses p ±1/√n as an approximation for a 95% confidence interval.  The margin of error in this case is slightly larger tha

Determine ytm price formula, YTM can be determined using the price formula...

YTM can be determined using the price formula of a bond. Part a The present value (price) formula for a zero coupon bond is: PV = F/(1+i) n Plugging in the given inf

Correlation analysis and coefficient, Individual Music scores Mathematics s...

Individual Music scores Mathematics scores Angela 2 8 Arthur 6 3 Peter 4 9 Mike 5 7 Barbara 7 2 Jane 7 3 Jean 2 9 Ruth 3 8 Alan 5 6 Theresa 4 7 Assess the data using a Correlation

Job order costing, Bedovin company manufactures office tables and chairs us...

Bedovin company manufactures office tables and chairs using job order costing. The data given below were taken from the records as of April 30, the first month of operations. Job

Cost behavior/classificationq, Shipping costs on Merchandise sold--it is a ...

Shipping costs on Merchandise sold--it is a variable cost, but is it a selling/adminstrative cost or product cost? Is it direct or indirect?

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