Premium Essay

Data Analysis Report

In: Business and Management

Submitted By zjsbenz
Words 2846
Pages 12
Data analysis report
Divine Elegance: A Restaurant
Table of Contents Introduction 2 Preliminary Analysis 2 Data Screening and Hypothesis Testing 2 1. How much are potential patrons willing to pay for the entrées? Is the $18 amount from the forecasting model correct? 2 2. Can Michael expect all patrons to spend an average of $200 a month on food? 4 3. Which zip code area(s) provide the best location for the restaurant? Does the expected average monthly spend differ between potential patrons residing in different zip codes 6 4. Does the likelihood to patronize the restaurant different between people with different income levels? 8 5.How elegant should the décor be? Would potential patrons prefer simple or elegant décor? 9 6. Should there be live entertainment? Would potential patrons prefer a string quartet or a jazz combo? 10 7. Which radio station(s) should Michael select for advertising? Which type of radio programming do people most likely to patronize the restaurant listen to? 10 8. Can the likelihood of patronizing the restaurant be explained in terms of evaluations on 
restaurant preference variables (Variables 11-20), age, family size and gender – when all of these variables are considered simultaneously? (*Hint, you may need to recode the ‘Year Born’ variable to determine age). 11 9. Does the average age between a probable and non probable patron differ? 13 10. Is there a relationship between gender and whether or not someone is a probable patron? 14 Conclusion and Recommendation 15 Appendix A 17 Categorical 17 Quantitate 24

Introduction
Michael Jenkins wants to open his own dream restaurant. Before open his restaurant, he has some concerns, firstly, he want to know is there demand for an upscale restaurant. Secondly, he wants to know how to design and what are the operating characteristics. Thirdly, the location of the…...

Similar Documents

Premium Essay

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

Premium Essay

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

Free Essay

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

Premium Essay

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

Premium Essay

Report on Data Mining

...Adelman MBA 511 Report – Webcast 8/13/14 on Data Mining SAS (Statistical Analysis System) was originally developed as a project to analyze agriculture from 1966-1976 at North Carolina State University. As demand for such software grew, SAS Institute was founded in 1976. SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it. SAS provides a graphical point-and-click user interface for non-technical users and they provide more advanced options through the SAS programming language. On August 13 2014, SAS sponsored a web seminar titled “Analytically Speaking” the topic of the webcast was data mining techniques. Michael Berry and Gordon Linoff were the featured speakers, they have written a leading introductory book (on data mining) titled “Data Mining Techniques”. They discussed a lot of the current data mining landscape, including new methods, new types of data and the importance of using the right analysis for your problem (as good analysis is wasted doing the wrong thing). They also briefly discussed using ‘found data’ – text data, social data and device data. Michael Berry is the Business Intelligence Director at TripAdvisor and co-founder of Data Miners Inc. Gordon Linoff is co-founder of Data Miners Inc. and a consultant to financial, media and pharmaceutical companies. Data mining is the analysis step of the “KDD” (Knowledge Discovery in Databases). Data mining is an......

Words: 818 - Pages: 4

Premium Essay

Report on Data Mining

...Adelman MBA 511 Report – Webcast 8/13/14 on Data Mining SAS (Statistical Analysis System) was originally developed as a project to analyze agriculture from 1966-1976 at North Carolina State University. As demand for such software grew, SAS Institute was founded in 1976. SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it. SAS provides a graphical point-and-click user interface for non-technical users and they provide more advanced options through the SAS programming language. On August 13 2014, SAS sponsored a web seminar titled “Analytically Speaking” the topic of the webcast was data mining techniques. Michael Berry and Gordon Linoff were the featured speakers, they have written a leading introductory book (on data mining) titled “Data Mining Techniques”. They discussed a lot of the current data mining landscape, including new methods, new types of data and the importance of using the right analysis for your problem (as good analysis is wasted doing the wrong thing). They also briefly discussed using ‘found data’ – text data, social data and device data. Michael Berry is the Business Intelligence Director at TripAdvisor and co-founder of Data Miners Inc. Gordon Linoff is co-founder of Data Miners Inc. and a consultant to financial, media and pharmaceutical companies. Data mining is the analysis step of the “KDD” (Knowledge Discovery in Databases). Data mining is an......

Words: 818 - Pages: 4

Premium Essay

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

Premium Essay

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

Premium Essay

Hr Data Report

...Tomos Rogers By Student: Iryna Zaliapska CIPD Course Level 3 Tutor: Tomos Rogers By Recording, analysing and using HR information Recording, analysing and using HR information Contents Activity 1 * Two reasons why the organisation needs to collect HR data * Two types of data that is collected within the organisation and how each supports HR practices * A description and benefits of two methods of storing records * A statement of two essential items of UK legislation relating to the recording, storage and accessibility of HR data Activity 2 Analysis and my own findings of the CIPD’s twelfth national survey of Absence Management trends, policy and practice * An introduction to the HR investigation and data interpretation of Absence Management in the organisations across the UK * The obtained results and it follows recommendations References and Bibliography Activity 1 A briefing note about organisation’s approach to collecting, storing and using HR data The Human Resources department collects lots of HR data from its employees. HR systems are increasingly used by HR departments to help collect, store and manage data about its workforce. The organisation needs to collect HR data for a number of reasons, some include: * Legal requirements - to prove that the organisation is hiring at an equal opportunity standard, also, to ensure that and prove that any firing done by the company is done for the right reasons and is readily available......

Words: 3445 - Pages: 14

Premium Essay

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

Premium Essay

Data Analysis Report

...Influence of Gender 4 4.2 – Influence of Single or Double Degree 5 4.3 – Influence of Quiz Results 6 4.4 – Influence of Report results 1 5.0 – Conclusion 1 Bibliography 2 Appendix 2 1.0 – Introduction The purpose of the following report is to display the significant role and factors that affect the student results and to prove the most efficient causes for high marks amongst the 705 students in BSB123. The variables are gender, whether the student is studying a double or single degree, quiz, report and exam results. The scope of the report is the population of university students studying BSB123, which will be examined. 2.0 – Outliers (Refer to the appendix) An outlier is an extreme value that differs greatly from other values that does not follow the overall data pattern.  Outliers are beneficial when analysing data, as it helps gather additional information, displays trends and patterns and helps define the scope of the population being investigated. In the provided data, there were no outliers found. Figure 13.0 displays a minimum Z-score of -1.8970567 and a maximum of 2.459087745, meaning no z-scores fell outside the range. This shows that the chosen population is more controlled, less susceptible to variation and that exceptional cases do not vary the data results. 3.0 – Distribution of Exam Results This section of the report will investigate the performance of the students in regards to the final examination. Figure 1.0 –......

Words: 1609 - Pages: 7

Premium Essay

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

Free Essay

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

Premium Essay

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

Premium Essay

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