Free Essay

Charts Bar

In:

Submitted By Vanou
Words 273
Pages 2
Graphical & Tabular Descriptive Summaries
Using the attached excel file, identify and discuss what makes a Crusty Pizza Company restaurant successful and conversely unsuccessful. Use the data for the 60 stores in worksheet “Case 1 and 2 data”.
Use graphical and tabular descriptive statistics. Plan the analysis by using a combination of summaries that best allow you to achieve the Key Objective, such as:
a. Tables (Frequency, percent frequency, contingency) for key variables as they pertain to success
b. Charts: Bar, pie, histograms, line charts, scatter plots, etc., for exploring relationships as they pertain to success
c. In all comparisons, comment on the results and interpret findings as they pertain to the Key Objective.

Solution:
Seating:

The mean and median profit is high with seating option.

Store Size:

VL store size has maximum profit as compare to other store size.
Liquor License:

The store which is having Liquor License has more profit.

We can see as the student population grows the monthly profit will also grow.
Review in local newspaper:

Review does not seem to be have impact on the profit because there does not seem to be any difference in the profit because mean is small for positive rating and median is high for positive rating.

The pizza variety does not have any impact on the profit.
Delivery option:

The stores provides delivery option have high mean and median profit as compare to the store which does not provide any delivery option.

Buffet on Weekends:

The stores provides Buffet on Weekends option have high mean and median profit as compare to the store which does not provide any Buffet on Weekends.

Similar Documents

Premium Essay

Doc, Docx, Pdf, Wps, Rtf, Odt

...IELTS Reading Test IELTS Listening Test Writing Task 1 - A Writing Task 1 - G Writing Task 2 IELTS Speaking IELTS Practice Tests IELTS General Tests IELTS Sample Exam IELTS Line Graphs IELTS Tips IELTS Writing Samples Speaking Part 1 Speaking Part 2 & 3 IELTS Writing Task 1 #101 You should spend about 20 minutes on this task. The chart below gives information about the UK's ageing population in 1985 and makes predictions for 2035. Summarise the information by selecting and reporting the main features, and make comparisons where relevant. Write at least 150 words. Source: Office for National Statistics, National Records of Scotland, Northern Ireland Statistics and Research Agency Test Tip In Task 1 of the IELTS Writing modules, you may be asked to interpret and describe data presented in graph form. There are three basic types of graph: pie charts, bar charts and line graphs. Bar charts are useful for comparing the quantities of different categories. Bar charts are constructed such that the lengths of the different bars are proportional to the size of the category they represent. Bar charts usually show the numbers or percentages on the y-axis and the different categories that are being measured along the x-axis. Both axes are labeled to show what they refer to. Sometimes each category along the x-axis can be divided into two further sub-groups, e.g. 1985/2035, so that these sub-groups can be compared. Model answer The graph shows...

Words: 465 - Pages: 2

Premium Essay

Gm533 Part 3

...customers and wants to find out more information about these customers. In analyzing the individual variable, using graphical illustrations I would be using histogram, bar chart and a pie chart because there are useful when using numerical comparison. The 3 individual variables 1) The 1st individual variable, I choose is the credit balance of the customers. Credit Balance Numerical Summary: | Credit Balance($) | Mean | 3970 | Median | 4090 | Mode | 3890 | Standard Deviation | 932 | Skewness | -0.15 | Range | 3814 | Minimum | 1864 | Sum | 198523 | Maximum | 5678 | Interpretation The mean credit balance of the customers is given as $3970. The standard deviation is given approximately as 932. The credit balance of the customers is more or less normally distributed with the peak of the bell shaped distribution lying in the range 3814. 2) The 2nd individual variable, I choose is the household size. Thus the number of people living in the households. SIZE Frequency Distribution | Size | Frequency | 1 | 5 | 2 | 15 | 3 | 8 | 4 | 9 | 5 | 5 | 6 | 5 | 7 | 3 | Interpretation The mean of the household size is known as 3 approximately as seen on Minitab. The median of the household size 3 and the mode would be 2. As seen in the bar chart above, the maximum number of a household size of 2 because it has a total of 15 members in the household. 3) The 3rd individual variable, I choose is the location of the...

