Statology

Statology

Statistics Made Easy

Skip to content
Menu
  • About
  • Course
  • Basic Stats
  • Machine Learning
  • Software Tutorials
    • Excel
    • Google Sheets
    • MongoDB
    • Python
    • R
    • SAS
    • SPSS
    • Stata
    • TI-84
    • VBA
  • Tools
    • Calculators
    • Critical Value Tables
    • Glossary

Category: Uncategorized

Uncategorized

How to Combine Date & Time in Google Sheets

Posted on September 20, 2023 by Zach

You can use the following formulas to combine a date and time in separate cells into one cell in Google Sheets: Method 1: Use Addition…

Uncategorized

Excel: Use VLOOKUP to Return Multiple Values Vertically

Posted on September 20, 2023 by Zach

Often you may want to use the VLOOKUP function in Excel to return multiple values vertically. Unfortunately, the VLOOKUP function can only look up some value…

Uncategorized

How to Stop Excel from Formatting Numbers with E+11

Posted on September 20, 2023 by Zach

Whenever you type a number into Excel that contains more than 11 digits, Excel will automatically format the number using E+11 at the end of it.…

Uncategorized

How to Remove Digits After Decimal in Excel (2 Methods)

Posted on September 20, 2023 by Zach

There are two common ways to remove digits after a decimal place in Excel: Method 1: Use TRUNC Function =TRUNC(B2) Method 2: Use INT Function…

Uncategorized

Excel: How to Find Duplicate Values without Deleting Them

Posted on September 20, 2023 by Zach

Often you may want to find duplicate values in an Excel sheet without deleting them. Fortunately this is easy to do using the Highlight Cell…

Uncategorized

How to Interpret Data where Mean is Less than Median

Posted on September 20, 2023 by Zach

When the mean is less than the median in a dataset, we say that the distribution of the data is left skewed. This means there…

Uncategorized

How to Interpret Data where Mean is Greater than Median

Posted on September 20, 2023 by Zach

When the mean is greater than the median in a dataset, we say that the distribution of the data is right skewed. This means there…

Uncategorized

How to Go to Specific Row in Excel (2 Methods)

Posted on September 20, 2023 by Zach

There are two ways to automatically go to a specific row in an Excel sheet: 1. Type cell address in the Name Box 2. Type…

Uncategorized

How to Update Pivot Table Range in Excel (With Example)

Posted on September 20, 2023 by Zach

The following step-by-step example shows how to update the range for a pivot table in Excel. Step 1: Enter the Data First, let’s enter the…

Uncategorized

Excel: How to Highlight Cell if Greater Than Another Cell

Posted on September 20, 2023 by Zach

To highlight cells that are greater than another cell in Excel, you can use the New Rule option under the Conditional Formatting dropdown menu within…

Posts navigation

Page 1 Page 2 … Page 498 Next Page

Search

ABOUT

Statology is a site that makes learning statistics easy by explaining topics in simple and straightforward ways. Learn more about us.

Statology Study

Statology Study is the ultimate online statistics study guide that helps you study and practice all of the core concepts taught in any elementary statistics course and makes your life so much easier as a student.

statology study

Introduction to Statistics Course

Introduction to Statistics is our premier online video course that teaches you all of the topics covered in introductory statistics. Get started with our course today.

introduction to statistics

Recent Posts

  • How to Combine Date & Time in Google Sheets
  • Excel: Use VLOOKUP to Return Multiple Values Vertically
  • How to Stop Excel from Formatting Numbers with E+11
© 2023 Statology | Privacy Policy
Wisteria Theme by WPFriendship ⋅ Powered by WordPress