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

Write a article critique on corporate social responsibility

Write a article critique  about the Corporate social responsibility. why have stakeholders given CSR more attention in recent years? Would you give CSR a significant portion

The information technology senior analyst

You are the information technology senior analyst at your company. Your company can be a real business where you work or a virtual business that you would like to start. In ei

How it is impacting the business processes of e-business

Discuss how IT is impacting the business processes and applications of e-Business? How does the system development life cycle (SDLC) assist in accomplishing essential tasks

Describe some of possible risks to the store security system

Draft a security policy that addresses the risks, identifies security goals, and discusses strategies for achieving those goals. Discuss some of the ethical and potential leg

Explain the systems development life cycle

Explain the systems development life cycle and how it is used in HCIT. Examine the role of a health care manager in a typical IT project. Compare the project management life c

Report on poor or insufficient availability of services

ISIT302/MTS9302 Corporate Network Management Assignment Instructions. Are there formal procedures that enable staff to report on poor or insufficient availability of services

Explain why is it surprising that money markets exist

Money market environment - Explain Why is it surprising that money markets exist? Why do they exist nonetheless? What factors explain the relative size of money markets in d

Have you ever encountered a filter bubble

What are you thoughts about companies collecting data about you? Do you feel this type of data collection is a beneficial or detrimental? Why? Do you feel you have a right t

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

 
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