Words: 327 - Pages: 2

Premium Essay

Data Summary

...Before we begin with the data summary, descriptive statistics is defined as mathematical methods (such as mean, median, standard deviation) that summarize and interpret some of the properties of a set of data (sample) but do not infer the properties of the population from which the sample was drawn. Descriptive statistics is the term given to the analysis of data that helps describe, show or summarize data in a meaningful way such that, for example, patterns might emerge from the data. Descriptive statistics do not, however, allow us to make conclusions beyond the data we have analysed or reach conclusions regarding any hypotheses we might have made. They are simply a way to describe our data. There are two general types of statistic that are used to describe data: Measures of central tendency and Measures of spread. Description of variables and types of data given are as follows: StartSal – Numerical and can be treated as continuous. OnRoad Pct – Numerical and continuous StateU – Categorical and can be treated as nominal CISDegree – categorical and can be treated as nominal Stayed3yrs – Categorical, ordinal and coded Tenure – Numerical and continuous With the given variables, here are the descriptive statistics: Note for non numeric data variables, the descriptive analysis could not be computed. These are: StateU, CISDegree and Stayed3yrs. Variable | Mean | StDev | Variance | Sum | Minimum | Maximum | Range | StartSal | 37986.36 | 1927.05 | 3713503.50 | 2507100...

Words: 563 - Pages: 3

Premium Essay

Week 5 Alternative Assignment

...of the following shapes best represents a normal distribution as it is depicted graphically?  A. Square B. Bell C. Triangle D. Star E. Hat For questions 2 through 4, consider the following array of numbers: 5 6 7 7 7 8 8 9 9 9 10 15 19 20 21   2. In the array provided, what is the mode?  A. 7 B. 9 C. 10 D. 15 E. Both A and B   3. In the array provided, what is the median?  A. 7 B. 9 C. 10 D. 15 E. Both A and B 4. In the array provided, what is the mean?  A. 7 B. 9 C. 10 D. 15 E. Both A and B 5. The difference between the smallest and the largest values in a distribution is the _____.  A. mean B. median C. mode D. range E. deviation 6. Which of the following is a bar chart arranged in increasing order by size?  A. Control chart B. Simple bar chart C. Pareto diagram D. Histogram 7. Which of the following hypotheses is a null hypothesis?  A. There is no difference in the monthly grocery bills of families with one child and families with two children B. Grocery bills vary according to the number of meals eaten outside the home C. Families with two children have significantly higher grocery bills than families with just one child D. There is a relationship between grocery bills and the number of people in a household E. The mean age in a household is predictive of the amount of money sent on food each month 8. _____ occurs when the sample results lead to the rejection of a null hypothesis that is in fact true.  A. Type I error B. Two-tailed...

Words: 445 - Pages: 2

Free Essay

Probability

...Probability Question 1 The comparison between the bar chart and histogram are bar graphs are normally used to represent the frequency of discrete items. They can be things, like colours, or things with no particular order. But the main thing about it is the items are not grouped, and they are not continuous. Where else for the histogram is mainly used to represent the frequency of a continuous variable like height or weight and anything that has a decimal placing and would not be exact in other words a whole number. An example of both the graphs:- Bar Graph Histogram These 2 graphs both look similar but however, in a histogram the bars must be touching. This is because the data used are number that are grouped and in a continuous range from left to right. But as for the bar graph the x axis would have its individual data like colours shown in the above. Question 2 a) i) The probability of females who enjoys shopping for clothing are 224/ 500 = 0.448. ii) The probability of males who enjoys shopping for clothing are 136/500 = 0.272. iii) The probability of females who wouldn’t enjoy shopping for clothing are 36/500 = 0.072. iv) The probability of males who wouldn’t enjoy shopping for clothing are 104/500 = 0.208. b) P (AᴗB) = P(A)+P(B)-P(AᴖB) P (A|B) = P(AᴖB)P(B) > 0 P (B|A) = PAᴖBPA PAᴖBPB = PAᴖBPA PAPB = 1 P(A) = P(B) P(AᴗB) = 1 P(A)+P(B) = 1 P(B) > 0.25 Question 3 1. Frequency Distribution of Burberry Clothing...

