Phase-change lines, scale breaks, and trend lines using Excel 2013

Neil Deochand1, Mack S Costello1, R Wayne Fuqua1

  • 1Western Michigan University.

Related Concept Videos

Microsoft Excel: Regression Analysis01:18

Microsoft Excel: Regression Analysis

Regression analysis in Microsoft Excel is a powerful statistical method for examining the relationship between a dependent variable and one or more independent variables. It's used extensively in fields such as economics, biology, and business to predict outcomes, understand relationships, and make data-driven decisions. The most common type is linear regression, which attempts to fit a straight line through the data points to model the relationship between variables.
To perform regression...
1.8K
Microsoft Excel: Median, Quartile range, and Box Plots01:29

Microsoft Excel: Median, Quartile range, and Box Plots

In Microsoft Excel, calculating the median, interquartile range, and creating box plots can help understand the distribution of your data.
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...
4.2K
Microsoft Excel: Plotting Mean, SD, and SE01:18

Microsoft Excel: Plotting Mean, SD, and SE

In Microsoft Excel, plotting the mean along with standard deviation (SD) and standard error (SE) helps visualize data variability and reliability. To plot these values, follow these steps:
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...
1.6K
Increasing Function01:18

Increasing Function

An increasing function exhibits a rise in output values as input values increase. This behavior is depicted graphically as a curve or line that slopes upward from left to right. Such a function satisfies the condition that if x1 < x2, then f(x1) < f(x2), indicating that the function values grow with increasing inputs. This concept is fundamental in understanding growth trends across various domains, such as population dynamics, financial investments, or resource consumption.The...
478
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis01:24

Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis

Central tendency refers to the central point or typical value of a dataset. It summarizes the data set with a single value that represents the center of its distribution. The three main measures of central tendency are:
Mean: The arithmetic average of all data points. It is calculated by adding all the values together and dividing by the number of values. The mean is sensitive to extreme values (outliers).
Median: The middle value when the data points are arranged in ascending or descending...
865
Types of Limits II01:24

Types of Limits II

When observing how a curve behaves near a specific point along the horizontal axis, there are cases where the curve’s height increases or decreases without limit as the position draws closer to that point. The curve does not settle at any particular value; instead, the values grow more extreme—upward or downward—the nearer they get. No defined value exists exactly at that location, yet the surrounding behavior becomes more dramatic, indicating a sharp change in direction.The...
268