Category: Statistics
How to Find Variance and Standard Deviation in Excel
Variance and standard deviation are components of statistical values that are most often found in descriptive analysis. When we perform statistical software analysis, we will find the value of variance and standard deviation if we enable descriptive statistics.
How does high variance affect hypothesis testing in linear regression?
Will a high variance value affect the statistical test on linear regression? Many questions related to this topic were Kanda Data obtained. On this occasion, Kanda Data will discuss the impact of the variance value on hypothesis testing on linear regression.
How to Write and Test Statistical Hypotheses in Simple Linear Regression
We need to develop hypotheses when conducting research. A hypothesis is a provisional assumption or statement of the research. The hypothesis needs to be proven, whether true or false, through the research process.
How to Reverse Natural Logarithm to Initial Data in Excel
Researchers often use the natural logarithm form (Ln) transformation. In the previous article, I have written about How to Transform Data into Natural Logarithm (Ln) in Excel.
How to Transform Data into Natural Logarithm (Ln) in Excel
You may have seen research data transformed into other forms in analyzing research data. The data transformation is determined by changing the measurement scale of the original data into another form.
Create Residual and Y Predicted in Excel
Residual and predicted Y have an important role in linear regression analysis using the Ordinary Least Square (OLS) method. Several OLS linear regression method assumptions were conducted to test the residuals, including normally distributed residuals and constant residual variance.
Nominal, ordinal, interval, and ratio scales | Types of Data Measurement
Types of data measurement scales are fundamental to understand well for researchers. Types of data measurement scales in statistics consist of nominal, ordinal, interval, and ratio scales. This article will discuss the different types of data measurement scales.
Why is Descriptive Statistical Analysis Important?
When you are completing your final project as a student, you will usually find descriptive statistical analysis results in one of the chapters. It can be seen in a separate sub-chapter or part of one of the chapters written in the thesis. For example, sub-chapters have used descriptive statistical analysis in economics and agribusiness research. Therefore, I will choose this topic to discuss.