Question

Create an additional column in tab Data that shows state from tab State (Explain procedure) How...

Create an additional column in tab Data that shows state from tab State (Explain procedure)

How do I I have to solve the question using this excel data set but note that this is not the full data set. I just need the steps please.

date_sign_up customer_id product_name marketing_channel City
4/17/2015 13:11 71041 Classic - 3 meals per week for 2 people Search Engine Marketing San Diego
4/14/2015 11:32 103289 Classic - 3 meals per week for 2 people Newsletters (internal) Los Angeles
4/14/2015 9:53 107746 Classic - 3 meals per week for 2 people Newsletters (internal) Los Angeles
4/14/2015 16:08 157441 Classic - 3 meals per week for 4 people Newsletters (internal) San Francisco
4/18/2015 8:04 158646 Classic - 3 meals per week for 2 people Newsletters (internal) San Diego
4/18/2015 15:41 178843 3 Meals (vegetarian) for 2 people TV / Radio Advertising Miami
4/15/2015 9:45 179297 Classic - 3 meals per week for 2 people Newsletters (internal) Philadelphia
4/15/2015 8:21 182439 3 Meals (vegetarian) for 2 people Newsletters (internal) San Francisco
4/17/2015 6:57 186180 Classic - 3 meals per week for 2 people Partnership Marketing San Diego
4/19/2015 20:39 190396 Classic - 3 meals per week for 2 people TV / Radio Advertising Miami
4/14/2015 10:26 194229 Classic - 3 meals per week for 2 people Search Engine Marketing Los Angeles
4/13/2015 20:17 194353 Classic - 3 meals per week for 2 people Search Engine Marketing Washington
4/15/2015 14:43 200286 Classic - 3 meals per week for 2 people Search Engine Marketing Philadelphia
4/16/2015 7:35 201307 Classic - 3 meals per week for 2 people TV / Radio Advertising 1San Diego
4/15/2015 6:54 203319 Classic - 3 meals per week for 2 people Newsletters (internal) San Francisco
4/14/2015 8:35 205233 Classic - 3 meals per week for 2 people TV / Radio Advertising Los Angeles
4/13/2015 12:08 205322 Classic - 3 meals per week for 2 people Newsletters (internal) Chicago
4/16/2015 5:04 205611 Classic - 3 meals per week for 2 people TV / Radio Advertising San Diego
4/15/2015 12:17 208066 3 Meals (vegetarian) for 4 people Newsletters (internal) Philadelphia


Homework Answers

Answer #1

Answer: I am giving you the steps to do in excel.

First of all, Create a Master table of state and city names where against each city their state names are mentioned.

Now insert a column in this data set in excel and make the column name as the state

Now use the Vlookup function =Vlookup(select the cell containing the city name, select the entire data range in the master table where the city name and state are listed,2, False)

The sampling formula would be like: (suppose the city name is in column E of current sheet)

State_name=Vlookup(E2,Satesheet!$A$1:$B$10,2,False)

Now drag down or copy-paste the formula in the entire column, you will get the state name against each entry or row where the cities are mentioned.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
This file contains data on the crime rates (total and violent) and population. Using Excel or...
This file contains data on the crime rates (total and violent) and population. Using Excel or other software of your choice, for each of the following pairs make a ScatterPlot then determine the Correlation Coefficient: (3pts) Crime Rate and Population (3pts) Violent Crime Rate and Population (3pts) Crime Rate and Population Density (that’s the Number of people Per square mile – Hint: You need to compute this last one on your own using data in the table.) Copy and paste...
1 Which of the following should be done for more effective"search engine marketing?" a. Bid on...
1 Which of the following should be done for more effective"search engine marketing?" a. Bid on Google AdWords b. Use page titles and key words within each page c. Retarget individuals who have searched (e.g., googled) key words. d. All of the above 2 A wholesaler/distributor: a. Typically works on a consignment basis. b. Is independently owned and operated, and sells the products of many manufacturers. c. Typically carries very little, if any, inventory. d. All of the above are...
***I do not need any of the figures, calculations or forums done, I am in need...
***I do not need any of the figures, calculations or forums done, I am in need of help for the written part of Week 7: Final Submission. I am very weak when it comes to writing and could use some guidance. Below I will list the 3 situations for your help. Thanks! Week 7: Final Submission Recommendations This week you will resubmit the updated tax preparation forms based on your manager’s (instructor’s) feedback. Along with this documentation, you will submit...
You are to prepare a two-page (single-spaced) paper based on the case assigned. The case is...
You are to prepare a two-page (single-spaced) paper based on the case assigned. The case is listed below. Case Note Format Your case analysis should be in the format of a two page (not counting the reference section) single-spaced Executive Summary. The report should follow the following format in sentence/paragraph form using APA format to cite sources. You are required to cite the textbook and at least one outside source from an academic peer-reviewed article. 1. Introduction of Firm 2....
The Halls Gap Wildlife Park offers a unique Australian wildlife experience. The park offers a scenic...
The Halls Gap Wildlife Park offers a unique Australian wildlife experience. The park offers a scenic comfortable nature walk around the facilities, with the chance to get up close and personal to some of Australia’s most famous native animals. With over 100 kangaroos roaming free, around the park, there is an opportunity to experience hand feeding these amazing animals. Visitors also have a chance to interact with koalas, wombats, and a variety of reptiles ranging from snakes to lizards and...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet with Mr. Carpenter, President of Jacobson Carpet Company. Ms. Lewis assumed that the meeting was related to the recent Board of directors of the company. As a direct assistant to the President, she knew from experience that this type of meeting often resulted in a project to be studied. Her expectation was confirmed as soon as Mr. Carpenter began to inform her of the...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
What strategy would you recommend for Dove (1) in responding (or in not responding) to consumers...
What strategy would you recommend for Dove (1) in responding (or in not responding) to consumers and (2) going forward (or not going forward) with the campaign? If they were to go forward with this campaign, should Dove revise its Real Beauty message and if, so, how? The Dove Real Beauty Campaign In 2004, with sales at approximately $2.5 billion, Dove saw an opportunity to tap into women’s self-perceptions of beauty to address female insecurities while building a connection between...
In narrative essay format, I want you to address a business/organization case study using multiple concepts...
In narrative essay format, I want you to address a business/organization case study using multiple concepts from class. The case question and case text begin on page 5 of this document. You need to demonstrate their best understanding of management and organizational behavior theory, and the application of those ideas to improve the understanding of various issues. You need to clearly identify at least 3 distinct, substantive issues. For each issue you need to 1), identify evidence from the case...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT