Lame Insurance Agency Data Analysis

In: Business and Management

Submitted By kjshultz
Words 481
Pages 2
Problem Definition:
The Problem in this case is to compare the data provided by Lame Insurance Agency and with data representing the state-wide insurance claims within Kentucky. In addition, we want to know the demographics specific to Lame Insurance Agency and which characteristics make up their individual profile.
Research Questions:
Are the claims that are reported to Lame Insurance Agency comparable to the statewide average in Kentucky?
What are the profile characteristics within Carr Insurance Agency?
- Is the average cost of claims the same for all age groups of the Insurance holders?
- Is the average cost of claims the same for all ages of the insurance holders’ cars?
- Is the average cost of claims the same for all vehicle groups (A,B,C,D)?
Conclusion and Recommendation:
In conclusion, Lame Insurance Agency’s average cost of collision claims are comparable to the state-wide average. However, it should be noted that the mean for Ms. Carr’s clients was slightly lower than Kentucky’s mean, but the difference proved not to be statistically significant. The mean for the state of Kentucky was $252 and the mean for Ms. Carr’s clients was approximately $231.
Concerning the demographics of profile of Carr Insurance Agency, some variables such as age of the car and vehicle group proved to be statistically significant. One notable conclusion I found while running the test is that the cost of the claim significantly decreases as the age of the car increases. For example, for vehicles between 0-3 years old the average cost of the claim was $304.69; between 4-7 years old the average claim decreases to $273.72; between 8-9 years old the average again drops to $191.23; lastly, for vehicles 10 years and older the average claim was the lowest, $142.61.
Additionally, there were similar significant differences within the vehicle groups. Vehicle group A had the…...

Similar Documents

Data Analysis

... Data Table Analysis Brief Ashley Jones ACC/542 November 5, 2012 Anita Rodriguez, M.A., CPA Data Table Analysis Brief Kudler Fine Foods has data that must be evaluated and automated into the data systems. Before the data can be automated, it must be evaluated for completeness. One must evaluate two different items: The Access data tables and The Inventory Database. To better assist Kudler Fine Foods, one must evaluate the design elements of the Access data tables from an accounting perspective and recommend improvements to the existing tables. An entity relationship diagram and pivot table will assist with understanding the data. One can then provide an explanation of how the information in the pivot table may improve decision making. Design Elements From an accounting perspective, the design elements of the data tables lack the information needed for processing transactions on a daily basis. The data in the table provide information on the customers, inventories, items, orders, order lines, stores, suppliers, tax tables, and tenders. The tables do not provide information on the transactions to journalize and add to the general ledger. The tables lack information for the financial reports, except for a few of the tables. The inventory table will provide the basic information for the quantity on hand for cost of goods calculations with unit cost for the income statement. The tender table will provide basic information on whether the payment is cash, credit......

Words: 536 - Pages: 3

Marketing of Insurance Services Agency Approach

...MARKETING OF INSURANCE SERVICES AGENCY APPROACH In recent times the insurance business has been based on agency representation and relationship. The agent represents the principal in the sale of insurance policies and in forcing a contractual relationship between the principal and the client. According to Nwachukwu (1991), the following criteria will be considered in agency creation 1) The creation of agency. The relationship can be formulated either through written or oral communication or by conduct. When required to act under seal, the agent must be given a document to validate his authority. This gives the agent power of attorney to act on behalf of his client. It has also been 2) Capacity: only individual who have been proven capable can act as agents. Exceptional cases are made during his period of sanity. Also a company can take up the role of an agent for another party, even if its not in line with the business operation of the company. The relationship that exists between the principals and agents is solely based on the resultant benefits. Classification of the Power and Authority of the agent 1) Express Authority: in this situation, the authority and rules governing the relationship is clearly spelt out in writing, oral or by deed. The oral form might not cure handy when issues come up. Where the written authority might not be specific and this gives room for manipulation of the principal by the agent. 2) Implied Authority: this......

Words: 1713 - Pages: 7

Data Analysis

...Data Table Analysis LeKane Gilling ACC/542 March 13, 2014 Brad Thompson Abstract In this brief, data tables will be analyzed because it can be critical to the accounting cycle. With accurate data that is informing, Kudler Fine Foods ought to be able to make more practical business decisions. With Kudler Fine Foods using data table to order, keep inventory, and to process their products, they can become more successful and on top of the food industry. As a company, Kudler needs to evaluate their design elements of the data tables that are needed for review from an accounting perspective. An entity relationship program would need to be developed showing the past data tables. A recommendation would need to be met for improvements or changes. With providing vital information in the pivot tables, then this will improve making decisions for every department at Kudler Fine Foods. By creating a pivot table that shows everything in a list, this will possibly help management see where items need to either increase or decrease because they're not selling. Data Table Analysis Kudler Fine Foods are a part of a broad spectrum of prestigious locations that are becoming successful. La Jolla, Del Mar, and Encinitas are the three stores that Kudler has opened, all located in California. The products range from fresh bread, harvest, meat and poultry, flavorings and packeted foods, and special milk and cheese products. Since 1998, Kudler’s goal is to supply the consumers carefully......

Words: 1218 - Pages: 5

Data Analysis

... Enerdecido, Tania Mae R. Ronario, Ma. Francesca S. Data Analysis Qualitative Data Analysis “Analysis is a breaking up, separating, or disassembling of research materials into pieces, parts, elements, or units. With facts broken down into manageable pieces, the researcher sorts and sifts them, searching for types, classes, sequences, processes, patterns or wholes. The aim of this process is to assemble or reconstruct the data in a meaningful or comprehensible fashion” (Jorgensen, 1989: 107). The researchers will analyze the data by means of using Powell and Renner’s analysis process. The analysis process is made up of getting to know the data, focusing the analysis, categorizing information, identifying patterns and connections within and between categories, and interpretation (Powell and Renner, 2003). This process will be used in analyzing all of the transcripts of parents of students from Mater Dei Academy. The identified consistencies and differences from responses of the interviewees (Powell and Renner, 2003) will be open-coded (Merriam, 2009). Identified consistencies and differences from the parents’ statements will be generalized. The researchers will then come up with patterns or themes that could be formed through the coded answers of parents (Merriam, 2009). Furthermore, these will all be interpreted. Specifically, the researchers followed the subsequent steps in doing their qualitative data analysis of parents’ of students from Mater Dei Academy......

Words: 513 - Pages: 3

Insurance Industry Analysis

...UNIVERSITY Providence, Rhode Island ENVIRONMENTAL ANALYSIS: Automobile insurance Industry Course: MGMT 6800 Yimeng Zhang October 4, 2014 Automobile insurance Industry- Environmental Analysis The motor vehicle insurance, refers to a kind of commercial insurance that offer liable for compensation to life or personal injury or property damage caused by motor vehicles due to natural disasters or accidents. Car insurance is a kind of property insurance. In the field of property insurance, motor insurance belongs to the young categories of insurance. This is because the car insurance comes and develops with the emergence and popularity of the car and. 1. Strategically Relevant Factors in the Macro-Environment-PESTEL Analysis PESTEL analysis focuses on the six principal components of strategic significance in the macro-environment: political factors, economic conditions, sociocultural forces, technological factors, (natural) environmental forces, and legal/regulatory factors. These are the significance factors of one industry varies and management will focus primarily on those with the greatest effect on their company. The most important factor in the vehicle insurance industry is Economic Factors. a. Political and legal factors The Automobile Insurance industry does not receive any direct assistance from the federal government in the form of tariffs. However, the National Association of Insurance Commissioners (NAIC) provides a forum for the......

Words: 3314 - Pages: 14

Data Analysis

