Assignment - Analytical Case Study

Assignment Help Other Subject
Reference no: EM132569275

Assignment - Analytical Case Study

In this assignment, you will examine employment data obtained through a survey of business school graduates undertaken by a university placement office. The data is contained in the file Survey_of_graduates.xls and contains the following columns (variables):

Variable

Description

Area

Area of employment: 1 = Accounting, 2 = Finance, 3 = General management, 4 = Marketing/Sales, 5 = Other

Gender

1 = Female, 2 = Male

Satisfaction

Job satisfaction: 4 = very, 3 = quite, 2 = little, 1 = none

Search

Number of weeks job searching

Salary

$thousands

Random Sample

Before you begin your analysis, you are required to take a random sample of size 150 from the 253 cases in the file. Use the file Sample-Generator.xls to do this. Your Lecturer will show you how this can be done in EXCEL. Your answers to the questions below are to be based on your sample of 150 cases. Make sure to keep a safe copy of your sample since you cannot use Sample-Generator to reproduce the first sample.

Provide a printout of the data in your sample, with ID numbers in ascending order.

Task 1: Variable List

1. Using the variables listed in the table above, Describe each variable.

2. State for each variable whether it is qualitative or quantitative; if it is qualitative, state whether it is nominal or ordinal, and if it is quantitative, state whether it is discrete or continuous.

Task 2: Histogram

3. Create a histogram showing the distribution of salaries. Find the 5-number summary of the distribution of salaries. Comment upon the shape of the distribution: is it symmetric? If it is not, is it positively or negatively skewed? Are there any outliers present? If so, are they of particular interest? State which central measure would be best to use to describe the centre of this distribution, and the reason(s) why?

Task 3: Descriptive Statistics

Prepare a simple summary table that shows the average and standard deviation of salary for the five work areas. Construct side-by-side boxplots for the salaries. Briefly comment upon any differences you observe in salaries for each work site.

Task 4: Pivot Table and Bar Chart

4. Construct a pivot table that shows satisfaction for each area of employment. Place satisfaction in the rows, area in the columns and a count of job satisfaction in the body of the table. Obtain a second pivot table by converting the frequencies in each column into relative frequencies in each column (right click on any number in the table, then choose Summarize Values as % of column totals).

If the business school graduate wanted to get most satisfaction from their job, based on the information in the table, which area of employment should they choose?

Construct a bar chart comparing the distribution of males and females in all areas of employment.

Do employment areas differ in percentage of female/male graduates? If yes, how?

Conclusion:

5. From the tasks above, you should have some idea of the employment of business school graduates. In this section, you should write a short paragraph summarising your main findings.

Attachment:- Analytical Case Study Assignment Files.rar

Reference no: EM132569275

Questions Cloud

Did you use the apostrophe correctly : Did you use the apostrophe correctly? Please explain.
Do you agree with this attitude : Socrates said to his jurors, "Are you not ashamed that, while you take care to acquire as much wealth as possible
Prepare the journal entry to record transaction for dilawar : If Dilawar exercises the call provision and retires one-third of the bond issue on July 1, Year 3. Prepare the journal entry to record this transaction
Difference between hearing and listening to music : Using Beethoven's "Eroica", discuss, the difference between "hearing" and "listening to" music.
Assignment - Analytical Case Study : Assignment - Analytical Case Study. Task 1: Variable List. Using the variables listed in the table above, Describe each variable
Determine the actuarial gain or loss : Determine the actuarial gain or loss from the defined benefit plan. The net defined benefit obligation at 31 March 2020 was £8 million.
Examples of fallacy : Examples of each fallacy and explain what makes it that fallacy. I am struggling with fallacies so bad.
Determining the humanities resources : My main resource for my research was the Shapiro Library, some lived experiences, along with of course some Google search.
Determine the impairment loss and show clearly : Determine the impairment loss and show clearly how the loss should be accounted for in 2020 in Entity C. Explain all the relevant accounting issues

Reviews

len2569275

7/10/2020 5:52:24 AM

Attached files are questions for this assignment excel part is data for this assignment so have to continue in this excel file to complete assignment, so please go through this question and please confirm that u will be able to complete assignment and also please make sure you show the formulas that you use to solve problems in word file while explaining this assignment. Thank you.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd