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.