DAT 375 Module 3-1 Assignment

This analysis uses quantitative methods to evaluate scraped data, identifying message and reshare averages per user and peak messaging times. Insights will guide improvements to our social media app's user interface.

Mason Bennett
Contributor
4.2
51
5 months ago
Preview (2 of 4 Pages)
100%
Purchase to unlock

Page 1

DAT 375 Module 3-1 Assignment - Page 1 preview image

Loading page image...

Module 3-1: Choosing The Right ScriptsRobert WoodSouthern New Hampshire University07/18/2024

Page 2

DAT 375 Module 3-1 Assignment - Page 2 preview image

Loading page image...

M o d u l e 3-1: Choosing The Right ScriptsAfter reviewing the problem for this analysis,themost appropriate data analysis technique touse in order to help with this problem would be a quantitative analysis. The purpose of the analysis thatwe are going to run is that we have been asked by our supervisor to use the provided scraped data setto find the average number of messages by a single username, the average number of reshares by asingle username and finally thetimeframe that has the highest numberoforiginal messages. The datathatwe collect fromthisanalysiswillhelp our companytobetter understand how the competitionhascreated the user interface for messagingon theirsocial media applications to improve upon and buildupon that for our own social media application. A quantitative approach tothisproblemisthe mostlogical fit since we are looking for numerical data from the present and are not looking to make futurepredictions at this time.The scripts that are necessary and that wereusedto find the average numberofmessages by asingle username and the average number of reshanes by a single username were pretty similar with onlysome slight changes in what was being pulled fromthedata and from where it was being pulled from.Meaning that the script essentially pul edthesame thing but from different columns/categories(messages and reshares). After running the script for the average number of messages by a singleusername using the following script we get the output that the average number of messages by a singleusername is roughly 945 messages.SELECT AVG(count)FROM (SELECTusername,count(-) as countFROM assignment3_l.rwDod_tableGROUP BY usernameORDER BY count DESC
Preview Mode

This document has 4 pages. Sign in to access the full document!

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Related Documents

View all