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

Author: Zach

Uncategorized

How to Calculate AIC in SAS (With Example)

Posted on March 31, 2023 by Zach

The Akaike information criterion (AIC) is a metric that is used to compare the fit of several regression models. It is calculated as: AIC =…

Uncategorized

How to Sum Across Columns in SAS (With Example)

Posted on March 31, 2023 by Zach

You can use the following syntax to sum across columns in a dataset in SAS: data new_data; set my_data; sum_stats = sum(of points, assists, rebounds);…

Uncategorized

SAS: How to Display IQR in PROC MEANS

Posted on March 31, 2023 by Zach

You can use PROC MEANS to calculate summary statistics for variables in SAS. By default, PROC MEANS does not display the interquartile range (IQR) as one…

Uncategorized

SAS: How to Display Median in PROC MEANS

Posted on March 31, 2023 by Zach

You can use PROC MEANS to calculate summary statistics for variables in SAS. By default, PROC MEANS does not display the median value as one of…

Uncategorized

How to Calculate RMSE in SAS

Posted on March 31, 2023 by Zach

One way to assess how well a regression model fits a dataset is to calculate the root mean square error, which is a metric that…

Uncategorized

How to Calculate R-Squared in SAS

Posted on March 31, 2023 by Zach

R-squared, often written as r2, is a measure of how well a linear regression model fits a dataset. This value represents the proportion of the…

Uncategorized

How to Highlight Rows in VBA (With Examples)

Posted on March 30, 2023 by Zach

You can use the following methods in VBA to highlight rows: Method 1: Highlight Active Row Sub HighlightActiveRow() ActiveCell.EntireRow.Interior.Color = vbYellow End Sub This particular…

Uncategorized

How to Highlight Cells in VBA (With Examples)

Posted on March 30, 2023 by Zach

You can use the following methods in VBA to highlight cells: Method 1: Highlight Active Cell Sub HighlightActiveCell() ActiveCell.Interior.Color = vbYellow End Sub This particular…

Uncategorized

VBA: How to Hide Rows Based on Criteria

Posted on March 30, 2023 by Zach

You can use the following syntax in VBA to hide rows based on a cell value: Sub HideRows() Dim i As Integer For i =…

Uncategorized

VBA: How to Find Value in Column (With Example)

Posted on March 30, 2023 by Zach

You can use the following basic syntax in VBA to find a value in a column in Excel: Sub FindValue() Dim rng As Range Dim…

Posts navigation

Page 1 Page 2 … Page 420 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 here and follow us on Twitter.

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 Calculate AIC in SAS (With Example)
  • How to Sum Across Columns in SAS (With Example)
  • SAS: How to Display IQR in PROC MEANS
© 2023 Statology | Privacy Policy
Wisteria Theme by WPFriendship ⋅ Powered by WordPress