Querri’s Post

🎥Ever wondered how to make the "Text contains" feature in Google Sheets evaluate multiple values using REGEXMATCH? 🤔 Learn how to use "Text contains" with REGEXMATCH in a few easy steps If you're a spreadsheet enthusiast or looking to up your data analysis game, this one's for you! 🔍💡 =regexmatch(A1,"X|Y|Z") #GoogleSheets #DataSkills #DataAnalysis #Spreadsheets101 #ExcelTips #DataManipulation #TechTutorial #REGEXMATCH #LinkedInLearning #DataNinja #ProductivityHacks #TechSkills #GoogleWorkspace #DataGeek #LearnWithMe #TutorialTuesday #TechEducation #SpreadsheetMagic #LinkedInVideo #DigitalSkills

Running a quick poll at a DEVFEST Conference in 2023, a couple of questions were asked to prove how a collection of opinions can be used for positive decision making in policy and in business. Using formulae like UNIQUE, SORT, VLOOKUP, COUNT, COUNTIF... transforms raw data into useful units which becomes clearer for the end user. This presentation was done using Google Forms and Google Sheets. #dataislife #dataanalyst #data

Hello everyone! Hope you are having a nice day 🤗 Allow me to share with you my latest achievement in Data Analysis, an A/B testing Jupyter notebook. This one was fun and challenging because we are studying here a Boolean type data. Like my previous notebooks I explain mathematically a lot of the numbers in this notebook. Hope you like it ❤️ . #a_b_testing #data_analysis #jupyter_notebook #statistics https://lnkd.in/eegwix3g

NEW step-by-step video tutorial on random forest regressions in Google Sheets with TableTorch add-on (5 minutes): https://lnkd.in/d75yh_DZ . Hope it helps your data analysis needs today!

"why we should plot the data" 🧠neuron 9 Our mind gets more from pictures than simply text formats. Finding the pattern that a data possess can be done more easily with plots. today ,i got to learn about ggplot2 in R studio . In the image shared below , that I have generated using R markdown using the line of command ggplot(data = mpg, aes(y=manufacturer)) geom_bar() we can find the below insights.... who is the number 1🏆 manufacturer in car industry who is having downtime📉 in manufactureing... who is the competitor....etc so why not plots ......

Check out the interactive version of this visualization of all possible Wordle solutions. Note, for example, that there are very few solutions ending in 'D' or 'S' due to the current exclusion of plural words ending in 'S' or verbs ending in the past tense 'ED.' Any other patterns you see? https://lnkd.in/ecD5rspi #wordle #data

Industries across the globe deal with structured and unstructured data on a daily basis. To generate insights, derive conclusions, identify trends, or identify issues, companies work towards analyzing their text data. 🧠 An overview of text analytics fundamentals and learn how to transform text data using different machine learning models: https://hubs.la/Q02cz_bw0 #textanalytics #machinelearning #rprogramming

How to manipulate with charts 101 If you want something to look amazing, graph it cumulative If you want it to be relatable, graph units per time If you want it to look bad, graph change vs previous period

In this simple notebook, i just created Linear Regression model from scratch using batch gradient descent algorithm via updating the weight and bias parameters (n) times of iteration , i tune my model using two parameters 1- alpha or learning rate : step size when updating weights and bias 2- no_of_iter : if this number terminated the model stop updating weights and bias , i test the model on small dataset that describe the relation between years_of_experience vs salary then i visualize the predicted line vs testing datapoints and how far they close to it ♥ : https://lnkd.in/dGDjBpCN

🚀 New Episode: Dive into Special Numbers and Table Transformations! 🧩🔢 Get ready for the latest episode of "R Solution for Excel Puzzles," where we explore fascinating number properties and master table transformations: Special Numbers: Triangular Numbers: Uncover the intriguing patterns of triangular numbers and their applications. Tech Numbers: Dive into the world of tech numbers, exploring their unique characteristics. Palindromes: Discover the symmetrical beauty of palindromic numbers and their hidden patterns. Transforming Tables: World Cup Data: Transform and analyze World Cup data, turning raw statistics into insightful visualizations. Language Learning Report: Organize and present language learning data in a clear and comprehensive manner. 🔗 Join us for a journey through special numbers and powerful table transformations, enhancing your data analysis and presentation skills! #SpecialNumbers #TableTransformation #ExcelAndR #DataAnalysis #TriangularNumbers #TechNumbers #Palindromes #WorldCupData #LanguageLearning #RStats #DataScience