Summarizing and Presenting Data

In: Business and Management

Submitted By msmonie431
Words 1600
Pages 7
Summarizing and Presenting Data

Team C

Erin E. DeVera, Robin Evans, Cheryl Houston,
Craig Isaac, Burnadette Johnson, Tiffany Pena, Darren Smith
QNT/351
June 25, 2012
Alemayehu Lirenso, PhD


Summarizing and Presenting Data

Summarizing data effectively to communicate concepts with clarity to ensure an understanding by an audience is important when presenting. The central location comprised of mean, median, and mode, followed by the measure of dispersion; standard deviation, variance, skewness, and coefficient of variation are used to evaluate wages, education level, and work experience. Bivariate charts in the form of bar, histogram, line or pie graphs are an effective method of displaying key findings necessary for data analyst and interpretations.

Central Location

Measure of central location is a measure of location within a distribution and summarizes the one score that best describes the centrality of the data. The measure of tendency that best represents the data set in this example is the median for wages as it represents a good indicator of the typical salary within the data set.
| | |Mean |Median |Mode |
|Wages |$3,083,346 |$30,833.46 |$43,036 |$20,852 |
|Education |1273 |12.73 |18 |12 |
|Experience |2038 |20.38 |27.5 |(6, 10) |








Measure of Dispersion
The standard deviation for the wage variable is 16,947.097270249 (16947.10 rounded). This data set has a variance of 287204105.88727 (287204105.89 rounded). This sample has a coefficient of variation of 0.54963332919 (0.55 rounded). The box and whiskers plot shows a skewness of…...

Similar Documents

Presenting to Stakeholders

...Presenting to Stakeholders The best way to present the information to the stakeholders is by giving information about the performance record. The stakeholders need to know the future expectations. Significant financial ratios will promotion in shaping the information requested. The stakeholders should receive an explanation about the different key ratios. Liquid ratios measure the company’s capability to meet cash requirements as the needs arise. The current ratio measures the ability of the company to pay debts. REC has increased cash flow from the previous year indicating an improvement for short-run solvency. The company’s average collection period has dropped five days from last year. The cash conversion cycle will show an improvement or decrease. REC has an improvement of 26 days. The stakeholders should be informed about the cash flow from operations. The stakeholders need to know about the risk inherited. The activity ratios show the liquidity of assets and the efficiency of managing assets. The accounts payable turnover has increased seven times from the previous year. This could mean the company is taking longer to repay the company vendors. The inventory turnover is slightly up from last year at .25. This could indicate an increase in sale of the products. By showing the leverage ratios to the stakeholders, the company could explain the company’s ability to cover interest, debt relative to equity, and other fixed charges. The cash interest has improved from......

Words: 335 - Pages: 2

Data

...Discuss the importance of data accuracy. Inaccurate data leads to inaccurate information. What can be some of the consequences of data inaccuracy? What can be done to ensure data accuracy? Data accuracy is important because inaccurate data leads may lead to such things as the closing down of business, it may also lead to the loosing of jobs, and it may also lead to the failure of a new product. To ensure that one’s data is accurate one may double check the data given to them, as well as has more than one person researching the data they are researching. Project 3C and 3D Mastering Excel: Project 3G CGS2100L - Section 856 MAN3065 - Section 846 | | 1. (Introductory) Do you think Taco Bell was treated fairly by the mass media when the allegations were made about the meat filling in its tacos? I think so being that they are serving the people for which I must say that if you are serving the people then it’s in the people rights to know what exactly you are serving them. 2. (Advanced) Do you think the law firm would have dropped its suit against Taco Bell if there were real merits to the case? It’s hard to say but do think that with real merits it would have changed the playing feel for wit real merits whose the say that Taco Bell wouldn’t have had an upper hand in the case. 3. (Advanced) Do you think many people who saw television and newspaper coverage about Taco Bell's meat filling being questionable will see the news about the lawsuit being withdrawn? I doubt...

