{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]

Foundations of Business Analysis

Data Analysis Report
Business Analysis: Employee Satisfaction
Newcastle Ltd is a medium-sized business with 3000 employees across Australia. The
business specialises in the production and sale of safety devices for the mining industry.
Debra Smith has just been appointed as the new CEO of Newcastle Ltd. One of Debra’s
initial strategic goals for the business is to build and maintain a high level of employee
satisfaction, as she views this as an important way to maximise productivity. To that end,
Debra has approached you to undertake a study that investigates the current level of
satisfaction within the organisation and whether that satisfaction differs across individuals
and divisions. As a benchmark, Debra believes that the minimum level of employee
satisfaction required to maximise efficiency is 7 out of 10.
Debra is willing to allocate funds towards improving employee satisfaction if required, but
she wants to know the most efficient way to allocate this money. She has already
commissioned an initial exploratory report, which has identified several possible initiatives
that can be used to improve employee satisfaction, including: paying additional wages or
bonuses, improving staff training and development opportunities, providing work social
events and improving employee benefits by decreasing their overtime requirements. Debra
is interested to know which of these strategies would be most effective to increase the
satisfaction of Newcastle Ltd employees.
A member of your team has already collected data that can be used for this analysis. To
collect this data, a random sample of 100 employees was selected from each of the five
divisions within Newcastle Ltd: accounting, administration, marketing, human resource
management and production. Of the 500 employees that were sent surveys, 400 responded.
The survey used to collect this data is provided below and the survey responses have been
collated in the Satisfaction.xls Excel file. You are required to write a report after performing
analysis on data collected from the employees of Newcastle Ltd.
A member of your team has suggested that when you perform this analysis, you should
undertake a series of hypothesis tests to examine the following:
1.  Does the current level of overall employee satisfaction differ from Debra’s goal of
2.  Is there a difference between the overall employee satisfaction of male and female
employees within the business?
3.  Are there any differences in the overall employee satisfaction across business
4.  Are there any differences in the gender compositions across divisions?

5.  Is there a relationship between an employee’s years of service and their overall
6.  Do employees who are employed on a different basis (casual, part-time, full-time)
have different perceptions about how they are valued within the organisation?
7.  Is there any difference between the importance that employees place on their
income and their training and development opportunities?
8.  Is there any difference between the importance that employees place on work social
events and the number of hours that they work?
9.  Is there a relationship between an employee’s salary and their overall satisfaction?
10. Which of the determinants of employee satisfaction (Questions 10-13) are related to
the overall satisfaction of Newcastle Ltd employees?
Write a data analysis report that provides the results to each of the ten hypothesis tests
above and make overall recommendations to the business that Debra can use for future
business decision making. Based on your analysis relating to these hypotheses, your report
should focus on two key questions: the current employee satisfaction within the business
and the strategy or strategies that would be most effective to increase employee

Employee Satisfaction Survey

Section 1: Personal information

Please complete the following information about yourself and your current employment.
Question 1 – Which department of the organisation do you work in?
Accounting                 Marketing               HRM                 Production                Administration
Question 2 – What is your gender?
Male                            Female
Question 3 – On what basis are you employed with the organisation?
Casual    Part-time         Full-time
Question 4 – How many years have you worked with the organisation? _____________________
Question 5 – What was your total taxable income for the 2013/2014 financial year? ___________

Section 2: Current Employee Satisfaction

Please circle the number that corresponds with your level of agreement.
Strongly Disagree = 1   Neutral = 5   Strongly Agree = 10
Question 6 – Overall, I am satisfied as an employee of Newcastle Ltd.
1  2  3  4  5  6  7  8  9  10

Question 7 – My pay is competitive with other places I could work.
1  2  3  4  5  6  7  8  9  10

Question 8 – I feel that I am valued within the organisation.
1  2  3  4  5  6  7  8  9  10

Question 9 – I agree with the strategic goals of the organisation.
1  2  3  4  5  6  7  8  9  10

Section 3: Determinants of Employee Satisfaction

Please circle the number that corresponds with your level of agreement.
Strongly Disagree = 1   Neutral = 5   Strongly Agree = 10
Question 10 – I am satisfied with my salary.
1  2  3  4  5  6  7  8  9  10

Question 11 – I am satisfied with the training and career development opportunities are available
within the organisation.
1  2  3  4  5  6  7  8  9  10

Question 12 – I am satisfied with social events that are provided within the workplace.
1  2  3  4  5  6  7  8  9  10

Question 13 – I am satisfied with the number of hours I am required to work each week.
1  2  3  4  5  6  7  8  9  10

Report Structure
Executive Summary
This section should provide a brief overview of the data analysis report. You should discuss the
subject matter, the method of analysis, the findings and recommendations and any limitations of the
report. It is suggested that the Executive Summary is the last section that you write. This section
should be 200 words maximum.
Provide a brief background to the case to put your analysis in context. Provide a discussion of the
objectives of your analysis. This section should be 150 words maximum.
Research Design
Discuss the data collection process and the sampling procedures that were applied. In this section
you should also outline the ethical considerations that would have been taken into account when
collecting data from this survey and reporting your results. This section should include references
from at least three credible sources, such as textbooks or journal articles. The research design
section should be 300 words maximum
Synthesise the hypothesis test results as they relate to the two key research questions. Report the
conclusions that can be derived from this analysis. This section should be 300 words maximum.
Briefly summarise your results and provide recommendations to Newcastle Ltd. Bullet points can be
used for the recommendations. This section should be 150 words maximum.
Appendix: Hypothesis Testing
For each hypothesis you should:
a)  State the null and alternative hypotheses.
b)  Select an appropriate statistical test and briefly justify your selection.
c)  Perform the appropriate test using Microsoft Excel.
d)  Report the results of your analysis (including test statistic and p-value).
e)  Provide a brief interpretation (both statistical and non-statistical) of the results.
Each hypothesis should be discussed in approximately 100 words. An example is provided below.

