Estimate of the proportion of employees

Assignment Help Management Information Sys

Reference no: EM132183781

Background

This is an individual assignment, which requires you to analyse a dataset, interpret the results and then report your findings to a person with little or no knowledge of statistical data analysis.

Scenario

Osmidium is an American car parts manufacturer with a factory in Adelaide which employs 2,000 people. The company wishes to study its full-time workforce by developing an employee profile that measures factors such as salary, job satisfaction, and career progress.

You will be playing the role of Alicia Stats, a Senior Analyst at the company. Senior management of Osmidium has asked you to conduct a survey of their employees. You decide to take a random sample of 450 staff and conduct the survey via company internal mail. The results are saved in the data set "AusNetData.xlsx".

Vito Genovese, Human Resources Manager at Osmidium, has written to you regarding the Osmidium employee survey. His letter to you is reproduced below.

Regarding the recently collected data from the Osmidium employee survey, please provide me with answers to the following questions. Your responses will assist our department in constructing the employee profile required by senior management.

1. Please provide an overall summary of employees' hours worked per week.

2. Please provide an estimate of the proportion of employees who are very likely to stay in their job.

3. Senior management is also interested in how hours worked is related to gender. Does there appear to be any relationship between an employee's hours worked and their gender?

4. Can you please provide an overall summary of how Osmidium employees rated their relations with the management?

5. Senior management is interested in which numerical variables, if any, seem to influence an employee's hours worked. Please provide a summary of these relationships ifany.

Please present your written findings in a report (no more than two pages), with an appendix (no more than eight pages) containing the results of your analysis, by no later than 6.00pm, Sunday 9th December 2018.

Part 1: Data Analysis

To prepare a reply to the manager's letter, you will need to use Excel to analyse the data set "AusNetData.xlsx". You will find this file on Moodle.

You will need to apply techniques you have learned during lectures and tutorials in Weeks 1 to 3 such as:
- tables
- graphs, and
- summary measures.

You may initially produce more Excel output than you need, so you will only need to copy and paste the relevant output from these worksheets to a ‘Results' worksheet. Keep in mind the page limit of 8 printed pages for the analysis AND that the presentation of the results will be marked too!

GUIDELINES

The manager has asked for a number of tasks to be done. The following guidelines for each question should be followed:

1. Please provide an overall summary of employees' hours worked per week.
You will need to use numerical analysis methods to summarise overall hours worked. In the report, you will also need to write about averages, variability etc. as presented in the examples in the relevant lecture and tutorial.

2. Please provide an estimate of the proportion of employees who are very likely to stay in their job. You will need determine the variable type and hence what methods you should use to provide this estimate.

3. Senior management is also interested in how hours worked is related to gender. Does there appear to be any relationship between an employee's hours worked and their gender?
You will need to focus on whether there is a difference or not. If yes, make sure you describe them. If not, you should explain why you think there is no difference.

4. Can you please provide an overall summary of how Osmidium employees rated their relations with the management?
You will need to use categorical analysis methods to summarise the variable. In the report you also need to briefly describe your findings. Examples can be found in the relevant lecture and tutorial.

5. Senior management is interested in which numerical variables seem to influence an employee's salary. Please provide a summary of these relationships if any.

Once more you will need to use techniques for the analysis of two variables. You will need to analyse six
(6) numerical relationships. In each case, the type of the relationship - if there is one - and its direction and strength are of interest. Make sure you comment on what you find in each case.