Words: 908 - Pages: 4

Free Essay

Upload

...Assignment one Question 1 (one) Figure 1.1 The bar chart, figure 1.1 illustrates the number of gold won by countries. As showed above, USA has the highest number of gold medals won amounting to 46 as compared as Indonesia, Greece and others. Figure 1.2 The bar chart in figure 2.2 shows the number of silver medals won by different countries. As shown in Figure 2.2 USA still has the highest number of Silver medals won, followed by the Great Britain. Figure 1.3 The bar charts above shows the number of Bronze medals won by different countries. The highest number of bronze is won by USA, followed by Japan as compared to Egypt, Cyprus and the other countries which they have not won anything. Figure 1.4 The graph above shows the total number of medals won by different countries. USA is ranked the highest in terms of number of gold won, followed by the United Kingdom (UK) Question Two (2) Figure 2.1 Medals | Ranges | Medians | Average | Gold | 46 | 1 | 3.55 | Silver | 29 | 1 | 3.58 | Bronze | 32 | 2 | 4.19 | Totals | 103 | 4 | 11.32 | Figure 2.2 Questions | Gold | Silver | Bronze | Totals | How far away from the average is the largest value in each of these columns? | 46 – 3.55 = 42.45 | 29-3.58 =25.42 | 32-4.19=27.81 | 104-1=103 | And how far away from the median? | 46-1=45 | 29-1=28 | 32 -2 =30 | 104-4=100 | How far away from the average is the smallest value in each of this column? | 3.55 | 3.58 | 4.19 | 10.32 | And how far...

Words: 337 - Pages: 2

Free Essay

Computer Graphics

...routinely in such diverse areas as science, engineering, medicine, business, industry, government, art, entertainment, advertising, education, and training. Figure 1-1 summarizes the many applications of graphics in simulations, education, and graph presentations. Before we get into the details of how to do computer graphics, we first take a short tour through a gallery of graphics applications. 6.1 Presentation Graphics One of the major application areas is presentation graphics, used to produce illustrations for reports or to generate 35-mm slides or transparencies for use with projectors. It is used to produce illustrations for reports or to generate slide for with projections. Examples of presentation graphics are bar charts, line graphs, surface graphs, pie charts and displays showing relationships between parameters. 3-D graphics can provide more attraction to the presentation. Presentation graphics is commonly used to summarize financial, statistical, mathematical, scientific, and economic data for research reports, managerial reports, consumer information bulletins, and other types of reports. Workstation devices and service bureaus exist for converting screen displays into 35-mm slides or overhead transparencies for use in presentations. Typical examples of...

Words: 1314 - Pages: 6

Premium Essay

Marketing Research

...Marketing Research Take Home Final Examination Name: Ma. Cristina Abella Course/Year: BSBA-MM 3 Case 1. Kendalures Requirement: Design the questionnaire for the fishermen who will use the lures. Develop a set of 20 questions maximum. The questions should be a variation among open-ended and closed-ended questions (i.e. dichotomous, multiple responses (with rating scales if appropriate)). The questionnaire should be formatted that is inclusive of all the prescribed parts of a marketing research questionnaire starting with opening comments that should be verbalized when approaching fishermen who are launching their boats. (35 points) RESEARCH QUESTIONNAIRE Thank you for your help with our research. The following questions serve as a guide to collect information as you test our exciting new product. We are very interested in your experience and your opinions. At the end of these, please feel free to add your own comments. We realize there may be no definitive answers to any of these questions, but as an experienced fisherman, you have a very good general idea. We are looking more for trends and opinions based on your expertise. 1. What time of day were you fishing? Before 6:00 am 12:00pm – 4:00 pm 6:00 am - 8:00 am 4:00 pm – 6:00 pm 8:00 am - 10:00 am 6:00 pm – 8:00 pm 10:00 am – 12:00 pm After 8:00 pm 2. What would you pay for something that increased your catch 300-800%? Would you pay P500.00? Would you pay...

