Question: In the readings section, I included two files with data from Facebook. Both the Microsoft Excel Download Microsoft Exceland Access files Download Access filesrefer to
In the readings section, I included two files with data from Facebook. Both the Microsoft Excel Download Microsoft Exceland Access files Download Access filesrefer to data from Facebook on the Wall Street Journal stories pertaining to Apple, Amazon, and WalMart on separate tabs in the spreadsheet The Excel and Access files already have some examples of the metrics such as total likescount etc. Explain how you would use Excel or Access technologies to answer the following questions:
How did the total likescount sum of all likes change from to to to and to for Apple? How did it change for WalMart? Discuss your answer with justification and how you used the technology to answer this question.
How did the total angrycount change by year for both Apple and WalMart from to Also, discuss your answer with justification and how you used the technology to answer this question.
For all stories included in this spreadsheet, regardless of the company, how did the total likescount change by year? To address this questions, use the total likescount for the three companies
What percentage of total likes did Apple obtain by year? To address this questions, use the total likescount for the three companies Use the following method:
Likes that Apple ReceivedLikes for Apple Likes for Walmart Likes for Amazon
Express this ratio as a percentage.
If your organization has a social media presence for the productsservices it offers, would you follow the "Apple" model or the "WalMart" model for building social media presence? Justify your answer based on likecount, angrycount analysis in earlier questions.
Submit either the Excel spreadsheet or the Microsoft Access database showing your work to arrive at the answers to these questions.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
