04 Dec Burrito casestudy instruction and hints
Needing by 12/7/24 – 3-5 pages
Data file: Burrito.xlsxDownload Data file: Burrito.xlsx
This case study will cover Excel Projects #3 50/50 points possible
Download the dataset and familiarize yourself with the data
Read articles about the California Burrito project
Burritos of San Diego (srcole.github.io)Links to an external site.
Watch this video of a very similar dataset analysis.
https://www.youtube.com/watch?v=IstUmTeVvik&embeds_referring_euri=https%3A%2F%2Fse.instructure.com%2Fcourses%2F7591%2Fpages%2Fburrito-case-study-instruction-and-hints%3Fmodule_item_id%3D820596&source_ve_path=Mjg2NjQsMjM4NTE
Learn a few things about your data and report those in a word document with snippets of the pivot tables data or charts. Tell a story of the data, share your insights, let me know what you learned. Turn in the excel workbook with the completed pivot tables you used to learn something about the data as well as a word document with narrative explanation and your story about the data. The word document with snippets should be 3-5 pages.
10D
| Location | Burrito | Date | Neighborhood | Address | URL | Yelp | Chips | Cost | Hunger | Mass (g) | Density (g/mL) | Length | Circum | Volume | Tortilla | Temp | Meat | Fillings | Meat:filling | Uniformity | Salsa | Synergy | Wrap | overall | Rec | Reviewer | Notes | Unreliable | NonSD | Beef | Pico | Guac | Cheese | Fries | Sour cream | Pork | Chicken | Shrimp | Fish | Rice | Beans | Lettuce | Tomato | Bell peper | Carrots | Cabbage | Sauce | Salsa | Cilantro | Onion | Taquito | Pineapple | Ham | Chile relleno | Nopales | Lobster | Queso | Egg | Mushroom | Bacon | Sushi | Avocado | Corn | Zucchini | |
| Donato's taco shop | California | 1/18/16 | Miramar | 6780 Miramar Rd | http://donatostacoshop.net/ | 3.5 | 4.2 | 6.49 | 3 | 3 | 5 | 3 | 3.5 | 4 | 4 | 4 | 4 | 4 | 3.8 | Scott | good fries: 4/5 | x | x | x | x | x | |||||||||||||||||||||||||||||||||||||||
| Oscar's Mexican food | California | 1/24/16 | San Marcos | 225 S Rancho Santa Fe Rd | http://www.yelp.com/biz/oscars-mexican-food-san-marcos | 3.5 | 3.3 | 5.45 | 3.5 | 2 | 3.5 | 2.5 | 2.5 | 2 | 4 | 3.5 | 2.5 | 5 | 3 | Scott | Fries: 3/5; too little meat | x | x | x | x | x | |||||||||||||||||||||||||||||||||||||||
| Oscar's Mexican food | Carnitas | 1/24/16 | 4.85 | 1.5 | 3 | 2 | 2.5 | 3 | 4.5 | 4 | 3 | 3 | 5 | 3 | Emily | x | x | x | |||||||||||||||||||||||||||||||||||||||||||||||
| Oscar's Mexican food | Carne asada | 1/24/16 | 5.25 | 2 | 3 | 2 | 3.5 | 3 | 4 | 5 | 4 | 4 | 5 | 3.75 | Ricardo | Go to average burrito place like Rigoberto's in la jolla; Terrible tamales | x | x | x | ||||||||||||||||||||||||||||||||||||||||||||||
| Pollos Maria | California | 1/27/16 | Carlsbad | 3055 Harding St | http://pollosmaria.com/ | 4 | 3.8 | x | 6.59 | 4 | 4 | 5 | 4 | 3.5 | 4.5 | 5 | 2.5 | 4.5 | 4 | 4.2 | Scott | x | x | x | x | ||||||||||||||||||||||||||||||||||||||||
| Pollos Maria | combo chicken | 1/28/16 | 6.99 | 4 | 3 | 4 | 5 | 3.5 | 2.5 | 2.5 | 2.5 | 4 | 1 | 3.2 | Emily | x | x | x | x | x | x | x | x | ||||||||||||||||||||||||||||||||||||||||||
| Nico's Taco Shop | California | 1/30/16 | Carmel Valley | 3860 Valley Centre Dr #404 | http://www.yelp.com/biz/nicos-taco-shop-san-diego | 3 | 2.9 | 7.19 | 1.5 | 2 | 3 | 3 | 2 | 2.5 | 2.5 | 2 | 3 | 2.6 | Scott | not fries. big potatoes | x | x | x | x | |||||||||||||||||||||||||||||||||||||||||
| Nico's Taco Shop | Carnitas | 1/30/16 | 6.99 | 4 | 2.5 | 3 | 3 | 2.5 | 3 | 3.5 | 2.5 | 3 | 3 | Emily | x | x | x | ||||||||||||||||||||||||||||||||||||||||||||||||
| Los Primos Mexican Food | Monster California | 2/1/16 | UTC | 7770 Regents Rd | http://www.primosmex.com/ | 3 | 3.7 | x | 9.25 | 3.5 | 2 | 4.5 | 4.5 | 3.5 | 1.5 | 3 | 3.5 | 4 | 2 | 3.9 | Scott | this tasted really bad leftover. not included in rating | x | x | x | x | x | x | |||||||||||||||||||||||||||||||||||||
| JV's Mexican Food | Carne Asada | 2/6/16 | Morena | 1112 Morena Blvd | http://jvsmexfood.com/ | 4 | 4.1 | 6.25 | 3.5 | 2.5 | 1.5 | 1.5 | 3 | 4.5 | 3 | 1.5 | 2 | 4.5 | 2 | Scott | x | x | x | ||||||||||||||||||||||||||||||||||||||||||
| JV's Mexican Food | Surf & Turf | 2/6/16 | 9.5 | 2 | 2.5 | 2.5 | 2.75 | 2.5 | 2.5 | 2 | 0.5 | 3 | 3.5 | 2.5 | Emily | Huge. Shrimp is good. Meat is normal | x | x | x | x | x | ||||||||||||||||||||||||||||||||||||||||||||
| Tony's Fresh Mexican Food | Chile verde pork | 2/11/16 | Miramar | 7122 Miramar Rd | https://www.yelp.com/biz/tonys-fresh-mexican-food-san-diego | 3 | 4.1 | x | 6.95 | 2 | 3 | 4 | 4 | 3 | 4 | 4 | 1 | 2 | 1 | 3 | Marc | x | x | x | x | x | x | ||||||||||||||||||||||||||||||||||||||
| Tony's Fresh Mexican Food | California | 2/11/16 | 6.25 | 3.5 | 3 | 3.5 | 3.5 | 4 | 2 | 3.5 | 1 | 4 | 4 | 3.9 | Scott | x | x | x | x | ||||||||||||||||||||||||||||||||||||||||||||||
| Tony's Fresh Mexican Food | battered fish | 2/11/16 | 6.99 | 3 | 3 | 1 | 1.5 | 2.5 | 4 | 4 | 3 | 4.5 | 5 | 2 | Nicole | x | x | x | |||||||||||||||||||||||||||||||||||||||||||||||
| Tony's Fresh Mexican Food | California | 2/11/16 | 6.25 | 3 | 4 | 2 | 2 | 4 | 4 | 3 | 4 | 2.75 | Cris | to-go, no guac or sour cream, fries are a small and underdone | x | x | x | x | |||||||||||||||||||||||||||||||||||||||||||||||
| Taco Stand | California | 2/12/16 | La Jolla | 621 Pearl St | http://letstaco.com/ | 4.5 | 4.4 | 7.49 | 4 | 3 | 2.5 | 4 | 4 | 3.5 | 2.5 | 3.5 | 5 | 4.5 | 4.2 | Emily | Horchata is very sweet | x | x | x | x | x | x | ||||||||||||||||||||||||||||||||||||||
| Taco Stand | Surf and turf | 2/12/16 | 8.49 | 2.5 | 4 | 4 | 4.5 | 4 | 5 | 4.5 | 3.5 | 4 | 2 | 4.1 | Scott | x | x | x | x | x | |||||||||||||||||||||||||||||||||||||||||||||
| Graciela's Taco Shop | Adobada | 2/14/16 | Bonita | 5047 Central Ave | https://www.yelp.com/biz/gracielas-taco-shop-bonita-2 | 4 | 4.5 | 5.99 | 3 | 4 | 4 | 3 | 3.5 | 4 | 4.5 | 4 | 4 | 4.5 | 4 | Scott | Salsa verde spicy | x | x | x | x | x | |||||||||||||||||||||||||||||||||||||||
| Graciela's Taco Shop | Barbacoa | 2/14/16 | 5.99 | 2 | 3.5 | 4 | 3.5 | 4 | 4 | 4 | 1.5 | 4 | Emily | x | <
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. About WridemyWe are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers. How It WorksTo make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Are there Discounts?All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Hire a tutor today CLICK HERE to make your first order |