This Project Requires Us To Use Excel To Analyze Data Using One Sample This project requires us to use Excel to analyze data using one-sample analysis, two-sample analysis, regression analysis, analysis of variance, and contingency table analysis. The main topic I chose is TikTok according to my project proposal (attached). I found a link to data but I need you to find more websites about TikTok to do analysis on. The project needs to meet the standard of the three examples (attached) and need to be more than 25 pages of PowerPoint. The main point of this project is to be fun and creative!
Paper For Above instruction Introduction The rapid rise of TikTok as a dominant social media platform has sparked significant interest among researchers, marketers, and social scientists alike. Its unique algorithm, user engagement strategies, and cultural impact make it an ideal subject for comprehensive data analysis using various statistical methods in Excel. This paper explores the analysis of TikTok data through techniques such as one-sample tests, two-sample comparisons, regression analysis, analysis of variance, and contingency tables, aimed at providing a holistic understanding of the platform’s dynamics and user behavior. Data Collection and Sources To facilitate a robust analysis, multiple sources of data related to TikTok were identified. The initial dataset, obtained via a provided link, offers valuable insights but is insufficient for comprehensive analysis. Therefore, additional datasets were explored from reputable websites such as Statista, DataReportal, and TikTok’s official analytics reports. These sources provide data on user demographics, regional engagement, content trends, and advertising metrics. For instance, Statista offers detailed reports on TikTok's user growth, engagement rates, and demographic breakdowns (Statista, 2023), while DataReportal provides data on regional distribution and content preferences (DataReportal, 2023). Methodology The analysis employs a combination of statistical techniques applied within Excel, leveraging its data analysis toolpak, and visualization features. 1. One-Sample Analysis: This technique assesses whether a sample mean significantly differs from a known or hypothesized