Need Help ! PLEASE

StudyAcer homework Experts at a Glance, Save Time and Excel

Writer avatar
Dr.Emma

Rating: 5/5    Reviews 482

Success rate 96%

Completed projects: 783

Hello, I am Prof Writers, I am a bold, accurate, and experienced tutor committed to providing clients with high quality, original, and timely work. As a writer, proficiency in several disciplines in academic writing is necessary, and that is why I prioritize on delivering quality and appropriate work. Be assured that I will always follow the lai...

Writer avatar
Dr.JamesPhD

Rating: 4.9/5    Reviews 373

Success rate 96%

Completed projects: 592

Hello, I am a full-time professional freelance writer with over 6 years experience in academic writing. I have a PhD in Strategic Management and have done several projects in business management, marketing and other subjects. This experience has helped me reinforce my ability to work in various fields and handle simple and complex topics. I am a...

Writer avatar
Dr.Success

Rating: 5/5    Reviews 1326

Success rate 99%

Completed projects: 1976

Hello :) My name is Dr.Success, I've started on my path as a professional writer mostly by writing essays. However, in the years since then, I've written various other academic papers, from research works to book reviews. From Sydney to New York, there are hundreds of students all over the world that are happy with the services I've provided the...

Writer avatar
MarvellousTutor

Rating: 5/5    Reviews 371

Success rate 96%

Completed projects: 1173

Hi there! Im MarvellousTutor, your perfect author with huge writing experience in English, Art and Business. What? Need assignment on another subject? No worries: I can deal with anything! If you're dreaming of the reliable, responsible and always-on-time writer, here I am! I manage my time greatly, thus, your deadline is highly important for me...

Writer avatar
Prof_Stephen

Rating: 4.7/5    Reviews 891

Success rate 96%

Completed projects: 1136

Hello there! My name is Prof Stephen. I have been a full-time freelance researcher and writer for a period of over 6 years. I have successfully completed over 1000 projects and assignments. I have had a good professional relationship with my clients who always come back for more quality papers since I highly value quality, professionalism, and i...

Writer avatar
Prof.TzKelly

Rating: 4.9/5    Reviews 244

Success rate 97%

Completed projects: 479

I'm ProfTzKelly, talented wordsmith, grammar afficionado, and writing machine. I'm written everything from outlines to screenplays and book reviews to advanced research papers. All you have to do to be well on your way to a great grade is chat with me! I'm experienced in all major styles, including APA, MLA, Chicago, Harvard, and Vancouver. You ...

Writer avatar
ProfAcer

Rating: 5/5    Reviews 465

Success rate 98%

Completed projects: 852

Hey! My name is ProfAcer, and my goal is to help you to get through a tough period of your life. I've been a student, and I know that the amount of work some professors expect you to do can be unfair and overwhelming. And that's without even accounting for the job you probably have an active social life each student should have. There is no sham...

Writer avatar
ProfessorEunice

Rating: 4.9/5    Reviews 412

Success rate 99%

Completed projects: 719

In academic writing, quality, originality, and deadlines are vital, and these are my primary offerings to all my clients. I have two years of experience as a full-time academic writer, with over 300 finance, economics, marketing, business, and general papers written from scratch. Since joining this site, I have also tackled sociology, healthcare...

Writer avatar
Think_Tank

Rating: 4.8/5    Reviews 319

Success rate 96%

Completed projects: 584

Hello! People call me ThinkTank, and I've been earning money as an academic writer for years. With a lot of works under my belt, you can bet that I've dealt with dozens of various topics and different forms of papers, including essays, research papers, and even dissertations. I like the challenge that comes with this job. I first fell in love wi...

Need Help ! PLEASE

Do Not Copy. Order Custom, Original Paper.

Aegis Inc. is a home inspection firm based in the Northern Virginia area. The President of the company, Ms. Rose Wilson, is concerned about the morale of the sales team.  Ms. Wilson had contracted a local firm to survey the employees of Aegis Inc. and the results were delivered to her in an EXCEL spreadsheet. She has tasked her Vice President of Human Resources, Mark Wolfe, to analyse the results of the survey and to report the results to her.  Ms. Wilson told Mark that she was concerned about the attitudes of the sales force.  In addition to the questions that were asked some additional data were recorded: the most recent base annual salary, commission and total pay, the years of seniority, the sales region of the individual, the gender (0=male, 1=female) and the number of contracts written in the pay period.

 

 

 

The survey instructions indicated that the first 5 questions were measured using a 5-point scale using the following key: 1 = strongly disagree, 2 = disagree, 3 = neither agree nor disagree, 4 = agree, 5 = strongly agree. The questions were as follows:

 

 

 

Q1:      Aegis Inc. has a good mentoring program

 

