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 pro Business & Finance Descriptive Statistics AnalysisDescribe 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 theUnit IV Scholarly Activity template.You will utilize the Microsoft Excel ToolPak. The links to the ToolPak are in theExcel 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.Unit IV TemplateInsert Title HereInsert Your Name HereInsert University HereCourse Name HereInstructor NameDateData Analysis: Descriptive Statistics and Assumption TestingDescribe 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 TestingFrequency Distribution TableInsert frequency distribution table here. Cut and paste from Excel.HistogramInsert histogram here. Cut and paste from Excel.Descriptive Statistics TableInsert table here. Cut and paste from Excel.Measurement ScaleDiscuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).Measure of Central TendencyDiscuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).Skewness and KurtosisDiscuss skewness and kurtosis and whether they are within acceptable ranges.EvaluationIn 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 TestingFrequency Distribution TableInsert frequency distribution table here. Cut and paste from Excel.HistogramInsert histogram here. Cut and paste from Excel.Descriptive Statistics TableInsert table here. Cut and paste from Excel.Measurement ScaleDiscuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).Measure of Central TendencyDiscuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).Skewness and KurtosisDiscuss skewness and kurtosis and whether they are within acceptable ranges.EvaluationIn 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 TestingFrequency Distribution TableInsert frequency distribution table here. Cut and paste from Excel.HistogramInsert histogram here. Cut and paste from Excel.Descriptive Statistics TableInsert table here. Cut and paste from Excel.Measurement ScaleDiscuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).Measure of Central TendencyDiscuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).Skewness and KurtosisDiscuss skewness and kurtosis and whether they are within acceptable ranges.EvaluationIn 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 SamplestTest: Descriptive Statistics and Assumption TestingFrequency Distribution TableInsert frequency distribution table here. Cut and paste from Excel.HistogramInsert histogram here. Cut and paste from Excel.Descriptive Statistics TableInsert table here. Cut and paste from Excel.Measurement ScaleDiscuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).Measure of Central TendencyDiscuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).Skewness and KurtosisDiscuss skewness and kurtosis and whether they are within acceptable ranges.EvaluationIn 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)tTest: Descriptive Statistics and Assumption TestingFrequency Distribution TableInsert frequency distribution table here. Cut and paste from Excel.HistogramInsert histogram here. Cut and paste from Excel.Descriptive Statistics TableInsert table here. Cut and paste from Excel.Measurement ScaleDiscuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).Measure of Central TendencyDiscuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).Skewness and KurtosisDiscuss skewness and kurtosis and whether they are within acceptable ranges.EvaluationIn 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 TestingFrequency Distribution TableInsert frequency distribution table here. Cut and paste from Excel.HistogramInsert histogram here. Cut and paste from Excel.Descriptive Statistics TableInsert table here. Cut and paste from Excel.Measurement ScaleDiscuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio).Measure of Central TendencyDiscuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode).Skewness and KurtosisDiscuss skewness and kurtosis and whether they are within acceptable ranges.EvaluationIn 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.ReferencesInclude references here using hanging indentations.Creswell, J. W., & Creswell, J. D. (2018).Research design: Qualitative, quantitative, and mixed methods approaches(5th ed.). SAGE.Excel ToolpakLinkYou 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-6b40ba1a66b4https://www.excel-easy.com/data-analysis/analysis-toolpak.html Continue to order Get a quote Post navigation Are Gary Hirshberg’s “hard-headed” conclusions little more than moral platitudes or are they really hard-earned, practical, positive (e.g., what is), and normative (e.g., what should be) lessons on ho