Need help for the following project of Android Apps Analysis The Scenario The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated with the apps The database can be created by running the following script Create Google sql The Request You are working for an independent third party company that is determining for Google the current app hits and flops, as well as aggregated data for apps being developed and deployed for the Android platform Requirements and Information Provide a visualization for the highest rated apps with a user rating of at least 4 6, have at least 1000 reviews, and does not have a content rating of Everyone Provide a visualization for the total number of apps for each of the 6 content categories Provide a visualization for the top 3 highest rated TOOLS apps that have more than 225,000 reviews Also, include at least 1 positive review for each of the top 3 apps in the visualization What to Submit Upload a completed lab report answering all questions and including the scripts that pulled the data and the visualizations used to effectively communicate the results

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 12, 2024

Need help for the following project of Android Apps Analysis: The Scenario: The Google Apps database stores many of the apps developed for android smart

Need help for the following project of Android Apps Analysis:

The Scenario:

The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated with the apps. The database can be created by running the following script: Create_Google.sql

The Request:

You are working for an independent third-party company that is determining for Google the current app hits and flops, as well as aggregated data for apps being developed and deployed for the Android platform.

Requirements and Information:

Provide a visualization for the highest-rated apps with a user rating of at least 4.6, have at least 1000 reviews, and does not have a content rating of Everyone.
Provide a visualization for the total number of apps for each of the 6 content categories.
Provide a visualization for the top 3 highest rated TOOLS apps that have more than 225,000 reviews. Also, include at least 1 positive review for each of the top 3 apps in the visualization.

What to Submit:

Upload a completed lab report answering all questions and including the scripts that pulled the data and the visualizations used to effectively communicate the results