Words: 857 - Pages: 4

Summarizing and Presenting Data

...Summarizing and Presenting Data Team C Erin E. DeVera, Robin Evans, Cheryl Houston, Craig Isaac, Burnadette Johnson, Tiffany Pena, Darren Smith QNT/351 June 25, 2012 Alemayehu Lirenso, PhD Summarizing and Presenting Data Summarizing data effectively to communicate concepts with clarity to ensure an understanding by an audience is important when presenting. The central location comprised of mean, median, and mode, followed by the measure of dispersion; standard deviation, variance, skewness, and coefficient of variation are used to evaluate wages, education level, and work experience. Bivariate charts in the form of bar, histogram, line or pie graphs are an effective method of displaying key findings necessary for data analyst and interpretations. Central Location Measure of central location is a measure of location within a distribution and summarizes the one score that best describes the centrality of the data. The measure of tendency that best represents the data set in this example is the median for wages as it represents a good indicator of the typical salary within the data set. |  |  |Mean |Median |Mode | |Wages |$3,083,346 |$30,833.46 |$43,036 |$20,852 | |Education |1273 |12.73 |18 |12 | |Experience |2038...

Words: 1600 - Pages: 7

Summarizing the Medigap Plan

...Summarizing the Medigap Program Medicare Part A and Part B do not always cover all of medical services and/or treatments that the beneficiary may need. Because of the “gaps” that these plans do not cover, many individuals often purchase additional insurance such as Medigap insurance or insurance a previous employer provides. Medigap is private insurance that may cover unpaid amounts within the annual deductible, any coinsurance, and payment for non-covered services. Private insurers offer these Medigap plans but the federal and state law regulates coverage and standards. Policyholders must pay monthly premiums and may choose 1 of 10 plans. The monthly premiums and plans vary depending on the insurance company selected but a set core of benefits is common among all Medigap plans. Medigap coverage also eliminates the need for the practice to file separate claims because the carrier automatically forwards the claim to the payer and the provider is paid directly. (Valerius, Bayes, Newby, & Seggern, 2008) Based on the information in this week’s readings and looking over the suggested websites, I feel that the different plan offered through Medigap at the prices offered is fairly reasonable. Because of the many different plans offered, the policyholder can choose a plan that fits them both medically and financially. Depending on the monthly premium the insured pays, Medigap covering certain expenses such as a long hospital stay, could save an individual a lot of money...

Words: 362 - Pages: 2

Data

