Cusatbahome.files.wordpress.com



ASSIGNMENTSubmitted By Group 1NamesBatchArcha PrasadMBA -CAnju FrancoMBA -CFariza Abdul LathiefMBA -CSharon Jose GadgilMBA -CSamruthaMBA -CQuestionAnalyse Sample Data set using Excel:i)Download a data set.ii)Provide a description for it.iii)Formulate meaningful questions and find its answers from the data setAnswerAnalysis of Mobile App Statistics (Apple iOS app store)i)Data set is downloaded from .)Data set Description.IntroductionMobile applications are available in abundant nowadays in different varieties. E-commerce is penetrating more in to customers with the help of their mobile applications which is convenient and compact. Mobile apps have become a very important part of every business. This data set provides an overview of applications available in IOS app store and the related information like no: of downloads, user ratings etc.Since apps being an important interface between customers and business it is necessary that they provide the best experience for customers. Analysing the extending applications would be helpful in such cases. This data set contains more than 7000 Apple iOS mobile application details. The data was extracted from the iTunes Search API at the Apple Inc website. Excel will be used to analyse the data set and to find answers to the questions formulated.Dimension of the data set: 7197 rows and 16 columnsAttributeDescriptionidApp IDtrack_nameApp Namesize_bytes Size (in Bytes)currency Currency TypepricePrice amountrating_count_totUser Rating counts (for all version)rating_count_verUser Rating counts (for current version)user_ratingAverage User Rating value (for all version)user_rating_verAverage User Rating value (for current version)ver Latest version codecont_rating Content Ratingprime_genre Primary Genresup_devices.numNumber of supporting devicesipadSc_urls.numNumber of screenshots showed for displaylang.numNumber of supported languagesvpp_licVpp Device Based Licensing Enablediii)Questions to be answered.1.What genre have maximum number of applications in the IOS store?What is the percentage of different genres of apps like Games/Education/Utility/Music etc.Answer. Games has maximum number of apps in store which is 3862 of the total 7197 apps.The graph showing the number of apps in each genre.The pivot table created for extracting information.Row LabelsCount of idBook112Business57Catalogs10Education453Entertainment535Finance104Food & Drink63Games3862Health & Fitness180Lifestyle144Medical23Music138Navigation46News75Photo & Video349Productivity178Reference64Shopping122Social Networking167Sports114Travel81Utilities248Weather72Grand Total71972.Which Application has got maximum user ratings? Which all applications comes under the top 20 ranked apps in IOS store based on the overall customer rating?Answer:Sort the data from largest to smallest ( customer rating column) and then insert a pivot table to get the 20 rated apps are s follows:Row LabelsMax of rating_count_totGames2130805Angry Birds824451Candy Crush Saga961794Clash of Clans2130805Clear Vision (17+)541693Crossy Road - Endless Arcade Hopper669079CSR Racing677247Fruit Ninja Classic698516Hay Day567344Injustice: Gods Among Us612532Minecraft: Pocket Edition522012PAC-MAN508808Solitaire679055Subway Surfers706110Temple Run1724546Music1126879Pandora - Music & Radio1126879Spotify Music878563Photo & Video2161558Instagram2161558Reference985920Bible985920Social Networking2974676Facebook2974676Pinterest10616243. Find the top rated apps in game genre and provide their content ratings and size of the app.The Game genres has 33 apps in the top 50 most rated apps in the IOS store. From the analysis it is found that the most rated apps have 9+ rating for its content and its size is comparatively low.track_namesize_bytesrating_count_totcont_ratingClash of Clans11647692821308059+Temple Run6592102417245469+Candy Crush Saga2228469769617944+Angry Birds1759662088244514+Subway Surfers1560381447061109+Fruit Ninja Classic1045903366985164+Solitaire1019432966790554+CSR Racing5248030726772474+Crossy Road - Endless Arcade Hopper1654712326690799+Injustice: Gods Among Us182959923261253212+4. Select a particular genre of application and find the best app in terms of current version ratings and least rated app in the same category5. Which application is more in size? Compare the high sized apps in each genre.6. Which application has provided maximum screenshots in display in each category and what is its relative ranking in terms of user rating counts?7.Which application has provided the maximum support languages for the application and the what is its relative ranking in terms of user rating counts?8.Does any app has average user rating count less than the average rating count for the current version?9. Which app has the maximum rating for its content? Find the best rated app for its content in each genre.10. Among the most rated 100 applications how many of them have more than 1 support language for it? Prepare a chart for the same11. Among the most rated 100 applications how many of them have more than 1 supporting devices for it? Prepare a chart for the same.12. Which is the price of top 5 high rated apps in all categories?13. How many apps are free downloadable in the top 100 most rated apps in IOS store?14. Which type of applications are having maximum supported devices?15.Prepare a list of high priced apps in each category and compare their other attributes like size ,no: of supporting languages etc. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download