From the course: Excel PivotTables: Real-World Case Studies

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Apple app ratings

Apple app ratings - Microsoft Excel Tutorial

From the course: Excel PivotTables: Real-World Case Studies

Start my 1-month free trial

Apple app ratings

“

- [Instructor] All right, next up we've got a really interesting case study looking at Apple App Store data. And what we've got here are details and descriptions for over 7,000 mobile apps. Now in terms of dimensions and measures, we got some really interesting fields that we're going to use to explore and analyze and really slice and dice this data. We've got a unique identifier called the app ID. We've got the app name itself, the size in terms of bytes, the currency type, the price, the age rating they're targeting and then the primary genre. So we'll be able to see apps that are categorized as games versus productivity apps versus weather apps or shopping and so on and so forth. Now for measures, the actual quantitative values that we're going to be analyzing here, we've got total ratings as well as the total average rating, which is in half point increments on a zero to five scale. And on top of that we also have ratings and average rating for the current version of the app…

Contents