Scholarly Activity?

Unit IV Data Analysis

SUCCESS CENTER 800. 977.8449 EX T. 6538 | TEAMSUCCE ED@ CO LUM BIA S OUTHERN.EDU

VIDEO RECORDING: https://youtu.be/lX3ori-QQ1o

PROBLEM: The following is a copy of the actual template you will use for this unit. For each worksheet in the workbook you are instructed to use Excel and install the Analysis Tool Pack to do the following: 1). Frequency Distribution Table 2). Histogram 3). Descriptive Statistics Table 4). Measurement Scale 5). Measure of Central Tendency

6). Evaluation

Describe the Sun Coast Remediation data using the descriptive statistics tools discussed in the lecture.

Establish whether assumptions are met to use parametric statistical procedures. Repeat this for each tab in the

Sun Coast Remediation Research Study data set.

Descriptive Data and Assumptions: Correlation

Frequency Distribution Table

Insert table here.

Histogram

Insert histogram here.

Descriptive Statistics Table

Insert table here.

Measurement Scale

State here.

Measure of Central Tendency

State here.

Evaluation

In this section, evaluate the above descriptive statistics in relation to assumptions of parametric testing .

Discuss whether the assumptions for parametric testing were met in approximately 100 words here.

SOLUTION: Descriptive Data and Assumptions: Correlation

Please note that the following instructions use only a small portion of the data, for demonstration

purposes.

Frequency Distribution Table

Insert table here. See instructions below.

Histogram

Insert histogram here. See instructions below.

Instruction: When working in Excel, you need to add the Analysis Tool Pack, as described in the Sun Coast Remediation Course Project Guidance you download ed in Unit I. For demonstration purposes, only 19 of the data will be used. In your project, you must use all of the data. 1. Click on the Correlation Data tab at the bottom of the workbook. 2. Click on the “Data” tab at the top. Select “Data Analysis” on the far right.

3. A dialog box will appear with a list of analysis tools. Scro ll down and choose HISTOGRAM and click OK.

4. Fill out the form as shown:

Leave the Bin Range blank, which will allow Excel to do it for you. Notice, the Output range is the area

highlighted with green dashes on the spreadsheet. This is where your results will appear. It does not

matter how small or large you select the area, Excel will adjust it accordingly.

Select OK.

You can change the name of “BIN” to read “Mean Annual Sick Days per Employee.” Just double-click on

BIN (in either the frequency table or the histogram) and type the new title (whatever you want it to say).

Frequency Table and Histogram:

5. Descriptive Statistics Table: Go to the Data and select the Data Analysis tool. Select Descriptive

Statistics from the menu and press OK.

Type information as shown, choosing a section in the spreadsheet for the output range. The input range

are the values in column C, beginning at cell C2 . Press OK. Please note: You must use all the data in

column C. This example is only using C2 to C13.

The table will appear, but you may need to widen the columns to see all the data.

Descriptive Statistics Table:

6. Measurement Scale.

If you read the explanations in the Unit IV St udy Guide, you can determine what was used. This is simply

asking you what type of measurements you are using based on the data. Is it nominal, ordinal, interval, or

ratio?

7. Measures of Central Tendency (mean, median, and mode) are found in the Descriptive Sta tistics table

(shown above, highlighted in yellow ). Highlight these in yellow with your data, if you want.

8. Evaluation.

This is the section that you will discuss what you have observed both visually (histogram) and

statistically (descriptive statistics table) to decide whether the data has met the assum ptions required for

parametric testing. The Unit IV Study Guide discusses the assumptions that should be mentioned in this

evaluation, including frequency table, histogram, mean, median, mode, kurtosis, and skewness.

To widen the first column, double-click in between the E a nd F. Do the same with the area to the right of the F

column to widen it as well. The screenshot on the right is after the column s have been widened.

The remaining information is to help you know which data to use for frequency tables, histograms, and

descriptive statistics tables. Everything else is done exactly the same as outlined previously.

Simple Regression Analysis

For histogram, frequency table, and descriptive statistics, use lost time hours data.

Multiple Regression Analysis

For histogram, frequency table, and descriptive statistics, use the decibel data.

Independent Samples t-Test

Do the histogram, frequency table, and descriptive statistics for both variables, separately.

Paired Samples t-Test

Do the histogram, frequency table, and descriptive statistics for both variables, separately.

One-Way Anova

For histogram, frequency table, and descriptive statistics you must do one for each of the variables.

These are all separate, independent variables reflecting return on investment based on air, soil, water,

and training.

Note: This is only a partial range for demonstration purposes only.

The data needs the columns widened. Follow instructions outlined in step 5 above to widen each column.

Widened columns:

To make it easier to read, move labels over one column, before removing columns H, J, and L.