Words: 1669 - Pages: 7

Free Essay

How to Write a Report

...said earlier. Following are the common elements can be found in many different reports: o Title page: The authors name, module, course and the date. o Acknowledgements: Give thanks to the librarians, technicians or computer centre staff. o Contents: List all the main sections in a sequence with page numbers. o Abstract of Summary: It should be concise informative and independent of the report. o Introduction: It will include context, scope of the report, terms of reference as well as define the limits of report, give a brief general background. o Methodology: Show the way of inquiry like interviews or questionnaires. o Results or findings: If possible then show in a tables graphs, pie charts, bar charts, diagrams or any others way. o Discussion: Analyze and interpret your results, identify important issues and suggest explanations. o Conclusion and Recommendations: Draws the main issues which should be relevant with the whole reports. Recommendation may include with conclusion or separate in another section....

Words: 356 - Pages: 2

Free Essay

Task 2

...Part A & C The first educational resource that I chose was a video though Kahn academy. I chose this because not only do the students watch a video about third grade math they have to work a few math problems. This educational resource is appropriate for most of the student population. The video is for third grade math so that makes it appropriate for early childhood. The video gives gradual instructions with visual aids, which can help students who have learning disabilities. The videos on Kahn academy are appropriate for gifted and talented students because the video is based on what the students is learning and what they know. This video is appropriate for students who have challenging behaviors because the video is active and can keep a students interest. The video is appropriate for English language learners because on the website you can choose a variety of languages to hear it in. The video on third grade math warm ups is not appropriate for students with hearing impairments because it does not have closed captioning as an option. The video was not appropriate for students with visual impairments because the video shows different math activities in step-by-step instructions. If a student cannot visually see the steps, I am not sure that the video will help them. Overall, I think that the Kahn academy video would be appropriate for most of the students. The second educational resource that I chose was the Scholastic website as a...

Words: 1475 - Pages: 6

Premium Essay

Nt1330 Unit 9 Final Project

...The activities are listed on the left side of the chart and the duration of each activity along with the percentage of completion is shown on the right side of the chart. This chart is effective in tracking the progress of tasks/activities in a project. Also, another useful tool is a Work Breakdown Structure¹, which decomposes the project into smaller tasks to show relationships between the tasks. By combining project scheduling, project time estimation and risks analysis, there will be a higher chance of finishing the project successfully without delays. 2.3.3 Cost Overruns Cost overruns are closely related to project delays, but that is not always the case. Other cases could be changing the project direction from what was planned, or stakeholders...

Words: 605 - Pages: 3

Free Essay

A Temperature Data Set Has Been Posted Under Course Content

...figure out how to make the graphs and tables in Excel, you are welcome to draw them by hand and then submit them as a scanned document or photo. 1. Open a blank Excel file and create a grouped frequency distribution of the maximum daily temperatures for the 50 states for a 30 day period. Use 8 classes. (8 points) 2. Add midpoint, relative frequency, and cumulative frequency columns to your frequency distribution. (8 points) 3. Create a frequency histogram using Excel. You will probably need to load the Data Analysis Add in within Excel. If you do not know how to create a histogram in Excel, view the video located at: http://www.youtube.com/watch?v=_gQUcRwDiik. Or a simple bar graph will also work. If you cannot get the histogram or bar graph features to work, you may draw a histogram by hand and then scan or take a photo (your phone can probably do this) of your drawing and email it to your teacher. (8 points) 4. Create a frequency polygon in Excel (or by hand). For help, view http://www.youtube.com/watch?v=7Q-KdmDJirg (8 points) 5. A. Do any of the temperatures appear to be unrealistic or in error? If yes, which ones and why. (4 points) B. Explain how this affects your confidence in the validity of this data set. (4 points) Submit your work through the assignment link by 11:59 p.m. (ET) on Monday of Module/Week...