Part 2: Report (that is, your reply to the Manager's letter)
Write a letter to the manager, explaining essential information and conclusions from your data analysis. You are allowed no more than two pages to convey your written findings.

- Keep the English simple and the explanations brief.
- Avoid the use of technical statistical terminology. Your reader will not necessarily understand even simple statistical terms, thus your task is to explain your analysis using plain, understandable language.

Assignment Checklist:

Part 1 (Data Analysis)
1. Have you applied the correct analysis techniques?
2. Is the analysis in the same order as the manager's requests?
3. Is every table and every graph clearly labelled?
4. Are there tables or graphs that are broken across 2 pages? (If yes, make sure you change that!)
5. Is the analysis output no more than 8 pages long?

Part 2 (Report)
1. Is your report written in plain language?
2. Is it free of grammar and spelling mistakes?
3. Is it free of technical language?
4. Is it free of Excel output (tables, graphs)?
5. Are the answers numbered and in the same order as the manager's requests?
6. Is the report no more than 2 pages long?

Attachment:- Business Analytics.rar

Reference no: EM132183781

Questions Cloud

Impact of the layoff in employees : What will you do to minimize the impact of the layoff in employees?

What is the minimum variance portfolio : FIN 3300 Investments Assignment - Risk/Return Trade-off (Markowitz Efficient Frontier), University of Denver, USA. What is the minimum variance portfolio

Briefly describe the creator of the document : Briefly describe the creator of the document. (To answer this question, you may need to use information obtained from the introduction to the source).

Explain the differences between call and puts : Explain the differences between call and puts, not just in definition, but in actual workings of the option, price changes, time value, the Greeks,

Estimate of the proportion of employees : MIS171 Business Analytics - Deakin University - Does there appear to be any relationship between an employee's hours worked and their gender

Describe what score you made and why you think you got : Describe what score you made and why you think you got the score.

Business press about major action taken by corporation : Read an article in the business press about a major action taken by a corporation. The Economist or Harvard Business Review, to name a few.

When and where was the document created : When and where was the document created? (Again, you may need to use information obtained from the introduction to the source, or other course materials.

What benefits does leasing offer compared to the purchase : Compare and contrast two types of leases and describe the advantages and disadvantages of each. Which type of lease would produce the lowest risk?

Reviews

len2183781

12/2/2018 11:22:56 PM

PART 2 : MEMORANDUM CONTENT Marks Available Marks Allocated Excellent Good OK Needs Work Poor 5 Provided an excellent Most of your summary was Your summary was OK. Some of your Generally a poor summary of all aspects well written. However, you have explanations were OK. summary.You may have in non-technical language. either missed explaining some However, you have generally not provided a used technical terms or your descriptions may be aspects or have not concise and accurate confusing or poorly provided a clear summary. structured. enough summary.

len2183781

12/2/2018 11:22:44 PM

5. Excellent Good OK Needs Work Poor 3 All scatter diagrams Most of the analysis was of Some of the analysis Some of your output Generally poor analysis included correct trend a high standard. Some of was well done. was OK. However, you with either numerous lines/curves, showed your scatter diagrams may However you have have a number of errors or incorrect the corresponding R^2 have included some small made a number of mistakes in your scatter techniques used or value, and had the mistakes. mistakes. E.g. put the diagrams or have missing results. Poor variables on the correct dependent/independent missing results. organisation of output. axes. variables on the wrong axis

len2183781

12/2/2018 11:22:35 PM

4. Excellent Good OK Needs Work Poor 1.5 Correct frequency table Most of the analysis was of Some of the analysis Some of your output Generally poor analysis which includes a high standard. Perhaps was well done. was OK. However, you with either numerous percentages. some small mistakes (eg. However there were may have used errors or incorrect

len2183781

12/2/2018 11:22:27 PM

3. Excellent Good OK Needs Work Poor 3 Comparative summary Most of the analysis was of Some of the analysis Some of your output Generally poor analysis measures calculated a high standard. Some of was well done. was OK. However, you with either numerous correctly, suitable your output may have However there were have made a number of errors or incorrect tables and graphs used. No irrelevant contained small mistakes or could be improved. Results either a few errors in your analysis OR you mistakes or have missing results. techniques used or missing results. Poor output and results very were well organised. had missing analysis. Organisation of output organisation of output. well organised. may need improvement.

len2183781

12/2/2018 11:22:20 PM

2. Excellent Good OK Needs Work Poor 1.5 Sample proportions Most of the analysis was of Some of the analysis Some of your output Generally poor analysis with counts calculated a high standard. Some of was well done. was OK. However, you with either numerous correctly. No irrelevant your output may have However there were have made a number of errors or incorrect output and results very well organised. contained small mistakes or could be improved. Results either a few errors in your analysis OR you mistakes or have missing results. techniques used or missing results. Poor Appropriate chart were well organised. had missing analysis. Organisation of output organisation of output. may need improvement.

len2183781

12/2/2018 11:22:12 PM

T3 2018 MIS171/MISP171: Business Analytics - Assignment 1 1. Student-ID Names PART 1 DATA ANALYSIS Marks Available Marks Allocated Excellent Good OK Needs Work Poor 3 All summary measures Most of the analysis was of Some of the analysis Some of your output Generally poor analysis calculated correctly, a high standard. Some of was well done. was OK. However, you with either numerous suitable tables and your output may have However there were have made a number of errors or incorrect graphs used. No contained small mistakes or either a few errors in mistakes or have techniques used or irrelevant output and could be improved. Results your analysis OR you missing results. missing results. Poor results very well were well organised. had missing analysis. Organisation of output organisation of output. organised. may need improvement

len2183781

12/2/2018 11:21:49 PM

Both parts may be contained in a single file, but their content must be separated. That is, you will submit one document only. The electronic submission will consist of two parts. Failure to separate Part 1 and Part 2 will be penalised. The Assignment must be submitted electronically and 10% of available marks will be deducted for late

len2183781

12/2/2018 11:21:25 PM

You DONOTneed toperformanyadditionalanalysisotherthan whatyouhavelearned inweeks 1, 2 and 3 though doingsomayattractadditionalmarksbutonlyifappropriateandinformative. You may initially produce more Excel output than you need, so you will only need to copy and paste the relevant output from these worksheets to a ‘Results’ worksheet. Keep in mind the page limit of 8 printed pages for the analysis AND that the presentation of the results will be marked too!

Write a Review

Required(*) Message

Management Information Sys Questions & Answers

Database management approach over file processing

Compare the advantages of a database management approach over file processing approach for storing large amounts of data

Explain why it projects are less likely to be delivered

Explain why IT projects (such as Web site development or redesign) are less likely to be delivered on time and within budget than large building construction pr

Explain how health care organizations use secondary data

Write a paper comparing and contrasting the collection of secondary data and their uses versus the analysis of current health care records and internal data such as incident reports and patient surveys. Explain how health care organizations use se..

Analyzes how the messages within the digital media

create a presentation (using an application like PowerPoint) which interprets and analyzes how the messages within the digital media were used to guide decision-making.

Describe what is meant by the internet of things

Describe what is meant by the "Internet of Things". What industries are most likely to use Internet of Things technology?

How many workers should be involved in this study

Construct a 95% confidence interval. (You don't need to check the conditions again, but calculate the CI and interpret it in context).

Computer security softwareby using computer security

computer security softwareby using computer security software and hacker tools to protect company systems employees

What if anything should we do about this blog entry

How much time and effort should an information technology (IT) department devote to scanning for and analyzing emerging technologies

Illustrate the possible placement of server including access

Business analytics gives companies the ability to look at past realizations and performance as well as set up new expectations and performance goals.

What is the real exchange rate and what is stagflation

On a correctly labeled graph, show AD, SRAS, LRAS, actual GDP, potential GDP and the equilibrium price level - government increases its spending by making three new Star Trek movies - On a graph, show the effect on AD, SRAS, LRAS, actual GDP, potent..

Create a network architecture diagram

Create a network "architecture" diagram representing your home network (presuming each of you have Internet access from home).

Install and run an existing tool for developing the idea

For this task, you need to ?nd, download, install, and run an existing tool for developing the idea/solution/concept you de?ned in the previous task.

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!

Submit Assignment

User Account

All Pages