DESCRIPTIVE STATISTICS AND VISUAL DISPLAYS

Module 1 – Case

DESCRIPTIVE STATISTICS AND VISUAL DISPLAYS

Assignment Overview

Professional Application with Excel

**Complete Module 1 SLP before Module 1 Case**

Critical thinking and analysis are valuable skills for professionals in any industry. Exploring data can include financials, sales figures, benchmarks, or survey results. While data is everywhere, it is meaningless unless we can use it to support decision-making.

Tables, graphs, and output from Excel may be non-sensical. This is where the analyst comes in; their knowledge and expertise are used to interpret results. If a visual or output cannot be easily explained, then it may not be useful.

Case 1 Resources
Load the Analysis ToolPak in Excel
Available chart types in Office
Analyze Data in Excel
Differences between histograms and bar charts
How to Label Figures in APA Format

Case Assignment

Industry Research and Analysis with Excel

Research the industry listed in the Excel sheet. Using a US Industry Report in IBISWorld’s Industry Research, provide a one-page background of the industry. Find a balance between explanations, data and statistics provided. You must decide what information should be included in this section.

(IBISWorld required) This section must be one page in length.

Next, create a histogram for each of the four survey measures. Describe the skew and spread. Make connections between analysis of each histogram and the “descriptives” from Module 1 SLP. Using research on the state of the industry, provide rationale for the results. (Research support required)

Finally, use Analyze Data in Excel. Select three of the suggestions and add them to this report.

  • Insert Chart in Word.
  • Describe the findings. Link to information from “descriptives.”
  • Discuss implications for the industry. (Make connections with the from IBISWorld).
Case 1 Assignment Guidance Files
BUS520 Case 1 Assignment Video Guidance BUS520 Case 1 Assignment Guide

No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.

This is the Data set that will be used for class.

**********A NEW SET OF DATA AND INDUSTRY ARE USED EACH SESSION**********

If you procure old assignments from students or websites and use the data for your assignment, you will receive a zero because it is considered a violation of the University’s academic integrity policy. The case will be referred and become part of your collegiate record. In certain circumstances, you may be awarded an F for the .

If you are taking this class for a second time, submission of past work involving the data sets will result in a zero for the assignment. Your answers will be wrong since you are working with a different set of numbers and a different industry.

**********A NEW SET OF DATA AND INDUSTRY ARE USED EACH SESSION**********

Assignment Expectations

Use the attached APA-formatted template (BUS520 Case1) to create your .

The template is set up in APA 7: double-spacing, font, margins, headings, page breaks, APA help links.

Your submission will include:

  • Trident University International’s cover page
  • A paper with APA citations (2- to 3-sentence introduction, body (includes Excel output), 2- to 3-sentence conclusion)
  • The reference list page in APA format
  • Excel Spreadsheet. Grade will not be posted without Excel upload.
Stuck With A Lot Of Homework Assignments And Feeling Stressed ? Take Professional Academic Assistance & Get 100% Plagiarism Free Papers

Get Help By Expert

For students who are struggling with essay writing, we can be a lifesaver. We offer essay writing help for students of all levels, from elementary school to college. Our team of experienced assignment writers can help you with any type of essay, from persuasive essays to comparative essays. So if you're struggling with essay writing, don't hesitate to contact us for assistance.

Answer

Looking For Plagiarism Free Answers For Your College/ University Assignments.

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Get Your Custom Answer Now