Q2:      Aegis Inc. is committed to delivering good value to customers

 

Q3:      Aegis Inc. has very traditional and conservative values

 

Q4:      Aegis Inc. company practices favor men

 

Q5:      Aegis Inc. has a lot of internal power politics.

 

 

 

The final question used a 1-10 scale:

 

Q6:      On a numeric scale, where 0 means totally autocratic and 10 means totally democratic, how would you rate the management style at Aegis Inc.?

 

 

 

There are only 2 divisional managers for Aegis Inc. The geographic regions of the sales team are as follows:

 

 

 

Region Number

Divisional

 Manager

 

Area

Size of Sales Force

1

A

South East

60

2

A

North East

93

3

A

Midwest

59

4

B

South West

49

5

B

Mountain States

80

6

B

West Coast

67

 

 

Total

408

 

 

 

Region 4 was only established eight months ago. Prior to that time, the branches were part of Regions 1, 5 and 6.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

INSTRUCTIONS

 

 

 

As a group: Answer the following questions involving Descriptive Statistics

 

Draw (create) a random sample of 50 from the full database then answer the following questions. You will ultimately use the sample of 50 from the full population of 408 to compare and contrast the sample and the population in the questions below. Typically you would not have the data for the entire population (such as in an election). So the point of this project is to use various statistical methods to examine how well your sample matches the population. It is obvious that the charts, figures etc. for the population should be the same for each group (or individual) that does this project. However, I would not expect to see the same results for any two groups (or individuals) samples since they are created using the Random number generator (RNG) mentioned below. This is a detailed and important project in this course, start early and take the time to do a good job. This assignment is worth twice what any one exam is worth.

 

 

 

 

 

1)     Draw a random sample of 50 from the full population provided by using the Random number generator (RNG) in Excel as a random sampling method (see my example of the RNG under Course documents). After creating the sample of fifty paste it here under this question.

 

 

 

 

 

 

 

 

 

2)     Describe how the random sample was taken. Discuss. This is the place that you discuss how you did number 1 above. Be detailed. Refer to the instructions for the RNG that are provided in the Excel document.

 

 

 

 

 

 

 

 

 

 

 

 

 

3)     Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for your SAMPLE. Save yourself some work here by using the Excel Descriptive statistics function.

 

 

 

 

 

 

 

 

 

 

 

4)     Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for the POPULATION. Save yourself some work here by using the Excel Descriptive statistics function.

 

 

 

 

 

 

 

 

 

 

 

5)     Briefly explain the differences between the population and your sample. Discuss. I am looking for a paragraph or so here of prose. I would expect more than a few sentences.

 

 

 

 

 

 

 

 

 

 

 

6)     Briefly explain the similarities between the population and your sample. Discuss. I am looking for a paragraph or so here of analysis. I would expect more than a few sentences.

 

 

 

 

 

 

 

 

 

 

 

7)     Is there a difference between your sample and the population in how the sales force is distributed within the regions? (Is the number of sales people in each of your sample regions proportionally the same as in the total population?) The best way to answer this is to set up a table of the regions in the population and the sample. The table would show how many people are associated with each region. Does the sample mimic the population? Discuss. Again, I am looking for analysis here so I would expect more than a few sentences.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                     Answer the following questions involving Inferential Statistics

 

 

 

 

 

8)     Is there a relationship between years of seniority and base pay for the sample? The population? (Hint: Use a Scatter chart- the scatter chart is required and should be displayed for this question.) If you determine if there is a relationship comment if the relationship is linear, curvilinear or something else. Does it change as the values change? Discuss fully.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

9)     Is there a relationship between years of seniority and commission pay for the sample? The population? (Hint: Use a Scatter chart- the scatter chart is required and should be displayed for this question.) If you determine if there is a relationship comment if the relationship is linear, curvilinear or something else. Does it change as the values change? Discuss fully.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

10)  Is there a relationship between years of seniority and total pay for the sample? The population? (Hint: Use a Scatter chart- the scatter chart is required and should be displayed for this question.) If you determine if there is a relationship comment if the relationship is linear, curvilinear or something else. Does it change as the values change? Discuss fully.

 

 

 

 

 

 

 

 

 

 

 

 

 

11)  Is there a large or small difference in your answers for the sample and the population for questions 8, 9 and 10?   (Hint: Compare the Scatter charts- the scatter charts in the prior questions can be referred to or you can copy them here.) Discuss fully.

 

 

 


Need help with writing Need Help ! PLEASE?

Get help


  • StudyAcer

    4.7/5
  • Trustpilot

    4.6/5
  • Sitejabber

    4.6/5

Please fill in the Order, to get Instant Homework Help


Attach files for the writers' reference