Hypothesis Testing Example (Based on previous assignment)
Question 1) How much are potential patrons willing to pay for the entrées? Is the $18 amount from
the forecasting model the correct value to use when setting food prices?
Appendix 1: Average patron expenditure
H0: The average amount patrons are willing to spend is equal to $18
: The average amount patrons are willing to spend is not equal to $18
A one sample t-test is used, as this is the appropriate test to compare the difference between one
variable and a pre-determined mean (Zikmund et al., 2013, p. 520). The results from this one-sample
t-test are shown below:
Table 1: One-sample t-test for difference in patron expenditure

Variable 1  Variable 2
Mean  20.14118  18
Variance  91.85022  0
Observations  340  340
Hypothesized Mean
Difference  0
df  339
t Stat  4.119569
P(T<=t) one-tail  2.39E-05 t Critical one-tail  1.649361 P(T<=t) two-tail  4.77E-05 t Critical two-tail  1.966986 From Table 1, it is evident that we can reject that null hypothesis that the average patron is willing to pay $18 for their entrée (p-value 0.0000477). As the average expenditure is greater than $18 ($20.14), this value should be used when pricing food in the restaurant. PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂

Sample Answer

Compelling correspondence is essential to the achievement all things considered but since of the changing idea of the present working environments, successful correspondence turns out to be more troublesome, and because of the numerous impediments that will permit beneficiaries to acknowledge the plan of the sender It is restricted. Misguided judgments.In spite of the fact that correspondence inside the association is rarely completely open, numerous straightforward arrangements can be executed to advance the effect of these hindrances.

Concerning specific contextual analysis, two significant correspondence standards, correspondence channel determination and commotion are self-evident. This course presents the standards of correspondence, the act of general correspondence, and different speculations to all the more likely comprehend the correspondence exchanges experienced in regular daily existence. The standards and practices that you learn in this course give the premise to additionally learning and correspondence.

This course starts with an outline of the correspondence cycle, the method of reasoning and hypothesis. In resulting modules of the course, we will look at explicit use of relational connections in close to home and expert life. These incorporate relational correspondence, bunch correspondence and dynamic, authoritative correspondence in the work environment or relational correspondence. Rule of Business Communication In request to make correspondence viable, it is important to follow a few rules and standards. Seven of them are fundamental and applicable, and these are clear, finished, brief, obliging, right, thought to be, concrete. These standards are frequently called 7C for business correspondence. The subtleties of these correspondence standards are examined underneath: Politeness Principle: When conveying, we should build up a cordial relationship with every individual who sends data to us.

To be inviting and polite is indistinguishable, and politeness requires an insightful and amicable activity against others. Axioms are notable that gracious “pay of graciousness is the main thing to win everything”. Correspondence staff ought to consistently remember this. The accompanying standards may assist with improving courtesy:Preliminary considering correspondence with family All glad families have the mystery of progress. This achievement originates from a strong establishment of closeness and closeness. Indeed, through private correspondence these cozy family connections become all the more intently. Correspondence is the foundation of different affiliations, building solid partners of obedient devotion, improving family way of life, and assisting with accomplishing satisfaction (Gosche, p. 1). In any case, so as to keep up an amicable relationship, a few families experienced tumultuous encounters. Correspondence in the family is an intricate and alluring marvel. Correspondence between families isn’t restricted to single messages between families or verbal correspondence.

It is a unique cycle that oversees force, closeness and limits, cohesiveness and flexibility of route frameworks, and makes pictures, topics, stories, ceremonies, rules, jobs, making implications, making a feeling of family life An intelligent cycle that makes a model. This model has passed ages. Notwithstanding the view as a family and family automatic framework, one of the greatest exploration establishments in between family correspondence centers around a family correspondence model. Family correspondence model (FCP) hypothesis clarifies why families impart in their own specific manner dependent on one another ‘s psychological direction. Early FCP research established in media research is keen on how families handle broad communications data. Family correspondence was perceived as an exceptional scholastic exploration field by the National Communications Association in 1989. Family correspondence researchers were at first impacted by family research, social brain science, and relational hypothesis, before long built up the hypothesis and began research in a family framework zeroed in on a significant job. Until 2001, the primary issue of the Family Communication Research Journal, Family Communication Magazine, was given. Family correspondence is more than the field of correspondence analysts in the family. Examination on family correspondence is normally done by individuals in brain science, humanism, and family research, to give some examples models. However, as the popular family correspondence researcher Leslie Baxter stated, it is the focal point of this intelligent semantic creation measure making the grant of family correspondence special. In the field of in-home correspondence, correspondence is normally not founded on autonomous messages from one sender to one beneficiary, yet dependent on the dynamic interdependency of data shared among families It is conceptualized. The focal point of this methodology is on the shared trait of semantic development inside family frameworks. As such, producing doesn’t happen in vacuum, however it happens in a wide scope of ages and social exchange.

Standards are rules end up being followed when performing work to agree to a given objective. Hierarchical achievement relies significantly upon compelling correspondence. So as to successfully impart, it is important to follow a few standards and rules. Coming up next are rules to guarantee powerful correspondence: clearness: lucidity of data is a significant guideline of correspondence. For beneficiaries to know the message plainly, the messages ought to be sorted out in a basic language. To guarantee that beneficiaries can without much of a stretch comprehend the importance of the message, the sender needs to impart unmistakably and unhesitatingly so the beneficiary can plainly and unquestionably comprehend the data.>

Our customer support team is here to answer your questions. Ask us anything!