Homework answers / question archive / G163 Essential Statistics and Analytics – Course Project Option 1   Introduction: As a professional in the real world, you will need to research and understand various aspects of Business applications

G163 Essential Statistics and Analytics – Course Project Option 1   Introduction: As a professional in the real world, you will need to research and understand various aspects of Business applications

Statistics

Share With

---

G163 Essential Statistics and Analytics – Course Project Option 1

 

Introduction:

As a professional in the real world, you will need to research and understand various aspects of Business applications.  Basic statistical analysis can be used to gain an understanding of current problems.  This course project will assist you in applying basic statistical principles to a fictional scenario in order to impact the clients being served.  

 

Your Course Project will be completed in phases throughout the course.  As you gain additional knowledge through the didactic portion of this course, you will be able to apply your new skills to this project.  You will receive formative feedback from your instructor on each submission.  The final project will be due in Module 05.  

 

Scenario: Salary Distributions

A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $40,000 to $120,000 per year.  As a Business Analyst your boss asks you to research and analyze the salary distributions.  You are given a spreadsheet that contains the following information:

• A listing of the jobs by title
• The salary (in dollars) for each job

 

The client needs the preliminary findings right away. Time to get to work!!!!

Background information on the Data:

The data set consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $40,000 to $120,000 for the state of Minnesota.

 

Remember, this project will be completed over the duration of the course. The requirements for each assignment are as follows:

 

Instructions for Each Assignment in the Course Project

 

 

Your analysis of this data set should include the following:

 

1. Introduce your scenario and data set.
   1. Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.
   2. Classify the variables in your data set.
      1. Which variables are quantitative/qualitative?
      2. Which variables are discrete/continuous?
      3. Describe the level of measurement for each variable included in your data set.

 

2. Summarize and graph your data.
   1. Choosing one of the quantitative variables from your data set, construct a frequency distribution that has a minimum of 5 classes (please do not include more than 10 classes). The frequency distribution should contain the following columns:
      1. Lower and Upper Class Limits
      2. Frequencies
      3. Class Boundaries
      4. Midpoints
      5. Relative Frequencies
      6. Cumulative Frequencies
   2. Interpret the results of your frequency distribution in context of your chosen scenario.
   3. Using the same variable from your frequency distribution, construct a histogram.
      1. Summarize the results of your histogram.
         1. Discuss the construction of your histogram.
            • What values were used on the horizontal and vertical axes?
            • What does the height of the bars represent?
            • What is the shape of the distribution?
         2. Interpret the results of your histogram in context of your chosen scenario.

 

3. Conclusion
   1. Recap your ideas by summarizing the information presented.

 

This assignment should be formatted using APA guidelines and be a minimum of 2 pages in length.