...EDUTL 5901 | Balanced Scorecard: an Empirical Study of Small and Medium Size Enterprises | Data Analysis | Guangting Zheng Guangting Zheng Introduction This study analyzes Balanced Scorecard (BSC) knowledge among small and medium enterprises (SMEs) in Portuguese industry. It basically resolves three problems: Do Portuguese industrial SMEs use the BSC? Are those in charge of management accounting aware of the Balanced Scorecard? Is there any relation between spreading knowledge about the Balanced Scorecard and specific contingency variables? Traditionally managers evaluate performance with exclusively financial measures. The first performance evaluation models were based solely on financial measures (BANKER; MASHRUWALA, 2007; CORONA, 2009; LUFT, 2009; MARTIN; PETTY, 2000). However, over-emphasis on this assessment method may drive managers to try to maximize short-term financial results, thus harming the sustainable development of the company. According to Dearman and Shields (2001), even when using other methods theoretically considered as inadequate, correct management decisions can be made as long as managers are aware of the more adequate methods. Then in 1990, a new model called Balanced Scorecard was proposed. Balanced scorecard (BSC) is a strategy performance management tool, which can be used by managers to keep track of the execution of activities in the company. Now BSC is used not only as performance evaluation, but also as a strategic management......

Words: 943 - Pages: 4

Use of Data Mining by Government Agencies and Practical Applications

