Apple-App-Store-Assignment---2

Apple App Store Analysis using Excel

Description of the Case Study

The case study is based on App Data of different apps available in the App Store. The dataset contains information related to details of the applications (such as size, price, ratings, genre, number of screenshots, and supported languages).

Insights

Key Performance Indicators:

• Total price
• Max Size Bytes
• Min Bytes Size
• Distinct Apps
• Total ratings
• Avg. ratings

Key Insights:

• Top 5 Apps by Total Bytes and prices
• Top 5 Primary Genre by average Ratings
• Top and Bottom 10 Apps by supported languages
• Top 5 Apps by Average rating and Current version Average ratings
• Age group and Bytes group wise Analysis (Price and Total ratings)