07 Sep Unit IV Scholarly Activity Instructions Descriptive Statistics Analysis Describe the Sun Coast data using the descriptive statistics tools discussed in the unit lesson. Establish whether as
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 .You will utilize the Microsoft Excel ToolPak. The links to the ToolPak are in the Excel ToolPak Links document .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.
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 APA-style formatting and guidelines, and use references and citations as necessary.
1
9
Insert Title Here
Insert Your Name Here
Insert University Here
Course Name Here
Instructor Name
Date
Data Analysis: Descriptive Statistics and Assumption Testing
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. Delete instructions and examples highlighted in yellow before submitting this assignment.
Correlation: Descriptive Statistics and Assumption Testing
Frequency Distribution Table
Insert frequency distribution table here. Cut and paste from Excel.
Histogram
Insert histogram here. Cut and paste from Excel.
Descriptive Statistics Table
Insert table here. Cut and paste from Excel.
Measurement Scale
Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).
Measure of Central Tendency
Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).
Skewness and Kurtosis
Discuss skewness and kurtosis and whether they are within acceptable ranges.
Evaluation
In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met.
Simple Regression: Descriptive Statistics and Assumption Testing
Frequency Distribution Table
Insert frequency distribution table here. Cut and paste from Excel.
Histogram
Insert histogram here. Cut and paste from Excel.
Descriptive Statistics Table
Insert table here. Cut and paste from Excel.
Measurement Scale
Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).
Measure of Central Tendency
Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).
Skewness and Kurtosis
Discuss skewness and kurtosis and whether they are within acceptable ranges.
Evaluation
In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met.
Multiple Regression: Descriptive Statistics and Assumption Testing
Frequency Distribution Table
Insert frequency distribution table here. Cut and paste from Excel.
Histogram
Insert histogram here. Cut and paste from Excel.
Descriptive Statistics Table
Insert table here. Cut and paste from Excel.
Measurement Scale
Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).
Measure of Central Tendency
Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).
Skewness and Kurtosis
Discuss skewness and kurtosis and whether they are within acceptable ranges.
Evaluation
In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met.
Independent Samples t Test: Descriptive Statistics and Assumption Testing
Frequency Distribution Table
Insert frequency distribution table here. Cut and paste from Excel.
Histogram
Insert histogram here. Cut and paste from Excel.
Descriptive Statistics Table
Insert table here. Cut and paste from Excel.
Measurement Scale
Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).
Measure of Central Tendency
Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).
Skewness and Kurtosis
Discuss skewness and kurtosis and whether they are within acceptable ranges.
Evaluation
In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met.
Dependent Samples (Paired-Samples) t Test: Descriptive Statistics and Assumption Testing
Frequency Distribution Table
Insert frequency distribution table here. Cut and paste from Excel.
Histogram
Insert histogram here. Cut and paste from Excel.
Descriptive Statistics Table
Insert table here. Cut and paste from Excel.
Measurement Scale
Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).
Measure of Central Tendency
Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).
Skewness and Kurtosis
Discuss skewness and kurtosis and whether they are within acceptable ranges.
Evaluation
In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met.
ANOVA: Descriptive Statistics and Assumption Testing
Frequency Distribution Table
Insert frequency distribution table here. Cut and paste from Excel.
Histogram
Insert histogram here. Cut and paste from Excel.
Descriptive Statistics Table
Insert table here. Cut and paste from Excel.
Measurement Scale
Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).
Measure of Central Tendency
Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).
Skewness and Kurtosis
Discuss skewness and kurtosis and whether they are within acceptable ranges.
Evaluation
In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met.
References
Include references here using hanging indentations.
Creswell, J. W., & Creswell, J. D. (2018). Research design: Qualitative, quantitative, and mixed methods approaches (5th ed.). SAGE.
,
Correlation Data
| job site | microns | mean annual sick days per employee |
| 1 | 4 | 11 |
| 2 | 6.5 | 7 |
| 3 | 8 | 5 |
| 4 | 8 | 5 |
| 5 | 4 | 10 |
| 6 | 7 | 7 |
| 7 | 2 | 11 |
| 8 | 5.5 | 9 |
| 9 | 5 | 7 |
| 10 | 4 | 10 |
| 11 | 4.5 | 8 |
| 12 | 8.5 | 4 |
| 13 | 7 | 7 |
| 14 | 5 | 8 |
| 15 | 9.5 | 3 |
| 16 | 7 | 7 |
| 17 | 9.5 | 5 |
| 18 | 9.5 | 7 |
| 19 | 5 | 10 |
| 20 | 6 | 6 |
| 21 | 8 | 5 |
| 22 | 7.5 | 6 |
| 23 | 8.5 | 5 |
| 24 | 9 | 4 |
| 25 | 3 | 7 |
| 26 | 6 | 7 |
| 27 | 7.5 | 7 |
| 28 | 7.5 | 5 |
| 29 | 2.7 | 7 |
| 30 | 2 | 9 |
| 31 | 7.5 | 6 |
| 32 | 9 | 4 |
| 33 | 6 | 6 |
| 34 | 3 | 8 |
| 35 | 8 | 5 |
| 36 | 1 | 8 |
| 37 | 8.5 | 5 |
| 38 | 0.7 | 8 |
| 39 | 0.5 | 8 |
| 40 | 8.5 | 4 |
| 41 | 2 | 8 |
| 42 | 4.5 | 9 |
| 43 | 6 | 7 |
| 44 | 7 | 7 |
| 45 | 5 | 10 |
| 46 | 2.5 | 12 |
| 47 | 5 | 9 |
| 48 | 4 | 7 |
| 49 | 8 | 5 |
| 50 | 5 | 7 |
| 51 | 3.5 | 9 |
| 52 | 8 | 6 |
| 53 | 5 | 5 |
| 54 | 4.9 | 10 |
| 55 | 7.5 | 9 |
| 56 | 2.5 | 7 |
| 57 | 6.5 | 7 |
| 58 | 8 | 6 |
| 59 | 5 | 6 |
| 60 | 7 | 6 |
| 61 | 4 | 9 |
| 62 | 8 | 5 |
| 63 | 1 | 8 |
| 64 | 2 | 8 |
| 65 | 4 | 10 |
| 66 | 4 | 9 |
| 67 | 7 | 7 |
| 68 | 5.2 | 10 |
| 69 | 5 | 7 |
| 70 | 6 | 6 |
| 71 | 8 | 6 |
| 72 | 6 | 7 |
| 73 | 6.5 | 6 |
| 74 | 1.5 | 8 |
| 75 | 8.5 | 6 |
| 76 | 2 | 8 |
| 77 | 8 | 5 |
| 78 | 10 | 4 |
| 79 | 10 | 5 |
| 80 | 8 | 8 |
| 81 | 1 | 8 |
| 82 | 7 | 6 |
| 83 | 10 | 2 |
| 84 | 7 | 8 |
| 85 | 7 | 6 |
| 86 | 6.5 | 7 |
| 87 | 7.5 | 6 |
| 88 | 8.5 | 6 |
| 89 | 3 | 8 |
| 90 | 0.5 | 9 |
| 91 | 1 | 8 |
| 92 | 9 | 6 |
| 93 | 7 | 7 |
| 94 | 2 | 9 |
| 95 | 8.5 | 7 |
| 96 | 3.5 | 9 |
| 97 | 3 | 8 |
| 98 | 7 | 6 |
| 99 | 5.5 | 7 |
| 100 | 7.5 | 7 |
| 101 | 0.2 | 12 |
| 102 | 4 | 8 |
| 103 | 5 | 9 |
Simple Regression Data
| contract # | safety training expenditure | lost time hours |
| 1116 | 1985.12 | 10 |
| 205 | 1500.00 | 30 |
| 2146 | 1126.46 | 40 |
| 1603 | 1294.10 | 40 |
| 914 | 1445.56 | 40 |
| 437 | 1112.47 | 50 |
| 598 | 1720.81 | 60 |
| 2801 | 1789.66 | 60 |
| 1420 | 1837.52 | 60 |
| 682 | 2000.00 | 60 |
| 714 | 2271.86 | 60 |
| 2336 | 1507.97 | 70 |
| 2216 | 1542.33 | 70 |
| 1327 | 1544.90 | 70 |
| 1025 | 1547.16 | 70 |
| 920 | 1567.55 | 70 |
| 465 | 1600.00 | 70 |
| 138 | 1452.69 | 80 |
| 1411 | 1500.00 | 80 |
| 1439 | 1500.00 | 80 |
| 2388 | 1326.60 | 90 |
| 1849 | 1351.25 | 90 |
| 1740 | 1380.69 | 90 |
| 1666 | 1423.57 | 90 |
| 1672 | 1095.58 | 100 |
| 2455 | 1132.88 | 100 |
| 403 | 1134.58 | 1
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. Do you need help with this question? Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems. WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations. With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Chat with us today! We are always waiting to answer all your questions. |