...Project Title Use of Data mining by government agencies and practical applications (Describe the Data Mining technologies, how these are being used in government agencies. Provide practical applications and examples) Compiled By:- Sneha Gang (Student # - 84114) Karan Sawhney (Student # - 85471) Raghunath Cherancheri Balan (Student # - 86088) Sravan Yella (Student # - 87041) Mrinalini Shah (Student # - 86701) Use of Data mining by government agencies and practical applications * Abstract (Sneha Garg) With an enormous amount of data stored in databases and data warehouses, it is increasingly important to develop powerful tools for analysis of such data and mining interesting knowledge from it. Data mining is a process of inferring knowledge from such huge data. It is a modern and powerful tool, automatizing the process of discovering relationships and combinations in raw data and using the results in an automatic decision support. This project provides an overview of data mining, how government uses it quoting some practical examples. Data mining can help in extracting predictive information from large quantities of data. It uses mathematical and statistical calculations to uncover trends and correlations among the large quantities of data stored in a database. It is a blend of artificial intelligence technology, statistics, data warehousing, and machine learning. These patterns...

Words: 4505 - Pages: 19

Data Analysis

...Data Table Analysis ACC/542 Data Table Analysis Kuder Fine Foods design elements table shows the different tables that are used to determine information. The breakout and design of the table is straight forward and provides what exactly is under each category. The customer information is very detailed and some other categories could be combined. Inventory and item could be combined since they both will provide some same information. Depending on the item that customers like can depend on the inventory amount on hand. Order and order line can also be combined in one and just add additional field where needed. The design of the access table can provide very detail information regarding inventory and items needed for each store. Combining some of the columns can help to formulize the information more and give a better results for the company to use for growth and revenue. Access Table Analysis Inventory is the key to Kudler Fine Foods business. The inventory stock has to stay stocked for the business to make profit. Having the right suppliers will make sure inventory is received in a timely manner. Cost reduction regarding how much is paid out to suppliers is important because it more cost is going to supplier, then what is sold there is an issue. Kudler Fine Foods should look into combining their stores to have one supplier. Management or owner should look into products and quantity on hand to determine their stock. Having a description of each item and supplier......

Words: 779 - Pages: 4

Data Analysis

...DATA ANALYSIS TAKE-HOME EXAM Introduction This report provides an insight into the investment behavior of 50 couples. Using different statistical methods and observing the trend followed by the effect of various independent variables on a single independent variable , a conclusion will be reached. The following are the main tools used for analysis of investment behavior of 50 couples who are selected from a sample size of 194 couples. 1. Descriptive statistics 2.Histograms 3.Pivot tables 4.Multiple Regression In this model , a scrutiny of the above statistical data will give the tendency to invest in retirement plans and the type of couples who invest and take advantage of the attractive investments in order to avail tax exemption. This report also elaborates on how the different independent variables - Number of children, Salary, Mortgage and Debt- have an effect on the dependent variable, i.e. the percentage of salary invested. Consequently the below tasks will be fulfilled. Step 1-Extracting a sample of 50 couples Step 2-Constructing histograms and point estimates with given confidence intervals Step 3-Inference from pivot tables to explain the preferences of different couples on investments based on independent variables Step 4-Performing multivariate regression and conducting significance tests on beta coefficients R^2 and F-tests and hence establish a correlation of different variables and ensuing effect on investments made. Dataset We have a......

Words: 1895 - Pages: 8

Data Analysis

...Data Collection Analysis: ITT Technical Institute Keller Graduate School of Management Training and Development HR592 Professor Robert Graver February 23, 2014 Table of Contents Overview of the Organization…..………………………………………………………………3 Executive Summary …………..………………………………………………………...…...…3,4 Analysis of Data Collected & Identified Training Need…………………………………..…4,5,6 Recommendations………………………………………………………………………………...7 Training or Intervention Strategy to Address the Needs…………………………………………8 Cost benefit analysis……………………………………………………………………………8,9 Conclusion……………………………………………………………………………………….10 References………………………………………………………………………………………..11 The ITT Technical Institutes is a leading private college system focused on technology-oriented programs of study. The seven schools of study at the ITT Technical Institutes [i.e., the School of Information Technology, the School of Drafting and Design, the School of Electronics Technology, the School of Business, the School of Criminal Justice, the School of Health Sciences and the Breckinridge School of Nursing] teach skills and knowledge that can be used to pursue employment opportunities in today’s world. There are over 140 ITT Technical Institutes in 38 states. ITT Technical Institutes predominantly offer career-focused, degree programs to over 70,000 students. The ITT Technical Institutes have been actively involved in the higher education community in the United States since 1969. Executive Summary ITT Technical......

Words: 2292 - Pages: 10

Data Analysis

...DATA ANALYSIS & DISCUSSION 1) How political environment affects on international trade? * In this question 1 respondent answers positively which is mentioned in option A, 14 respondents answers negatively which is mentioned in option B and most of the respondent answer option C. * We think the answer might be C which explains political environment affects international trade both positively & negatively. 2) How government can affect on the international trade? * 4 respondents response option A which is new rules & regulation, 3 respondents response on potion B which is economic shift, 6 respondents response option C which is fiscal & monetary policy and after all, 38 respondents response option D which indicates all of the above option result we think. * The possible result might be option D which tells all of the above option ( New & regulation, Economic shift, Fiscal& monetary policy) 3) How political parties can influence the level of political stability? * High tariff & non-tariff barriers in option A is chosen by 5 respondents, Foreign direct investment restrictions is chosen by 6 respondents, Foreign exchange control is chosen by 5 respondents and all of the above is chosen by 34 respondents. * We think that all of the mentioned option can influence the level of political stability. 4) What will be the role of government to promote a country interests in the international area? →Option a national......

Words: 848 - Pages: 4

Data Analysis

...Writing Assignment #3 (Data Analysis/Social media) One widely recognized issue that we face these days is the distraction social networking can be when it comes to education. I mean, if biology class is a total drag you are going to want to find something to entertain yourself with for the time being, right? While I agree that a boring class is not the best thing in the world, the information being taught is much more important than what’s being posted on your Instagram or Twitter feed. According to a post on NBC News’ website regarding research on the connection between the average American teen’s attention span with common distractions such as cell phones, text messaging and social networks, and how it affects grades, approximately 47 percent of American high school or college students have either failed one or more classes due to distractions, furthering my point that too much online social activity can be a harmful distraction. Social network overuse can not only affect your academic life, but also your personal life as well. From my own experience, just about anyone getting too comfortable on social networks can definitely serve as a threat to his or her personal well-being. I’ve witnessed many arguments and disagreements on social media leading to physical altercations between classmates. With so many different mindsets and opinions floating around, it is almost impossible to post something without at least one person disagreeing or feeling personally offended...