...Data Verification- Effectiveness of Testing • Prepared a survey to ask 20 students 10 girls, 10 boys • Each person was allowed to tick one option in each question • The questions of the survey were: 1. About how many tests do you have per week? -less than 2 (7/7 -more than 2 (3/3) -more than 3 (0) 2. Do you get good grades in most tests? -yes (5/7) -no (1/0) -so so (4/3) 3. Do you find the tests in our school helpful? -yes (5/3) -not at all (0) -some are helpful some are not (5/7) 4. Which subjects are good to be tested on? -Math (5/5) -Languages (2/3) -Sciences (3/2) 5. Do you think testings like the IGCSE exams will help you in the future? -Yes, I think they will prepare me for university (9/9) -I think some are not useful, but some are (1/1) - No, I think they are not useful at all (0) • Our results were: BOYS GIRLS -results are next to the questions Conclusion -Boys and girls have the same amount of tests. More of them have less than 2 per week (not including quizzes) -Most girls get good grades, more boys said ‘so so’ than girls. - Half of the boys said tests are good, half said some are and some aren’t. More Girls said some are and some aren’t......

Words: 316 - Pages: 2

Summarizing the Medigap Program

...  Summarizing the Medigap Program Medicare Parts A and B do not cover everything for patients who have it. Medigap fills in these “gaps” in coverage. Some people would certainly benefit by purchasing a Medigap policy. A Medigap policy can help its holders pay for their deductibles and co-pays for Medicare Parts and B. Some other services, like medications and emergency care while traveling in foreign countries, may be covered by Medigap policies. Based on my understanding of the Medigap program, I believe it meets consumers’ needs quite well. For people who are unable to meet the additional costs of co-pays, deductibles, and medications, this program can help. After reading the material from the American Diabetes Association (n.d.), the plans’ costs seems to be fair, taking into consideration the limits and benefits each plan offers. For example, if a person paid a co- pay for a hospital stay and did not have a Medigap policy, that person’s expense would be higher than themonthly premium for Medigap. If an individual does not need to visit the doctor frequently, has fairly good health and anticipates remaining healthy, choosing to pay an occasional co- pay may wind up being a better financial decision than paying a monthly premium. One implication from having a government insurance program and a private insurance company in association with each other is the services that are not and are covered by each. People who have private insurance as well as government insurance will......

Words: 300 - Pages: 2

Prewriting, Summarizing, and Paraphrasing

...Prewriting, Summarizing, and Paraphrasing Jonathan Carroll December 21, 2013 Part 1: Background of the Problem * As a result of underage college drinking men and women are having unprotected sex while under the influence of alcohol; in some cases they acquire a sexually transmitted disease including herpes and Aids etc. * Violent crimes are being commended on university campuses, because of alcohol use. * Excessive drinking can result in memory loss and could be a gateway to drugs such as marijuana etc. Needs * Preventing alcohol abuse will reduce automobile crashes resulting in death within teens. * Preventing teen drinking will help kids with long lasting health issues that will occur if the teen drinks alcohol excessively. * Preventing alcohol abuse teens will most likely succeed in life. Our Proposed Ideas * Try to avoid bars and people that drink on a regular basis. * Acquire new friends that don’t drink alcohol. * Avoid people that try to peer pressure you to consume alcohol. Benefits * Preventing alcohol use will lower crime rate on campuses across the nation. * Preventing alcohol abuse will help student increase their study behaviors by attending more classes and focusing while in class. * Preventing alcohol abuse on campus will help universities control student deaths related to underage drinking. Implementation * Discuss with your young teens about what alcohol can do to you. * Give teens...

Words: 536 - Pages: 3

Summarizing and Presenting Data

...Summarizing and Presenting Data QNT / 351 Summarizing and Presenting Data In both employee surveys BIMS used all three levels of measurement to analyze the data collected. In reviewing the findings from the employee survey, the ultimate goal was to get the overall census of the employees on the survey questions. These survey questions were engineered to evaluate the satisfaction level of the employees at BIMS and to reveal the underlying issues and continuous concerns that were causing the high turnover and low morale at BIMS. The interval level of measurement was used to display the employee’s length of employment and a numeric code was used to describe the nominal, ordinal and interval data. Descriptive statistics was used to show the mean, median, mode and central tendency of the data. An analysis of each survey question was broken down and the interpretation displayed on tables, charts and graphs. These graphs give an overall visual description of the answers to each question. After all the data had been analyzed, displayed, and interpreted, the outcome shows that BIMS was experiencing high turnover due to low pay and lack of communication within the organization. Descriptive Analysis The intention of descriptive analysis is provide a clear understanding through the use of graphical and numerical visual of the patterns and unique trends in the data set of interest. The inferences made through these resources will provide valuable information for the decision...

Words: 1977 - Pages: 8

Summarizing and Presenting Data

...Summarizing and Presenting Data QNT/351 Ballard Integrated Managed Services, Inc. Data Collection- Part One Ballard Integrated Managed Services, Inc., (BIMS) is an organization that provides food and accommodations for their employees, the patients at Douglas Medical Center, along with other large companies. A change in the company has been taking place and trending towards many employees leaving for other employment opportunities. The turnover rate for BIMS is normally in the range of 55 to 60%, however, for the past few months it has increased to 64%. What is causing the turnover rate to increase and the moral across the organization to decrease? If management puts an emphasis on the employees and their training, will the turnover rate improve? Overview Barbra has noticed several other behaviors lately which appear to be a symptom of a deeper problem, but has been unable to determine the root cause of a climbing turnover rate and the overall decline in morale. In effort to discover the cause within the organization, a survey was administered. Unfortunately, the survey did not provide the results or guidance for management to lead the team in a direction that would change the culture of the organization or the way the employees at BIMS feel about their experiences at BIMS. If management continues to look only at the symptoms of the problem, the root cause will continue to exist and deteriorate the culture further. Debbie Horner, the HR manager developed and...

Words: 1624 - Pages: 7

Summarizing and Presenting Data

...Ballard Integrated: Human Resource Data Team “B” has been assigned to assist Ballard Integrated Managed Services Inc., (BMIS) determine why turnover rates have increased, and morale has decreased at the Douglas Medical Center site. BMIS is a national company that handles housekeeping, food service, general cleaning, and plant maintenance for more than 153 companies, including 22 Fortune 100 businesses, 16 major universities, 14 medical centers, 3 large regional airports, and more than 100 midsize businesses. Four months ago, BMIS and DMC agreed to renew its contract for five years under the same stipulations as the first three-year contract. Since the new contract was signed, something is decreasing morale. Barbara Tucker, the general manager for the site has worked with human resources and three divisional managers to no avail, and has assigned Debbie Homer to survey employees to solve the puzzle of low morale (Lind, Marchal, & Wathen, 2011). BIMS provides food and hospitality services on a contractual basis for patients and staff. The managers of the company have noticed an increased turnover rate over. Turnover has gone from 55-60% to 64% in the last four months. The managers feel the morale of the company is going down. Division managers and human resources have come up with a survey for the employees to determine the problem area within the company. BIMS has been receiving complaints from Douglas Medical Center (DMC) concerning the quality of work and...

Words: 1424 - Pages: 6

Qnt 351summarizing and Presenting Data

...Summarizing and Presenting Data Summarizing and Presenting Data The Ballard Integrated Managed Services (BIMS) management team will review the data collected from the case study and present the information using descriptive statistics. Team C will review the measures that the management team will use when reporting the descriptive statistics. Team C will prepare and describe the methods of measurement for mean, median, mode, standard deviation, and provide graphical display of data. Team C will use each measurement method and draw random selections from the BIMS Coding spreadsheet to report conclusions and make recommendations about the data. The following survey was given to every BIMS employee to get an idea on how Ballard satisfied the employees were with the company. The management team will use this information to report conclusions drawn from the data and make recommendations to Ballard’s management team to improve the employee’s morale, communication, and working conditions. Very Negative Very Positive 1. How well do you enjoy working for BIMS? 2. You enjoy your assigned shift. 3. Your request for your desired shift was fulfilled. 4. How many times have you called in sick in the last month? 5. You are well trained for your work. 6. You are paid fairly for the work you do. 7. Your supervisor treats you fairly. 8. Your supervisor’s boss treats your division fairly. 9. The company is good at...

Words: 1840 - Pages: 8

Summarizing and Presenting Data

...Summarizing and Presenting Data University of Phoenix Quantitative Analysis for Business QNT/351 June 02, 2014 Summarizing and Presenting Data At Ballard Integrated Managed Services (BIMS), we pride ourselves on providing excellent services to our business partners and offering excellent employment opportunities. This is why Barbara Tucker, the general manager for BIMS at Douglas Medical Center, has grown concerned over a recent increase in employee turnover rates. The employee turnover rate has increased from annual averages of 55%-60%, which correlates with other local area businesses, up to its current peak of 64%. Barbara believes that the increased turnover rate among BIMS employees is due to an overall decrease in morale. In an attempt to identify the contributing factors of this problem and offer insight to a possible solution, an anonymous non-mandatory survey was administered to each of its 449 employees. Out of the 449 employees, only 78 completed the survey. In this report, several key factors will be discussed as to why employee morale is low and turnover rates high. Recommendations for a solution to the problems and ways to increase employee participation with surveys moving forward will be addressed. The data collected from the surveys issued to employees indicate that the increase in turnover rates is directly related to low morale among the staff. Some of the more concerning answers were from questions six and nine, which revealed negative...

Words: 1220 - Pages: 5

Data

...Data Collection - Ballard Integrated Managed Services, Inc. (BIMS) Learning Team C QNT/351 September 22, 2015 Michael Smith Data Collection - Ballard Integrated Managed Services, Inc. (BIMS) Identify types of data collected--quantitative, qualitative, or both--and how the data is collected. A survey was sent out to all the employees’ two paychecks prior and a notice to complete the survey was included with their most recent paychecks. After reviewing the surveys that have been returned it was found that the data collected is both quantitative and qualitative. Questions one thru ten are considered qualitative data because the response for those questions are numbered from one (very negative) to five (very positive), which are measurements that cannot be measured on a natural numerical scale. They can only be classified or grouped into one of the categories and are simply selected numerical codes. Then, questions A-D could fall under quantitative data because it can determine the number of employees in each department, whether they are male or female and amount of time employed with the company. From that data it is able to find an average of time employed, then subcategorize by department, gender and if they are a supervisor or manager. Identify the level of measurement for each of the variables involved in the study. For qualitative variable there are a couple levels of measurements. Questions A, C, and D in Exhibit A fall in nominal-level data because when...

Words: 594 - Pages: 3

Presenting Academic Paper

...Presenting an Academic Paper AGUS GUNAWAN Discussion points  What is a good presentation? What will the audience remember?  What is the most difficult aspect of presenting? Why?  Are you nervous when you have to present? What are you afraid of?  What do you hope to learn from this training? What we will discuss…  Designing presentation content  Designing effective power point  Presenting your work Designing Presentation Content Things to be considered…  Creates an overall framework – intro, main body, conclusion  Understand key terminology  Assumes the audiences knows nothing about the subject at all  Time management  Keep your own voice: start & end your paragraphs  Applies critical thinking Develop the presentation content  Identify your audience  Formulate your objectives  Make a statement Expand on the statement Use clear signpost to guide the audience through your discussion Back up with evidence and examples A major stimulant to creative thinking is focused questions Three principal questions for critical thinking  What  Why  How “What?”  Identifies the key message you wish to communicate.  What is the benefit of your message for the audience ?  What can they do with the information ? “Why?”  Addresses the next obvious question that arises in the audience.  “why should I do that?”  “why should I think that?”  “why should that be the case...

Words: 1649 - Pages: 7

Summarizing Closing the Gap

...S w 910M51 CLOSING THE GAP – THE CHANGING HOME CARE ENVIRONMENT (A) Rida Elias wrote this case under the supervision of Professor Roderick E. White solely to provide material for class discussion. The authors do not intend to illustrate either effective or ineffective handling of a managerial situation. The authors may have disguised certain names and other identifying information to protect confidentiality. Richard Ivey School of Business Foundation prohibits any form of reproduction, storage or transmission without its written permission. Reproduction of this material is not covered under authorization by any reproduction rights organization. To order copies or request permission to reproduce materials, contact Ivey Publishing, Richard Ivey School of Business Foundation, The University of Western Ontario, London, Ontario, Canada, N6A 3K7; phone (519) 661-3208; fax (519) 661-3882; e-mail cases@ivey.uwo.ca. Copyright © 2010, Richard Ivey School of Business Foundation Version: (A) 2010-07-09 It was nearing the end of another busy day, and Connie Clerici’s last appointment had been cancelled. Clerici was glad to have some time to reflect on both her business and her personal situation before the meeting with her advisory board, scheduled for the next day, September 25, 2009. She knew the business environment of her company, Closing the Gap (CTG), continued to change, presenting opportunities and challenges. She wanted to be prepared for a productive...

Words: 5536 - Pages: 23