Words: 304 - Pages: 2

Premium Essay

St. Dismas Assisted Living Facility Project Action Plan -- 3

...1. Draw a Gantt chart for the construction phase of the program. What is the completion date if construction starts in March? What is the completion date of the project if construction is started in November? If the project is started on March 1st, 2012, the finish date is July 30th, 2013. For the November start date, the case does not mention exactly what date the project should start but rather mentions that it should start after the elections. We do not have the election date so I will assume a start date of November 14th, 2011, which is a Monday. In this case, the end date of the project would be April 11th, 2013. However, the case states that if the project starts in November, bad weather could affect the outside operations, adding as much as 2 months to the duration. If we add 2 months to phase 1, the entire project is delayed 2 months. However, if the delay only occurs in phase 2, than the end date of the project would not be affected since no tasks have phase 2 as a predecessor. This is quite unlikely since it would impossible, in real life, to proceed to phases 3 and 4 (Enclosures and Interiors) without first completing or at least having a certain percentage completed of phase 2 (Structure). For this reason, I choose to add 2 months in phase 1 and therefore have a new end date of July 4th, 2013. Please note that I have also considered that the 2 months delay include the Christmas and New Year holidays. Gantt charts of both start dates (including the...

Words: 690 - Pages: 3

Premium Essay

Operational Dashboard At Optum

...Organizational Dashboards The operational dashboard at Optum includes graphic representations of the data measured related to the state and federal regulatory requirements, and value drivers, for each area of the company in a concentrated form (Optum, n.d.). The data obtained from around the organization is compiled on one large screen allowing the company’s senior leaders an opportunity to visualize the big picture of how the organization is meeting its regulatory and targeted objectives. The information developed in coordination with the senior leaders is shared with the department heads and managers and is broken up into department and section related scorecards which are then shared with the individual workgroups at the discretion of the leadership staff. The departmental scorecards are specific to the value drivers for each department and primarily house the metrics related to the performance indicators established for the department or team (Optum, n.d.). As explained by Weiner, Balijepally, Tanniru, & Bunjnowski (2015), financial business objectives and goals are one of the areas included in a balanced scorecard approach to monitoring key performance indicators. As a member of the Claim Review and Resolution (CRR) clinical team at Optum, our objectives are primarily found within the financial area of the organization and focused on payment integrity. The key performance indicators used for the pre and post claim payment service area of Optum are developed by the managers...

Words: 544 - Pages: 3

Premium Essay

Nt1310 Unit 2 Milestone Analysis

...Task 2(2) 2- Milestones and estimated time When we install the new system there will be lot of milestones. Firstly if when we plug the monitor it starts working then it is one of the milestones. second we have to check whether mouse and keyword are also work fine, if it is working then this is another milestone. If the processor which we have installed started working then it is one milestone. In addition to this we have added 2 RAM in different slot if both of the RAM is working in the computer then it is another milestone. We also have installed a hard drive in the system, if it is storing the data without any of the problem then it another milestone. After plugging the modem if it starts the working like modulating the signals then it is also a milestone. For the video conferencing of the John we also have placed a webcam. If this webcam is working without any fault like it is showing the image clear then another milestone. We have also added speakers for listening the voice during the video conferencing if speaker is working without any vibrate voice or we can say in with clear frequency then this is also another milestone. We also have attached it with the printer. If we try to print something and we are able to do so then this is another milestone. In addition to this opening the Microsoft word, Skype and internet all of these are also small-small milestones. RESOURCED NEEDED DURING INSTALATION:- There is several things which are require while installation of the computer...

Words: 643 - Pages: 3