Homework answers / question archive / MBA 5652-18P-3A22-S3, Research Methods Book: Research Design John W

MBA 5652-18P-3A22-S3, Research Methods Book: Research Design John W

Statistics

Share With

---

MBA 5652-18P-3A22-S3, Research Methods

Book: Research Design John W. Creswell; J. David Creswell

Hello Everyone:

In Unit III, you developed your research design, or blueprint, for the research project. It is now time to begin working the plan by working with the data. In Unit IV, you will describe the data to determine if assumptions for parametric testing are met. Parametric tests are more powerful and superior to non-parametric tests, so it is desirable to use them if possible. However, data must meet a number of assumptions to be able to use parametric statistical procedures. Although assumptions vary by statistical procedure, nearly all statistical tests require the assumption of normality, or a normal distribution of data. When plotted, normality is represented by a bell-shaped curve. This is one of several assumptions you will test for in Unit IV.

The Unit IV study guide topics will include:

- Descriptive Statistics

- Assumption Testing

- Validity and Reliability

Course Project Note

You will be working with the Sun Coast data in this unit. There are six data tabs in the spreadsheet and each tab relates to one of the six Sun Coast problems that have been identified. You will also need to install the Excel Toolpak add-in to your Excel program. The directions are in the Course Project Guidance Document. Do not worry about breaking anything. If you happen to delete data from the file, or make any other mistake, you can simply download a fresh data set.

When using the Excel ToolPak program to generate a histogram and descriptive statistics to test assumptions for parametric procedures it is only necessary to use the dependent variable(s). For example, you will only look to see if the dependent variable is normally distributed using a histogram. When creating the histogram, the bin range should be left empty.

Please note that when using the t test and ANOVA the independent variables are the grouping variables (e.g. air, water, soil, training) while the dependent variables are the criterion you are measuring (e.g. ROI). You will always have at least two groups (e.g. pre-exposure lead vs. post-exposure lead), therefore, you will have at least two histograms and at least two sets of descriptive statistics to generate for these statistical procedures. If you have four groups, as in the case of the Sun Coast ANOVA, you will generate four histograms and four sets of descriptive statistics.

Correlation:

Input range = Mean Annual Sick Days per Employee

Bin range = leave blank

Simple Regression:

Input range = Lost Time Hours

Bin range = leave blank

Multiple Regression:

Input range = Decibel Level

Bin range = leave blank

Independent Samples t test:

Input range = Group A Prior Testing

Bin range = leave blank

Input range = Group B Revised Testing

Bin range = leave blank

Paired Samples t test:

Input range = Pre-Exposure μg/dL

Bin range = leave blank

Input range = Post-Exposure μg/dL

Bin range = leave blank

ANOVA:

Input range = Air

Bin range = leave blank

Input range = Soil

Bin range = leave blank

Input range = Water

Bin range = leave blank

Input range = Training

Bin range = leave blank

 

 

 

Assignment Instructions

Descriptive Statistics Analysis

 

Describe the Sun Coast data using the descriptive statistics tools discussed in the unit lesson. Establish whether assumptions are met to use parametric statistical procedures. Repeat the tasks below for each tab in the Sun Coast research study data set. Utilize the  Unit IV Scholarly Activity template . See Sun Coast Data File attachment.

You will utilize the Microsoft Excel ToolPak. The links to the ToolPak are in the  Excel ToolPak Links document .

Statistical Tools

 

You will conduct the data analysis using Microsoft Excel Toolpak. See the links below for more information.

 

https://support.office.com/en-us/article/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4

 

https://www.excel-easy.com/data-analysis/analysis-toolpak.html

 

 

Here are some of the items you will cover.

• Produce a frequency distribution table and histogram.
• Generate descriptive statistics table, including measures of central tendency (mean, median, and mode), kurtosis, and skewness.
• Describe the dependent variable measurement scale as nominal, ordinal, interval, or ratio.
• Analyze, evaluate, and discuss the above descriptive statistics in relation to assumptions required for parametric testing. Confirm whether the assumptions are met or are not met.
• Only use peer reviewed references from Columbia Southern Library plus the above book for this course.

 

The title and reference pages do not count toward the page requirement for this assignment. This assignment should be no less than five pages in length, follow 7^th edition APA-style formatting and guidelines, and use references and citations as necessary. See essay attachment template.

 

Discussion Board Question

 

Consider the four survey questions below from a job satisfaction survey, and indicate the levels of measurement used for each question (nominal, ordinal, interval, or ratio). Briefly explain your rationale for each decision. Double check the work of at least one peer, and discuss any differences. Just give a brief summary of this, less than 150 words please. 

A. I feel I am being paid a fair amount for the work I do (Fields, 2002).

1. Disagree very much
2. Disagree moderately
3. Disagree slightly
4. Agree slightly
5. Agree moderately
6. Agree very much

 

B. My primary role within the company is:

1. administrative.
2. maintenance.
3. laborer.
4. manager.
5. driver.

C. An amount I feel is reasonable to contribute annually to the company's health plan is:

1. $1,000 to $2,000.
2. $2,001 to $4,000.
3. $4,001 to $7,000.
4. $7,001 to $8,000.
5. $8,001 or greater.

D. Indicate the highest amount (to the closest thousand) you were able to contribute to your 401k in 2020.

1. $1,000
2. $2,000
3. $3,000
4. $4,000
5. $5,000
6. $6,000
7. $7,000
8. $8,000
9. $9,000
10. $10,000
11. $11,000
12. $12,000
13. $13,000
14. $14,000
15. $15,000
16. $16,000
17. $17,000
18. $18,000
19. $19,000
20. $20,000
21. $21,000
22. $22,000
23. $23,000
24. $24,000

Reference

Fields, D. L. (2002). Taking the measure of work: A guide to validated scales for organizational research and diagnosis. Thousand Oaks, CA: Sage.