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

Ordering cost, 1) Define and explain the following: i) Ordering cost ii) Sa...

1) Define and explain the following: i) Ordering cost ii) Safety stock iii) Re-order point 2) Profit Volume Chart. 3) Discuss the various techniques of financial statement analysis

Cost accounting, what is the relationship of cost accounting to financial a...

what is the relationship of cost accounting to financial and management accounting?

Cost management, if sales is 6800 and variable costs are 2856 what is the v...

if sales is 6800 and variable costs are 2856 what is the variable cost percentage?

Closing Stock , How to calculate closing stock in Tally while we are postin...

How to calculate closing stock in Tally while we are posting with inventory.

Number of faults to line length, A study on the occurrence of line faults i...

A study on the occurrence of line faults in an electricity supply network was carried out over a two-year period.  Data was collected from six regions on the number of faults per y

Quartile deviation, find quartile deviation from the student test marks of ...

find quartile deviation from the student test marks of your own

Statistics, example of descriptive and inferential statistics?

example of descriptive and inferential statistics?

Why Agency code is useful, Why Agency code is useful The four personality n...

Why Agency code is useful The four personality number code allocated by the Workplace of Economical Control to select the unique business models of condition. Organization requirem

Time series, discuss the nature and causes of the components of an economic...

discuss the nature and causes of the components of an economic time series?

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