Saint Leo University Purpose of Assignment Paper

Saint Leo University Purpose of Assignment Paper

Integrity is one of the core values at Saint Leo University. Read Case 3: Real Sales or Wishful Thinking? nd discuss your thoughts. Is there an ethical issue in this situation that relates to integrity? If so, what is the issue, and how should it be addressed?

Purpose of Assignment

The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excelprior to the course start.

Assignment Steps

This assignment has an Exceldataset spreadsheet attached. You will be required to only do one of the three datasets.

Resource:Microsoft Excel, Statistics Concepts and Descriptive Measures Data Set

Downloadthe Statistics Concepts and Descriptive MeasuresData Set.

Chooseone of the following datasets to complete this assignment:

Consumer Food
Financial
Hospital

Answereach of the following in a total of 90 words:

For each column, identify whether the data is qualitative or quantitative.
Identify the level of measurement for the data in each column.
For each column containing quantitative data:
    Evaluate the mean and median
    Interpret the mean and median in plain non-technical terms
    Use the Excel =AVERAGE function to find the mean
    Use the Excel =MEDIAN function to find the median

For each column containing quantitative data:
    Evaluate the standard deviation and range
    Interpret the standard deviation and range in plain non-technical terms
    Use the Excel =STDEV.S function to find the standard deviation
    For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN function
Grading Guide
Content     Met     Partially Met   Not Met     Comments:
This assignment has an Excel dataset spreadsheet attached. Students will be required to do one of the three datasets only and submit.                  
Download the Consumer Food, Financial, or Hospital Excel Data Set.



Note:you have to work on only ONE dataset and not ALL.

Answereach of the following in a total 90 words:

For eachcolumn, identify whether the data is qualitative or quantitative.

Identify the level of measurement for the data in each column.

For each column containing quantitative data:

oEvaluate the mean and median

oInterpret the mean and median in plain non-technical terms

oUse the Excel =AVERAGE function to find the mean

oUse the Excel =MEDIAN function to find the median

For each column containing quantitative data:

oEvaluate the standard deviation and range

oInterpret the standard deviation and range in plain non-technical terms

oUse the Excel =STDEV.S function to find the standard deviation

For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excels =MIN function






        Total Available     Total Earned     
          3   #/3      




Writing Guidelines     Met     Partially Met   Not Met     Comments:
The paperincluding tables and graphs, headings, title page, and reference pageis consistent with APA formatting guidelines and meets course-level requirements.                  
Intellectual property is recognized with in-text citations and a reference page.                  
Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper.                  
Sentences are complete, clear, and concise.                  
Rules of grammar and usage are followed including spelling and punctuation.                  
          Total Available     Total Earned     
          2   #/2

Saint Leo University Purpose of Assignment Paper