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

Intermediate, The screening test for the hep-c virus works by detecting the...

The screening test for the hep-c virus works by detecting the presence of antibodies to the virus. However, some non-HCV proteins can trigger a false positive, at a probability of

Cost accounting, To bring Mr. Kid to justie, the company must reconstruct i...

To bring Mr. Kid to justie, the company must reconstruct its activities for June. You have been assigned to perform the task of reconstruc*ion. After interviewing selected employee

Feature of accounting transaction, Classification feature of Accounting Tra...

Classification feature of Accounting Transaction. Under the classification accountant posts the entries into their respective ledgers in the Accounts Books. Every Account entry

Data graphical representationhic, if the class intervals of data are equal....

if the class intervals of data are equal. though it is ranges,do we have to use bar charts keeping a same space between bars or a histogram?

Difference, what is the difference between HISTORIGRAMS and HISTOGRAMS?

what is the difference between HISTORIGRAMS and HISTOGRAMS?

3-month absolute deviation, For our class homework we prepared a 3-month fo...

For our class homework we prepared a 3-month forecast for sales (12 months with actual sales for each month). What or how do we figure the absolute deviation of the 3-month foreast

Probability, #question An electronic assembly is subjected to a final funct...

#question An electronic assembly is subjected to a final functional test. Suppose that defects occur at random in these assemblies, and that these defects occur according to a Pois

Financial accounting, During October, Alcorn Company had 81,250 of cash rec...

During October, Alcorn Company had 81,250 of cash receipts and 83,688.00 of cash disbursements. The October 31 cash balance was 14,060. Determine how much cash the company had at

Identification of null and alternative hypotheses, A politician claims that...

A politician claims that the mean salary for managers in his state is more than national mean $82,000.  The salaries (in dollars) for a random sample of 30 managers in the state ar

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