Words: 331 - Pages: 2

Data Analysis

...HCS/577 – Financial Management in Health Care Financial Data Analysis Introduction To have a full understanding we need to know what an operating budget is and it can be defined as the upcoming statement of profit and loss for the different divisions and units of a company as well as the company as whole for the upcoming year. To identify the variances as well as to monitor things this operating budget is normally divided into what is usually called quarters. For a health care company these budgets are prepared for the following year and is normally discussed for some kind of approval by the upper management teams. When the year is at an end the management team that is in charge of certain areas are then asked to provide an account of the performances from the previous year. Effective financial management practices in creating and monitoring an operating budget When it comes to creating and monitoring a budget, the use of financial management should not be overemphasized. To start off, the budget construction form should be able to identify all of the relevant data that is involved. The operating budget can be best utilized as a profit and loss statement projection and to prepare the estimates of expenses and future revenues. To make it easier to monitor Finkler (2006) states that an operating budget should be presented together......

Words: 948 - Pages: 4

Analysis of Data

... The terms "statistical analysis" and "data analysis" can be said to mean the same thing -- the study of how we describe, combine, and make inferences based on numbers. A lot of people are scared of numbers (quantiphobia), but data analysis with statistics has got less to do with numbers, and more to do with rules for arranging them. It even lets you create some of those rules yourself, so instead of looking at it like a lot of memorization, it's best to see it as an extension of the research mentality, something researchers do anyway (i.e., play with or crunch numbers).  Once you realize that YOU have complete and total power over how you want to arrange numbers, your fear of them will disappear.  It helps, of course, if you know some basic algebra and arithmetic, at a level where you might be comfortable solving the following equation There are three (3) general areas that make up the field of statistics: descriptive statistics, relational statistics, and inferential statistics.  1. Descriptive statistics fall into one of two categories: measures of central tendency (mean, median, and mode) or measures of dispersion (standard deviation and variance). Their purpose is to explore hunches that may have come up during the course of the research process, but most people compute them to look at the normality of their numbers. Examples include descriptive analysis of sex, age, race, social class, and so forth.  2. Relationalstatistics fall into one of three categories: univariate...

Words: 4590 - Pages: 19

Insurance Analysis

...EXECUTIVE SUMMARY This project was carried out in the HR department of BHARTI AXA Life insurance co. Pune. Bharti AXA Life insurance is only concern with life insurance and General insurance. The objective of this project is to study the entire Recruitment & Selection processes at Bharti AXA Life insurance. The Human Resources Department of Bharti AXA Life insurance carries out both these functions quite effectively. Hence, the procedure of Recruitment is studied thoroughly and some inferences accordingly. The data and information collected is with respect to working procedure specifically regarding recruitment procedure, the data referred for this study is for the year 2007 - 08. I have applied the concept and gained knowledge learned during the course in at CMRD In practical business situation and understood these concepts in better way. The research work really has poured of immense learning for me. I would like to thank whole heartedly to Bharti AXA and CMRD, for giving me this exposure. Introduction Company profile: Bharti AXA Life Insurance is a joint venture between Bharti, one of India’s leading business groups with interests in telecom, agro business and retail, and AXA, world leader in financial protection and wealth management. The joint venture company has a 74% stake from Bharti and 26% stake of AXA. The company launched national operations in December 2006. Today, company has over 5200 employees across over 12 states in......

Words: 3465 - Pages: 14

Toriko 3D: Kaimaku Gourmet Adventure!! | Business | Disney Interactive