[Unlocked] Data Analysis Using Microsoft

[Unlocked] Data Analysis Using Microsoft

  Reference – Uploaded – Sun Coast.pdf

Describe the Sun Coast data (SunCoastDataFiles_StudentGuide.xlsx) using the descriptive statistics tools . Establish whether assumptions are met to use parametric statistical procedures. Repeat the tasks below for each tab in the (Uploaded – SunCoastDataFiles_StudentGuide.xlsx). Utilize the template (Uploaded – Unit IV – Template.pdf)

You will conduct the data analysis using Microsoft Excel Toolpak. View these links for information: https://support.office.com/en-us/article/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4 and 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.

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.